目录
一,创建数据库
1.在mybatis数据库下面创建一个表名为t_customer数据库,并插入3条测试数据,具体代码如下:
use mybatis;
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','xixi','performer','145789654');
INSERT INTO t_customer VALUES('2','qiqi','work','145778452');
INSERT INTO t_customer VALUES('3','mumu','teacher','1457235454');
二,创建pojo类
1.在com.itheima.pojo包下创建一个类Customer,并且在类中定义声明id,username,jobs,phone属性,以及相应属性対应getter(),和setter()方法,具体代码如下:
package com.itheima.pojo;
public class Customer {
private Integer id; //封装客户id
private String username; //封装客户姓名
private String jobs; //职业
private String phone; //电话
//通过generate自动生成getter(),setter()方法,快捷键:Alt+insert
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+"]";
}
}
三,创建映射文件
1.在com.itheima.mapper包下面创建映射文件CustomerMapper.xml,根据客户姓名和年龄组合的条件查询客户信息,使用<if>元素编写该组合条件的动态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.itheima.mapper.CustomerMapper">
<!-- <if>元素的使用-->
<select id="findCustomerByNameAndJobs"
parameterType="com.itheima.pojo.Customer"
resultType="com.itheima.pojo.Customer">
select * from t_customer where 1=1;
<if test="username !=null and username !=''">
and username like concat('%',#{username},'%')
</if>
<if test="jobs !=null and jobs!=''">
and jobs=#{jobs}
</if>
</select>
</mapper>
四,修改核心配置文件
1.在配置文件mybatis-config.xml中,引入CustomerMapper.xml映射文件,在《Mapper》元素下添加代码:
<mapper resource="com/itheima/mapper/CustomerMapper.xml"/>
五,创建获取SqlSession对象的工具类
1.在src/main/java下面创建一个com.itheima.utils包,具体代码如下:
package com.itheima.utils;
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.Reader;
//工具类
public class MyBatisUtils {
private static SqlSessionFactory sqlSessionFactory=null;
//初始化SQLSessionFactory对象
static {
try{
//使用MyBatis提供的Resource类加载Mybatis的配置文件
Reader reader=
Resources.getResourceAsReader("mybatis-config.xml");
//构建SqlSessionFactory
sqlSessionFactory=
new SqlSessionFactoryBuilder().build(reader);
}catch (Exception e){
e.printStackTrace();
}
}
//获取SQLSession对象的静态方法
public static SqlSession getSession(){
return sqlSessionFactory.openSession();
}
}
六,修改测试类
1.在测试类MyBatisTest中,编写测试方法findCustomerByNameAndJobsTest(),用于查询客户信息,具体代码如下:
package Test;
import com.itheima.pojo.Customer;
import com.itheima.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class MyBatisTest2 {
@Test
public void findCustomerByNameAndJobsTest(){
//通过工具类获取SQLSession对象
SqlSession session= MyBatisUtils.getSession();
//创建Customer对象,封装需要组合查询的条件
Customer customer=new Customer() ;
customer.setUsername("xixi");
customer.setJobs("performer");
//执行SqlSession的查询方法,返回结果集
List<Customer>customers=session.selectList("com.itheima.mapper"+".CustomerMapper.findCustomerByNameAndJobs",customer);
//输出查询结果
for(Customer customer1:customers){
//打印输出结果
System.out.println(customer1);
}
//关闭Sqlsession
session.close();
}
}
七,执行结果
结果出现以上错误,org.apache.ibatis.exceptions.PersistenceException:
### Error building SqlSession.
### The error may exist in com/itheima/mapper/CustomerMapper.xml
### The error occurred while processing mapper_resultMap[studentMap]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException; lineNumber: 5; columnNumber: 14; 2 字节的 UTF-8 序列的字节 2 无效,原因是因为语句
<?xml version="1.0" encoding="UTF-8"?>多写了一个-,以及
select * from t_customer where 1=1;语句后面多写了一个分号,
改正后的代码如下:
<?xml version="1.0" encoding="UTF8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.itheima.mapper.CustomerMapper">
<!-- <if>元素的使用-->
<select id="findCustomerByNameAndJobs"
parameterType="com.itheima.pojo.Customer"
resultType="com.itheima.pojo.Customer">
select * from t_customer where 1=1
<if test="username !=null and username !=''">
and username like concat('%',#{username},'%')
</if>
<if test="jobs !=null and jobs!=''">
and jobs= #{jobs}
</if>
</select>
</mapper>
运行结果如下:
八,总结
1.写代码的时候一定要认真,细致,要不然出现我这种情况,真的是找几个小时都找不出来,要不是一行一行对着找,还真找不出来,戒浮躁!
2.更改数据库时要改db.properties中数据库的名称,如下:
本文章为学习javaee中MyBatis的核心配置课程时的笔记 ,代码以及文字描述均为书上的代码,支持书本,支持原创。
参考文献:JAVA EE 企业版应用开发教程第2版(黑马程序员 编著)