Mybatis操作数据库

项目的基本配置参照
https://blog.csdn.net/weixin_45402151/article/details/115483026

查询单条数据

代码实现

创建User实体类

@ToString
@Data
public class User {
    private Integer id;
    private String username;
    private Integer age;
    private Integer score;
}

创建UserMapper接口

public interface UserMapper {
    User selectUserById(Integer id);

}

创建UserMapper.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace表示命名空间 -->
<mapper namespace="com.mapper.UserMapper">

	<select id="selectUserById" parameterType="java.lang.Integer" resultType="user" >
		select * from user where id =#{id}
	</select>
</mapper>

创建测试类UserTest

@SuppressWarnings({"Duplicates"})
public class UserTest {
    public static void main(String[] args) throws IOException {
        // 读取配置文件
        InputStream configuration = Resources.getResourceAsStream("mybatis-config.xml");
        // 得到 SqlSessionFactory 核心类
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
        // 开始一个 sql 会话
        SqlSession