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

Illllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll用户登录////〃/〃///〃///〃/////////////////〃////〃〃//package com.newer.prop erty;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.*;import java.sql.Statement;import java.sql.ResultSet;import javax.swing.JButton;import javax.swing.JLabel;import javax.swing.JTextField;import javax.swing.JPasswordField;import javax.s wing.J Panel;import javax.swing.JFrame;public classuser_land extendsJFrame implementsActionListener{static Connection conn=null;import java.awt.B or der Lay out;import java.awt.Color;import java.awt.Dialog;import java.awt.FlowLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenuBar;import javax.swing.JMenultem;import javax.swing.JM enu;import javax.swing.JPanel;import javax.s wing.JT extAr ea;import javax.swing.JTextField;public classSys_interface extendsJFrame implementsActionListener{JPanel p=null;JM enult em jmi_lJmi_2Jmi_3JmL4,jmi_5Jmi_6Jmi_7,jmi_8Jmi_9Jmi_10;JMenuBar jmb=null;JMenu jm_l=nulljm_2=nulljm_3=nulljm_4=null;JLabel text;（）｛public Sys_interface定资产与设备管理系统叱（nthis.setTitle欢迎进入定资产与设备管理系text=new JLabelf统”）；（（宋体,））text.setFont newFont1,28;（）text.s etForeground Color.blue;p=new JPanelQ;）jmb=new JMenuBarf;（”系统功能）；jm_l=new JMenu（资产管理”）;jm_2=new JMenu（系统查询”）；jm_3=new JMenu（帮助）;jm_4=new JMenu（用户登录）；jmi_l=new JMenuItem（注销用户）；jmi_2=new JMenuItem（用户添加）；jmi_3=new JMenuItem（退出系统）；jmi_4=new JMenuItem（资产借出管理”）;jmi_5=new JMenuItem（资产信息管理jmi_6=new JMenuItem（资产信息查询”）;jmi_7=new JMenuItem资产借出查询;jmi_8=new JMenuItem资产归还查询;jmi_9=new JMenuItem关于；jmi_10=new JMenuItemjm_l.addjmi_l;jm_l.addjmi_2;jm_l.addjmi_3;jm_l.addjmi_4;jm_

2.addjmi_5;jm_

2.addjmi_6;jm_

3.addjmi_7;jm_

3.addjmi_8;jm_

3.addjmi_9;jm_

4.addjmi_10;jmb.addjm_l;jmb.addjm_2;jmb.addjm_3;jmb.addjm_4;addtext,BorderLayout.CENTER;this.s etJMenuBarfjmb;//this.setLay out new Border Layout;//this.addp,BorderLayout.NORTH;jmi_l.addActionListenernew ActionListener{public voidactionPerformedActionEvent e{newuser_land.show;};jmi_

2.addActionListenerthis;jmi_

2.addActionListenernew ActionListenerf{©Overridepublic voidactionPerformedActionEvent argO{newuser_land.show;}};jmi_3,addActionListenernew ActionListener{public voidactionPerformedfActionEvent e{new Pass_word.show;;jmi_

4.addActionListenernew ActionListener{public voidactionPerformedActionEvent e{System.exitO;};jmi_

5.addActionListenernew ActionListener{public voidactionPerformedfActionEvent e{newloan_prop_manage.show;}};jmi_

6.addActionListenerfnew ActionListener{public voidactionPerformedfActionEvent e{newproperty_Info.show;}};jmi_

7.addActionListenerfnew ActionListener{public voidactionPerformedfActionEvent e{newprop_info_select.show;};jmi_

8.addActionListenerfnew ActionListener{public voidactionPerformedfActionEvent e{newLoan_prop_select.show;;jmi_9,addActionListenerfnew ActionListener{public voidactionPerformedfActionEvent e{newback_prop_select.show;};jmi_10,addActionListenerfnew ActionListener{public voidactionPerformedfActionEvent e{newabout.show;;；this.setBounds200200500,400,,this.setDefaultCloseOperationEXIT_ON_CLOSE;}public voidactionPerformedfActionEvent e{//System.exitO;this.setVisiblefalse;}public staticvoid mainString[]args{new Sys_interface.show;//////////////////////////////////////////////////////////////////////////////////////////////////////////III IlliI IlliI IlliIIIH资产借出管理////////////////////////////////////////////////////////////〃///〃///〃////〃////〃/////〃//////〃///〃//III IIlli111III11Illi Ipackage com.newer.property;import java.awt/;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql/;import java.util.Vector;import javax.swing.*;import java.awt.event.FocusEvent;import java.awt.event.FocusListener;import java.awt.event.MouseEvent;import java.awt.event.MouseListener;import javax.swing,event.ListSelectionEvent;import javax.swing,event.ListSelectionListener;import javax.swing,event.TableModelListener;import javax.swing,event.TableModelEvent;import javax.swing.table.DefaultTableModel;import javax.swing.table.TableModel;public classloan_prop_manage extendsJFrame implementsActionListenerVectorVector data=null;DefaultTableModel model=null;Connection conn=null;Statement stat=null;ResultSet rsl=null;JTable loan_prop=null;JLabel label;JTextField text;JTextField txtO1,txt02,txtO3,txtO4,txtO5,txt06;JPanel pl=null p2=null p3=null,p4p5p6p7,p8,p9,pl0;,,,,,Choice cl=null c2=null;JLabelIbl=nulljb2=null,lb3=nulljb4=nulljb5=null lb6=null;,JButton btnok=null;JButton btnexit=null;JButton btn fresh=null;JButton btnsave=null;JButton btndel=null;VectorString columnName=new VectorQ;（）｛public loan_prop_manage）text=new JTextFieldf;（资产编号）cohimnName.add;（资产名称）;columnName.add（资产型号）;cohimnName.add（借出时间）columnName.add;（借出数量”）;columnName.add（借出人）;cohimnName.addpl=new JPanelQ;p2=new JPanelQ;）p3=new JPanelf;p4=new JPanelQ;p5=new JPanelQ;p6=new JPanelQ;p7=new JPanelQ;p8=new JPanelQ;）p9=new JPanelf;（）plO=new JPanel;（资产编号）；lb1=new JLabel（资产名称”）；（资产型号”）;lb2=new JLabellb3=new JLabelstaticStatement stat=null;static ResultSet rs=null;static Stringn Hurl=jdbc:sqlserver://

127.

0.

0.1:1433;Databas eNam e=_Prop erty;H nstaticString user=sa;nnstatic Stringpassword=;JPanel pl,p2p3,p4,p5;,JLabel Ibll,lbl2lbl3,lbl4;,JTextField txt_name;J Password Fieldtxt_pwd;JButton btnlbtn2btn3;,static{tryHClass.forName com.microsoft.sqlserver.jdbc.SQLServerDriver}catchException e{加载驱动失败；e.printStackTraceQ;借出时间；借出数量叱Ib4=new JLabellb5=new JLabel借出人；lb6=new JLabeltxt01=new JTextField8;txt02=new JTextField8;txt03=new JTextField8;txt04=new JTextField8;txt05=new JTextField8;txt06=new JTextField8;cl=new Choicef;c2=new Choicef;text=new JTextField5;资产编号叱cl.add；c

2.add=确定”；退出btn_ok=new JButton btn_exit=new JButton；”刷新”;btn_fresh=new JButton btn_save=new保存；删除；JButton btn_del=new JButtonpl.addfnew查询字段;JLabel pl.addcl;运算符”；pl.addfnew JLabel“pl.addc2;输入数据”;pl.addfnew JLabelpl.add text;pl.addbtn_ok;p l.addbtn_exit;请操作;npl.setBorderBorderFactory.createTitledBorderp

3.addlbl;p

3.addtxt01;p

4.addlb2;p

4.addtxt02;p

5.addlb3;p

5.addtxt03;p

6.addlb4;p

6.addtxt04;p

7.addlb5;p

7.addtxt05;p

8.addlb6;p

8.addtxt06;plO.add btn_fresh;plO.add btn_save;plO.addbtn_d el;p

2.set Lay outnewGridLayout32;,p

2.addp3;p

2.addp4;p

2.addp5;p

2.addp6;p

2.addp7;p

2.addp8;loan_prop=new JTablethis.getDate,columnName;model=newDefaultTableModelgetDate,columnName;p

9.addnew JScrollPaneloan_prop;this.setLayoutnew GridLayout4,1;this,add pl;this.addp9;this.addp2;this.addplO;；this.setBounds400,300500,400,this.setDefaultCloseOperationEXIT_ON_CLOSE;资产借出管理;this.setTitlebtn_save.addActionListenernew ActionListener{public voidactionPerformedfActionEvent argO{HClass.forName;nconn=DriverManager.getConnection jdbc:sqlserver:/n n H nn；/

127.

0.

0.1:1433;DatabaseName=_property sa,,stat=conn.createStatement;nString sql=insert intoloan_infon H,f,prop_name prop_type loan_time loan_num+values+txt

02.get,,,；,,Text+,+txtO

3.getText++txtO

4.getText+,+txtO

5.getTextstat.executeUpdatesql;D efaul tTab1eM od elmod=newDefaultTableModelgetDate,columnName;loan_prop.setModelmod;loan_prop.repaint;loan_prop.updateUIf;}catchException e{System.out.printlne.getMessage;try{ifrsl!=null{rsl.closed;ifstat!=null{stat.closef;}ifconn!=null{conn.closeQ;}}catchException e2{关闭失败;System,out.println1e

2.print StackTrac e;}};btn_ok.addActionListenernew ActionListener{public voidactionPerformedActionEvent e{DefaultTableModel dtb=newDefaultTableModelselectDate,columnName;loan_prop.setModeldtb;loan_prop.repaint;loan_prop.updateUIf;};/*btn_exit.addActionListenernew ActionListener{publicvoid actionPerformedActionEvent argO{btn_exit.addActionListenerthis;btn_fresh.addActionListenernew ActionListener{D efaultTableModel modnewpublic voidactionPerformedActionEvent argO{DefaultTableModelgetDate,columnName;loan_prop.setModelmod;loan_prop.repaint;loan_prop.updateUIf;}；loan_prop.getSelectionModel.addListSelectionListenernew ListSelectionListener{public voidvalueChangedListSelectionEvente{btn__del.addActionListenernewActionListener{public voidactionPerformedfActionEvent argO{try{int j=loan_prop.getSelectedRow;HClass.forNamenconn=DriverManager.getConnectionn n H nn；.1:1433;DatabaseName=_property,sa,stat=conn.createStatement;String sql1=delete fromH nn nnloan_info whereprop_id=++data.getj.get0+;stat.executeUpdatefsql1;}catchException ee{System.out.printlnee.getMessage;}finally{rsl.closeQ;ifstat!=null{stat.closef;}ifconn!=null{conn.closef;}catchException e2{关System.out.printing闭失败；e

2.printStackTrace;!DefaultTableModel mod=new DefaultTableModelgetDate,columnName;loan_prop.setModelmod;loan_prop.repaintf;loan_prop.updateUIf;}；};loan_prop.getSelectionModel.addListSelectionListenernew ListSelectionListener{public voidvalueChangedfListSelectionEvent einti=loan_prop.getSelectedRow;txt

01.setTextdata.geti.get

0.toString;txtO

2.s etTextString data.geti.getl;txt

03.s etText String data,get i.get2;txt

04.setTextdata.geti.get

3.toString;txtO

5.s etText data,geti.get

4.toStringf;txtO

6.s etText data.geti.get

5.toStringf;}};}public VectorselectDate{data=new VectorVector;trynconn=DriverManager.getConnectionn n n，n；.1:1433;DatabaseName=_property sa/stat=conn.createStatement;int x=Integer.parselnttext.getText.trim;//System.out.printlnx;rs1=stat.executeQuery select*from loan_info whereHprop_id=+x;whilefrs l.next{Vector al=new Vectorf;n nal.addrsl.getlnt prop_id;H nal.addfrs

1.getString prop_name;H n；al.addrsl.getString prop_type H Hal.addrsl.getDate loan_time;n nal.addrsl.getlnt loan_num;n H；al.addfrs

1.getString u_namedata.addal;}}catchException e{・e printStackT rac e;}finally{定资产与设备用户登录）；nthis.setTitlepublic user_land{pl=new JPanelQ;p2=new JPanelQ;p3=new JPanelQ;p4=new JPanelQ;p5=new JPanelf;欢迎登录；lbll=new JLabel用户名:；lbl2=new JLabel密码；lbl3=new JLabeltxt_name=new JTextFieldlO;txt_pwd=new JPasswordField10;“登录；btnl=new JButton清空；btn2=new JButton退出”;btn3=new JButtonpl.addlbll;p

2.addlbl2;p

2.add txt_nam e;try{ifrsl!=null{rsl.closeQ;ifstat!=null{stat.closed;}ifconn!=null{conn.closed;}}catchException e2{关闭失败;System,out.printine

2.print StackTrac e;}}return data;}public VectorgetDate{data=new VectorVector;tryn;Hconn=DriverManager.getConnection jdbc:sqlserver:/nf n H,；/

127.

0.

0.1:1433;DatabaseName=_property/sa/stat=conn.createStatement;n H；rs1=stat.executeQuery select*from loan_infowhilefrsl.next{Vector al=new Vectorf;H H；al.addfrs

1.getInt prop_id H H；al.addrsl.getString prop_name H n；al.addrsl.getString prop_type n n；al.addfrs

1.getDate loan_time n n；al.addfrs

1.getlnt loan_num H Hal.addrs

1.getString u_name;data,add al;}catchException e{System.out.printlne.getMessage;}finally{try{ifrsl!=null{rsl.closed;ifstat!=null{stat.closef;ifconn!=null{conn.closef;}}catchException e2{关闭失败;System,out.printine

2.printStackTrace;}return data;public staticvoid mainString[]args{newloan_prop_manage.show;}public voidactionPerformedfActionEvent e{//System.exitO;this.setVisiblefalse;IIIIII nili HUi UHi mu mu muumu HH i HUi HUi HU11m11HHi资产借出查询//〃////〃////////////〃////〃///〃//////////〃/〃///i///11///11//1111///11//11111/1111//11///11////1///11//////////////////////package com.newer.prop erty;import java.sql.*;import java.util.Ar rayLis t;import javax.swing.JButton;import java.awt.event/;import javax.swing.JTextField;import java.util.Vector;import java.awt.BorderLayout;import java.awt.Choice;import java.awt.FlowLayout;import javax.swing.BorderFactory;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;public classLoan_prop_s elect extendsJFrame implementsActionListener{Connection conn=null;Statement stat=null;ResultSet rs=null;JTable table=null;JLabel label;JTextField text;JButtonbtn_ok=null btn_exit=null;,JPanel p1=null,p2=null;）VectorString columnName=new Vectorf;（）public Loan_prop_select{（资产借出查询”）；（流水号）;this.setTitlecohimnName.add资产编号cohimnName.add“借用人;cohimnName.add借出数量”;cohimnName.add借出时间”；cohimnName.addpl=new JPanel;p2=new JPanel;text=new JTextFieldf;text=new JTextField5;查询”；btn_ok=new JButton退出”；btn_exit=new JButton资产编号；pl.addfnew JLabelpl.add text;pl.addbtn_ok;p l.addbtn_exit;数据查询»;Hpl.setBorderBorderFactory.createTitledBorderbtn_exit.addActionListenerthis;table=new JTablethis.getDate columnName;,this.setLayoutnew BorderLayoutf;this.addp1,BorderLayout.NORTH;this.addfnew JScrollPanetable,BorderLayout.CENTER;；this.setBounds400,300500,400,this.setDefaultCloseOperationEXIT_ON_CLOSE;btn_ok.addActionListenernew ActionListenerf{©Overridepublic voidactionPerformedActionEvent argO{DefaultTableModel dtm=newDefaultTableModelselectDate columnName;table.setModeldtm;table.repaint;table.updateUlQ;}};}public VectorselectDate{VectorVector data=new VectorVector;try{HClass.forNamen；nconn=DriverManager.getConnection jdbc:sqlserver:/n n H nn/

127.

0.

0.1:1433;DatabaseName=_property,sa,;stat=conn.createStatement;int x=Integer.parseInttext.getText.trim;//System.out.printin x;Hrs=stat.executeQuery select*from loan_info wherenprop_id=+x;whilers.next{Vector al=new VectorQ;n nal.addrs.getString loan_id;H H；al.addrs.getString prop_id MHal.addfrs.getString u_id;H nal.add rs.get String loan_num;n Hal.addfrs.getString loan_time;data.addal;}}catchException e{System.out.printlne.getMessage;}finally{〃关闭try{rs.closeQ;ifstat!=null{stat.closef;ifconn!=null{conn.closef;}catchException e2{关闭失败；System.out.printine

2.printStackTracef;}}return data;}public VectorgetDate{VectorVector data=new VectorVector;tryMClass.forName）；nconn=DriverManager.getConnection jdbc:sqlserver:/n nH nn/

127.

0.

0.1:1433;DatabaseName=_property,sa,;stat=conn.createStatement;H n；rs=stat.executeQuery select*from loan_Info whilers.next{Vector al=new Vectorf;H Hal.add rs.get String loan_id;H H；al.addrs.getString prop_id,n；al.addrs.getString u_id nH；al.addrs.getString loan_num H n；al.addrs.getString loan_timedata.addal;}}catch Exception e{System.out.printlne.getMessage;}finally{//关闭try{ifrs!=null{rs.closed;ifstat!=null{p

4.addbtnl;p

4.addbtn2;p

4.addbtn3;p

5.addlbl4;；this.setLayoutfnew GridLayout5,1this,add pl;this.addp2;this.addp3;this.addp4;this.addp5;this.setBounds400,300,400,300;this.setDefaultCloseOperationEXIT_ON_CLOSE;this.setVisibletrue;//添加按钮登录事务btn

1.addActionListenerfnew ActionListener{public voidactionPerformedActionEvent e{,n,if txt_name.getText.equals==truetxt_pwd.getText.equalHH==sfalse登录失败，用户名不能为空lbl

4.setTextstat.closed;ifconn!=null{conn.closef;}catchException e2{关闭失败;System,out.printine

2.printStackTracef;}}return data;public staticvoid mainString[]args{new Loan_prop_select.show;}public voidactionPerformedActionEvent e{//System.exitO;this.setVisiblefalse;//////////////////////////////////////////////////////////////////////////////////////////////////////////III IlliI III资产归还查询////////////////////////////////////////////////////////////〃///〃///〃////〃////〃/////〃//////〃///〃/////////////package com.newer.property;import java.sql.*;import java.util.Vector;import java.awt.BorderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.FocusEvent;import java.awt.event.FocusListener;import java.awt.event.MouseEvent;import java.awt.event.MouseListener;import javax.swing.BorderFactory;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JTextField;import javax.swing.JButton;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;import javax.swing.table.TableModel;import javax.swing,event.ListSelectionEvent;import javax.swing,event.ListSelectionListener;import javax.swing.event.TableModelEvent;import javax.swing.event.TableModelListener;public classback_prop_select extendsJFrame implementsActionListener{VectorVector data=null;DefaultTableModel model=null;Connection conn=null;Statement stat=null;ResultSet rs=null;JPanel palpa2;JButton btnlbtn2;JTable tab=null;JTextField tex=null;JTextField txt1,txt2,txt3,txt4,txt5;JLabel labl,lab2,lab3;Vector columnName=new VectorQ;（）｛public back_prop_select（流水号）；（资产编号”）；cohimnName.add columnName.add（借用人）；（借cohimnName.add1111111^

1116.@1用数量）；（借用时间”）;columnName.add cohimnName.add（归还数量”）；（”归还时间”）；columnName.add）pal=new JPanelf;）pa2=new JPanelf;（确定”）；btnl=new JButton（“退出”）;btn2=new JButton（查询字段:）;lab1=new JLabel（借用人叱lab2=new JLabel（）tex=new JTextField5;））tab=new JTablefthis.getDatef,columnName;txtl=new JTextFieldlO;txt2=new JTextFieldlO;txt3=new JTextFieldlO;txt4=new JTextFieldlO;txt5=new JTextFieldlO;pal.addflab1;pal.addlab2;pal.add tex;pal.addbtnl;pal.addbtn2;pa

2.addtab;model=new DefaultTableModelgetDate columnName;tab=new JTablemodel;查询参数・・pal setBorderBorderFactorycreateTitledBorder；pa

2.addnew JScrollPanetab;资产归还查询”；this.setTitlethis.s etLay outn ewBorderLayoutf;this.addfpa1,Bord er Lay out.NORTH;this.addfnew JScrollPanetab;this.setBounds300,200500,300;,this.s etD efaultClo s eOperationEXIT_O N_CLOSE;//查询btn

1.addActionListenernew ActionListener{public voidactionPerformedfActionEvent e{、定义一个方法//I、更新表格的显示〃2Defaul tTab1eM od eldtm=newDefaultTableModelselectDatecolumnName;tab.s etModeldtm;tab.r epaint;tab.updateUIf;}};/*tab.getSelectionModel.addListSelectionListenernew ListSelectionListener{public voidvalueChangedfListSelectionEvent e{int x=tab.getSelectedRowf;txt

1.s etText Stringdata.getx.getO;txt2,s etText Stringdata.getx.getl;txt

3.s etText Stringdata,get x.get2;txt

4.s etText Stringdata.get x.get3;txt

5.s etTextdata.getx.get

4.toString;;*///选中显示/*tab.getSelectionModel.addListSelectionListenernew ListSelectionListener{public voidvalueChangedfListSelectionEvent e{int x=tab.getSelectedRow;txt

1.s etText Stringdata.get x.get0;txt

2.setT ext Stringdata.get x.getl;txt

3.s etTextStringdata,get x.get2;txt

4.s etText data,get x.get

3.toStringO;;Vbtn

2.addActionListenerthis;public VectorgetDate{VectorVector data=new VectorVector;tryHClass.forNamenconn=DriverManager.getConnection jdbc:sqlserver:/nH n n；/

127.

0.

0.1:1433;DatabaseName=Property sa/123stat=conn.createStatement;Hn；rs=stat.executeQuery select*from loan_Info whilers.next{Vector al=new Vectorf;n n；al.addrs.getString loan_id,f Hal.add rs.get String pr op_id;nH；al.addrs.getString u_id Hnal.add rs.get Stringloan_time;Hn；al.addrs.getString loan_numdata.addal;}}catchException e{System.out.printlne.getMessage;}finally{//关闭try{ifrs!=null{rs.closef;ifstat!=null{stat.closeQ;ifconn!=null{conn.closef;关闭失败；System.out.printine

2.printStackTrace;}}return data;public VectorselectDate{data=new VectorVector;tryHClass.forNamenconn=DriverManager.getConnectionn Hn n；.1:1433;DatabaseName=Property sa/123stat=conn.createStatement;=,,String lablselect*from loan_info where,H；u_id=+tex.getText.trim+”rs=stat.executeQuerylab1;whilers.next{Vector back=new VectorQ;if txt_name.getText.equals==false86txt_pwd.getT ext.equal s==true登录失败，密码不能为空”;lbl

4.setTextif txt_name.getText.equals==truetxt_pwd.getText.equals==true登录失败，用户名/密码不能为lbl

4.setText空；ifis_Property{new Sys_interface.show;}elseif txt_name.getTextf.equals==falsetxt_pwd.getText.equals==false登录失败，用户名/密码错误lbl

4.setText；}};1nback.add rs.get String1*loan_id;H H；back.addrs.getString prop_id H H；back.addrs.getString u_id n n；back.addrs.getString loan_timeb ack.add rs.get IntHloan_num;data.addback;}}catchException e{System.out.printlne.getMessage;}finally{//关闭try{ifrs!=null{rs.closef;ifstat!=null{stat.closeQ;ifconn!=null{conn.closef;关闭失败”;System.out.printine

2.print StackTrac e;}}return data;public staticvoid mainString[]args{new back_prop_select.show;public voidtableChangedTableModelEvent e{public voidactionPerformedfActionEvent e{this.setVisiblefalse;}///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////资产信息管理///////〃/〃〃///〃/////////////////〃////〃〃///〃///////////////////////////////////////////////////////u mumumm u/〃资产信息管理package com.newer.prop erty;import java.awt.*;import java.awt.event.*;import java.sql.*;import java.util/;import javax.swing.*;import javax.swing.JFrame/;import java.util.Ar rayLis t;import java.util.Vector;import java.awt.FlowLayout;import java.awt.G ridLayout;import javax.swing.JFrame;import javax.swing.JScrollPane;import javax.swing.JTable;import java.awt.event.ActionListener;import java.awt.event.ActionEvent;import javax.swing.JButton;import javax.swing.JComboBox;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;import javax.swing.event.TableModelEvent;import javax.swing,event.TableModelListener;import javax.swing.table.DefaultTableModel;import javax.swing.table.TableModel;public classproperty_Info extendsJFrame implementsActionListener{Connection conn=null;Statement stat=null;ResultSet rs=null;JPanel pl,p2,p3,p4,p5,p6,p7,p8,p9,pl0,pl lpl2;JButton bl,b2,b3b4b5;,,JLabel ll1213J415,16171819110;,,,,,,JTextField tl,t2,t3,t4t5t6,t7t8t9text_show;,,,,,JTable table=null;JComboBox cob;String sql;VectorString columnName=new Vector;public property_Info{pl=new JPanelf;p2=new JPanelf;p3=new JPanelQ;p4=new JPanel;p5=new JPanel;p6=new JPanel;p7=new JPanel;p8=new JPanelQ;p9=new JPanel;plO=new JPanelf;pl l=new JPanelQ;pl2=new JPanelf;刷新叱存盘”;bl=new JButton1b2=new JButton退出;b3=new JButton删除b4=new JButtonJ”确定”;b5=new JButton产品编号”;ll=new JLabel产品名称;12=new JLabel产品类型”;13=new JLabel产品总量14=new JLabel”（产品价格”）；15=new JLabel（产品厂商）；16=new JLabel（购买日期）；17=new JLabel（出产日期）；18=new JLabel（购买人”）；19=new JLabel（产品名称）；110=new JLabel（）tl=new JTextFieldlO;（）t2=new JTextFieldlO;（）t3=new JTextFieldlO;（）t4=new JTextFieldlO;（）t5=new JTextFieldlO;（）t6=new JTextFieldlO;（）t7=new JTextFieldlO;（）t8=new JTextFieldlO;（）t9=new JTextFieldlO;（）text_show=new JTextFieldlO;（产品编号”）；cohimnName.add（”产品名称”）；（”产品类cohimnName.add cohimnName.add型”）；（产品总量”）；（产品价格cohimnName.add cohimnName.add）;“产品厂商”；cohimnName.add购买时间cohimnName.add出厂日期；columnName.add购买人;cohimnName.addcob=new JComboBoxf;p

4.add12;p

4.addt2;p

5.add13;p

5.addt3;p

6.add14;p

6.addt4;p

7.add15;p

7.addt5;p

8.add16;p

8.addt6;p

9.add17;p

9.addt7;pl

0.add18;pl

0.addt8;pl l.add19;pl l.addt9;p

2.addp4;p

2.addp5;p

2.addp6;p

2.addp7;p

2.addp8;p

2.addp9;p

2.addpl0;p

2.addpl1;p

3.addbl;p

3.addb2;p

3.addb3;p

3.addb4;pl

2.add110;产品编号;cob.additem产品名称;cob.additem产品类型;cob.additempl

2.addcob;p

12.add text_show;pl

2.addb5;this.addpl2;this.addpl;this.addp2;this.addp3;table=new JTablethis.getDatecolumnName;,this.s etLayoutn ewFlowLayoutj;；this.setLayoutnew GridLayout4,1p

2.setLayoutfnew FlowLayoutJ;p

2.setLayoutfnew GridLayout4,2;pl.addnew JScrollPanetable;this.setBounds400,400^600,400;this.setVisibletrue;资产信息管理表叱this.setTitlethis.setDefaultCloseOperationEXIT_ON_CLOSE;b

1.addActionListenerfnew ActionListener{public voidactionPerformedfActionEventargO{〃刷新，重新显示数据D efaultTableModel dtm=newDefaultTableModelgetDate columnName;,table,s etModeldtm;table.repaintQ;table.updateUlQ;；b

2.addActionListenernew ActionListenerf{public voidactionPerformedActionEvent argO{try{MClass.forNamenconn=DriverManager.getConnection jdbc:sqlserver:/.1:f H nn/

127.

0.01433;DatabaseName=_property7sa,;stat=conn.createStatement;HString sql=insert intoprop_Infoprop_name,prop_type,prop_num,prop_price prop_commdity,proH n,H,,np_buyTime prop_proTime prop_purchaser+values+t

2.getText+^+t

3.,,n,，，fn ngetText+^+t

4.getText+7+t

5.getText+7+t

6.getTen,n n，,n nn,，txt+\+t

7.getText+7+t

8.getText+7+t

9.getText+;stat,execut eUpdatesql;btnl.addActionListenerthis;//清空用户名和密码btn

2.addActionListenerfnew ActionListener{public voidactionPerformedActionEvent e{txt_name.setT extnull;txt_pwd.s etTextnull;lbl

4.s etText null;//退出btn

3.addActionListenerfnew ActionListener{public voidactionPerformedActionEvent e{System,exit0;）；}catchException e{System.out.printlne.getMessage;}};b

3.addActionListenerthis;b

5.addActionListenernew ActionListenerf{public voidactionPerformedActionEvent argO{DefaultTableModel dtm=newDefaultTableModelselectDate,columnName;table.setModeldtm;table.repaintf;table.updateUlQ;}};}public VectorgetDate{VectorVector data=new VectorVector;try{HClass.forName;nconn=DriverManager.getConnectionn fnH,；.1:1433;DatabaseName=_Property/sa/stat=conn.createStatement;nn；rs=stat.executeQuery select*from prop_Info whilers.next{Vector al=new Vectorf;Hal.add rs.get Stringpr op_id;f,!,；al.addrs.getString prop_name!,H；al.addrs.getString prop_type Hnal.add rs.get String prop_num;H H；al.addrs.getString prop_price H Hal.addrs.getString prop_commdity;H H；al.addrs.getString prop_buyTime HH；al.addrs.getString prop_proTime n；al.add rs.get Stringpr op_pur chaser data.addal;}}catch Exceptione{System.out.printlne.getMessage;}finally{//关闭try{ifrs!=null{rs.closef;}ifstat!=null{stat.closef;}ifconn!=null{conn.closed;}}catchException e2{关闭失败;System,out.printine

2.print StackTrac e;}return data;public VectorselectDate{VectorVector data=new VectorVector;try{HClass.forNamenconn=DriverManager.getConnection jdbc:sqlserver:/，H nn；/

127.

0.

0.1:1433;DatabaseName=_Property7sa,stat=conn.createStatement;String x=cob.getSelectedItem.toString;int y=Integer.parseInttext_show.getText.trim;//System.out.printin y;nrs=stat.executeQuery select*from prop_info whereHprop_id=+y;whilers.next{Vector v=new VectorQ;HH；v.addrs.getString prop_id n nv.addrs.getString prop_name;nnv.addrs.getString prop_type;Hn；v.addrs.getString prop_num HH；v.addrs.getString prop_price HH；v.addrs.getString prop_commdity HH；v.addrs.getString prop_buyTime HH；v.addrs.getString prop_proTime nnv.add rs.get String prop_purchas er;data,addv;}catchException e{System.out.printlne.getMessage;}finally{〃关闭try{ifrs!=null{rs.closef;}ifstat!=null{stat.closef;ifconn!=null{conn.closed;}}catchException e2{关闭失败；System.out.printine

2.print StackTrac e;return data;public voidactionPerformedfActionEvent e{//System.exitO;this.setVisiblefalse;}public staticvoid mainString[]args{new property_Info;}//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////资产信息查询/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////package com.newer.property;import java.awt.FlowLayout;import javax.swing.JFrame;import javax.swing.JTextField;import javax.swing.JTable;import java.sql.*;import java.util.Vector;import javax.swing.JScrollPane;import java.awt.event.*;import java.awt.BorderLayout;import java.awt.Choice;import javax.swing.BorderFactory;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JButton;import javax.swing.table.DefaultTableModel;public classprop_info_select extendsJFrame implementsActionListener{Connection conn=null;Statement stat=null;ResultSetrs=null;JTable table=null;JLabel label;JTextField text;JButtonbtn_ok=null btn_exit=null;JPanel p1=null,p2=null;Choice c1=null,c2=null;（）public staticvoid mainString[]args{（）（）new prop_info_select.show;}）VectorString columnName=new Vectorf;（）public prop_info_select{（资产设备信息状况查询）this.setTitle;（）this.setBounds0,0,500,300;）this.setLayoutfnew FlowLayoutO;JTable prop_info=null;（设备编号）;cohimnName.add（设备名称”）;cohimnName.add（设备型号）；cohimnName.add（设备数量）；cohimnName.add（库存数量）；columnName.add（设备价格）；cohimnName.add（出厂商家）；（H生cohimnName.add columnName.add产时间”）;巳@购买时间”；811111111^%1111“”购买者，;cohimnName.addpl=new JPanelf;p2=new JPanelf;cl=new ChoiceQ;c2=new Choicef;text=new JTextFieldQ;;text=new JTextField5;设备编号”;cl.addc

2.add=;确定；btn_ok=new JButton取消”；btn_exit=new JButton查询字段;pl.addfnew JLabelpl.addcl;运算符；pl.addfnew JLabelpl.addc2;数量；pl.addfnew JLabelpl.add text;pl.addbtn_ok;p l.addbtn_exit;查npl.setBorderBorderFactory.createTitledBorderbtn_ok.addActionListenernew ActionListenerf{DefaultTableModel dtm=newpublic voidactionPerformedActionEvent argO{DefaultTableModelselectDate columnName;table.s etModeldtm;table.repaintQ;table.updateUlQ;}；btn_exit.addActionListener this;table=new JTablethis.getDateQ columnName;this.setLayoutnew BorderLayoutQ;this.addpl,BorderLayout.NORTH;this.addnewJScrollPanetable,BorderLayout.CENTER;；this.setBounds400300500,400,,this.setDefaultCloseOperationEXIT_ON_CLOSE;}public VectorselectDate{VectorVector data=new VectorVector;protected voiduser_landObject setVisible{//TODO Auto-gen erated methodstub}public booleanis_Property{try{连接胜利；stat=conn.createStatement;=,HString sqlselect*from Admin_Info;rs=stat.executeQuerysql;whilers.next{nHHn//System.out.printlnrs.getString A_name+\t+rs.getStringA_pwd;String name=txt_name.getText;String pwd=txt_pwd.getText;n nifname.equalsrs.getString A_nameH Hpwd.equalsrs.getString A_pwd{登录胜利！！”;try{nClass.forNamenconn=DriverManager.getConnectionn nn nn.1:1433;DatabaseName=_property,sa,;stat=conn.createStatement;int x=Integer.parseInttext.getText.trim;//System.out.printin x;rs=stat.executeQuery select*from prop_info whereprop_id=+x;whilers.next{Vector al=new VectorQ;nn；al.addrs.getlnt prop_id H Hal.addrs.getString prop_name;HH；al.addrs.getString prop_type11nal.add rs.getlntprop_num;HH；aLaddrs.getInt prop_spare nn；al.addrs.getFloat prop_price HHal.add rs.get Stringprop_commdity;HH；al.addrs.getDate prop_proTime nH；al.addrs.getDate prop_buyTime HH；al.addrs.getString prop_purchaser data.addal;}catchException e{System.out.printin e.getM essagej;}finally{//关闭tryifrs!=null{rs.closed;}ifstat!=null{stat.closef;}ifconn!=null{conn.closed;}}catchException e2{关闭失败；Sy stem.out.pr intine

2.print StackTrac e;return data;public voidactionPerformedActionEvent e{//System.exitO;this.setVisiblefalse;}public VectorgetDate{VectorVector data=new VectorVector;try{HClass.forNamenconn=DriverManager.getConnectionn fHnn；.1:1433;DatabaseName=_property/sa,stat=conn.createStatement;Hrs=stat.executeQuery select*fromHprop_Info;whilers.next{Vector al=new VectorQ;nn；al.addrs.getlnt prop_id HHal.addrs.getString prop_name;HHal.addrs.getString prop_type;nn；al.addrs.getlnt prop_num nn；al.addrs.getlnt prop_spare HH；al.addrs.getFloat prop_price nnal.add rs.get String prop_commdity;HH；al.addrs.getDate prop_proTime HH；aLaddrs.getDate prop_buyTime nHal.addrs.getString prop_purchaser;data.addal;}}catchException e{System.out.printlne.getMessage;}finally{//关闭try{ifrs!=null{rs.closef;}ifstat!=null{stat.closed;ifconn!=null{conn.closed;}}catchException e2{关闭失败;HSystem.out.printlne

2.printStackTrac e;}return data;////////////////////////////////////////////////////////////////////////////////////////////////////////////////////管理员添加/////////////////////////////////////////////////////////////////////////////////package com.newer.property;import java.awt.B orderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;import org.omg.CORBA.SystemException;public classPass_word extendsJFrame implementsActionListener{Connectionconn=null;Statement stat=null;JButton btnl,btn2;」JLabel lblb2Jb3,lb4;JTextField txt1txt2,txt3,txt4;,JPanel palpa2,pa3;public Pass_word{pal=new JPanelf;pa2=new JPanelf;pa3=new JPanelf;“增加”;btnl=new JButton退出”；btn2=new JButton用户lbl=new JLabel“ID;用户姓名;lb2=new JLabel用户口令；lb3=new JLabel重复口令lb4=new JLabeltxtl=new JTextFieldlO;txt2=new JTextFieldlO;txt3=new JTextFieldlO;txt4=new JTextFieldlO;pal.addlbl;pal.addtxtl;pal.addlb2;pal.addtxt2;pa

2.addlb3;pa

2.addtxt3;pa

2.addlb4;pa

2.addtxt4;pa

3.addbtnl;pa

3.addbtn2;this.setLayoutnew BorderLayoutf;this.addpa3BorderLayout.SOUTH;,this.addfpal,BorderLayout.NORTH;this.addpa2,BorderLayout.CENTER;this.setBounds200300,500,150;,this.setD efaultCloseOperationEXIT_O N_CLO SE;用户添加管理”;this.setTitlebtn

1.addActionListenernew ActionListener{public voidactionPerformedActionEventargO{trynClass.forName；nconn=DriverManager.getConnectionf,nn,H.1:1433;DatabaseName=_Property sa/;stat=conn.createStatement;nString sql=insert inton,,,,n nadminJnfoa_pwd,a_name+values+txt

3.getText+7+txt

2.getTextO+;stat,ex ecuteU pdat es ql;“添加胜利”；System.out.println}catchException e{System.out.printlne.getMessage;；〃退出btn

2.addActionListenerthis;}public voidactionPerformedActionEvent e{//System.exitO;this.setVisiblefalse;public staticvoid mainString[]args{new Pass_word.show;/////////////////////////////////////////////////////m Imu IHU Imu Im11m I关于/〃//////////////〃//〃///////////〃〃〃/////〃/////////////〃///〃///〃/////〃///〃package com.newer.property;import java.awt.Border Layout;import java.awt.Color;import java.awt.Font;import javax.swing.JFrame;import javax.swing.JLabel;public classabout extendsJFrame{JLabel text;public about{text=new JLabelQ;this.setBounds300300,200,200;,关于叱this.setTitlereturn true;}}catchSQLException e{连接失败!!!;System,out.printinge.printStackTrace;}//关闭数据库finallytry{ifrs!=null{rs.closef;ifstat!=null{stat.closef;ifconn!=null{conn.closeQ;}}catchException e2{关闭失败；System.out.printine

2.print StackTrace;实训第四组成员出品；ntext=new JLabel宋体,text.setFontnew Font1,16;text.setForegroundColor.blue;addtext BorderLayout.CENTER;}public staticvoid mainString[]args{new about.show;注本系统由第四小组共同完成小组成员吕斌、盛渊、吴瑶、周敏、彭璨婷return false;public staticvoid mainString[]args{new user_land;}public voidactionPerformedActionEvent e{//System.exitO;this.setVisiblefalse;}//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////主界面/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////packagecom.newer.property;。