现在有一个表(student),我们利用SpringBoot集成Mybatis进行数据库操作
SpringBoot集成Mybatis的结构
不使用注解
(1)首先编写数据库的Pojo映射类
@Data
public class Student {
private int id;
private String schoolnum;
private String grade;
private String name;
private String gender;
private int chinese;
private int english;
private int math;
private int score;
}
(2)设计Dao层
@Repository
public interface UseXmlDao {
List<Student> selectAll(); //无参
List<Student> queryAll(String grade,String gender); //有参
}
(3)设计Service层
//Service接口
@Service
public interface UserService {
List<Student> selectALL();
List<Student> checkALL(Student student);
}
//Service接口实现
@Service
public class UserServiceImp implements UserService {
@Autowired
private UseXmlDao useXmlDao;
//无参
@Override
public List<Student> selectALL() {
List<Student> students = useXmlDao.selectAll();
return students;
}
//有参
@Override
public List<Student> queryALL(String grade,String gender) {
List<Student> students = useXmlDao.queryAll(grade,gender);
return students;
}
}
(4)设计Controller层
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping ("/wucan")
public @ResponseBody List<Student> selcetAll(){
List<Student> students = userService.selectALL();
return students;
}
@RequestMapping ("/youcan")
public @ResponseBody List<Student> queryAll(String grade,String gender){
List<Student> students = userService.queryALL(grade,gender);
return students;
}
}
(5)编写Xml,也可以在Dao层接口上使用@Select注解
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xiaosuda.boot.Dao.UseXmlDao">
<select id="queryAll" resultType="com.xiaosuda.boot.Pojo.Student">
select * from student
where
grade = #{grade}
and
gender = #{gender}
</select>
<select id="selectAll" resultType="com.xiaosuda.boot.Pojo.Student">
select * from student
order by grade
</select>
<mapper>
(6)启动SpringBoot工程,查询结果
无参查询结果
有参查询结果
有参查询中,使用Get请求方式,在URL中向后端传递参数
使用@Param注解(常用)
当有参数传递时,不使用注解,需要在Controller层,Service层传入Dao层需要的具体参数
(比如gender,grade),非常不方便,使用@Param注解时,可以传入Pojo映射对象,在xml中在具体说明参数。
//Controller层
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping ("/zhujie")
public @ResponseBody List<Student> checkALL(Student student){
List<Student> students = userService.checkALL(student);
System.out.println(students);
return students;
}
}
//Service接口层
@Service
public interface UserService {
List<Student> checkALL(Student student);
}
//service实现层
@Service
public class UserServiceImp implements UserService {
@Autowired
private UseXmlDao useXmlDao;
@Override
public List<Student> checkALL(Student student) {
List<Student> students = useXmlDao.checkAll(student);
System.out.println("Service"+students);
return students;
}
}
//DAO层
@Repository
public interface UseXmlDao {
List<Student> checkAll(@Param("S")Student student); //使用注解@Param
}
//XML文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xiaosuda.boot.Dao.UseXmlDao">
<select id="checkAll" resultType="com.xiaosuda.boot.Pojo.Student" >
select * from student
where
student.score > #{S.score}
and
student.gender = #{S.gender} //等号左边为数据库参数,等号右边为Pojo类参数
</select>
</mapper>
优点:(1)可以在xml中,动态的确定sql语句条件的个数,没有限定死
(2)可以传入多个Pojo类,进行复杂查询
(3)也可直接在第一种方法加@Param(即传入基本类型),xml中填#{ 注解value}
@Param注解查询结果
提示:使用URL进行传参,参数为数据库参数