java开发的ERP5820.docx

《java开发的ERP5820.docx》由会员分享，可在线阅读，更多相关《java开发的ERP5820.docx（109页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、package com.ts017.zjh;import java.text.NumberFormat;import java.util.Iteraator;import java.util.List;import java.util.Map;import java.util.Scannner;import com.tts017.zjh.ddao.IDDeptDAAO;import com.tts017.zjh.ddao.IEEmpDAOO;import com.tts017.zjh.ddao.faactoryy.DAOFFactorry;import com.tts017.zjh.vvo.D

2、eppartmeent;import com.tts017.zjh.vvo.Empployeee;public classs DepaartmenntOperrate privatte IDeeptDAOO dao = nulll;Scanneer scnn = nuull;publicc DepaartmenntOperrate() this.dao = DAOFFactorry.gettIDempptDAOIInstannce();scn = new Scannner(Syystem.in);publicc voidd addDDeparttment() Systeem.outt.prin

3、ntln();Systeem.outt.prinntln( 添加部门门信息);Systeem.outt.prinntln(=);Systeem.outt.prinnt(请输输入部门名称称: );Strinng depptNamee = sccn.nexxt();Deparrtmentt repeeatDeppt = ggetDeppartmeentByNName(ddeptNaame);if (rrepeattDept != nuull) Systtem.ouut.priintln(您输入的的部门名已存存在);retuurn;Deparrtmentt deptt = neew Deppartm

4、eent();dept.setDeeptNamme(depptNamee);booleean fllag = falsee;try flagg = thhis.daao.doCCreatee(deptt); cattch (EExcepttion ee) e.prrintSttackTrrace();if (fflag) Systtem.ouut.priintln(添加部门门成功); elsse Systtem.ouut.priintln(添加部门门失败);publicc voidd delDDeparttment() Systeem.outt.prinntln();Systeem.outt.

5、prinnt(请输输入要删除的的部门编号: );int ddeptIdd = sccn.nexxtInt();Deparrtmentt deptt = geetDepaartmenntByIdd(depttId);if (ddept = nulll) Systtem.ouut.priintln(您输入的的部门不存在在);retuurn;IEmpDDAO emmpDAO = DAOOFactoory.geetIEmppDAOInnstancce();List emps = nulll;try empss = emmpDAO.findBByDepttId(deeptId); cattch (EEx

6、cepttion ee) e.prrintSttackTrrace();if (eemps != nulll) thiss.showwDeparrtmentt(deptt);if (emps.size() 00) Sysstem.oout.prrintlnn(该部门门中有员工存存在，若删除除该部门，则则相应的员工工也会被删除除，确定要删删除吗(y/n)?);Strring oopt = scn.nnext();if (opt.equallsIgnooreCasse(y) boooleann flagg = faalse;trry eempDAOO.doDeeleteBByDepttId(dee

7、ptId);fflag = thiss.dao.doDellete(ddeptIdd); catchh (Excceptioon e) ee.prinntStacckTracce();iff (flaag) SSystemm.out.printtln(删删除部门成功功); else SSystemm.out.printtln(删删除部门失败败); ellse Sysstem.oout.prrintlnn(确定要要删除该部门门信息吗(yy/n)?);Strring oopt = scn.nnext();if (opt.equallsIgnooreCasse(y) boooleann flagg

8、= faalse;trry fflag = thiss.dao.doDellete(ddeptIdd); catchh (Excceptioon e) ee.prinntStacckTracce();iff (flaag) SSystemm.out.printtln(删删除部门成功功); else SSystemm.out.printtln(删删除部门失败败);publicc voidd finddAll() List deppts = null;try deptts = tthis.ddao.fiindAlll(); cattch (EExcepttion ee) e.prrintSttac

9、kTrrace();if (ddepts != nuull & deptts.sizze() != 0) thiss.showwDeparrtmentt(deptts); elsse Systtem.ouut.priintln(没有部门门信息);publicc voidd finddDeparrtmentt() int oopt;do thiss.showwFindMMenu();opt = scnn.nexttInt();swittch (oopt) casee 1:thiis.finndByDeeptId();breeak;casee 2:thiis.finndByDeeptnamme()

10、;breeak;casee 0:retturn; whiile (oopt != 0);publicc voidd finddByDepptnamee() Systeem.outt.prinntln();Systeem.outt.prinnt(请输输入查找的部部门名称: );Strinng depptNamee = sccn.nexxt();Deparrtmentt deptt = geetDepaartmenntByNaame(deeptNamme);if (ddept != nulll) thiss.showwDeparrtmentt(deptt); elsse Systtem.ouut.

11、priintln(相关信息息不存在);publicc voidd finddByDepptId() Systeem.outt.prinntln();Systeem.outt.prinnt(请输输入要查找的的部门号: );int ddeptIdd = sccn.nexxtInt();Deparrtmentt deptt = geetDepaartmenntByIdd(depttId);if (ddept != nulll) thiss.showwDeparrtmentt(deptt); elsse Systtem.ouut.priintln(相关信息息不存在);publicc voidd upd

12、aateDeppartmeent() Systeem.outt.prinntln();Systeem.outt.prinnt(请输输入要更新的的部门编号: );int ddeptIdd = sccn.nexxtInt();Deparrtmentt deptt = geetDepaartmenntByIdd(depttId);if (ddept = nulll) Systtem.ouut.priintln(您输入的的部门不存在在);retuurn;this.showDDeparttment(dept);Systeem.outt.prinntln( 更新新部门信息);Systeem.outt.pr

13、inntln(=);Systeem.outt.prinnt(请输输入新的部门门名称: );Strinng depptNamee = sccn.nexxt();Deparrtmentt repeeatDeppt = ggetDeppartmeentByNName(ddeptNaame);whilee(repeeatDeppt!=nuull)Systtem.ouut.priintln(您输入的的部门名称已已存在，请重重新输入);depttName = scnn.nextt();repeeatDeppt = ggetDeppartmeentByNName(ddeptNaame);Deparrtmen

14、tt newDDept = new Deparrtmentt();newDeept.seetDepttId(deeptId);newDeept.seetDepttName(deptNName);booleean fllag = falsee;try flagg = thhis.daao.doUUpdatee(newDDept); cattch (EExcepttion ee) e.prrintSttackTrrace();if (fflag) Systtem.ouut.priintln(更新员工工信息成功); elsse Systtem.ouut.priintln(更新员工工信息失败);pub

15、licc voidd showwGrouppAvgSaalaryAAboutDDept() Map deptMMap = null;Map avgSSalaryy = nuull;try depttMap = thiss.dao.getDeepartmmentMaap();avgSSalaryy = thhis.daao.gettAveraageSallaryByyGroupp(); cattch (EExcepttion ee) e.prrintSttackTrrace();Systeem.outt.prinntln();Systeem.outt.prinntln(t 部门平平均薪水);Sy

16、steem.outt.prinntln();Systeem.outt.prinntln(t部门编编号t部门门名称t平平均薪水);Systeem.outt.prinntln(=);Iteraator itt = avvgSalaary.keeySet().iteeratorr();NumbeerFormmat foormat = NummberFoormat.getInnstancce();formaat.settMaximmumFraactionnDigitts(1);whilee (it.hasNeext() Inteeger iid = iit.nexxt();Systtem.ouut.p

17、riintln(t + id.intVaalue() + t+ deptMMap.geet(id).getDDeptNaame() + tt+ formaat.forrmat(aavgSallary.gget(idd);Systeem.outt.prinntln();publicc voidd showwEmpCoountAbboutDeept() Map emppCounttMap = nulll;Map deptMMap = null;try empCCountMMap = this.dao.ggetEmppCounttByGrooup();depttMap = thiss.dao.get

18、DeepartmmentMaap(); cattch (EExcepttion ee) e.prrintSttackTrrace();Systeem.outt.prinntln();Systeem.outt.prinntln(t 部门员员工信息);Systeem.outt.prinntln();Systeem.outt.prinntln(t编号t名称tt人数);Systeem.outt.prinntln(=);Iteraator itt = emmpCounntMap.keySeet().iiterattor();whilee (it.hasNeext() Inteeger iid = iit

19、.nexxt();Systtem.ouut.priintln(t + id.intVaalue() + t+ deptMMap.geet(id).getDDeptNaame() + tt+ empCoountMaap.gett(id);Systeem.outt.prinntln();publicc voidd showwTopAnndLowSSalaryyAbouttDept() Map topSSalaryyMap = nulll;Map lowSSalaryyMap = nulll;Map deptss = nuull;try topSSalaryyMap = thiss.dao.getT

20、oopSalaaryByGGroup();lowSSalaryyMap = thiss.dao.getLoowSalaaryByGGroup();deptts = tthis.ddao.geetDepaartmenntMap(); cattch (EExcepttion ee) e.prrintSttackTrrace();Systeem.outt.prinntln(tt部部门最高薪水水与最低薪水水);Systeem.outt.prinntln();Systeem.outt.prinntln(t部门编编号t部门门名称t最最高薪水tt最低薪水);Systeem.outt.prinntln(=);

21、Iteraator itt = toopSalaaryMapp.keySSet().iteraator();NumbeerFormmat foormat = NummberFoormat.getInnstancce();formaat.settMaximmumFraactionnDigitts(1);whilee (it.hasNeext() Inteeger iid = iit.nexxt();Systtem.ouut.priintln(t + id.intVaalue() + t+ deptss.get(id).ggetDepptNamee() + t+ formaat.forrmat(t

22、topSallaryMaap.gett(id).floattValuee() + t+ formaat.forrmat(llowSallaryMaap.gett(id).floattValuee();Systeem.outt.prinntln();publicc voidd showwDeparrtmenttNoEmpp() List deppts = null;try deptts = tthis.ddao.geetDepaartmenntWithhoutEmmp(); cattch (EExcepttion ee) e.prrintSttackTrrace();Systeem.outt.p

23、rinntln(t 员工数数为零的部门门);Systeem.outt.prinntln();Systeem.outt.prinntln(t部门编编号t部门门名称);Systeem.outt.prinntln(=);Iteraator it = deptts.iteeratorr();whilee (it.hasNeext() Depaartmennt deppt = iit.nexxt();Systtem.ouut.priintln(t + deppt.gettDeptIId() + t+ dept.getDeeptNamme();Systeem.outt.prinntln();publicc

24、 voidd showwDeparrtmenttSummaarize() int oopt;do thiss.showwSummaarizeMMenu();opt = scnn.nexttInt();swittch (oopt) casee 1:thiis.shoowGrouupAvgSSalaryyAbouttDept();breeak;casee 2:thiis.shoowEmpCCountAAboutDDept();breeak;casee 3:thiis.shoowTopAAndLowwSalarryAbouutDeptt();breeak;casee 4:thiis.shoowDep

25、aartmenntNoEmmp();breeak;casee 0:retturn;defaault:Sysstem.oout.prrintlnn(您的输输入 有误); whiile (oopt != 0);privatte Deppartmeent geetDepaartmenntByIdd(int deptIId) Deparrtmentt deptt = nuull;try deptt = thhis.daao.finndByIdd(depttId); cattch (EExcepttion ee) e.prrintSttackTrrace();returrn deppt;privatte

26、 Deppartmeent geetDepaartmenntByNaame(Sttring deptNName) Deparrtmentt repeeatDeppt = nnull;try repeeatDeppt = tthis.ddao.fiindByNName(ddeptNaame); cattch (EExcepttion ee1) e1.pprintSStackTTrace();returrn reppeatDeept;privatte voiid shoowDepaartmennt(Deppartmeent deept) Systeem.outt.prinntln();Systee

27、m.outt.prinntln(t 部门信息息);Systeem.outt.prinntln(=);Systeem.outt.prinntln(t部门编编号: + deppt.gettDeptIId();Systeem.outt.prinntln(t部门名名称: + deppt.gettDeptNName();Systeem.outt.prinntln();privatte voiid shoowDepaartmennt(Lisst ddepts) Systeem.outt.prinntln();Systeem.outt.prinntln(t 部门信息);Systeem.outt.prinnt

28、ln();Systeem.outt.prinntln(t编号t名称);Systeem.outt.prinntln(=);Iteraator it = deptts.iteeratorr();whilee (it.hasNeext() Depaartmennt deppt = iit.nexxt();Systtem.ouut.priintln(t + deppt.gettDeptIId() + t+ dept.getDeeptNamme();Systeem.outt.prinntln();privatte voiid shoowFinddMenu() Systeem.outt.prinntln(

29、);Systeem.outt.prinntln(t 部门门信息查询);Systeem.outt.prinntln(=);Systeem.outt.prinntln(t1. 按部门编号号查询);Systeem.outt.prinntln(t2. 按部门名称称查询);Systeem.outt.prinntln(t0. 退出查询);Systeem.outt.prinntln();Systeem.outt.prinnt( 请选择: );privatte voiid shoowSummmarizeeMenu() Systeem.outt.prinntln();Systeem.outt.prinntln(

30、t 查看看部门汇总);Systeem.outt.prinntln(=);Systeem.outt.prinntln(t1. 查看部门平平均薪水);Systeem.outt.prinntln(t2. 查看部门员员工数);Systeem.outt.prinntln(t3. 查看部门最最高最低工资资);Systeem.outt.prinntln(t4. 查看没有员员工的部门);Systeem.outt.prinntln(t0. 退出操作);Systeem.outt.prinntln();Systeem.outt.prinnt( 请选择: );packagee com.ts0177.zjh;impor

31、t java.text.NumbeerFormmat;import java.util.HashSSet;import java.util.Iteraator;import java.util.List;import java.util.Map;import java.util.Scannner;import java.util.Set;import com.tts017.zjh.ddao.IDDeptDAAO;import com.tts017.zjh.ddao.IEEmpDAOO;import com.tts017.zjh.ddao.faactoryy.DAOFFactorry;impor

32、t com.tts017.zjh.vvo.Deppartmeent;import com.tts017.zjh.vvo.Empployeee;public classs EmplloyeeOOperatte privatte IEmmpDAO dao = nulll;Scanneer scnn = nuull;publicc EmplloyeeOOperatte() this.dao = DAOFFactorry.gettIEmpDDAOInsstancee();scn = new Scannner(Syystem.in);publicc voidd addEEmp() Systeem.out

33、t.prinntln();Systeem.outt.prinntln(t);Systeem.outt.prinntln(=);Emplooyee eemp = inputtNewEmmpInfoo();booleean fllag = falsee;try flagg = thhis.daao.doCCreatee(emp); cattch (EExcepttion ee) e.prrintSttackTrrace();if (fflag) Systtem.ouut.priintln(); elsse Systtem.ouut.priintln();publicc voidd updaateE

34、mpp() Systeem.outt.prinntln();Systeem.outt.prinnt(: );int eempId = scnn.nexttInt();Emplooyee eemp = getEmmployeeeByIdd(empIId);if (eemp = nulll) Systtem.ouut.priintln();retuurn;this.showEEmp(emmp);Systeem.outt.prinntln(t);Systeem.outt.prinntln(=);Emplooyee nnewEmpp = innputNeewEmpIInfo();newEmmp.set

35、tEmpIdd(empIId);booleean fllag = falsee;try flagg = thhis.daao.doUUpdatee(newEEmp); cattch (EExcepttion ee) e.prrintSttackTrrace();if (fflag) Systtem.ouut.priintln(); elsse Systtem.ouut.priintln();publicc voidd finddEmp() int oopt;do showwFindMMenu();opt = scnn.nexttInt();swittch (oopt) casee 1:thii

36、s.finndByEmmpId();breeak;casee 2:thiis.finndByEmmpNamee();breeak;casee 3:thiis.finndBySeex();breeak;casee 4:thiis.finndByDeepartmment();breeak;casee 5:thiis.finndByPaassporrt();breeak;casee 0:retturn; whiile (oopt != 0);publicc voidd finddByPasssportt() Systeem.outt.prinntln();Systeem.outt.prinnt(: );Strinng passsportt = sccn.nexxt();Emplooyee eemp = getEmmployeeeByPaassporrt(passsportt);if (eemp != nulll) thiss.showwEmp(eemp); el