MyBatis—Book示例

MyBatis—Book示例

1. 创建一个示例表 BOOK

列名	类型	约束	备注
book_id	number	序列自增	主键
book_name	varchar2(32)		图书名称
book_auth	varchar2(32)		图书作者
book_brief	varchar2(32)		图书描述
book_create_date	date	默认时间	时间戳

2. 创建java项目

3. 导包ojdbc6.jar，mybatis-3.2.6.jar

4. 创建MVC文件层结构

5. 创建实体类 Book.java

package com.entity;

import java.util.Date;

public class Book {

	private int bookId;
	private String bookName;
	private String bookAuth;
	private String bookBrief;
	private Date bookCreatedate;
	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 getBookAuth() {
		return bookAuth;
	}
	public void setBookAuth(String bookAuth) {
		this.bookAuth = bookAuth;
	}
	public String getBookBrief() {
		return bookBrief;
	}
	public void setBookBrief(String bookBrief) {
		this.bookBrief = bookBrief;
	}
	public Date getBookCreatedate() {
		return bookCreatedate;
	}
	public void setBookCreatedate(Date bookCreatedate) {
		this.bookCreatedate = bookCreatedate;
	}
	public Book() {
		super();
	}
	public Book(int bookId, String bookName, String bookAuth, String bookBrief, Date bookCreatedate) {
		super();
		this.bookId = bookId;
		this.bookName = bookName;
		this.bookAuth = bookAuth;
		this.bookBrief = bookBrief;
		this.bookCreatedate = bookCreatedate;
	}
	@Override
	public String toString() {
		return "Book [bookId=" + bookId + ", bookName=" + bookName + ", bookAuth=" + bookAuth + ", bookBrief="
				+ bookBrief + ", bookCreatedate=" + bookCreatedate + "]";
	}
	
}

6. 配置主配置文件 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>
	
	<!-- 配置数据库连接信息 -->
	<environments default="development">
		<environment id="development">
				<transactionManager type="JDBC"/>
				<dataSource type="POOLED">
					<property name="driver" value="oracle.jdbc.OracleDriver"/>
					<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
					<property name="username" value="hr"/>
					<property name="password" value="123456"/>
			</dataSource>
		</environment>
	</environments>
	
	<!-- 配置mapper文件的路径 -->
	<mappers>
		<mapper resource="com/dao/BookMapper.xml"/>
	</mappers>
	
</configuration>

7. 配置mapper文件，主要写SQL语句，插入，修改，删除

<?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="?">
		
	    <!-- 通用查询映射结果 -->
	    <resultMap id="BaseResultMap" type="com.entity.Book">
	        <id column="book_Id" property="bookId" />
	        <result column="book_Name" property="bookName" />
	        <result column="book_Auth" property="bookAuth" />
	        <result column="book_Brief" property="bookBrief" />
	        <result column="book_create_date" property="bookCreatedate" />
	    </resultMap>
    	
    	<!-- 查询list -->
    	<select id="selectBookList" resultMap="BaseResultMap">
    		select * from book
    	</select>
    	
</mapper>

8. Test_Main测试

package com.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.entity.Book;

public class TestMain {

	public static void main(String[] args) throws IOException {
		//ibatis3.0   mybatis3.0    加载(读取)总配置文件
		String resouce = "mybatis-config.xml";  //代表总配置文件的路径
		InputStream is = Resources.getResourceAsStream(resouce);
		//获取SqlSessionFactory对象
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
		//通过SqlSessionFactory打开SqlSession，是数据库之间的会话,通过session连接数据库. session类似于jdbc的connection数据库连接
		SqlSession session = factory.openSession();
		//SqlSession内置多个操作数据库的API方法， 参数通过字符串名称 获取mapper文件中的id,进而获取的sql语句发送给数据库
		//List<Book> bookList = session.selectList("selectList");
		List<Book> list = session.selectList("selectBookList");
		System.out.println(list);
		//关闭session
		session.close();
	}

}