6.1什么是Mybaits
- mybaits是持久层框架,支持普通sql查询、存储过程、高级映射。
- 使java中的对象和数据库中表进行对应。
- mybatis和hibernate的区别:
hibernate是一个全表映射的框架,自动生成查询sql。
优点:效率高
缺点:多表关联支持差、不支持存储过程、不能优化sql性能、更新数据需要发送所有字段
mybatis是半自动映射框架,提供对象、表、sql。
优点:可以配置动态sql、支持sql优化
缺点:代码量比hibernate多
6.2Mybatis的下载和使用
- 6.2.1下载网址:https://github.com/mybatis/mybatis-3/releases
下载完毕后,解压,并把mybatis-x.x.x.jar和lib文件夹下的jar包添加到项目的lib中去。 - 6.2.2通过查询客户入门mybatis
- 整体目录结构:
- 创建数据库表,并导入demo数据
- 整体目录结构:
#创建一个名称为 t_customer表,同时插入几条数据
CREATE TABLE t_customer(
id int(32) PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50),
jobs VARCHAR(50),
phone VARCHAR(16)
)
#插入3条数据
INSERT INTO t_customer VALUES ('1','andy','doctor','13213221212');
INSERT INTO t_customer VALUES ('2','bob','teacher','13513551515');
INSERT INTO t_customer VALUES ('3','camer','worker','13613661616');
INSERT INTO t_customer VALUES ('4','dubbo','farmer','13813881818');
INSERT INTO t_customer VALUES ('5','ela','lower','13913991919');
SELECT * from t_customer;
-
添加相应的jar包
-
配置控制台输出查询sql语句。java根目录创建log4j.properties,并把下面代码复制到properties文件中去
# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
- 创建数据库表对应的java实体类
package com.itheima.po;
/**
* 客户持久化类
* @author lchh
*
*/
public class Customer {
private Integer id;
private String username;
private String jobs;
private String phone;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getJobs() {
return jobs;
}
public void setJobs(String jobs) {
this.jobs = jobs;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
@Override
public String toString() {
return "Customer [id=" + id + ", username=" + username + ", jobs=" + jobs + ", phone=" + phone + "]";
}
}
- 配置mapper映射 CustomerMapper.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">
<!-- namespace表示命名空间 -->
<mapper namespace="com.itheima.mapper.CustomerMapper">
<select id="findCustomerById" parameterType="Integer" resultType="com.itheima.po.Customer">
select * from t_customer where id = #{id}
</select>
</mapper>
- 配置myuabtis的核心文件 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>
<!-- 1.配置环境,默认的环境id为mysql -->
<environments default="mysql">
<!-- 1.2配置id为mysql的数据库环境 -->
<environment id="mysql">
<!-- 使用jdbc的事务管理 -->
<transactionManager type="JDBC"/>
<!-- 数据库连接池 -->
<dataSource type="POOLED">
<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="root"/>
</dataSource>
</environment>
</environments>
<!-- 2.配置Mapper的位置 -->
<mappers>
<mapper resource="com/itheima/mapper/CustomerMapper.xml"/>
</mappers>
</configuration>
- 创建测试类 MybatisTest ,执行查询
package com.itheima.test;
import java.io.IOException;
import java.io.InputStream;
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 org.junit.Test;
import com.itheima.po.Customer;
public class MybatisTest {
/**
* 根据客户端编号查询客户信息
* @throws IOException
*/
@Test
public void findCustomerByIdTest() throws IOException {
//1.读取配置文件
String resource = "mybatis-config.xml";
InputStream is = Resources.getResourceAsStream(resource);
//2.根据配置文件构建SqlSessionFactory
SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(is);
//3.通过SqlSessionFactory创建SqlSession
SqlSession ss = ssf.openSession();
//4.SqlSession执行映射文件定义的SQL,并返回映射结果
String str = "com.itheima.mapper.CustomerMapper.findCustomerById";
Customer customer = ss.selectOne(str, 1);
//打印输出
System.out.println(customer.toString());
//5.关闭SqlSession
ss.close();
}
}
- 最终输出结果: