MyBatis的注解使用、ORM层优化（懒加载和缓存）

Mybatis注解

• 查找

      @Select( "SELECT * FROM tt_user WHERE username Like #{id};")
      User findUserByName(String name);

      <!--以map为输入参数查找-->
      @Select("select * from tt_user where username= #{name} and  password=#{pass}")
      User findUserByUsernameAndPassword(HashMap map);

• 插入

      @Insert("insert into tt_user values (#{
  id},#{
  username},#{
  password},#{
  email},#{
  age})")
      int AddUser(User user) throws IOException;

• 更改

      @Update("update tt_user set username = #{username} where id = #{id}")
      void updateUserById(User user);

• 删除

      @Delete("delete from tt_user where id =#{id}")
      void deleteUserById(String id);

• 动态SQL语句

      @SelectProvider(type = UserDaoSqlProvider.class,method = "findUserByName")
      List<User> findUserByName(String username) throws