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) { 
this.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;

<&＃63;xml version="1.0" encoding="UTF-8" &＃63;> 
 
 
 
 
 
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} 
 
 
 
 
 
 
 
 
 
 
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} 
 
 
 
select * 
from student 
 
 
id>2 
 
 
and name like '%g%' 
 
 
 
 
 
 
 
 
 
 
{call get_all_student(#{students ,mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=studentMap} )} 
 
 
 
 
select stu_id_sequence.nextval from dual 
 
insert into student(id,name,birth) values(#{id},#{name},#{birth}) 
 
 
 
 where id=#{id} 
 
 
 
 order by id