Mybatis注解开发

1. 工具类创建时实现自动提交事务：

   public static SqlSession getSqlsession(){
       SqlSession sqlSession = sqlSessionFactory.openSession(true);
       return sqlSession;
   }

2. 编写接口，增加注释

   @Select("Select * from User where id = #{id}")
   User getUserById(@Param("id") int id);
   ​
   //添加用户
   @Insert("insert into user(id,name,pwd) values(#{id},#{name},#{pwd})")
   int addUser(User user);
   ​
   //更新用户
   @Update("Update user set name=#{name},pwd=#{pwd} where id=#{id}")
   int updateUser(User user);
   ​
   //删除用户
   @Delete("delete from user where id = #{id}")
   int deleteUser(int id);

3. 测试类：

   @Test
   public void getUserByLimit(){
       SqlSession sqlsession = MybatisUtils.getSqlsession();
       UserMapper mapper = sqlsession.getMapper(UserMapper.class);
       List<User> userlist = mapper.getUserlist();
       for (User user : userlist) {
           System.out.println(user);
       }
       sqlsession.close();
   ​
   }
   ​
   @Test
   public void getUserById(){
       SqlSession sqlsession = MybatisUtils.getSqlsession();
       UserMapper mapper = sqlsession.getMapper(UserMapper.class);
       User userById = mapper.getUserById(1);
       System.out.println(userById);
       sqlsession.close();
   ​
   }
   ​
   @Test
   public void addUser(){
       SqlSession sqlsession = MybatisUtils.getSqlsession();
       UserMapper mapper = sqlsession.getMapper(UserMapper.class);
       int a = mapper.addUser(new User(11, "a", "123456"));
       System.out.println(a);
       sqlsession.close();
   ​
   }
   ​
   @Test
   public void updateUser(){
       SqlSession sqlsession = MybatisUtils.getSqlsession();
       UserMapper mapper = sqlsession.getMapper(UserMapper.class);
       int aa = mapper.updateUser(new User(11, "aa", "123456"));
       System.out.println(aa);
       sqlsession.close();
   ​
   }
   ​
   @Test
   public void deleteUser(){
       SqlSession sqlsession = MybatisUtils.getSqlsession();
       UserMapper mapper = sqlsession.getMapper(UserMapper.class);
       int aa = mapper.deleteUser(11);
       System.out.println(aa);
       sqlsession.close();
   ​
   }

   【注意：接口必须注册核心配置文件之中】

• 关于@param（）注解

  • 基本类型的参数或者string，必须加上

  • 引用类型不需要添加

  • 若果是一个基本类型，可以忽略

  • 在SQL中引用到的变量名为@param（“idd”），则为：idd