用MyBatis实现数据的增删改查

来源:互联网 发布:淘宝上的衣服能买吗 编辑:程序博客网 时间:2024/05/21 06:18
package dao;


import java.util.List;


import javax.security.auth.Subject;
import javax.xml.ws.RequestWrapper;


import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Many;
import org.apache.ibatis.annotations.One;
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 entity.Grade;

public interface SubjectDao {
@Select("select * from subject")
@Results({
/* @Result(column="subjectNo" ,id =true,property="subjectNo"),
@Result(property="subjectName",column="gradeName"),
@Result(property="classHour",column="classHour"),*/

/*@Result(property="gradeId",column="gradeId"),*/

//propert用于指定返回值类型column用于指定select="dao.GradeDao.findById")的这个函数的参数

@Result(property="grade",column="gradeId",
  one=@One(select="dao.GradeDao.findById")),
})
public List<entity.Subject> findAllSubject();
@Insert("insert into subject values (null,#{subjectName},#{classHour},#{gradeId})")
public void addSubject (entity.Subject s);
@Delete("delete from subject where subjectNo=#{subjectNo}")
public void deleteSubject (int id);
@Update("update  subject set subjectName=#{subjectName} where subjectNo=(#{subjectNo})")
public void updateSubject(entity.Subject subject);


}