关于MyBatis框架这一篇就够了
public class IUserDaoTest {
?????private InputStream in;
?????private SqlSession sqlSession;
?????private IUserDao userDao;
?????/**
??????*?在測試執(zhí)行方法執(zhí)行前執(zhí)行
??????* @throws IOException
??????*/
?????@Before
?????public void init() throws IOException {
?????????// 1.?讀取配置文件,外匯跟單gendan5.com生成字節(jié)輸入流
?????????in = Resources.getResourceAsStream("mybatis-config.xml");
?????????// 2.?獲取?SqlSessionFactory
?????????SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
?????????// 3.?獲取?SqlSession?對象
?????????sqlSession = factory.openSession();
?????????// 4.?獲取?dao?對象
?????????userDao = sqlSession.getMapper(IUserDao.class);
?????}
?????/**
??????*?用于在測試方法執(zhí)行后執(zhí)行
??????* @throws IOException
??????*/
?????@After
?????public void destroy() throws IOException {
?????????//?提交事務(wù)
?????????sqlSession.commit();
?????????//?釋放連接
?????????sqlSession.close();
?????????in.close();
?????}
?????/**
??????*?測試查詢所有用戶
??????*/
?????@Test
?????public void testGetUsers() {
?????????List<User> users = userDao.getUsers();
?????????for (User user : users) {
?????????????System.out.println(user);
?????????}
?????}
?????/**
??????*?測試根據(jù)?id?獲取用戶
??????*/
?????@Test
?????public void testGetUserById() {
?????????User user = userDao.getUserById(41);
?????????System.out.println(user);
?????}
?????/**
??????*?測試更新用戶操作
??????*/
?????@Test
?????public void testUpdateUser() {
?????????User user = new User();
?????????user.setUserId(48);
?????????user.setUserName("Bruce");
?????????user.setUserSex("?男?");
?????????user.setUserBirthday(new Date());
?????????user.setUserAddress("?山東濟南?");
?????????userDao.updateUserById(user);
?????}
?????/**
??????*?測試保存賬戶
??????*/
?????@Test
?????public void testSaveUser() {
?????????User user = new User();
?????????user.setUserName("Bruce");
?????????user.setUserSex("?男?");
?????????user.setUserBirthday(new Date());
?????????user.setUserAddress("?山東濟南?");
?????????userDao.saveUser(user);
?????????System.out.println(new Date());
?????}
?????/**
??????*?測試根據(jù)?id?刪除用戶
??????*/
?????@Test
?????public void testDeleteUserById() {
?????????userDao.deleteUserById(59);
?????}
?????/**
??????*?測試根據(jù)名稱查詢用戶
??????*/
?????@Test
?????public void testGetUserByName() {
?????????List<User> users = userDao.getUserByName("Bruce");
?????????for (User user : users) {
?????????????System.out.println(user);
?????????}
?????}
?????/**
??????*?獲取用戶總條目數(shù)
??????*/
?????@Test
?????public void testGetUserTotal() {
?????????int userTotal = userDao.getUserTotal();
?????????System.out.println("?用戶總數(shù)為:?" + userTotal);
?????}
}
總結(jié)
以上是生活随笔為你收集整理的关于MyBatis框架这一篇就够了的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 数据库altert日志中的GTX提示
- 下一篇: ssh ip登录缓慢问题解决