Mybatis实现CRUD操作

1.dao层接口编写

public interface IUserDao {
    /**
     * 查询所有
     * @return
     */
    List<User> findAll();
    /**
     * 查询一条
     * @return
     */
    User findById(Integer id);
    /**
     * 保存
     * @return
     */
    void saveUser(User user);
    /**
     * 根据id删除
     * @return
     */
    void deleteUser(Integer id);
    /**
     * 修改
     * @return
     */
    void updateUser(User user);
    /**
     * 模糊查询
     * @return
     */
    List<User> findName(String name);

}

**

2.映射文件编写

<mapper namespace="com.rpf.dao.IUserDao">
    <!--配置查询所有-->
    <select id="findAll" resultType="com.rpf.domain.User">
        select * from user
    </select>
    <!--保存数据-->
    <insert id="saveUser" parameterType="com.rpf.domain.User">
        insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday});
    </insert>
    <!--根据id删除-->
    <delete id="deleteUser" parameterType="Integer">
        delete from user where id=#{id};
    </delete>
      <!--修改-->
    <update id="updateUser" parameterType="com.rpf.domain.User">
        update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id={uid};
    </update>
      <!--查询一条-->
    <select id="findById" parameterType="Integer" resultType="com.rpf.domain.User">
        select * from user where id=#{id}
    </select>
      <!--模糊查询-->
    <select id="findName" parameterType="String" resultType="com.rpf.domain.User">
        select * from user where username like #{name};
    </select>
    <!--显示刚插入的id-->
     <insert id="saveUser" parameterType="com.rpf.domain.User">
       <selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
           select last_insert_id();
       </selectKey>
    insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday});
    </insert>
</mapper>

3.测试方法

 public static void main(String[] args)throws Exception {
        //1.读取配置文件
        InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
        //2.创建SqlSessionFactory工厂
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(in);
        //3.使用工厂生产SqlSession对象
        SqlSession session = factory.openSession();
        //4.使用SqlSession创建Dao接口的代理对象
        UserDao userDao = session.getMapper(UserDao.class);
        //5.使用代理对象执行方法
        List<User> users = userDao.findAll();
        for(User user : users){
            System.out.println(user);
        }
        //6.释放资源
        session.close();
        in.close();

        @Test
        public void testFindName(){
            List<User> users = userDao.findName("%王%");
            for (User user:users){
                System.out.println(user);
            }
        }
}