MyBatis增删改查

一、增

public interface BookMapper {
    /* public abstract */ List selectAll();
//    Book selectOneBook(String name,String author);
//    Book selectOneBook2(Book book);
//    Book selectOneBook3(String name,Book book);
    int addBook(Book book);
}

    <insert id="addBook" >
        INSERT INTO t_book(id,name,author,price)VALUES (#{id},#{name},#{author},#{price})
    </insert>

        //业务代码
        Book b=new Book();
        b.setId(3);
        b.setName("红楼梦");
        b.setAuthor("曹雪芹");
        b.setPrice(19.9);
        int i = mapper.addBook(b);
        System.out.println(i>0?"插入成功！":"插入失败");
        //提交事务才会更新数据库
        sqlSession.commit();

二、删

int removeBookById(int id);

    <delete id="removeBookById">
        DELETE FROM t_book WHERE id=#{param1}
    </delete>

        int i = mapper.removeBookById(3);
        System.out.println(i>0?"删除成功！":"删除失败");
        //提交事务才会更新数据库
        sqlSession.commit();

三、改

int updateBookById(Book book);

    <update id="updateBookById">
        UPDATE t_book set id=#{id},name=#{name},author=#{author},price=#{price} WHERE id=#{id}
    </update>

//        改
        Book b=new Book();
        b.setId(2);
        b.setName("红楼梦");
        b.setAuthor("曹雪芹");
        b.setPrice(19.9);
        int i = mapper.updateBookById(b);
        System.out.println(i>0?"修改成功！":"修改失败");
        //提交事务才会更新数据库
        sqlSession.commit();

四、查

/* public abstract */ List selectAll();

<select id="selectAll"  resultType="Book"><!--    parameterType形参类型，resultType返回的list中元素类型    -->
        SELECT *
        FROM t_book
    </select>

//查
        List list = mapper.selectAll();
        for (int j = 0; j < list.size(); j++) {
            Book book=(Book) list.get(j);
            System.out.println(book.getId()+"---"+book.getName()+"---"+book.getAuthor()+"---"+book.getPrice());
        }