欢迎来到天天文库
浏览记录
ID:9357949
大小:66.08 KB
页数:124页
时间:2018-04-28
《定制服装单量单裁管理系统 -java代码》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Packagecom.dingzhi.danldanc.control.xitong;importcom.bwm.string.Str;importcom.zh.conpool.*;importjava.sql.Connection;importjava.sql.ResultSet;publicclassArraysql{privateResultSetrs=null;privateStringsql="";Condatacon=newCondata();Connectionconn=null;Strstr=newStr();publicResultSettoRs(
2、){sql="SELECT*FROMtb_th_types";try{con.getConnection();rs=con.executeQuery(sql);}catch(Exceptioneee){System.out.println(eee.getMessage()+"3333");}returnrs;}publicResultSettoRst(){sql="SELECT*FROMtb_th_unit";try{con.getConnection();rs=con.executeQuery(sql);}catch(Exceptioneee){System.ou
3、t.println(eee.getMessage()+"3333");}returnrs;}publicResultSettoRstb(){sql="SELECT*FROMtb_th_boss";try{con.getConnection();rs=con.executeQuery(sql);}catch(Exceptioneee){System.out.println(eee.getMessage()+"3333");}returnrs;}publicvoidclose(){try{conn=null;}catch(Exceptione){System.out.p
4、rint("f1");}try{con.close();con=null;}catch(Exceptionee){System.out.print("f");}finally{conn=null;con=null;}}}Packagecom.dingzhi.danldanc.control.xitong;publicclassCutstring{privateStringcut="";privateStringcuting="";publicStringtoCut(Stringcut){this.cut=cut;if(cut.length()>=8){cuting=
5、cut.substring(0,8);returncuting;}else{returncuting=cut;}}publicStringtoCutlong(Stringcut){this.cut=cut;if(cut.length()>=15){cuting=cut.substring(0,15);returncuting;}else{returncuting=cut;}}}Packagecom.dingzhi.danldanc.control.xitong;importjava.sql.*;importcom.zh.conpool.Condata;publicc
6、lassGroupName{privateConnectionconn=null;privateResultSetrs=null;privateCondatacon=newCondata();privateintStat_num=0;privateintnums=0;privateStringnames="";privateStringrsSql="";privateStringsql="SELECTName,SUM(Numbers)Stat_Num,SUM(Money)ASStat_MonFROMtb_th_planWHERE(Name='";privateStr
7、ingP_sql="')AND(Planing='";privateStringE_sql="')GROUPBYName";synchronizedpublicintrbNum(Stringname,intnum){this.nums=num;this.names=name;/*if(nums==1){rsSql=sql+name+In_sql;}if(nums==2){rsSql=sql+name+Out_sql;}if(nums==3){rsSql=sql+name+Dis_sql;}else{returnStat_num=0;}*/rsSql=sql+na
此文档下载收益归作者所有