MyBatis学习笔记：使用MyBatis对数据库进行操作

使用MyBatis框架进行基本数据库操作简单例子

注：这里的jar包根据自己的具体情况去官网下载，建议将自己项目可能需要的jar包新建一个jar文件夹放入，然后将具体使用的jar包build path加到项目中

以下是各文件夹下的代码：

com.briup.mappers下的文件
package com.briup.mappers;

import com.briup.pojo.Student;
import java.util.List;

//创建映射器Mapper接口StudentMapper
//方法名和StudentMapper.xml中定义的SQL映射定义名相同
//这个其实就是dao层接口(数据访问层,负责和数据库进行交互)
public interface StudentMapper {
	//StudentMapper.xml文件中有这些方法的实现
	List<Student> findAllStudents(); 
	Student findStudentById(Integer id); 
	void insertStudent(Student student);
	void deleteStudnet();
	void deleteStudnetById(Integer id);
}

<?xml version="1.0" encoding="UTF-8"?>
<!-- 引入dtd文件，自动提示功能，将 PUBLIC后面的地址复制，不要"";在widows下的prefences找到xml.catalog,然后add；key为复制PUBLIC；location则为dtd文件位置-->
<!---//mybatis.org//DTD Mapper 3.0//EN -->
			<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
			"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- com.briup.mappers.StudentMapper是我们定义接口的全限定名字 这样就可以使用接口调用映射的SQL语句了 这个名字一定要和接口对应上 -->
<mapper namespace="com.briup.mappers.StudentMapper">
	<!-- 需要返回Student的结果集时，使用 resultMap="StudentResult"-->
	<resultMap type="Student" id="StudentResult">
		<id property="studId" column="stud_id" />
		<result property="name" column="name" />
		<result property="email" column="email" />
		<result property="dob" column="dob" />
	</resultMap>
	<!-- 查询表中所有信息 -->
	<select id="findAllStudents" resultMap="StudentResult">
		SELECT * FROM STUDENTS
	</select>

		<!-- 列名和属性名字不一致可以给查询的列起一个别名 -->
	<select id="findStudentById" parameterType="int"
		resultType="Student">
		SELECT STUD_ID AS STUDID,NAME,EMAIL,DOB
		FROM STUDENTS
		WHERE
		STUD_ID=#{id}
	</select>
	
	<!-- 向表中插入学生数据 -->
	<insert id="insertStudent" parameterType="Student">
		INSERT INTO
		STUDENTS(STUD_ID,NAME,EMAIL,DOB)
		VALUES(#{studId},#{name},#{email},#{dob})
	</insert>
	
	<!-- 删除表中所有数据 -->
	<delete id="deleteStudnet" parameterType="Student">
		DELETE FROM
		STUDNETS
	</delete>
	
	<!-- 通过id删除某个学生 -->
	<delete id="deleteStudnetById" parameterType="int">
		DELETE FROM
		STUDENTS
		WHERE
		STUD_ID=#{id}
	</delete>
</mapper>

com.briup.pojo下的文件，实体类

package com.briup.pojo;

import java.util.Date;

public class Student {
	private Integer studId; 
	private String name; 
	private String email; 
	private Date dob;
	public Integer getStudId() {
		return studId;
	}
	public void setStudId(Integer studId) {
		this.studId = studId;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public Date getDob() {
		return dob;
	}
	public void setDob(Date dob) {
		this.dob = dob;
	}
	public Student() {
		super();
	}
	public Student(Integer studId, String name, String email, Date dob) {
		super();
		this.studId = studId;
		this.name = name;
		this.email = email;
		this.dob = dob;
	}
	@Override
	public String toString() {
		return "Studnet [studId=" + studId + ", name=" + name + ", email=" + email + ", dob=" + dob + "]";
	}
	
	
}

com.briup.utils下的文件

//这个类是在test类中调用该类中的方法创建Sqlsessoion对象
package com.briup.utils;


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;

public class MyBatisSqlSessionFactory {
	private static SqlSessionFactory sqlSessionFactory;

	public static SqlSessionFactory getSqlSessionFactory() {
		if (sqlSessionFactory == null) {
			InputStream inputStream = null;
			try {
				inputStream = Resources.getResourceAsStream("mybatis-config.xml");
				sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			} catch (IOException e) {
				e.printStackTrace();
				throw new RuntimeException(e.getCause());
			}
		}
		return sqlSessionFactory;
	}

	public static SqlSession openSession() {
		return openSession(false);
	}
		//autoCommit填false和上面的无参方法一样；false表示事物自己手动提交
	public static SqlSession openSession(boolean autoCommit) {
		return getSqlSessionFactory().openSession(autoCommit);
	}

}

db.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:XE
jdbc.username=briup
jdbc.password=briup

log4j.properties

log4j.rootLogger=DEBUG, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d [%-5p] %c - %m%n
#show sql
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- 引入dtd文件，自动提示功能，将 PUBLIC后面的地址复制，不要"";在widows下的prefences找到xml.catalog,然后add；key为复制PUBLIC；location则为dtd文件位置-->
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 读取db.properties文件中的数据key-value的形式 -->
	<properties resource="db.properties">
		  <!-- 设置默认值 -->
		  <!-- 注意:是dp.properties文件中的值优先级高；dp.properties文件中没配置才使用这里的默认值 -->
		  <property name="jdbc.username" value="briup" /> 
		  <property name="jdbc.password" value="briup" /> 
	</properties>
	<typeAliases>
		<typeAlias type="com.briup.pojo.Student" alias="Student" />
	</typeAliases>

	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
			<!-- 读取db.properties文件中的数据key-value的形式；获取driver，url，username，password -->
				<property name="driver"
					value="${jdbc.driverClassName}" />
				<property name="url"
					value="${jdbc.url}" />
				<property name="username" value="${jdbc.username}" />
				<property name="password" value="${jdbc.password}" />
			</dataSource>
		</environment>
	</environments>

	<mappers>
		<mapper resource="com/briup/mappers/StudentMapper.xml" />
	</mappers>

</configuration>

dtd文件是自动提示的配置文件，可去网上下载

测试类
com.briup.test

package com.briup.test;
import java.io.InputStream;
import java.util.Date;

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.briup.mappers.StudentMapper;
import com.briup.pojo.Student;
import com.briup.utils.MyBatisSqlSessionFactory;
public class StudentMapperTest {
	@Test
	public void test_insert1(){
		
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); 
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			
			StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
//			System.out.println(studentMapper.getClass());
			Student s = new Student(1,"tom","123@briup.com",new Date());	
			studentMapper.insertStudent(s);
			sqlSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	//使用MyBatisSqlSessionFactory工具类获取SqlSession对象
	@Test
	public void test_insert2(){
		
		try {
			//使用MyBatisSqlSessionFactory创建SqlSession对象，这样把创建SqlSession对象的固定步骤放到MyBatisSqlSessionFactory，
			//使用时调用方法openSession()创建SqlSession对象，相比上面的方法创建更方便
			  SqlSession openSession = MyBatisSqlSessionFactory.openSession();
			
			StudentMapper studentMapper = openSession.getMapper(StudentMapper.class);
//			System.out.println(studentMapper.getClass());
			Student s = new Student(2,"tom","123@briup.com",new Date());	
			studentMapper.insertStudent(s);
			openSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	@Test
	public void test_selectById(){
		
		try {
			  SqlSession openSession = MyBatisSqlSessionFactory.openSession();
			
			StudentMapper studentMapper = openSession.getMapper(StudentMapper.class);
//			System.out.println(studentMapper.getClass());
			Student stu = studentMapper.findStudentById(1);
			System.out.println(stu);
			openSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	@Test
	public void test_deleteByid(){
		
		try {
			  SqlSession openSession = MyBatisSqlSessionFactory.openSession();
			
			StudentMapper studentMapper = openSession.getMapper(StudentMapper.class);
//			System.out.println(studentMapper.getClass());
			studentMapper.deleteStudnetById(2);
			openSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
}

想要进行什么操作就运行哪个方法