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"),*/
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);
}
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);
}