MyBatis存储过程、MyBatis分页、MyBatis一对多增删改查操作

 package com.company.entity; import java.io.Serializable; import java.util.Date; public class Student implements Serializable{ private static final long serialVersionUID = 1L; private int id; private String name; private Date birth; private Group group; public Group getGroup() { return group; } public void setGroup(Group group) { this.group = group; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Date getBirth() { return birth; } public void setBirth(Date birth) { this.birth = birth; } @Override public String toString() { return "Student [birth=" + birth + ", group=" + group + ", id=" + id + ", name=" + name + "]"; } }

 package com.company.entity; import java.util.List; public class Group { private int id; private String name; private String position; private List students; public List getStudents() { return students; } public void setStudents(List students) { this.students = students; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPosition() { return position; } public void setPosition(String position) { t<i style="color:transparent">来源gaodai$ma#com搞$$代**码)网</i>his.position = position; } @Override public String toString() { return "Group [id=" + id + ", name=" + name + ", position=" + position + "]"; } }

 create table student( id int primary key, name varchar(20), birth date, group_id int references g_group(g_id));

 create table g_group( g_id int primary key, g_name varchar(20), g_position varchar(30));

 create sequence student_id_sequence; create sequence group_id_sequence;

   <!-- mybatis缓存 --><!-- sql标签用来定义一些可以被重用的sql语句或字段或片段等 -->select id,name,birth from student<!-- 此处获得多对一的关系 ,但就单条记录而言却是一对一的关系，所以一对一的写法跟此相同-->   select s.id,s.name,s.birth,s.group_id,g.g_id,g.g_name,g.g_position from student s left join g_group g on s.group_id = g.g_id where s.id = #{id} <!-- 意图是获得一个学生，并且获得该学生所属的组，跟上面的意思差不多 ,用association的select属性--><!-- 于上面的相比个人感觉上面的效率要高些，因为上面只有一条sql语句 -->  select * from student where id = #{id} <!-- 此处实用缓存 --> select g_id as id, g_name as name, g_position as position from g_group where g_id = #{id} <!-- 动态sql语句 的测试dynamic sql--> select * from student   id>2  and name like '%g%' <!-- MyBatis调用存储过程 -->  {call get_all_student(#{students ,mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=studentMap} )} <!-- MyBatis向student表中插入一条数据 -->  select stu_id_sequence.nextval from dual  insert into student(id,name,birth) values(#{id},#{name},#{birth}) <!-- 根据id获得学生的信息 -->  where id=#{id} <!-- 此处的实现方法是一个分页的原型,请查看IStudentDAOImpl.java中的调用方法 -->  order by id<!--此处是引用了上面预定义好的sql语句-->