带条件查询
mapper文件的内容:
<select id="getSelectElectron" resultType="electron">
select * from electron where date > #{date}
</select>
select的实现:
public void getSelectElectron() throws Exception {
Date date =new SimpleDateFormat("yyyy-MM-dd").parse("2015-12-31");
List<electron> getalluser = sqlSession.getMapper(ElectronDao.class).getSelectElectron(date);
for (electron user: getalluser) {
System.out.println(user.getType());
}
}
增加操作
mapper文件的内容:
<insert id="InsElectronDao" useGeneratedKeys="true" keyProperty="id" parameterType="electron">
insert into electron (id,type,price,date) values (#{id},#{type},#{price},#{date})
</insert>
insert的实现:
//添加操作
public void InsElectronDao() throws Exception {
BigDecimal decimal =new BigDecimal("2356.23");
Date date =new SimpleDateFormat("yyyy-MM-dd").parse("2016-10-25");
electron elect = new electron(5,"CDMA-2", decimal,date);
Integer integer = sqlSession.getMapper(ElectronDao.class).InsElectronDao(elect);
System.out.println("id："+elect.getId());
if (integer>0){
sqlSession.commit();
System.out.println("添加成功！");
}else{
System.out.println("添加失败!");
}
}
修改操作
mapper文件的内容:
<update id="UpdateElectronDao" parameterType="electron">
update electron set type=#{type},price=#{price},date=#{date} where id=#{id}
</update>
update的实现：
//修改操作
public void UpdateElectronDao() throws Exception {
BigDecimal decimal =new BigDecimal("2356.23");
Date date =new SimpleDateFormat("yyyy-MM-dd").parse("2016-10-25");
electron elect = new electron(2,"CDMA-2", decimal,date);
Integer integer = sqlSession.getMapper(ElectronDao.class).UpdateElectronDao(elect);
if (integer>0){
sqlSession.commit();
System.out.println("修改成功！");
}else{
System.out.println("修改失败!");
}
}
删除的操作：
mapper文件的内容:
<delete id="DelElectronDao">
delete from electron where id=#{id}
</delete>
delete的实现:
//删除操作
public void DelElectronDao() throws Exception {
Integer integer = sqlSession.getMapper(ElectronDao.class).DelElectronDao(4);
if (integer>0){
sqlSession.commit();
System.out.println("删除成功！");
}else{
System.out.println("删除失败!");
}
}
原文：https://www.cnblogs.com/wishsaber/p/11604133.html