mybatis入门案例:
目录结构:
按思维顺序编写:
首先要有个pojo类来存数据库中的数据吧:
1、pojo实体类Bookborrow.java`
package com.shuai.pojo;
public class Bookborrow {
String stuName;
Integer bookId;
public String getStuName() {
return stuName;
}
public void setStuName(String stuName) {
this.stuName = stuName;
}
public Integer getBookId() {
return bookId;
}
public void setBookId(Integer bookId) {
this.bookId = bookId;
}
@Override
public String toString() {
return "bookborrow{" +
"stuName='" + stuName + '\'' +
", bookId=" + bookId +
'}';
}
}
接着要对库进行CRUD吧,那先写个接口,实现细节交给mybatis映射文件
2、DAO层被代理接口bookborrow
package com.shuai.dao;
import com.shuai.pojo.Bookborrow;
import java.util.List;
public interface IBookborrow {
List<Bookborrow> getAllBookborrow();
}
这不,mybaits映射文件来了,里面实现具体细节:
3、映射文件mapper.xml 提供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="com.shuai.dao.IBookborrow">
<select id="getAllBookborrow" resultType="com.shuai.pojo.Bookborrow">
select * from mybatis.bookborrow
</select>
</mapper>
要告诉mybatis,映射文件放在哪了吧,数据库怎么连接也要告诉它把,写个核心配置文件
4、Mybatis核心配置文件:负责配置数据库相关信息,绑定映射的那些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="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?
useSSL=true$amp;useUnicode=true$amp;characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/shuai/dao/bookborrowMapper.xml"/>
</mappers>
</configuration>
把核心配置文件加载上去,让mybatis利用你写的核心配置文件连上数据库,找到并利用配置文件,将dao层接口代理增强。
5、编写测试类
import com.shuai.dao.IBookborrow;
import com.shuai.pojo.Bookborrow;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Demo {
public static void main(String[] args) throws IOException {
//1读取mybatis配置文件
InputStream in = Resources.getResourceAsStream("MapperConfig.xml");
//2创建sqlsessionFactory工厂
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
SqlSessionFactory build = builder.build(in);
//3生产sqlsession对象
SqlSession sqlSession = build.openSession();
//4得到DAO接口的代理对象
IBookborrow mapper = sqlSession.getMapper(IBookborrow.class);
List<Bookborrow> allBookborrow = mapper.getAllBookborrow();
for(Bookborrow bk : allBookborrow){
System.out.println(bk);
}
//5、释放资源
sqlSession.close();
in.close();
}
}
本文仅仅是从使用者的视角表述mybatis如何操作,如需了解底层实现,请看我的另一个文章”Mybatis复习2-拆开分析底层原理“(正在编写)
特别记忆节点:
1、xml映射文件放在resource目录下,并且建立于src下同样的目录结构。
2、mybatis核心配置文件中,指定好mapper的resource时,用“/”分隔。
3、Resources.getResourceAsStream()方法需要添加依赖
<dependency>
<groupId>javax.annotation</groupId>
<artifactId>javax.annotation-api</artifactId>
<version>1.3.1</version>
</dependency>