示例说明
使用方法
继承BaseDAO
重写BaseDAO的构造器
使用new关键字实例化,使用Dao的方法操作数据库
简单示例
public class IpuMemberInfoDao extends BaseDAO {
private static transient Logger log = Logger.getLogger(IpuMemberInfoDao.class);
public IpuMemberInfoDao(String connName) throws Exception {
super(connName);
}
public DatasetList getInfos(IData params) {
DatasetList infos = new DatasetList();
try {
IData datas = this.queryList("select * from IpuMemberInfo s where s.STAFFID = :StaffID",params).first();
infos.add(datas);
if (log.isDebugEnabled()){
log.debug("查询到的数据为" + datas == null ? "null" : datas.toString());
}
} catch (Exception e) {
e.printStackTrace();
return null;
}
return infos;
}
public boolean updateInfos(IDataset infos) throws Exception{
IData data = infos.getData(0);
boolean resultFlag = this.update("IpuMemberInfo", data, new String[]{"STAFFID"});
if (log.isDebugEnabled()){
log.debug(resultFlag ? "数据更新成功" : "数据更新失败");
}
this.commit();
return resultFlag;
}
public boolean insertInfos(IDataset infos) throws Exception{
IData data = infos.getData(0);
boolean resultFlag = this.insert("IpuMemberInfo", data);
if (log.isDebugEnabled()){
log.debug(resultFlag ? "数据插入成功" : "数据插入失败");
}
this.commit();
return resultFlag;
}
public boolean deleteInfos(IDataset staffid) throws Exception{
IData data = staffid.getData(0);
boolean resultFlag = this.delete("IpuMemberInfo", data , new String[]{ "STAFFID" });
if (log.isDebugEnabled()){
log.debug(resultFlag ? "数据删除成功" : "数据删除失败");
}
this.commit();
return resultFlag;
}
}