尚硅谷-MyBatis的CRUD操作 - 数据库编程

sion=factory.openSession(true); String statement = "com.atguigu.mybatis.bean.userMapper.updateUser"; int update =session.update(statement,new User(3, "KKK111", 25)); session.close(); System.out.println(update); } @Test public void testDelete(){ SqlSessionFactory factory=MybatisUtils.getFactory(); //默认是手动提交 SqlSession session=factory.openSession(true); String statement = "com.atguigu.mybatis.bean.userMapper.deleteUser"; int delete =session.delete(statement,3); session.close(); System.out.println(delete); } @Test public void testGetUser(){ SqlSessionFactory factory=MybatisUtils.getFactory(); //默认是手动提交 SqlSession session=factory.openSession(true); String statement = "com.atguigu.mybatis.bean.userMapper.getUser"; User user=session.selectOne(statement, 1); session.close(); System.out.println(user); } @Test public void testGetAll(){ SqlSessionFactory factory=MybatisUtils.getFactory(); //默认是手动提交 SqlSession session=factory.openSession(true); String statement = "com.atguigu.mybatis.bean.userMapper.getAllUsers"; List list=session.selectList(statement); session.close(); System.out.println(list); } //--------------------------------测试注解的实现 @Test public void testAdd2(){ SqlSessionFactory factory=MybatisUtils.getFactory(); SqlSession session=factory.openSession(true); UserMapper mapper=session.getMapper(UserMapper.class); int add=mapper.add(new User(-1, "SS", 34)); session.close(); System.out.println(add); } }
数据库配置代码db.properties：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis
name=root
password=123456

可以在src下加入log4j的配置文件,打印日志信息：

-->首先添加 log4j-1.2.16.jar

-->然后：

log4j.properties（方式一）

        log4j.properties，
	log4j.rootLogger=DEBUG, Console
	#Console
	log4j.appender.Console=org.apache.log4j.ConsoleAppender
	log4j.appender.Console.layout=org.apache.log4j.PatternLayout
	log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
	log4j.logger.java.sql.ResultSet=INFO
	log4j.logger.org.apache=INFO
	log4j.logger.java.sql.Connection=DEBUG
	log4j.logger.java.sql.Statement=DEBUG
	log4j.logger.java.sql.PreparedStatement=DEBUG

log4j.xml（方式二）

尚硅谷-MyBatis的CRUD操作(二)