mybatis源码学习之

2023-12-23 14:36| 来源: 网络整理| 查看: 265

为方便进行debug，我们可以写一个简单的测试类，通过断点来跟踪mybatis的执行过程。

1、创建测试包com.mybatis.mine

2、创建mybatis配置文件mybatis-config.xml，配置文件对数据库进行简单配置

3、创建测试使用的POJO

package com.mybatis.mine; import java.io.Serializable; import java.util.Date; public class User implements Serializable{ private String userCode; private String userName; private Date createTime; private String userType; private String mobile; public String getUserCode() { return userCode; } public void setUserCode(String userCode) { this.userCode = userCode; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public Date getCreateTime() { return createTime; } public void setCreateTime(Date createTime) { this.createTime = createTime; } public String getUserType() { return userType; } public void setUserType(String userType) { this.userType = userType; } public String getMobile() { return mobile; } public void setMobile(String mobile) { this.mobile = mobile; } @Override public String toString() { return "User{" + "userCode='" + userCode + '\'' + ", userName='" + userName + '\'' + ", createTime=" + createTime + ", userType='" + userType + '\'' + ", mobile='" + mobile + '\'' + '}'; } }

3、创建UserMapper.java

package com.mybatis.mine; public interface UserMapper { public User selectUser(String id); }

4、创建userMapper.xml

select * from u_user where usercode = #{id}

5、在配置文件mybatis-config.xml中对mapper进行配置

…………

6、编写测试类

package com.mybatis.mine; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.jupiter.api.Test; import java.io.IOException; import java.io.InputStream; public class MineTest1 { @Test public void test01() throws IOException { String resource = "com/mybatis/mine/mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); //1、创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //2、获取sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //3、获取mapper UserMapper userMapper = sqlSession.getMapper(UserMapper.class); //4、执行数据库操作，并处理结果集 User user = userMapper.selectUser("10"); System.out.println(user); } }

7、运行测试类进行测试，如果测试成功，即可在测试代码中打断点进行debug了

附：u_user表的建表语句

CREATE TABLE `u_user` ( `usercode` varchar(60) NOT NULL DEFAULT '', `password` varchar(128) DEFAULT NULL, `usertype` varchar(2) DEFAULT NULL COMMENT '00：老师；01：学生 02：家长', `mobile` varchar(11) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `createtime` datetime DEFAULT NULL, PRIMARY KEY (`usercode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

【本文地址】

mybatis源码学习之

mybatis源码学习之

今日新闻

推荐新闻