Java固定资产管理系统源代码

;importpublicclassuser_landextendsJFrameimplementsActionListener{staticConnectionconn=null;staticStatementstat=null;staticResultSetrs=null;staticStringurl="jdbc:;DatabaseName=_Property";staticStringuser="sa";staticStringpassword="";JPanelp1,p2,p3,p4,p5;JLabellbl1,lbl2,lbl3,lbl4;JTextFieldtxt_name;JPasswordFieldtxt_pwd;JButtonbtn1,btn2,btn3;static{try{"";}catchExceptione{"加载驱动失败";;}}publicuser_land{"固定资产及设备用户登录";p1=newJPanel;p2=newJPanel;p3=newJPanel;p4=newJPanel;p5=newJPanel;lbl1=newJLabel"欢迎登录";lbl2=newJLabel"用户名：";lbl3=newJLabel"密码：";lbl4=newJLabel;txt_name=newJTextField10;txt_pwd=newJPasswordField10;btn1=newJButton"登录";btn2=newJButton"清空";btn3=newJButton"退出";lbl1;lbl2;txt_name;lbl3;txt_pwd;btn1;btn2;btn3;lbl4;newGridLayout5,1;p1;p2;p3;p4;p5;400,300,400,300;EXIT_ON_CLOSE;true;quals""==true&&.equals""==false"登录失败,用户名不能为空";if.equals""==false&&.equals""==true"登录失败,密码不能为空";if.equals""==true&&.equals""==true"登录失败,用户名/密码不能为空";ifis_Property{newSys_interface.show;}elseif.equals""==false&&.equals""==false"登录失败,用户名/密码错误";}};this;how;}};this;newActionListener{OverridepublicvoidactionPerformedActionEventarg0{newuser_land.show;}};newActionListener{publicvoidactionPerformedActionEvente{newPass_word.show;}};newActionListener{publicvoidactionPerformedActionEvente{0;}};newActionListener{publicvoidactionPerformedActionEvente{newloan_prop_manage.show;}};newActionListener{publicvoidactionPerformedActionEvente{newproperty_Info.show;}};newActionListener{publicvoidactionPerformedActionEvente{newprop_info_select.show;}};newActionListener{publicvoidactionPerformedActionEvente{newLoan_prop_select.show;}};newActionListener{publicvoidactionPerformedActionEvente{newback_prop_select.show;}};newActionListener{publicvoidactionPerformedActionEvente{newabout.show;}};200,200,500,400;EXIT_ON_CLOSE;}publicvoidactionPerformedActionEvente{how;}};importimportimport.;importimport.;importimportimportimportimportimportimportimportimportimportpublicclassloan_prop_manageextendsJFrameimplementsActionListener{Vectordata=null;DefaultTableModelmodel=null;Connectionconn=null;Statementstat=null;ResultSetrs1=null;JTableloan_prop=null;JLabellabel;JTextFieldtext;JTextFieldtxt01,txt02,txt03,txt04,txt05,txt06;JPanelp1=null,p2=null,p3=null,p4,p5,p6,p7,p8,p9,p10;Choicec1=null,c2=null;JLabellb1=null,lb2=null,lb3=null,lb4=null,lb5=null,lb6=null;JButtonbtn_ok=null;JButtonbtn_exit=null;JButtonbtn_fresh=null;JButtonbtn_save=null;JButtonbtn_del=null;VectorcolumnName=newVector;publicloan_prop_manage{text=newJTextField;"资产编号";"资产名称";"资产型号";"借出时间";"借出数量";"借出人";p1=newJPanel;p2=newJPanel;p3=newJPanel;p4=newJPanel;p5=newJPanel;p6=newJPanel;p7=newJPanel;p8=newJPanel;p9=newJPanel;p10=newJPanel;lb1=newJLabel"资产编号";lb2=newJLabel"资产名称";lb3=newJLabel"资产型号";lb4=newJLabel"借出时间";lb5=newJLabel"借出数量";lb6=newJLabel"借出人";txt01=newJTextField8;txt02=newJTextField8;txt03=newJTextField8;txt04=newJTextField8;txt05=newJTextField8;txt06=newJTextField8;c1=newChoice;c2=newChoice;text=newJTextField5;"资产编号";"=";btn_ok=newJButton"确定";btn_exit=newJButton"退出";btn_fresh=newJButton"刷新";btn_save=newJButton"保存";btn_del=newJButton"删除";newJLabel"查询字段";c1;newJLabel"运算符";c2;newJLabel"输入数据";text;btn_ok;btn_exit;"请操作";lb1;txt01;lb2;txt02;lb3;txt03;lb4;txt04;lb5;txt05;lb6;txt06;btn_fresh;btn_save;btn_del;newGridLayout3,2;p3;p4;p5;p6;p7;p8;loan_prop=newJTable,columnName;model=newDefaultTableModelgetDate,columnName;newJScrollPaneloan_prop;newGridLayout4,1;p1;p9;p2;p10;400,300,500,400;EXIT_ON_CLOSE;"资产借出管理";newActionListener{publicvoidactionPerformedActionEventarg0{try{"";conn="jdbc:;DatabaseName=_property","sa","";stat=;Stringsql="insertintoloan_infoprop_name,prop_type,loan_time,loan_num"+"values'"++"','"++"','"++"','"++"'";sql;DefaultTableModelmod=newDefaultTableModelgetDate,columnName;mod;;;}catchExceptione{}try{ifrs1=null{;}ifstat=null{;}ifconn=null{;}}catchExceptione2{"关闭失败";;}}};newActionListener{publicvoidactionPerformedActionEvente{DefaultTableModeldtb=newDefaultTableModelselectDate,columnName;dtb;;;}};/newActionListener{publicvoidactionPerformedActionEventarg0{}};/this;newActionListener{publicvoidactionPerformedActionEventarg0{DefaultTableModelmod=newDefaultTableModelgetDate,columnName;mod;;;}};.addListSelectionListenernewListSelectionListener{publicvoidvalueChangedListSelectionEvente{newActionListener{publicvoidactionPerformedActionEventarg0{try{intj=;"";conn="jdbc:;DatabaseName=_property","sa","";stat=;Stringsql1="deletefromloan_infowhereprop_id="+""+j.get0+"";sql1;}catchExceptionee{}finally{try{ifrs1=null{;}ifstat=null{;}ifconn=null{;}}catchExceptione2{"关闭失败";;}}DefaultTableModelmod=newDefaultTableModelgetDate,columnName;mod;;;}};}};.addListSelectionListenernewListSelectionListener{publicvoidvalueChangedListSelectionEvente{inti=;i.get0.toString;Stringi.get1;Stringi.get2;i.get3.toString;i.get4.toString;i.get5.toString;}};}publicVectorselectDate{data=newVector;try{"";conn="jdbc:;DatabaseName=_property","sa","";stat=;intx=.trim;how;}publicvoidactionPerformedActionEvente{;importclassLoan_prop_selectextendsJFrameimplementsActionListener{Connectionconn=null;Statementstat=null;ResultSetrs=null;JTabletable=null;JLabellabel;JTextFieldtext;JButtonbtn_ok=null,btn_exit=null;JPanelp1=null,p2=null;VectorcolumnName=newVector;publicLoan_prop_select{"资产借出查询";"流水号";"资产编号";"借用人";"借出数量";"借出时间";p1=newJPanel;p2=newJPanel;text=newJTextField;text=newJTextField5;btn_ok=newJButton"查询";btn_exit=newJButton"退出";newJLabel"资产编号";text;btn_ok;btn_exit;"数据查询";this;table=newJTable,columnName;newBorderLayout;p1,;newJScrollPanetable,;400,300,500,400;EXIT_ON_CLOSE;newActionListener{OverridepublicvoidactionPerformedActionEventarg0{DefaultTableModeldtm=newDefaultTableModelselectDate,columnName;dtm;;;}};}publicVectorselectDate{Vectordata=newVector;try{"";conn="jdbc:;DatabaseName=_property","sa","";stat=;intx=.trim;how;}publicvoidactionPerformedActionEvente{;importclassback_prop_selectextendsJFrameimplementsActionListener{Vectordata=null;DefaultTableModelmodel=null;Connectionconn=null;Statementstat=null;ResultSetrs=null;JPanelpa1,pa2;JButtonbtn1,btn2;JTabletab=null;JTextFieldtex=null;JTextFieldtxt1,txt2,txt3,txt4,txt5;JLabellab1,lab2,lab3;VectorcolumnName=newVector;publicback_prop_select{"流水号";"资产编号";"借用人";"借用数量";"借用时间";"归还数量";"归还时间";pa1=newJPanel;pa2=newJPanel;btn1=newJButton"确定";btn2=newJButton"退出";lab1=newJLabel"查询字段：";lab2=newJLabel"借用人";tex=newJTextField5;tab=newJTable,columnName;txt1=newJTextField10;txt2=newJTextField10;txt3=newJTextField10;txt4=newJTextField10;txt5=newJTextField10;lab1;lab2;tex;btn1;btn2;tab;model=newDefaultTableModelgetDate,columnName;tab=newJTablemodel;"查询

参数

转速和进给参数表a氧化沟运行参数高温蒸汽处理医疗废物pid参数自整定算法口腔医院集中消毒供应

";newJScrollPanetab;"资产归还查询";newBorderLayout;pa1,;newJScrollPanetab;300,200,500,300;EXIT_ON_CLOSE;ddListSelectionListenernewListSelectionListener{publicvoidvalueChangedListSelectionEvente{intx=;Stringx.get0;Stringx.get1;Stringx.get2;Stringx.get3;x.get4.toString;}};/ddListSelectionListenernewListSelectionListener{publicvoidvalueChangedListSelectionEvente{intx=;Stringx.get0;Stringx.get1;Stringx.get2;x.get3.toString;}};/this;}publicVectorgetDate{Vectordata=newVector;try{"";conn="jdbc:;DatabaseName=Property","sa","123";stat=;rs="selectfromloan_Info";while{Vectoral=newVector;"loan_id";"prop_id";"u_id";"loan_time";"loan_num";al;}}catchExceptione{}finally{rim+"'";rs=lab1;while{Vectorback=newVector;"loan_id";"prop_id";"u_id";"loan_time";"loan_num";back;}}catchExceptione{}finally{how;}publicvoidtableChangedTableModelEvente{}publicvoidactionPerformedActionEvente{false;}};import.;import.;import.;importclassproperty_InfoextendsJFrameimplementsActionListener{Connectionconn=null;Statementstat=null;ResultSetrs=null;JPanelp1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12;JButtonb1,b2,b3,b4,b5;JLabell1,l2,l3,l4,l5,l6,l7,l8,l9,l10;JTextFieldt1,t2,t3,t4,t5,t6,t7,t8,t9,text_show;JTabletable=null;JComboBoxcob;Stringsql;VectorcolumnName=newVector;publicproperty_Info{p1=newJPanel;p2=newJPanel;p3=newJPanel;p4=newJPanel;p5=newJPanel;p6=newJPanel;p7=newJPanel;p8=newJPanel;p9=newJPanel;p10=newJPanel;p11=newJPanel;p12=newJPanel;b1=newJButton"刷新";b2=newJButton"存盘";b3=newJButton"退出";b4=newJButton"删除";b5=newJButton"确定";l1=newJLabel"产品编号";l2=newJLabel"产品名称";l3=newJLabel"产品类型";l4=newJLabel"产品总量";l5=newJLabel"产品价格";l6=newJLabel"产品厂商";l7=newJLabel"购买日期";l8=newJLabel"出产日期";l9=newJLabel"购买人";l10=newJLabel"产品名称";t1=newJTextField10;t2=newJTextField10;t3=newJTextField10;t4=newJTextField10;t5=newJTextField10;t6=newJTextField10;t7=newJTextField10;t8=newJTextField10;t9=newJTextField10;text_show=newJTextField10;"产品编号";"产品名称";"产品类型";"产品总量";"产品价格";"产品厂商";"购买时间";"出厂日期";"购买人";cob=newJComboBox;l2;t2;l3;t3;l4;t4;l5;t5;l6;t6;l7;t7;l8;t8;l9;t9;p4;p5;p6;p7;p8;p9;p10;p11;b1;b2;b3;b4;l10;"产品编号";"产品名称";"产品类型";cob;text_show;b5;p12;p1;p2;p3;table=newJTable,columnName;newFlowLayout;newGridLayout4,1;newFlowLayout;newGridLayout4,2;newJScrollPanetable;400,400,600,400;true;"资产信息管理表";EXIT_ON_CLOSE;newActionListener{publicvoidactionPerformedActionEventarg0{oString;inty=.trim;;importpublicclassprop_info_selectextendsJFrameimplementsActionListener{Connectionconn=null;Statementstat=null;ResultSetrs=null;JTabletable=null;JLabellabel;JTextFieldtext;JButtonbtn_ok=null,btn_exit=null;JPanelp1=null,p2=null;Choicec1=null,c2=null;publicstaticvoidmainStringargs{newprop_info_select.show;}VectorcolumnName=newVector;publicprop_info_select{"资产设备信息情况查询";0,0,500,300;newFlowLayout;JTableprop_info=null;"设备编号";"设备名称";"设备型号";"设备数量";"库存数量";"设备价格";"出厂商家";"生产时间";"购买时间";"购买者";p1=newJPanel;p2=newJPanel;c1=newChoice;c2=newChoice;text=newJTextField;;text=newJTextField5;"设备编号";"=";btn_ok=newJButton"确定";btn_exit=newJButton"取消";newJLabel"查询字段";c1;newJLabel"运算符";c2;newJLabel"数量";text;btn_ok;btn_exit;"查询数据";newActionListener{publicvoidactionPerformedActionEventarg0{DefaultTableModeldtm=newDefaultTableModelselectDate,columnName;dtm;;;}};this;table=newJTable,columnName;newBorderLayout;p1,;newJScrollPanetable,;400,300,500,400;EXIT_ON_CLOSE;}publicVectorselectDate{Vectordata=newVector;try{"";conn="jdbc:;DatabaseName=_property","sa","";stat=;intx=.trim;how;}}how;}}注：本系统由第四小组共同完成;小组成员：吕斌、盛渊、吴瑶、周敏、彭璨婷