package com.java1234.mappers;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.One;
import com.java1234.model.Student;
public interface StudentMapper {
@Insert("insert into t_student values(null, #{name}, #{age})")
public int insertStudent(Student student);
@Update("update t_student set name = #{name}, age = #{age} where id = #{id}")
public int updateStudent(Student student);
@Delete("delete from t_student where id = #{id}")
public int deleteStudent(int id);
@Select("select * from t_student where id = #{id}")
public Student getStudentById(Integer id);
@Select("select * from t_student")
@Results(
{
@Result(id=true,column="id",property="id"),
@Result(column="name",property="name"),
@Result(column="age",property="age")
}
)
public List<Student> findStudents();
@Select("select * from t_student where id=#{id}")
@Results(
{
@Result(id=true,column="id",property="id"),
@Result(column="name",property="name"),
@Result(column="age",property="age"),
@Result(column="addressId", property="address", one=@One(select="com.java1234.mappers.AddressMapper.findById"))
}
)
public Student selectStudentWithAddress(int id);
@Select("select * from t_student where gradeId=#{gradeId}")
@Results(
{
@Result(id=true,column="id",property="id"),
@Result(column="name",property="name"),
@Result(column="age",property="age"),
@Result(column="addressId", property="address", one=@One(select="com.java1234.mappers.AddressMapper.findById"))
}
)
public Student selectStudentByGradeId(int gradeId);
}
MyBatisPro11_1.rar （29个子文件） 
MyBatisPro11_1 
.project 390B src com java1234 service StudentTest.java 1KB mappers AddressMapper.java 251B GradeMapper.java 639B StudentMapper.java 2KB model Grade.java 647B Student.java 1KB Address.java 700B util SqlSessionFactoryUtil.java 831B jdbc.properties 131B mybatis-config.xml 807B log4j.properties 335B .settings org.eclipse.jdt.core.prefs 598B jdbc 
mysql-connector-java-3.1.12-bin.jar 436KB log4j log4j-1.2.17.jar 478KB mybatis mybatis-3.2.8.jar 697KB .classpath 585B db_mybatis.sql 3KB bin com java1234 service StudentTest.class 2KB mappers GradeMapper.class 651B StudentMapper.class 2KB AddressMapper.class 337B model Address.class 1KB Grade.class 2KB Student.class 2KB util SqlSessionFactoryUtil.class 1KB jdbc.properties 131B mybatis-config.xml 807B log4j.properties 335B资源评论
