maven增删改查

Mybatis入门——增删改查操作

1.select 查询

在接口中添加方法

//    根据ID查询用户
    User getUserById(int id);

添加SQL语句

 <select id="getUserById" parameterType="int" resultType="com.kuang.pojo.User">
       select * from mybat.user where id=#{id}
    </select>

测试

    @Test
    public void getUserById(){
   
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.getUserById(