MyBatis存储过程、MyBatis分页、MyBatis一对多增删改查操作
一、用到的实体类如下：
Student.java
packagecom.company.entity;
importjava.io.Serializable;
importjava.util.Date;
publicclassStudentimplementsSerializable{
privatestaticfinallongserialVersionUID=1L;
privateintid;
privateStringname;
privateDatebirth;
privateGroupgroup;
publicGroupgetGroup(){
returngroup;
}
publicvoidsetGroup(Groupgroup){
this.group=group;
}
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicDategetBirth(){
returnbirth;
}
publicvoidsetBirth(Datebirth){
this.birth=birth;
}
@Override
publicStringtoString(){
return"Student[birth="+birth+",group="+group+",id="+id
+",name="+name+"]";
}
}
Group.Java
packagecom.company.entity;
importjava.util.List;
publicclassGroup{
privateintid;
privateStringname;
privateStringposition;
privateList<Student>students;
publicList<Student>getStudents(){
returnstudents;
}
publicvoidsetStudents(List<Student>students){
this.students=students;
}
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicStringgetPosition(){
returnposition;
}
publicvoidsetPosition(Stringposition){
this.position=position;
}
@Override
publicStringtoString(){
return"Group[id="+id+",name="+name+",position="+position
+"]";
}
}
二、实体对应的表结构
student表:
createtablestudent( idintprimarykey, namevarchar(20), birthdate, group_idintreferencesg_group(g_id));
g_group表:
createtableg_group( g_idintprimarykey, g_namevarchar(20), g_positionvarchar(30));
sequence:
createsequencestudent_id_sequence; createsequencegroup_id_sequence;
三、Student和Group的映射文件如下，你可以在映射文件中找到，关于MyBatis的增删改查操作，MyBatis调用存储过程，MyBatis分页以及MyBatis对一对一、多对多的处理
xml文件中都标有注释，看的时候配合下面的具体实现看，虽然有点乱
student.xml
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mappernamespace="com.company.dao.IStudentDAO">
<!--mybatis缓存-->
<cacheeviction="LRU"flushInterval="600000"size="1024"readOnly="false"/>
<!--sql标签用来定义一些可以被重用的sql语句或字段或片段等-->
<sqlid="studentColumns">selectid,name,birthfromstudent</sql>
<!--此处获得多对一的关系,但就单条记录而言却是一对一的关系，所以一对一的写法跟此相同-->
<resultMaptype="Student"id="getStudentAndGroup">
<idcolumn="id"property="id"/>
<resultcolumn="name"property="name"/>
<resultcolumn="birth"property="birth"/>
<associationproperty="group"column="group_id"javaType="Group">
<idcolumn="g_id"property="id"/>
<resultcolumn="g_name"property="name"/>
<resultcolumn="g_position"property="position"/>
</association>
</resultMap>
<selectid="many2one"resultMap="getStudentAndGroup"parameterType="int">
selects.id,s.name,s.birth,s.group_id,g.g_id,g.g_name,g.g_position
fromstudents
leftjoing_groupgons.group_id=g.g_id
wheres.id=#{id}
</select>
<!--意图是获得一个学生，并且获得该学生所属的组，跟上面的意思差不多,用association的select属性-->
<!--于上面的相比个人感觉上面的效率要高些，因为上面只有一条sql语句-->
<resultMaptype="Student"id="getStudentAndGroupUseSelectMap">
<idcolumn="id"property="id"/>
<resultcolumn="name"property="name"/>
<resultcolumn="birth"property="birth"/>
<associationproperty="group"column="group_id"javaType="Group"select="selectGroup"/>
</resultMap>
<selectid="getStudentAndGroupUseSelect"resultMap="getStudentAndGroupUseSelectMap"parameterType="int">
select*
fromstudent
whereid=#{id}
</select>
<selectid="selectGroup"resultType="Group"parameterType="int"flushCache="false"useCache="true"><!--此处实用缓存-->
selectg_idasid,g_nameasname,g_positionasposition
fromg_group
whereg_id=#{id}
</select>
<!--动态sql语句的测试dynamicsql-->
<selectid="getStudentBySomeCondition"parameterType="Student"resultType="Student">
select*
fromstudent
<where>
<iftest="id!=null">
id>2
</if>
<iftest="name!=null">
andnamelike'%g%'
</if>
</where>
</select>
<!--MyBatis调用存储过程-->
<resultMaptype="Student"id="studentMap">
<idcolumn="id"property="id"/>
<resultcolumn="name"property="name"/>
<resultcolumn="birth"property="birth"/>
</resultMap>
<selectid="getAllUser"statementType="CALLABLE">
{callget_all_student(#{students,mode=OUT,jdbcType=CURSOR,javaType=ResultSet,resultMap=studentMap})}
</select>
<!--MyBatis向student表中插入一条数据-->
<insertid="add"parameterType="Student"keyColumn="id">
<selectKeykeyProperty="id"order="BEFORE"resultType="int">
selectstu_id_sequence.nextvalfromdual
</selectKey>
insertintostudent(id,name,birth)values(#{id},#{name},#{birth})
</insert>
<!--根据id获得学生的信息-->
<selectid="getById"parameterType="int"resultType="Student">
<includerefid="studentColumns"/>whereid=#{id}
</select>
<!--此处的实现方法是一个分页的原型,请查看IStudentDAOImpl.java中的调用方法-->
<selectid="getAllStudent"resultMap="studentMap">
<includerefid="studentColumns"/>orderbyid<!--此处是引用了上面预定义好的sql语句-->
</select>
</mapper>
以上所述是小编给大家介绍的MyBatis存储过程、MyBatis分页、MyBatis一对多增删改查操作，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！