MyBatis资源文件xxx.do.xml增删改查语句规范

最新推荐文章于 2024-01-17 03:03:55 发布

struggle小白

最新推荐文章于 2024-01-17 03:03:55 发布

阅读量221

点赞数

分类专栏： MyBatis

本文链接：https://blog.csdn.net/rdz_NNN/article/details/87890874

版权

本文主要介绍了MyBatis中资源文件xxxDao.xml的增删改查语句规范，包括如何在主配置文件中注册以及对应的测试类test.java的编写注意事项。

摘要由CSDN通过智能技术生成

一：在主资源文件注册完毕的配置资源文件 xxxDao.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.rdz.dao.StudentDao">
	 
	 <select id="getTotal" resultType="int">
	 
	 	select count(*) from tbl_student
	 
	 </select>
	 
	 <select id="getAll" resultType="student">
	 
	 	select * from tbl_student
	 
	 </select>
	 
	 <insert id="save">
	 
	 	insert into tbl_student(id,name,age) values(#{id},#{name},#{age})
	 
	 </insert>
	
	 <select id="getById" parameterType="java.lang.String" 
	 resultType="com.rdz.domain.Student">
	 
	 	select * from tbl_student where id=#{id}
	 	
	 </select>
	 
	 <select id="select1" parameterType="String" resultType="Student">
	 
	 	select * from tbl_student where id=#{id}
	 	
	 </select>
	 
	 <select id="select2" parameterType="int" resultType="Student">
	 
	 	select * from tbl_student where age=#{age}
	 
	 </select>
	 
	 <select id="select3" parameterType="Student" resultType="Student">
	 
	 	select * from tbl_student where id=#{id}
	 
	 </select>
	 
	 <select id="select4" parameterType="Student" resultType="Student">
	 
	 	select * from tbl_student where name=#{name} and age=#{age}
	 
	 </select>
	 
	 <select id="select5" parameterType="map" resultType="Student">
	 
	 	select * from tbl_student where name=#{name123} and age=#{age}
	 
	 </select>
	 
	 <select id="select6" resultType="Student">
	 
	 	select * from tbl_student where id='${value}'
	 
	 </select>
	 
	 <select id="select7" resultType="Student">
	 
	 	select * from tbl_student where name like '%${value}%'
	 
	 </select>
	 
	 <select id="select8" resultType="Student">
	 
	 	select * from tbl_student where name like #{name}
	 
	 </select>
	 
	 <!-- 
	 
	 	注意如下使用方式一定是   '%'空格#{name}空格'%'
	 	空格不能省略掉
	 
	  -->
	 <select id="select9" resultType="Student">
	 
	 	select * from tbl_student where name like '%' #{name} '%'
	 
	 </select>
	 
	 <select id="select10" resultType="int">
	 
	 	select count(*) from tbl_student
	 
	 </select>
	 
	 <select id="select11" resultType="String">
	 
	 	select name from tbl_student
	 
	 </select>
	 
	 &