①导入相关依赖:
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.0.11.RELEASE</version>
</dependency>
</dependencies>
②创建实体类
public class Student {
int id;
String name;
public void setId(int id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "Student{" +
"id=" + id +
", name='" + name + '\'' +
'}';
}
}
③创建DAO接口及实现类
接口:
import Pojo.Student;
import java.util.List;
public interface StudentDao {
List<Student> getStudents();
}
实现类:
import Pojo.Student;
import org.mybatis.spring.SqlSessionTemplate;
import java.util.List;
public class StudentDaoImpl implements StudentDao{
SqlSessionTemplate sqlSessionTemplate;
public List<Student> getStudents() {
StudentDao studentDao=sqlSessionTemplate.getMapper(StudentDao.class);
return studentDao.getStudents();
}
public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate){
this.sqlSessionTemplate=sqlSessionTemplate;
}
}
④创建service接口及实现类:
接口:
import Pojo.Student;
import java.util.List;
public interface StudentService {
List<Student> getStudent();
}
实现类:
import Dao.StudentDao;
import Pojo.Student;
import java.util.List;
public class StudentServiceImpl implements StudentService{
StudentDao studentDao=null;
public List<Student> getStudent() {
return studentDao.getStudents();
}
public void setStudentDao(StudentDao studentDao){
this.studentDao=studentDao;
}
}
⑤创建mybatis配置文件和对于应的mapper
mybatis配置文件:(甚至可以不用,因为配置都可以在spring中配置)
<?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>
<typeAliases>
<package name="Pojo"/>
</typeAliases>
<mappers>
<!--<mapper resource="studentMapper.xml"/>-->
</mappers>
</configuration>
mapper:
<?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="Dao.StudentDao">
<select id="getStudents" resultType="Pojo.Student">
select * from student
</select>
</mapper>
⑥创建spring配置文件,将需要实例化的依赖进行注入:
⑦编写测试类
import Service.StudentService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Test {
public static void main(String args[]){
ApplicationContext context=new ClassPathXmlApplicationContext("Application.xml");
StudentService studentService= (StudentService) context.getBean("studentService");
System.out.println(studentService.getStudent());
}
}
运行结果: