Mybaits 基础之 CRUD

先准备要必要的Jar包以及项目   Mybaits入门

 

增加

Category.xml

<insert id="addCategory" parameterType="Category" >
insert into category_ ( name ) values (#{name})
</insert>

Test.java

Category c = new Category();
c.setName("新增加的Category");
session.insert("addCategory",c);

 

删除

<delete id="deleteCategory" parameterType="Category" >
    delete from category_ where id= #{id}   
</delete>

Category c = new Category();
c.setId(6);
session.delete("deleteCategory",c);

 

获取

<select id="getCategory" parameterType="_int" resultType="Category">
    select * from   category_  where id= #{id}    
</select>

Category c= session.selectOne("getCategory",3);

 

修改

<update id="updateCategory" parameterType="Category" >
    update category_ set name=#{name} where id=#{id}    
</update>

session.update("updateCategory",c);

 

查询所有

 
<select id="listCategory" resultType="Category">
    select * from   category_      
</select>

List<Category> cs = session.selectList("listCategory");

 

模糊查询

<select id="listCategoryByName"  parameterType="string" resultType="Category">
            select * from   category_  where name like concat('%',#{0},'%')
        </select>  

  List<Category> cs = session.selectList("listCategoryByName","cat");
        for (Category c : cs) {
            System.out.println(c.getName());
        }
 

 

多条件查询 重点

<select id="listCategoryByIdAndName"  parameterType="map" resultType="Category">
    select * from   category_  where id> #{id}  and name like concat('%',#{name},'%')
</select>

 
        Map<String,Object> params = new HashMap<>();
        params.put("id", 3);
        params.put("name", "cat");
        List<Category> cs = session.selectList("listCategoryByIdAndName",params);