mybatis学习：一

导入需要使用到的jar包

1.创建表

CREATE TABLE `book` (
  `bookId` int(11) NOT NULL auto_increment,
  `bookName` varchar(20) default NULL,
  `bookAuthor` varchar(200) default NULL,
  `bookPrice` decimal(9,2) default NULL,
  `bookInfo` longtext,
  PRIMARY KEY  (`bookId`)
)

2.创建实体bean

public class Book implements Serializable{
private int bookId;
private String bookName;
private String bookAuthor;
private double bookPrice;
private String bookInfo;

public int getBookId() {
return bookId;
}
public void setBookId(int bookId) {
this.bookId = bookId;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public String getBookAuthor() {
return bookAuthor;
}
public void setBookAuthor(String bookAuthor) {
this.bookAuthor = bookAuthor;
}
public double getBookPrice() {
return bookPrice;
}
public void setBookPrice(double bookPrice) {
this.bookPrice = bookPrice;
}
public String getBookInfo() {
return bookInfo;
}
public void setBookInfo(String bookInfo) {
this.bookInfo = bookInfo;
}

@Override
public String toString() {
return "Book [bookId=" + bookId + ", bookName=" + bookName + ", bookAuthor=" + bookAuthor + ", bookPrice="
+ bookPrice + ", bookInfo=" + bookInfo + "]\r\n";
}

}

3.在src下创建配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <typeAliases>
        <typeAlias type="com.han.mybatis.vo.Book" alias="Book"/>
    </typeAliases>

    <!-- 配置环境(支持多个环境)  -->
    <environments default="development">
        <!-- 其中一个环境 -->
        <environment id="development">
            <!-- 事务管理(JDBC事务) -->
            <transactionManager type="JDBC"></transactionManager>
            <!-- 数据源 -->
            <dataSource type="UNPOOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="********"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/han/mybatis/vo/BookMapper.xml"/>
    </mappers>
</configuration>

4.创建方法映射文件BookMapper.xml

<?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="com.han">
    <select id="loadAll" resultType="Book">
        select * from Book
    </select>
    <insert id="save" parameterType="Book">
        insert into Book(bookName,bookAuthor,BookPrice,bookInfo)
           values(#{bookName},#{bookAuthor},#{bookPrice},#{bookInfo})
    </insert>

    <delete id="delete" parameterType="int">
        delete from Book where bookId=#{id}
    </delete>

    <update id="update" parameterType="Book">
        update book set bookName=#{bookName},bookAuthor=#{bookAuthor},
            bookPrice=#{bookPrice},bookInfo=#{bookInfo} where bookId=#{bookId}
    </update>

    <select id="loadById" resultType="Book" parameterType="int">
        select * from book where bookId=#{id}
    </select>
</mapper>

5.在主函数中测试

public class Main {

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        InputStream inputStream = null;
        SqlSession session = null;
        try {
            inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
            session=sessionFactory.openSession();
            List<Book> books=session.selectList("com.han.loadAll");
            System.out.println(books);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            session.close();
            try {
                inputStream.close();
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}