Java自学之mybatis：简单的CURD

学习目的：使用mybatis实现简单的增删改查。

Part 1

配置pojo.xml，添加增删查改对应的标签，其中id=getCategroy，因为要根据id获取到category对象，对传入的id要声明数据类型：parameterType="_int"。

注意：_int映射Java中的int，int映射Java中的Integer。详见官方文档。

<?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">

<mapper namespace="cn.vaefun.pojo">
    <insert id="addCategory" parameterType="Category">
        insert into category_ (name) values (#{name})
    </insert>
    <delete id="deleteCategory" parameterType="Category">
        delete from category_ where id = #{id}
    </delete>
    <select id="getCategory" parameterType="_int" resultType="Category">
        select * from category_ where id = #{id}
    </select>
    <update id="updateCategory" parameterType="Category">
        update category_ set name = #{name} where id = #{id}
    </update>

    <select id="listCategory" resultType="Category">
            select * from   category_
        </select>
    <select id="listProduct" resultType="Product">
            select * from   product_
        </select>
</mapper>

Part 2

TestMybatis

package cn.vaefun.test;

import cn.vaefun.pojo.Category;
import cn.vaefun.pojo.Product;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class TestMybatis {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session=sqlSessionFactory.openSession();
        //insertCategory(session);
        //deleteCategory(session);
        //getCategory(session);
        updateCategory(session);
        listAll(session);

        session.commit();
        session.close();
  
    }

    /**
     * 显示所有
     * @param session
     */
    public static void listAll(SqlSession session){
        List<Category> cs=session.selectList("listCategory");
        for (Category c : cs) {
            System.out.println(c.getId()+"\t"+c.getName());
        }

//        List<Product> products=session.selectList("listProduct");
//        for (Product p : products) {
//            System.out.println(p.getId());
//            System.out.println(p.getName());
//            System.out.println(p.getPrice());
//        }
    }

    /**
     * 添加
     * @param session
     */
    public static void insertCategory(SqlSession session){
        Category c = new Category();
        c.setName("这是insert的Category");
        c.setId(5);
        session.insert("addCategory",c);
    }

    /**
     * 删除
     * @param session
     */
    public static void deleteCategory(SqlSession session){
        Category c = new Category();
        c.setId(5);
        session.delete("deleteCategory",c);
    }

    /**
     * 查找
     * @param session
     */
    public static void getCategory(SqlSession session){
        Category c = session.selectOne("getCategory",3);
        System.out.println(c.getName()+c.getId());
    }

    /**
     * 修改
     * @param session
     */
    public static void updateCategory(SqlSession session){
        Category c = session.selectOne("getCategory",4);
        c.setName("修改过的Category");
        session.update("updateCategory",c);

    }
}