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 {
String resouce = "mybatis-config.xml";
InputStream is = Resources.getResourceAsStream(resouce);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
SqlSession session = factory.openSession();
List<Book> list = session.selectList("selectBookList");
System.out.println(list);
session.close();
}
}