java搭建mybatis_Mybatis环境搭建及测试

packagemybatis0523;importjava.io.InputStream;importjava.util.Date;importjava.util.List;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.junit.Test;importcn.itheima.pojo.User;public classUserTest {

@Testpublic void testFindUserById() throwsException {

String resource= "SqlMapConfig.xml";//通过流将核心配置文件读取进来

InputStream inputStream =Resources.getResourceAsStream(resource);//通过核心配置文件创建会话工厂

SqlSessionFactory factory = newSqlSessionFactoryBuilder().build(inputStream);//通过会话工厂创建会话

SqlSession session =factory.openSession();

User user= session.selectOne("test.findUserById", 1);

System.out.println(user);

}

@Testpublic void testFindUserByUserName() throwsException {

String resource= "SqlMapConfig.xml";

InputStream inputStream=Resources.getResourceAsStream(resource);

SqlSessionFactory factory= newSqlSessionFactoryBuilder().build(inputStream);

SqlSession session=factory.openSession();

List list = session.selectList("test.findUserByUserName", "王");

System.out.println(list);

}

@Testpublic void testInsertUser() throwsException {

String resource= "SqlMapConfig.xml";

InputStream inputStream=Resources.getResourceAsStream(resource);

SqlSessionFactory factory= newSqlSessionFactoryBuilder().build(inputStream);

SqlSession session=factory.openSession();

User user= newUser();

user.setUsername("赵四");

user.setBirthday(newDate());

user.setSex("1");

user.setAddress("北京昌平");

System.out.println(user.getId());

session.insert("test.insertUser", user);//mybatis中事务默认是开启的，所以在mybatis中不需要显式开启事务，只需要显式提交事务//提交事务

session.commit();

System.out.println(user.getId());

}

@Testpublic void testDeleteUserById() throwsException {

String resource= "SqlMapConfig.xml";

InputStream inputStream=Resources.getResourceAsStream(resource);

SqlSessionFactory factory= newSqlSessionFactoryBuilder().build(inputStream);

SqlSession session=factory.openSession();

session.delete("test.deleteUserById", 27);

session.commit();

}

@Testpublic void testUpdateUserById() throwsException {

String resource= "SqlMapConfig.xml";

InputStream inputStream=Resources.getResourceAsStream(resource);

SqlSessionFactory factory= newSqlSessionFactoryBuilder().build(inputStream);

SqlSession session=factory.openSession();

User user= newUser();

user.setUsername("赵四");

user.setId(24);

session.update("test.updateUserById", user);

session.commit();

}

}