一、数据库建表语句
DROP TABLE IF EXISTS `m_book`;CREATE TABLE `m_book` ( `id` varchar(255) NOT NULL, `bname` varchar(255) DEFAULT NULL, `btime` datetime DEFAULT NULL, `price` double DEFAULT NULL, PRIMARY KEY (`id`))
二、
1dao层接口(注:mybatis默认返回int)
package com.test.dao;import com.test.model.Book;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import java.util.List;public interface IBookDao { @Insert("insert into m_book(id,bname,btime,price) values(#{book_id},#{book_name},#{book_time},#{book_price})") public Integer addBook(Book book); @Delete("delete from m_book where id=#{book_id}") public Integer delBook(String id); @Update("update m_book set bname=#book_name},btime=#{book_time},price=#{book_price} where id=#{book_id}") public Integer updateBook(Book Book); @Select("select * from m_book") public List getAllBooK();}
2设置扫描你写的接口与注解
其他省略