package cn.bdqn.jsp.dao.impl;
import java.util.ArrayList;
import java.util.List;
import cn.bdqn.jsp.dao.BaseDao;
import cn.bdqn.jsp.dao.StandardDao;
import cn.bdqn.jsp.entity.Standard;
import cn.bdqn.jsp.util.SQLHandler;
public class StandardDaoImpl extends BaseDao implements StandardDao {
@Override
public int save(Standard standard) {
try {
if(super.openDatabase()) {
String sql="insert into standard(id,stdnum,zhname,version,keys,releasedate,impldate,packagepath) "+
"values(std_id.nextval,?,?,?,?,?,?,?)";
java.sql.Date releaseDate=null;
if(null!=standard.getReleaseDate()) {
releaseDate=new java.sql.Date(standard.getReleaseDate().getTime());
}
java.sql.Date implDate=null;
if(null!=standard.getImplDate()) {
implDate=new java.sql.Date(standard.getImplDate().getTime());
}
Object[] params= {standard.getStdNum(),standard.getZhName(),standard.getVersion(),standard.getKeys(),releaseDate,implDate,standard.getPackagePath()};
return super.executeUpdate(sql, params);
}else {
return -1;
}
} catch (Exception e) {
e.printStackTrace();
return -1;
} finally {
closeResource();
}
}
@Override
public int update(Standard standard) {
try {
if(super.openDatabase()) {
String sql="update standard set stdnum=?,zhname=?,version=?,keys=?,releasedate=?,impldate=?,packagepath=? where id=?";
java.sql.Date releaseDate=null;
if(null!=standard.getReleaseDate()) {
releaseDate=new java.sql.Date(standard.getReleaseDate().getTime());
}
java.sql.Date implDate=null;
if(null!=standard.getImplDate()) {
implDate=new java.sql.Date(standard.getImplDate().getTime());
}
Object[] params= {standard.getStdNum(),standard.getZhName(),standard.getVersion(),standard.getKeys(),releaseDate,implDate,standard.getPackagePath(),standard.getId()};
return super.executeUpdate(sql, params);
}else {
return -1;
}
} catch (Exception e) {
e.printStackTrace();
return -1;
} finally {
closeResource();
}
}
@Override
public int delete(int id) {
try {
if(super.openDatabase()) {
String sql="delete from standard where id=?";
Object[] params= {id};
return super.executeUpdate(sql, params);
}else {
return -1;
}
} catch (Exception e) {
e.printStackTrace();
return -1;
} finally {
closeResource();
}
}
@Override
public Standard getById(int id) {
try {
if(super.openDatabase()) {
String sql="select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where id=?";
Object[] params= {id};
super.rs=super.executeQuery(sql, params);
if (rs.next()) {
Standard standard=new Standard();
standard.setId(rs.getInt("id"));
standard.setStdNum(rs.getString("stdnum"));
standard.setZhName(rs.getString("zhname"));
standard.setVersion(rs.getString("version"));
standard.setKeys(rs.getString("keys"));
standard.setReleaseDate(rs.getTimestamp("releasedate"));
standard.setImplDate(rs.getTimestamp("impldate"));
standard.setPackagePath(rs.getString("packagepath"));
return standard;
}else {
return null;
}
}else {
return null;
}
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
closeResource();
}
}
@Override
public List<Standard> getList(String queryCondition, int pageIndex, int pageSize) {
try {
if(super.openDatabase()) {
SQLHandler handler=new SQLHandler();
List<Standard> standards=new ArrayList<Standard>();
StringBuilder sql=new StringBuilder("select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where 1=1");
if(null!=queryCondition && !"".equals(queryCondition)){
sql.append(" and (stdnum like ? or zhname like ?)");
}
sql.append(" order by id");
if(null!=queryCondition && !"".equals(queryCondition)){
Object[] params={"%"+queryCondition+"%","%"+queryCondition+"%"};
String newSql=handler.getOraclePageSQL(sql.toString(), pageIndex, pageSize);
rs=executeQuery(newSql, params);
}else{
Object[] params={};
String newSql=handler.getOraclePageSQL(sql.toString(), pageIndex, pageSize);
rs=executeQuery(newSql, params);
}
while(rs.next()) {
Standard standard=new Standard();
standard.setId(rs.getInt("id"));
standard.setStdNum(rs.getString("stdnum"));
standard.setZhName(rs.getString("zhname"));
standard.setVersion(rs.getString("version"));
standard.setKeys(rs.getString("keys"));
standard.setReleaseDate(rs.getTimestamp("releasedate"));
standard.setImplDate(rs.getTimestamp("impldate"));
standard.setPackagePath(rs.getString("packagepath"));
standards.add(standard);
}
return standards;
}else {
return null;
}
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
closeResource();
}
}
@Override
public int getCount(String queryCondition) {
try {
if(openDatabase()) {
int result=0;
StringBuilder sql=new StringBuilder("select count(id) as cnt from standard where 1=1");
if(null!=queryCondition && !"".equals(queryCondition)){
sql.append(" and (stdnum like ? or zhname like ?)");
}
if(null!=queryCondition && !"".equals(queryCondition)){
Object[] params={"%"+queryCondition+"%","%"+queryCondition+"%"};
rs=executeQuery(sql.toString(), params);
}else{
Object[] params={};
rs=executeQuery(sql.toString(), params);
}
if(rs.next()) {
result=rs.getInt("cnt");
}
return result;
}else {
return 0;
}
} catch (Exception e) {
e.printStackTrace();
return 0;
} finally {
closeResource();
}
}
@Override
public Standard getByStdNum(String stdNum) {
try {
if(super.openDatabase()) {
String sql="select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where stdnum=?";
Object[] params= {stdNum};
super.rs=super.executeQuery(sql, params);
if (rs.next()) {
Standard standard=new Standard();
standard.setId(rs.getInt("id"));
standard.setStdNum(rs.getString("stdnum"));
standard.setZhName(rs.getString("zhname"));
standard.setVersion(rs.getString("version"));
standard.setKeys(rs.getString("keys"));
standard.setReleaseDate(rs.getTimestamp("releasedate"));
standard.setImplDate(rs.getTimestamp("impldate"));
standard.setPackagePath(rs.getString("packagepath"));
return standard;
}else {
return null;
}
}else {
return null;
}
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
closeResource();
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
jsp.zip (55个子文件)
jsp
src
cn
bdqn
jsp
entity
Standard.java 1KB
filter
EncodingFilter.java 703B
dao
BaseDao.java 2KB
impl
StandardDaoImpl.java 7KB
StandardDao.java 394B
util
Utility.java 394B
ConfigManager.java 1KB
SQLHandler.java 844B
PageBean.java 2KB
service
StandardService.java 421B
impl
StandardServiceImpl.java 2KB
constrant
Const.java 276B
servlet
ListServlet.java 2KB
SaveServlet.java 3KB
DeleteServlet.java 934B
JudgeServlet.java 847B
UpdateServlet.java 4KB
database.properties 118B
.classpath 771B
build
classes
cn
bdqn
jsp
entity
Standard.class 2KB
filter
EncodingFilter.class 1KB
dao
StandardDao.class 531B
BaseDao.class 2KB
impl
StandardDaoImpl.class 7KB
util
Utility.class 796B
PageBean.class 3KB
ConfigManager.class 1KB
SQLHandler.class 1KB
service
StandardService.class 539B
impl
StandardServiceImpl.class 3KB
constrant
Const.class 596B
servlet
JudgeServlet.class 1KB
DeleteServlet.class 2KB
ListServlet.class 2KB
SaveServlet.class 5KB
UpdateServlet.class 5KB
database.properties 118B
.settings
org.eclipse.wst.jsdt.ui.superType.container 49B
org.eclipse.wst.common.project.facet.core.xml 345B
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.wst.common.component 461B
.jsdtscope 567B
org.eclipse.jdt.core.prefs 364B
WebContent
META-INF
MANIFEST.MF 39B
list.jsp 5KB
add.jsp 3KB
index.jsp 282B
update.jsp 3KB
WEB-INF
lib
commons-io-2.4.jar 181KB
commons-fileupload-1.2.2.jar 58KB
ojdbc.jar 1.47MB
jstl.jar 20KB
standard.jar 384KB
web.xml 2KB
.project 903B
共 55 条
- 1
资源评论
MelodyChiu
- 粉丝: 3
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功