MyBatis基础(二)增删改查
conf文件配置信息:
conf.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://127.0.0.1:3306/user_mybatis?characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="111111"/>
</dataSource>
</environment>
</environments>
<!-- 配置映射文件:用来配置sql语句和结果集类型等 -->
<mappers>
<mapper resource="pers/qiu/entity/StudentMapper.xml"/>
</mappers>
</configuration>
- conf.xml中环境可以有很多个:例如上面的id为development的就是开发环境,还可以有测试环境、运行环境。因为在不同机器上数据库信息不同。
选择环境使用environments标签中的default属性选择。
环境的选择也可以从java代码中手动选择:
Reader reader = Resources.getResourcesAsReader("conf.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader, "development");
- transactionManager:是事物的提交方式,有:
- JDBC:利用JDBC方式处理事物(也就是手动commit、rollback、close)
- MANAGED:将事物交给其他组件进行托管(用spring、jobss),使用这种方式默认每次使用完都会自动关闭。如果想关闭自动关闭,使用以下代码进行配置:
<transactionManager type="MANAGED"/>
<propertity name="closeConnection" value"false"/>
使用对象作为参数进行CUDR
#{}的使用方法
- 当参数类型为8种基本类型以及String类型时,#{}中参数名可以随便写。因为这九种类型只有一个值,所以mybatis可以识别出来。
- 当参数为对象时,#{}中参数只能是对象中的属性,不用是对象.属性。
查
参数为基本类型+String
session.selectOne(statement, param)
<mapper namespace="pers.qiu.entity.StudentMapper">
<!--查询一个-->
<select id="selectStudentById" parameterType="int" resultType="pers.qiu.entity.Student">
select * from student where id = #{id}
</select>
</mapper>
注意:Mybatis在形式上只能有一个参数类型(也就是一个值),但是可以在逻辑上变通传递多个参数:使用集合、列表等数据结构。
参数为对象
所以如果有多个条件的查询可以例如以下代码:
<mapper namespace="pers.qiu.entity.StudentMapper">
<select id="selectStudentByIdAndName" parameterType="pers.qiu.entity.Student" resultType="pers.qiu.entity.Student">
selsct * from student where id=#{id} and name=#{name}
</select>
</mapper>
#{id}、#{name}是因为Student类中属性名是id、name。
返回值有多个的情况
注意!无论返回一个还是多个元组,resultType都是一个类型(不用写什么数组类型等)例如:int或pers.qiu.entity.StudentMapper。 只不过改Java代码就可以接受多个返回值。
List<Student> studends = session.selectList(statement);
增
int count = session.insert(statement, param);
//count是增加的元组数量
//使用JDBC方式提交后,需要手动提交以下事务
session.commit();
<mapper namespace="pers.qiu.entity.StudentMapper">
<insert id="insertStudent" parameterType="pers.qiu.entity.Student">
insert into student values (#{id}, #{name}, #{age})
</insert>
</mapper>
增因为没有返回值所以可以不用写。
删
int count = session.delete(statement, param);
session.commit();
<mapper namespace="pers.qiu.entity.StudentMapper">
<delete id="deleteStudentById" parameterType="int">
delete from student where id = #{id}
</delete>
</mapper>
删除因为没有返回值所以不用写返回类型。
改
int count = session.update(statement, param);
<mapper namespace="pers.qiu.entity.StudentMapper">
<update id="updateStudent" parameterType="pers.qiu.entity.Student">
update student set `name`=#{name}, age=#{age} where id=#{id}
</update>
</mapper>
总结
在mybatis中conf文件写项目的配置信息(例如数据库信息)。 mapper映射文件中写实体类的CUDR操作(所以一个mapper对应一个实体类)。具体操作代码由java代码中的session连接执行,增删改只有一次操作所以只有一个session函数与之对应,但是查询可能会由多个结果所以出现了selectOne、selectList,通过动态代理模式将之转换成相应类型。
-------------------------------------千万要注意增删改后要commit提交才能持久化数据-------------------------------------------
小例子:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org/DTD Mapper 3.0"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="pers.qiu.entity.StudentMapper">
<select id="selectStudentByAgeAndName" parameterType="pers.qiu.entity.Student" resultType="pers.qiu.entity.Student">
select * from student where age=#{age} and `name`=#{name}
</select>
<select id="selectStudentById" parameterType="pers.qiu.entity.Student" resultType="pers.qiu.entity.Student">
select * from student where id = #{id}
</select>
<select id="selectAllStudent" resultType="pers.qiu.entity.Student">
select * from student
</select>
<insert id="insertStudent" parameterType="pers.qiu.entity.Student">
insert into student values (#{id}, #{name}, #{age})
</insert>
<delete id="deleteStudentById" parameterType="int">
delete from student where id = #{id}
</delete>
<update id="updateStudent" parameterType="pers.qiu.entity.Student">
update student set id=#{id}, `name`=#{name}, age=#{age}
</update>
</mapper>
package pers.qiu.service;
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 pers.qiu.entity.Student;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
/**
* @program: MybatisStudyTwo
* @description: test student mybatis
* @author: qiucehao
* @create: 2020-11-13 09:35
**/
public class StudentService {
public Student selectStudentByAgeAndName(String name, int age){
Reader resourceAsReader = null;
SqlSessionFactory build = null;
SqlSession sqlSession = null;
try {
resourceAsReader = Resources.getResourceAsReader("conf.xml");
build = new SqlSessionFactoryBuilder().build(resourceAsReader);
sqlSession = build.openSession();
Student student = new Student(1, name, age);
String statement = "pers.qiu.entity.StudentMapper.selectStudentByAgeAndName";
Student getStudent = sqlSession.selectOne(statement, student);
if (sqlSession != null)
sqlSession.close();
return getStudent;
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
public Student selectStudentById(int id){
Reader resourceAsReader = null;
SqlSessionFactory build = null;
SqlSession sqlSession = null;
try {
resourceAsReader = Resources.getResourceAsReader("conf.xml");
build = new SqlSessionFactoryBuilder().build(resourceAsReader);
sqlSession = build.openSession();
String statement = "pers.qiu.entity.StudentMapper.selectStudentById";
Student getStudent = sqlSession.selectOne(statement, id);
if (sqlSession != null)
sqlSession.close();
return getStudent;
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
public List<Student> selectAllStudent(){
List<Student> students = null;
try {
Reader reader = Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement = "pers.qiu.entity.StudentMapper.selectAllStudent";
students = session.selectList(statement);
if (session != null)
session.close();
} catch (IOException e) {
e.printStackTrace();
}
return students;
}
public int insertStudent(Student student){
try {
Reader reader = Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement = "pers.qiu.entity.StudentMapper.insertStudent";
int count = session.insert(statement, student);
session.commit();
if (session != null)
session.close();
return count;
} catch (IOException e) {
e.printStackTrace();
}
return 0;
}
public int deleteStudentById(int id){
try {
Reader reader = Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement = "pers.qiu.entity.StudentMapper.deleteStudentById";
int count = session.delete(statement, id);
session.commit();
if (session != null)
session.close();
return count;
} catch (IOException e) {
e.printStackTrace();
}
return 0;
}
public int updateStudent(Student student){
try {
Reader reader = Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement = "pers.qiu.entity.StudentMapper.updateStudent";
int count = session.update(statement, student);
session.commit();
if (session != null)
session.close();
return count;
} catch (IOException e) {
e.printStackTrace();
}
return 0;
}
public static void main(String[] args) throws IOException {
StudentService studentService = new StudentService();
Student student = new Student(0, "za", 21);
int count = studentService.insertStudent(student);
Student student1 = studentService.selectStudentById(1);
System.out.println(count);
System.out.println(student1.getName());
}
}