SSM-MyBatis-12：Mybatis中添加单个对象返回主键id列

------------吾亦无他,唯手熟尔，谦卑若愚，好学若饥-------------

实体类

public class Book {
    private Integer bookID;
    private String bookName;
    private String bookAuthor;
    private Integer bookPrice;    public Book() {
    }    public Integer getBookID() {
        return this.bookID;
    }    public void setBookID(Integer bookID) {
        this.bookID = bookID;
    }    public String getBookName() {
        return this.bookName;
    }    public void setBookName(String bookName) {
        this.bookName = bookName;
    }    public String getBookAuthor() {
        return this.bookAuthor;
    }    public void setBookAuthor(String bookAuthor) {
        this.bookAuthor = bookAuthor;
    }    public Integer getBookPrice() {
        return this.bookPrice;
    }    public void setBookPrice(Integer bookPrice) {
        this.bookPrice = bookPrice;
    }
}

接口中的方法

//添加
    public int insertBook(Book book);

小配置中

<!--返回主键列-->
    <insert id="insertBook">
        INSERT  INTO book(bookname,bookauthor,bookprice) VALUES (#{bookName},#{bookAuthor},#{bookPrice})
        <selectKey resultType="int" keyProperty="bookID">
            SELECT @@IDENTITY
        </selectKey>
    </insert>

测试类

///添加后返回主键列的测试方法
    //加使用mybatis工具类
    @Test
    public void t2Insert(){
        SqlSession session= MyBatisUtils.getSession();
        Book book=new Book();
        book.setBookName("心想事成");
        book.setBookAuthor("孟七");
        book.setBookPrice();
        IBookDAO mapper = session.getMapper(IBookDAO.class);
        int i = mapper.insertBook(book);
        session.commit();
        System.out.println("受影响的行数"+i);
        System.out.println("返回的主键列的id=============="+book.getBookID());        session.close();    }

它可以把id通过调用这个insertBook的方法，把id注入到传进去的这个对象里，因为他是引用类型