1 搭建开发环境
1.1 数据准备
创建数据库和数据表
在student表中插入数据
insert into student(sname,age,course) values ('ZhangSan','20','Java');
insert into student(sname,age,course) values ('LiSi','21','Java');
insert into student(sname,age,course) values('WangWu','22','Java');
insert into student(sname,age,course) values ('ZhaoLiu','22','Python ');
insert into student(sname,age,course) values ('SunQi','22','PHP');
insert into student(sname,age,course) values('ZhangSanSan','22','PHP');
1.2 创建工程
在IDEA中创建maven工程
- pom.xml 代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>chapter01</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<!-- Mybatis核心 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!-- junit测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- MySQL驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
</dependency>
</dependencies>
</project>
- 工程目录如下:
2 创建POJO类
- Student.java 代码如下:
该类提供了成员变量和getter/setter方法、toString方法。
package com.qfedu.pojo;
public class Student {
private int sid;
private String sname;
private String age;
private String course;
public Student(){
super();
}
public Student(int sid, String sname, String age, String course) {
this.sid = sid;
this.sname = sname;
this.age = age;
this.course = course;
}
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getCourse() {
return course;
}
public void setCourse(String course) {
this.course = course;
}
@Override
public String toString() {
return "Student{" +
"sid=" + sid +
", sname='" + sname + '\'' +
", age='" + age + '\'' +
", course='" + course + '\'' +
'}';
}
}
3 创建配置文件
Mybatis通过配置文件映射Student类与数据表student的关系。
3.1 配置文件(mybatis-config.xml)
- 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="mysql">
<environment id="mysql">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://localhost:3306/chapter01"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--引入映射文件-->
<mappers>
<!-- <mapper resource="com/qfedu/mapper/StudentMapper.xml"/>-->
<mapper resource="com.qfedu.mapper/StudentMapper.xml"></mapper>
</mappers>
</configuration>
此处使用的mysql版本为8.0.27,至于mysql5.0版本driver需要修改一下。
3.2 映射文件(StudentMapper.xml)
- StudentMapper.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">
<mapper namespace="student">
<!-- 1.查询-->
<select id="findStudentBySid" parameterType="Integer" resultType="com.qfedu.pojo.Student">
select * from Student where sid = #{sid}
</select>
<select id="findStudentBySname" parameterType="String" resultType="com.qfedu.pojo.Student">
select * from Student where sname like '%${value}%'
</select>
<!-- 2.插入-->
<insert id="addStudent" parameterType="com.qfedu.pojo.Student">
insert into student(sname,age,course) values (#{sname},#{age},#{course})
</insert>
<!-- 3.修改/更新-->
<update id="updateStudent" parameterType="com.qfedu.pojo.Student">
update student set sname = #{sname},course = #{course} where sid = #{sid}
</update>
<!-- 4.删除-->
<delete id="deleteStudent" parameterType="Integer">
delete from student where sid = #{sid}
</delete>
</mapper>
4 编写测试类
4.1 查询(select)
4.1.1 通过sid字段查询学生信息
- TestFindBySid.java 代码如下:
package com.qfedu.test;
import java.io.*;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.Student;
public class TestFindBySid {
public static void main(String[] args) {
//读取配置文件
String resource = "mybatis-config.xml";
try {
InputStream in = Resources.getResourceAsStream(resource);
//创建SQLSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//创建SqlSession对象
SqlSession sqlSession = factory.openSession();
//调用SqlSession的selectOne()方法查询
Student student = sqlSession.selectOne("student.findStudentBySid",2);
System.out.println(student.toString());
//关闭SqlSession
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
4.1.1 通过sname字段模糊查询学生信息
- TestFindBySname.java 代码如下:
package com.qfedu.test;
import com.qfedu.pojo.Student;
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 TestFindBySname {
public static void main(String[] args) {
//读取配置文件
String resource = "mybatis-config.xml";
try {
InputStream in = Resources.getResourceAsStream(resource);
//创建SQlSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//创建SqlSession对象
SqlSession sqlSession = factory.openSession();
//调用SqlSession的selectList()方法查询
List<Student> selectList = sqlSession.selectList("student.findStudentBySname", "ZhangSan");
for(Student student : selectList){
System.out.println(student.toString());
}
//关闭SqlSession
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
4.2 添加(insert)
- TestAdd.java 代码如下:
package com.qfedu.test;
import com.qfedu.pojo.Student;
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;
public class TestAdd {
public static void main(String[] args) {
//1.读取配置文件
String resource = "mybatis-config.xml";
try {
InputStream in = Resources.getResourceAsStream(resource);
//2.创建SQLSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//3.创建SqlSession对象
SqlSession sqlSession = factory.openSession();
Student student = new Student();
student.setSname("ZhaoBa");
student.setAge("21");
student.setCourse("Java");
//4.调用SqlSession的insert()方法查询
int result = sqlSession.insert("student.addStudent",student);
if(result>0){
System.out.println("成功插入"+result+"条数据");
}else{
System.out.println("插入操作失败");
}
//5.提交事务
sqlSession.commit();
//6.关闭SqlSession
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
4.3 修改(update)
- TestUpdate.java 代码如下:
package com.qfedu.test;
import com.qfedu.pojo.Student;
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;
public class TestUpdate {
public static void main(String[] args) {
//1.读取配置文件
String resource = "mybatis-config.xml";
try {
InputStream in = Resources.getResourceAsStream(resource);
//2.创建SQLSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//3.创建SqlSession对象
SqlSession sqlSession = factory.openSession();
Student student = new Student();
student.setSname("WuJiu");
student.setSid(7);
student.setCourse("Python");
//4.调用SqlSession的update()方法查询
int result = sqlSession.insert("student.updateStudent",student);
if(result>0){
System.out.println("成功更新"+result+"条数据");
}else{
System.out.println("更新操作失败");
}
//5.提交事务
sqlSession.commit();
//6.关闭SqlSession
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
4.4 删除(delete)
- TestDelete.java 代码如下:
package com.qfedu.test;
import com.qfedu.pojo.Student;
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;
public class TestDelete {
public static void main(String[] args) {
//1.读取配置文件
String resource = "mybatis-config.xml";
try {
InputStream in = Resources.getResourceAsStream(resource);
//2.创建SQLSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//3.创建SqlSession对象
SqlSession sqlSession = factory.openSession();
//4.调用SqlSession的delete()方法查询
int result = sqlSession.delete("student.deleteStudent",7);
if(result>0){
System.out.println("成功删除"+result+"条数据");
}else{
System.out.println("删除操作失败");
}
//5.提交事务
sqlSession.commit();
//6.关闭SqlSession
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
5 总结
Mybatis是一款优秀的ORM(对象-关系映射)框架,它支持自定义SQL、存储过程以及高级映射。几乎避免了所有的JDBC代码和手动设置参数以及获取结果集。
MyBatis的工作流程图: