package org.jvsun.dao.impl;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.jvsun.dao.RepairDAO;
import org.jvsun.pojo.ProductPOJO;
import org.jvsun.pojo.RepairPOJO;
public class RepairDAOImpl implements RepairDAO {
public Connection conn;
public RepairDAOImpl(Connection conn){
this.conn=conn;
}
/*
* 报修单的删除
* @see org.jvsun.dao.RepairDAO#doDel(java.math.BigDecimal)
*/
public boolean doDel(BigDecimal repairId) {
boolean flag= false;
PreparedStatement pstate= null;
String sql = "update repair set is_delete = 0 where repair_id = ?";
try {
this.conn.setAutoCommit(false);
pstate= this.conn.prepareStatement(sql);
pstate.setBigDecimal(1, repairId);//����id
pstate.execute();
this.conn.commit();
flag=true;
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
pstate.close();
this.conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return flag;
}
/*
* 保修单的新增
* @see org.jvsun.dao.RepairDAO#doIns(org.jvsun.pojo.RepairPOJO)
*/
public boolean doIns(RepairPOJO pojo) {
boolean flag= false;
PreparedStatement pstate= null;
String sql = "insert into repair (repair_id ,product_name, repair_content ,up_date,is_over, customer_id ,is_delete )" +
" values(dh3.nextval,?,?,sysdate,0,?,1)";
try {
this.conn.setAutoCommit(false);
pstate= this.conn.prepareStatement(sql);
pstate.setString(1, pojo.getProductName());
pstate.setString(2, pojo.getRepairContent());
pstate.setBigDecimal(3, pojo.getCustomerId());
pstate.execute();
this.conn.commit();
flag = true;
} catch (SQLException e) {
e.printStackTrace();
}
return flag;
}
/*
* 报修单的修改
* @see org.jvsun.dao.RepairDAO#doUpd(java.math.BigDecimal, java.lang.String)
*/
public boolean doUpd(BigDecimal repairId, String repairContent) {
boolean flag = false;
PreparedStatement pstate = null;
String sql = "update repair set repair_Content=? , up_date=sysdate,is_over = 0 where repair_Id = ? ";
try {
this.conn.setAutoCommit(false);
pstate= this.conn.prepareStatement(sql);
pstate.setString(1, repairContent);//������Ϣ
pstate.setBigDecimal(2, repairId);//����ID
pstate.execute();
this.conn.commit();
flag = true;
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
pstate.close();
this.conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return flag;
}
/*
* 取得 报修单的数据笔数
* @see org.jvsun.dao.RepairDAO#findByCustomerId(java.math.BigDecimal)
*/
public List<ProductPOJO> findByCustomerId(BigDecimal customerId) {
List<ProductPOJO> list = new ArrayList<ProductPOJO>();
PreparedStatement pstate = null;
ResultSet res = null;
try {
String sql="select p.product_name from customer_product cp,product p " +
" where cp.customer_id=? and cp.product_id=p.product_id";
pstate = this.conn.prepareStatement(sql);
pstate.setBigDecimal(1, customerId);//�ͻ�ID
res = pstate.executeQuery();
while(res.next()){
ProductPOJO pojo= new ProductPOJO(res.getString(1));
list.add(pojo);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try {
res.close();
pstate.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return list;
}
/*
* 取得报修单的数据笔数
* @see org.jvsun.dao.RepairDAO#findByProduct(java.lang.String, java.math.BigDecimal, int, int)
*/
public List<RepairPOJO> findByProduct(String productName,
BigDecimal customerId, int pageSize, int pageCurrent) {
List<RepairPOJO> list = new ArrayList<RepairPOJO>();
PreparedStatement pstate = null;
ResultSet res = null;
try {
String sql="select f.repair_id , f.product_name , f.repair_content , f.up_date , f.is_over , f.customer_id " +
" ,f.rept_content,f.is_delete from (select a.repair_id , a.product_name , a.repair_content ," +
" a.up_date , a.is_over , a.customer_id ,a.is_delete ,b.rept_content,rownum abc " +
" from repair a,repair_return b where a.product_name like ? and b.repair_id(+)=a.repair_id " +
" and a.is_delete= 1 and a.customer_id=? order by a.is_over desc) f where abc>? and abc<=? ";
pstate = this.conn.prepareStatement(sql.toString());
pstate.setString(1,"%"+productName+"%");//��Ʒ��
pstate.setBigDecimal(2, customerId);//�ͻ�id
pstate.setInt(3, (pageCurrent-1)*pageSize);
pstate.setInt(4, pageCurrent*pageSize);
res = pstate.executeQuery();
while(res.next()){
RepairPOJO pojo = new RepairPOJO(res.getBigDecimal(1),res.getString(2),res.getString(3),res.getDate(4),
res.getInt(5),res.getBigDecimal(6),res.getString(7),res.getInt(8));
list.add(pojo);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try {
res.close();
pstate.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return list;
}
/*
* ��ѯ���ʱ���¼
* @see org.jvsun.dao.RepairDAO#findByRepairId(java.math.BigDecimal)
*/
public RepairPOJO findByRepairId(BigDecimal repairId) {
RepairPOJO pojo= null;
PreparedStatement pstate = null;
ResultSet res = null;
try {
StringBuffer sql = new StringBuffer();
sql.append(" select a.repair_id , a.product_name ,a.repair_content ,a.up_date,a.is_over,a.customer_id , b.rept_content from repair a,repair_return b where" +
" a.repair_id=b.repair_id and a.repair_id=? and a.is_delete = 1");
pstate = this.conn.prepareStatement(sql.toString());
pstate.setBigDecimal(1, repairId);//����id
res = pstate.executeQuery();
while(res.next()){//
pojo = new RepairPOJO(res.getBigDecimal(1),res.getString(2),res.getString(3),res.getDate(4),
res.getInt(5),res.getBigDecimal(6),res.getString(7),1);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try {
res.close();
pstate.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return pojo;
}
/*
* ��ѯ����¼����
* @see org.jvsun.dao.RepairDAO#findCountById(java.math.BigDecimal)
*/
public int findCountById(BigDecimal customerId) {
int count = 0;
PreparedStatement pstate = null;
ResultSet res = null;
try {
StringBuffer sql = new StringBuffer();
sql.append("select count(repair_id) from repair where customer_id = ? and is_delete= 1");
pstate = this.conn.prepareStatement(sql.toString());
pstate.setBigDecimal(1, customerId);//�ͻ�id
res = pstate.executeQuery();
while(res.next()){
count = res.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try {
res.close();
pstate.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return count;
}
//根据id查询报修单实现方法
public RepairPOJO findByRepairIdJi(BigDecimal repairId) {
RepairPOJO pojo = null;
PreparedStatement pstate = null;
ResultSet res = null;
try {
String sql = "select repair_id, product_name, repair_content, up_date, is_over, customer_id,is_delete from repair where repair_id = ? ";
pstate = this.conn.prepareStatement(sql);
pstate.setBigDecimal(1, repairId);
res = pstate.executeQuery();
while(res.next()){
pojo = new RepairPOJO(res.getBigDecimal(1),res.getString(2),res.getString(3),res.getDate(4),
res.getInt(5),res.getBigDecimal(6),res.getInt(7));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
res.close();
pstate.close();
} catch (Exception e2) {
jsp+servlet实现的CRM管理系统 （470个子文件） 
FeedBackDAOImpl.class 10KB RepairDAOImpl.class 10KB CustomerDAOImpl.class 9KB CompetitorProductDAOImpl.class 7KB ContractDAOImpl.class 7KB ProductDAOImpl.class 7KB FeedBackReturnDAOImpl.class 7KB WorkerDAOImpl.class 7KB RepairRetrunDAOImpl.class 7KB NeedDAOImpl.class 7KB CompetitorDAOImpl.class 6KB ManRoleDAOImpl.class 6KB RoleMenuDAOImpl.class 6KB RoleDAOImpl.class 6KB CustomerQuery.class 6KB UserInfo.class 6KB MenuDAOImpl.class 5KB UserLoginDAOImpl.class 5KB FeedBackReturnQuery.class 4KB CustomerPOJO.class 4KB FeedBackQuery.class 4KB ContractPOJO.class 4KB ContractQuery.class 4KB QueryRepair.class 4KB RepairReturnQuery.class 4KB ManRoleQuery.class 4KB CompetitorProductQuery.class 4KB RoleMenuQuery.class 4KB CompetitorQuery.class 4KB ProductQuery.class 4KB RepairQuery.class 4KB WorkerQuery.class 4KB QueryFeedBack.class 4KB UpServlet.class 3KB PhotoDAOImpl.class 3KB NeedQuery.class 3KB NeedPOJO.class 3KB MenuQuery.class 3KB RoleQuery.class 3KB FeedBackDAOProxy.class 3KB RepairDAOProxy.class 3KB CompetitorProductPOJO.class 3KB CustomerInfoDAOImpl.class 3KB FeedBackPOJO.class 3KB RepairPOJO.class 3KB CustomerDAOProxy.class 3KB ProductPOJO.class 3KB WorkerInfoDAOImpl.class 3KB CheckLoginId.class 3KB SelectProduct.class 3KB CustomerUpd.class 3KB FeedBackReturnPOJO.class 3KB WorkerPOJO.class 3KB FeedBackReturnUpd.class 3KB PhotoPOJO.class 3KB ProductUpd.class 3KB ContractUpd.class 2KB AddCompetitorProduct.class 2KB AddCustomer.class 2KB GraphicHelper.class 2KB AddProduct.class 2KB AddContract.class 2KB CompetitorProductUpd.class 2KB RoleMenuDAOProxy.class 2KB FindCompetitorProductById.class 2KB ManRoleDAOProxy.class 2KB NeedUpd.class 2KB CompetitorUpd.class 2KB RepairReturnPOJO.class 2KB CompetitorProductDAOProxy.class 2KB FilterCRM.class 2KB FeedBackReturnDAOProxy.class 2KB AddFeedBack.class 2KB FeedBackReturnAdd.class 2KB RepairReturnDAOProxy.class 2KB ContractDAOProxy.class 2KB NeedDAOProxy.class 2KB AddCompetitor.class 2KB AddNeed.class 2KB WorkerUpdate.class 2KB RepairAdd.class 2KB WorkerDAOProxy.class 2KB CompetitorDAOProxy.class 2KB RoleDAOProxy.class 2KB RepairReturnUpd.class 2KB ProductDAOProxy.class 2KB EncodingFilter.class 2KB ModifyPassword.class 2KB CustomerInfoUpd.class 2KB WorkerAdd.class 2KB RepairFindByCustId.class 2KB MenuDAOProxy.class 2KB MenuUpdate.class 2KB RepairReturnAdd.class 2KB RoleUpdate.class 2KB MenuAdd.class 2KB UserLoginDAOProxy.class 2KB VerifyCodeServlet.class 2KB CompetitorPOJO.class 2KB WorkerInfoUpd.class 2KB共 470 条
- 1
- 2
- 3
- 4
- 5
资源评论
「已注销」2018-11-16也许挺好的吧，感觉这么大
java开发者日常
- 粉丝: 5
- 资源: 3
最新资源
- C# Winform简单的俄罗斯方块小游戏源码2.zip
- 混合动力汽车动态规划算法理论油耗计算与视频教学，使用matlab编写快速计算程序，整个工程结构模块化，可以快速改为串联，并联，混联等 控制量可以快速扩展为档位，转矩，转速等 状态量一般为SOC，目
- 全国职业院校技能大赛网络建设与运维规程
- agv 1223.fbx
- 考虑泄流效应的光伏无功优化matlab 以IEEE33节点为例，分析泄流效应下，最佳网络无功补偿方案，程序运行稳定
- jetbra插件工具，方便开发者快速开发
- 云计算2401班课程设计资料.zip
- 企业宣传PPT模板， 企业宣传PPT模板
- 微环谐振腔的光学频率梳matlab仿真 微腔光频梳仿真 包括求解LLE方程（Lugiato-Lefever equation）实现微环中的光频梳，同时考虑了色散，克尔非线性，外部泵浦等因素，具有可延展
- 生菜生长记录数据集.zip
- 基于Springboot+Vue健身房管理系统-毕业源码案例设计（高分项目）.zip
- 中国风格， 节日 主题， PPT模板
- lcd取模工具，很难找的有用的LCD显示开发工具
- 基于Springboot+Vue健身房管理系统-毕业源码案例设计（源码+数据库）.zip
- 基于Springboot+Vue江理工文档管理系统的设计与实现-毕业源码案例设计（源码+论文）.zip
- 基于Springboot+Vue教师工作量管理系统-毕业源码案例设计（高分毕业设计）.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
