用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"),*/
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);
}
阅读全文
0 0
- mybatis ---- 实现数据的增删改查
- MyBatis实现数据的增删查改
- Mybatis实现数据的增删改查
- 用MyBatis实现数据的增删改查
- mybatis实现的对数据的增删查改
- mybatis实现的对数据的增删查改
- Mybatis实现的对数据的增删查改
- Mybatis学习(3)实现数据的增删改查
- Mybatis实现数据的增删改查(CRUD)
- Mybatis实现数据的增删改查(CRUD)
- MyBatis 通配,实现数据的增删改查
- Mybatis实现数据的增删改查(CRUD)
- MyBatis第三步、实现数据的增删改查
- Mybatis实现数据的增删改查(CRUD)
- Mybatis入门学习三:实现数据的增删改查
- Mybatis实现数据的增删改查(CRUD)
- Mybatis实现数据的增删改查(CRUD)
- mybatis实现的增删改查例子
- 积木大赛 洛谷p1969
- 希尔排序(C语言版本)
- Hello,World
- 如何获取发布版SHA1和调试版的SHA1
- Java实现-子树
- 用MyBatis实现数据的增删改查
- UVa 10288(Coupons) 数学期望(概率+递推) Java
- 加载进度条
- jzoj 3518_进化序列_模拟
- stl-vector
- json总结
- order by实现数据排序
- 蒙层
- Android_广播大全