- 创建一个maven项目,以及一个数据库school在数据库创建一个表student(项目的github地址:https://github.com/wangxian01/MyBatis01)
- 配置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>MyBatis01</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.4</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
<scope>test</scope>
</dependency>
</dependencies>
</project>
- 创建学生实体类和学生dao接口
package com.wangxian.mybatis01.entity;
public class Student {
private Integer id;
private String name;
private String age;
private String sex;
private String address;
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "Student{" +
"id=" + id +
", name='" + name + '\'' +
", age='" + age + '\'' +
", sex='" + sex + '\'' +
", address='" + address + '\'' +
'}';
}
}
package com.wangxian.mybatis01.dao;
import com.wangxian.mybatis01.entity.Student;
import java.util.List;
public interface StudentDao {
List<Student> findAllStudent();
void SaveStudent(Student student);
void updateStudent(Student student);
void deleteStudent(Integer integer);
}
- 在项目的resources下创建一个SqlMapConfig.xml文件,在这个文件中配置连接mysql所需
<?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">
<!--配置mysql环境-->
<environment id="mysql">
<!--配置事务-->
<transactionManager type="JDBC"></transactionManager>
<!--配置连接池-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<!--数据库,我的数据库名为school-->
<property name="url" value="jdbc:mysql://localhost:3306/school"/>
<!--数据库账号-->
<property name="username" value="root"/>
<!--数据库密码-->
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!-- 配置映射文件位置-->
<mappers>
<mapper resource="com/wangxian/mybatis01/dao/StudentDao.xml"></mapper>
</mappers>
</configuration>
- 在resources下创建和StudentDao相同的包结构,再在包中创建StudentDao.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="com.wangxian.mybatis01.dao.StudentDao">
<!--查找所有学生信息-->
<select id="findAllStudent" resultType="com.wangxian.mybatis01.entity.Student">
select * from student
</select>
<!--新增学生信息-->
<insert id="SaveStudent" parameterType="com.wangxian.mybatis01.entity.Student">
insert into student(name,age,sex,address)values (#{name},#{age},#{sex},#{address});
</insert>
<!--根据id修改学生信息-->
<update id="updateStudent" parameterType="com.wangxian.mybatis01.entity.Student">
update student set name=#{name},age=#{age},sex=#{sex},address=#{address} where id=#{id}
</update>
<!--根据id删除学生信息-->
<delete id="deleteStudent" parameterType="java.lang.Integer">
delete from student where id=#{uid}
</delete>
</mapper>
- 再创建一个测试类测试刚刚的接口
package com.wangxian.mybatis01.dao;
import com.wangxian.mybatis01.entity.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 org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class StudentDaoTest {
private InputStream inputStream;
private SqlSession sqlSession;
private StudentDao studentDao;
@Before
public void before() throws IOException {
inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
sqlSession = factory.openSession();
studentDao = sqlSession.getMapper(StudentDao.class);
}
@After
public void after() throws IOException {
sqlSession.commit();
sqlSession.close();
inputStream.close();
}
@Test
public void findAllStudent() {
List<Student> studentList = studentDao.findAllStudent();
for (Student student:studentList) {
System.out.println(student.toString());
}
}
@Test
public void saveStudent() {
Student student = new Student();
student.setName("李四");
student.setAge("16");
student.setSex("女");
student.setAddress("北京市朝阳区");
studentDao.SaveStudent(student);
}
@Test
public void updateStudent() {
Student student = new Student();
student.setId(1);
student.setName("张五");
student.setAge("50");
student.setSex("女");
student.setAddress("成都市武侯区");
studentDao.updateStudent(student);
}
@Test
public void deleteStudent() {
studentDao.deleteStudent(1);
}
}