package com.icss.oa.dao.impl;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;
import java.sql.*;
import java.util.ArrayList;
import com.icss.oa.common.DbCon;
import com.icss.oa.dao.YuanGongDAO;
import com.icss.oa.vo.Page;
import com.icss.oa.vo.YuanGong;
public class YuanGongDAOImpl implements YuanGongDAO {
public int yuanGongTJ(YuanGong yuangong){
Connection conn=DbCon.getConnectionByDBCP();
PreparedStatement pstam,pstam1;
int n=0;
try {
String sql="insert into ygxxb(ygh,ygmm,ygxm,xb,csrq,bgsdh,sj,yx,zz,grjj,bmh,jsbbh) " +
"values (?,'111111',?,?,?,?,?,?,?,?,(select bmh from bmb where bmm=?),(select jsbbh from jsb where jsm=?))";
String sql1="insert into ygdlb(ygh,ygmm,jsh,ygxm) values(?,'111111',(select jsbbh from jsb where jsm=?),?)";
pstam = conn.prepareStatement(sql);
pstam1=conn.prepareStatement(sql1);
conn.setAutoCommit(false);
pstam1.setString(1,yuangong.getYgh());
pstam1.setString(2,yuangong.getJsm());
pstam1.setString(3, yuangong.getYgxm());
pstam1.executeUpdate();
pstam.setString(1,yuangong.getYgh());
pstam.setString(2,yuangong.getYgxm());
pstam.setInt(3,yuangong.getXb());
pstam.setDate(4,yuangong.getCsrq());
pstam.setString(5,yuangong.getBgsdh());
pstam.setString(6,yuangong.getSj());
pstam.setString(7,yuangong.getYx());
pstam.setString(8,yuangong.getZz());
pstam.setString(9,yuangong.getGrjj());
pstam.setString(10,yuangong.getBmm());
pstam.setString(11,yuangong.getJsm());
n=pstam.executeUpdate();
// System.out.println("员工"+yuangong.getYgxm()+"已添加成功！");
conn.commit();
conn.setAutoCommit(true);
pstam.close();
conn.close();
return n;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return 0;
}
}
public Page queryAllYuanGong(String cxfs,String cxtj,int page){
List list = new ArrayList();
Statement pstmt = null;
Statement st=null;
ResultSet rs = null;
ResultSet rs1=null;
Connection conn=DbCon.getConnectionByDBCP();
String sql="";
String sql1="";
int numOfPage=10;
int tJiLu=4;
int tPage=4;
Page p=new Page();
try {
st=conn.createStatement();
if(cxfs.equals("按员工号")){
sql = "select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygh='"+cxtj+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygh='"+cxtj+"'";
}
if(cxfs.equals("按姓名")){
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygxm='"+cxtj+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygxm='"+cxtj+"'";
}
if(cxfs.equals("按性别")){
if(cxtj.equals("男")){
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and xb=1) A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and xb=1";
}
else{
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and xb=0) A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and xb=0";
}
}
if(cxfs.equals("按部门")){
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and bmm='"+cxtj+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and bmm='"+cxtj+"'";
}
if(cxfs.equals("按角色")){
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and jsm='"+cxtj+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and jsm='"+cxtj+"'";
}
rs1=st.executeQuery(sql1);
if(rs1.next()){
tJiLu=rs1.getInt(1);}
tPage=(tJiLu+numOfPage-1)/numOfPage;
if(page<1){
page=1; }
if(page>tPage){
page=tPage;}
pstmt=conn.createStatement();
rs=pstmt.executeQuery(sql);
while (rs.next()) {
YuanGong yuangong = new YuanGong();
yuangong.setYgh(rs.getString("ygh"));
yuangong.setYgxm(rs.getString("ygxm"));
yuangong.setYgmm(rs.getString("ygmm"));
yuangong.setXb(rs.getInt("xb"));
yuangong.setCsrq(rs.getDate("csrq"));
yuangong.setSj(rs.getString("sj"));
yuangong.setBgsdh(rs.getString("bgsdh"));
yuangong.setZz(rs.getString("zz"));
yuangong.setGrjj(rs.getString("grjj"));
yuangong.setYx(rs.getString("yx"));
yuangong.setBmh(rs.getInt("bmh"));
yuangong.setJsm(rs.getString("jsm"));
yuangong.setBmm(rs.getString("bmm"));
yuangong.setJsbbh(rs.getInt("jsbbh"));
list.add(yuangong);
}
rs.close();
rs1.close();
st.close();
pstmt.close();
conn.close();
p.setLi(list);
p.setPage(page);
p.setTJiLu(tJiLu);
p.setTPage(tPage);
p.setPageDaXiao(numOfPage);
return p;
}catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}finally{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(pstmt!=null){
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public Page queryAllTaRenTJ(String ygh,int page,String cxfs,String cxtj){
List list = new ArrayList();
Statement pstmt = null;
Statement st=null;
ResultSet rs = null;
ResultSet rs1=null;
Connection conn=DbCon.getConnectionByDBCP();
String sql="";
String sql1="";
int numOfPage=10;
int tJiLu=4;
int tPage=4;
Page p=new Page();
try {
st=conn.createStatement();
if(cxfs.equals("按员工号")){
sql = "select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygh='"+cxtj+"' and ygh!='"+ygh+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count(ygh) from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygh='"+cxtj+"' and ygh!='"+ygh+"'";
}
if(cxfs.equals("按姓名")){
sql="select * from ( select A.*, ROWNUM RN FROM (select ygxxb.*,bmm,jsm from ygxxb,bmb,jsb where ygxxb.bmh=bmb.bmh and ygxxb.jsbbh=jsb.jsbbh and ygxm='"+cxtj+"' and ygh!='"+ygh+"') A WHERE ROWNUM <= "+(numOfPage*page)+" ) WHERE RN >= "+((page-1)*numOfPage+1);
sql1="select count
OA.rar_java oa_oa java_oa struts
版权申诉
144 浏览量
2022-09-19
16:00:41
上传
评论
收藏 3.55MB RAR 举报
OA.rar_java oa_oa java_oa struts （470个子文件） 
YuanGongDAOImpl.class 16KB HuiYiQingDanDAOImpl.class 14KB RiChengDAOImpl.class 12KB YouJianDAOImpl.class 9KB YuYueHuiYiShiDAOImpl.class 8KB HuiYiShiDAOImpl.class 7KB MingPianDAOImpl.class 7KB GongSiTongXunLuDAOImpl.class 7KB UserDAOImpl.class 7KB GeRenWenJianJiaDAOImpl.class 6KB DepartmentDAOImpl.class 6KB JueSeDAOImpl.class 6KB LianXiRenDAOImpl.class 4KB ShangChuanServlet.class 4KB BuMenDAOImpl.class 3KB YuanGongTJNewServlet.class 3KB YouJianMgrImpl.class 3KB ZuZhiTuServlet.class 3KB HuiYiXGServlet.class 3KB YuanGongXGNewServlet.class 3KB HuiYiJiLuTJServlet.class 3KB BenRenXGNewServlet.class 3KB User.class 3KB HuiYiCXServlet.class 3KB YouJianFaSongStr.class 3KB YuanGong.class 3KB HuiYiQingDanMgrImpl.class 3KB AddUserServlet.class 3KB HuiYiChaXunServlet.class 3KB AddYuYueHuiYiShi.class 3KB HuiYiCXFYServlet.class 3KB GongSiTongXunLuCXServlet.class 3KB DaoChuExcel.class 3KB RiChengCXTJServlet.class 3KB LuanMaChuLiServlet.class 3KB GongSiTongXunLuServlet.class 3KB YuYueBiaoFYServlet.class 3KB GongZuoQingDanServlet.class 3KB LuanMaServlet.class 3KB AddMingPian.class 3KB TaRenCXServlet.class 3KB YuanGongXinXi.class 3KB RiChengMgrImpl.class 3KB HuiYiCXJTServlet.class 3KB RiChengTJServlet.class 3KB JueSeTJServlet.class 3KB YouJian.class 3KB MingPianCLServlet.class 3KB LoginChuListr.class 2KB RiChengXGServlet.class 2KB HuiYiShiFYServlet.class 2KB YuanGongCXServlet.class 2KB MingPianXinXiXGServlet.class 2KB TaBanTJServlet.class 2KB YuYueHuiYiShi.class 2KB LianXiRenTJStr.class 2KB MingPianServlet.class 2KB YuYueXiangQingServlet.class 2KB YuanGongMgrImpl.class 2KB YuYueChuLiServlet.class 2KB HuiYiJiLuGLServlet.class 2KB BuMenXiuGaiStr.class 2KB IsLogin.class 2KB WenJian.class 2KB MingPianXGServlet.class 2KB YuYueBiaoServlet.class 2KB HuiYiShiServlet.class 2KB AddHuiYiShi.class 2KB YuanGongXGServlet.class 2KB HuiYiSheBei.class 2KB HuiYiJiLuXGServlet.class 2KB DaiBanShiXiangServlet.class 2KB HuiYiShi.class 2KB AddSheBei.class 2KB HuiYiQingDan.class 2KB MiMaXGServlet.class 2KB HuiYiXiangQingCXServlet.class 2KB BenRenCXServlet.class 2KB TongXunLuStr.class 2KB RiChengCXBPServlet.class 2KB YuanGongSCServlet.class 2KB SheZhiGongXiang.class 2KB ShanChuShangChuan.class 2KB ShouJianXiangZXStr.class 2KB YiFaYouJianStr.class 2KB WeiDuYouJianStr.class 2KB ShanChuLianXiRen.class 2KB GeRenWenJianJiaStr.class 2KB MingPianSCServlet.class 2KB YouJianShanChuStr.class 2KB YouJianBiaoJiStr.class 2KB JianCeShiJianStr.class 2KB JueSeSCServlet.class 2KB CaoGaoXiangStr.class 2KB AddDepartment.class 2KB GongXiangStr.class 2KB RiCheng.class 2KB JueSeCXServlet.class 2KB ZhuangTaiXGServlet.class 2KB BuMenGuanLiServlet.class 2KB共 470 条
- 1
- 2
- 3
- 4
- 5
资源评论
