Java固定資產(chǎn)管理系統(tǒng)源代碼

1、用戶登錄/ / /importjimportjava.sql.*;publicclassuser_landextendsJFrameimplementsActionListenerstaticConnectionconn=null;staticStatementstat=null;staticResultSetrs=null;staticStringuser="sa"staticStringpassword=""JPanelp1,p2,p3,p4,p5;JLabellbl1,lbl2,lbl3,lbl4;JTextFieldtxt_name;JPassw

2、ordFieldtxt_pwd;JButtonbtn1,btn2,btn3;statictrycatch(Exceptione)加載驅(qū)動(dòng)失敗 ");e.printStackTrace();publicuser_land()this.setTitle(" 固定資產(chǎn)及設(shè)備用戶登錄 ");p1=newJPanel();p2=newJPanel();p3=newJPanel();p4=newJPanel();p5=newJPanel();lbl1=newJLabel(" 歡迎登錄 ");lbl2=newJLabel(" 用戶名： "

3、);lbl3=newJLabel(" 密碼： ");lbl4=newJLabel();txt_name=newJTextField(10);txt_pwd=newJPasswordField(10); btn1=newJButton(" 登錄 "); btn2=newJButton(" 清空 "); btn3=newJButton(" 退出 "); p1.add(lbl1);p2.add(lbl2); p2.add(txt_name);p3.add(lbl3);p3.add(txt_pwd);p4.add(btn1

4、);p4.add(btn2);p4.add(btn3);p5.add(lbl4);this.setLayout(newGridLayout(5,1);this.add(p1);this.add(p2);this.add(p3);this.add(p4);this.add(p5);this.setBounds(400,300,400,300);this.setDefaultCloseOperation(EXIT_ON_CLOSE);this.setVisible(true);/ 添加按鈕登錄事件btn1.addActionListener(newActionListener()publicvoi

5、dactionPerformed(ActionEvente)if(txt_name.getText().equals("")=true)&&(txt_pwd.getText().equals("")=false)lbl4.setText(" 登錄失敗，用戶名不能為空 ");if(txt_name.getText().equals("")=false)&&(txt_pwd.getText().equals("")=t rue)lbl4.setText" 登

6、錄失敗，密碼不能為空 "if(txt_name.getText().equals("")=true)&&(txt_pwd.getText().equals("")=tr ue)lbl4.setText(" 登錄失敗，用戶名 / 密碼不能為空 "); if(is_Property() newSys_interface().show();elseif(txt_name.getText().equals("")=false)&&(txt_pwd.getText().equals(

7、"" )=false)lbl4.setText(" 登錄失敗，用戶名 / 密碼錯(cuò)誤 "););btn1.addActionListener(this);/ 清空用戶名和密碼btn2.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)txt_name.setText(null);txt_pwd.setText(null);lbl4.setText(null););/ 退出btn3.addActionListener(newActionListener()

8、publicvoidactionPerformed(ActionEvente) System.exit( 0););protectedvoiduser_land(ObjectsetVisible)/TODOAuto-generatedmethodstubpublicbooleanis_Property()try conn=DriverManager.getConnection(url,user,password); stat=conn.createStatement();Stringsql="select*fromAdmin_Info" rs=stat.executeQue

9、ry(sql);while(rs.next() Stringname=txt_name.getText();Stringpwd=txt_pwd.getText();if(name.equals(rs.getString("A_name")&&pwd.equals(rs.getString("A_pwd") 登錄成功！ ！ );returntrue;catch(SQLExceptione)e.printStackTrace();/ 關(guān)閉數(shù)據(jù)庫finallytryif(rs!=null)rs.close();if(stat!=null)sta

10、t.close();if(conn!=null)conn.close();catch(Exceptione2)e2.printStackTrace();returnfalse;publicstaticvoidmain(Stringargs) newuser_land(); publicvoidactionPerformed(ActionEvente)/System.exit(0);this.setVisible(false);/ /主界面/ / imppublicclassSys_interfaceextendsJFrameimplementsActionListener JPanelp=nu

11、ll;JMenuItemjmi_1,jmi_2,jmi_3,jmi_4,jmi_5,jmi_6,jmi_7,jmi_8,jmi_9,jmi_10; JMenuBarjmb=null;JMenujm_1=null,jm_2=null,jm_3=null,jm_4=null;JLabeltext;publicSys_interfacethis.setTitle" 固定資產(chǎn)及設(shè)備管理系統(tǒng) "text=newJLabel " 歡迎進(jìn)入固定資產(chǎn)及設(shè)備管理系統(tǒng)"text.setFont newFont " 宋體 ",1,28 ;text.setF

12、oreground Color.blue ; p=newJPanel ;jmb=newJMenuBar ; jm_1=newJMenu "系統(tǒng)功能 " jm_2=newJMenu "資產(chǎn)管 理 " ; jm_3=newJMenu " 系統(tǒng)查詢 " ;jm_4=newJMenu "幫助 " jmi_1=newJMenuItem " 用戶登錄 " jmi_2=newJMenuItem " 注銷用戶 " jmi_3=newJMenuItem " 用戶添加 " j

13、mi_4=newJMenuItem " 退 出系統(tǒng) " jmi_5=newJMenuItem " 資產(chǎn)借出管理 " jmi_6=newJMenuItem " 資 產(chǎn)信息管理 " ; jmi_7=newJMenuItem " 資產(chǎn)信息查詢 " jmi_8=newJMenuItem " 資產(chǎn)借出查詢 " jmi_9=newJMenuItem " 資產(chǎn)歸還查詢 " jmi_10=newJMenuItem " 關(guān)于 " jm_1.add jmi_1 ;jm_1.a

14、dd jmi_2 ; jm_1.add( jmi_3 );jm_1.add( jmi_4 );jm_2.add( jmi_5 );jm_2.add( jmi_6 );jm_3.add(jmi_7);jm_3.add(jmi_8);jm_3.add(jmi_9);jm_4.add(jmi_10);jmb.add(jm_1);jmb.add(jm_2);jmb.add(jm_3);jmb.add(jm_4); add(text,BorderLayout.CENTER); this.setJMenuBar(jmb);/this.setLayout(newBorderLayout(); /this.a

15、dd(p,BorderLayout.NORTH);jmi_1.addActionListener(newActionListener() publicvoidactionPerformed(ActionEvente) newuser_land().sho w(););jmi_2.addActionListener(this); jmi_2.addActionListener(newActionListener()OverridepublicvoidactionPerformed(ActionEventarg0)newuser_land().show(););jmi_3.addActionLis

16、tener(newActionListener() publicvoidactionPerformed(ActionEvente) newPass_word(). show(););jmi_4.addActionListener(newActionListener() publicvoidactionPerformed(ActionEvente) System.exit(0););jmi_5.addActionListener(newActionListener() publicvoidactionPerformed(ActionEvente) newloan_prop_m anage().s

17、how(););jmi_6.addActionListener(newActionListener() publicvoidactionPerformed(ActionEvente) newproperty_Info().show(););jmi_7.addActionListener( newActionListener()publicvoidactionPerformed(ActionEvente) newprop_info_select().show(););jmi_8.addActionListener(newActionListener()publicvoidactionPerfor

18、med(ActionEvente) newLoan_prop_select().show(););jmi_9.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente) newback_prop_select().show(););jmi_10.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente) newabout().show(););this.setBounds(200,200,500,400);

19、this.setDefaultCloseOperation(EXIT_ON_CLOSE);publicvoidactionPerformed(ActionEvente)/System.exit(0);this.setVisible(false);publicstaticvoidmain(Stringargs)iimK = 三三三三三三三三三三三三三三三三三三三三三三三三三三/ /importjava.awt.*;r;importjava.sql.*;importjavax.swing.*;publicclassloan_prop_manageextendsJFrameimplementsAct

20、ionListenerVector<Vector>data=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;JLabel

21、lb1=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;資產(chǎn)編號 ");Vector<String>columnName=newVector();publicloan_prop_manage() text=newJTextField(); columnName.add("columnName.add(&quo

22、t; 資產(chǎn)名稱 "); columnName.add(" 資產(chǎn)型號 "); columnName.add(" 借出時(shí)間 "); columnName.add(" 借出數(shù)量 ");columnName.add(" 借出人 "); p1=newJPanel(); p2=newJPanel(); p3=newJPanel();p4=newJPanel(); p5=newJPanel(); p6=newJPanel(); p7=newJPanel();p8=newJPanel(); p9=newJPanel();

23、 p10=newJPanel(); lb1=newJLabel(" 資產(chǎn)編號 "); lb2=newJLabel(" 資產(chǎn)名稱 "); lb3=newJLabel(" 資產(chǎn)型號 "); lb4=newJLabel(" 借 出時(shí)間 "); lb5=newJLabel(" 借出數(shù)量 ");lb6=newJLabel(" 借出人 ");txt01=newJTextField(8);txt02=newJTextField(8);txt03=newJTextField(8);txt04

24、=newJTextField(8);txt05=newJTextField(8); txt06=newJTextField(8); c1=newChoice(); c2=newChoice();text=newJTextField(5);c1.add(" 資產(chǎn)編號 "); c2.add("=");btn_ok=newJButton(" 確定 "); btn_exit=newJButton(" 退出 ");btn_fresh=newJButton(" 刷新 "); btn_save=newJBut

25、ton(" 保存 ");btn_del=newJButton(" 刪除 "); p1.add(newJLabel(" 查詢字段 "); p1.add(c1);p1.add(newJLabel(" 運(yùn)算符 "); p1.add(c2);p1.add(newJLabel(" 輸入數(shù)據(jù) "); p1.add(text);p1.add(btn_ok);p1.add(btn_exit); 請操作 "); p1.setBorder(BorderFactory.createTitledBorder(

26、" p3.add(lb1);p3.add(txt01);p4.add(lb2);p4.add(txt02);p5.add(lb3);p5.add(txt03);p6.add(lb4);p6.add(txt04);p7.add(lb5);p7.add(txt05);p8.add(lb6);p8.add(txt06);p10.add(btn_fresh);p10.add(btn_save);p10.add(btn_del);p2.setLayout(newGridLayout(3,2);p2.add(p3);p2.add(p4);p2.add(p5);p2.add(p6);p2.add(

27、p7);p2.add(p8); loan_prop=newJTable(this.getDate(),columnName); model=newDefaultTableModel(getDate(),columnName);p9.add(newJScrollPane(loan_prop); this.setLayout(newGridLayout(4,1);this.add(p1);this.add(p9);this.add(p2);this.add(p10);this.setBounds(400,300,500,400);this.setDefaultCloseOperation(EXIT

28、_ON_CLOSE);this.setTitle(" 資產(chǎn)借出管理 ");btn_save.addActionListener(newActionListener() publicvoidactionPerformed(ActionE ventarg0) tryconstat=conn.createStatement();Stringsql="insertintoloan_info(prop_name,prop_type,loan_time,loan_num)"+"values('"+txt02.getText()+"

29、;','"+txt03.getText()+"','"+txt04.getText()+"','"+txt0 5.getText()+"')" stat.executeUpdate(sql);DefaultTableModelmod=newDefaultTableModel(getDate(),columnName);loan_prop.setModel(mod);loan_prop.repaint();loan_prop.updateUI();catch(Except

30、ione)tryif(rs1!=null)rs1.close();if(stat!=null)stat.close();if(conn!=null)conn.close();catch(Exceptione2)關(guān)閉失敗 ");e2.printStackTrace(););btn_ok.addActionListener(newActionListener() publicvoidactionPerformed(ActionEvente)DefaultTableModeldtb=newDefaultTableModel(selectDate(),columnName);loan_pro

31、p.setModel(dtb);loan_prop.repaint();loan_prop.updateUI(););/*btn_exit.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventarg0);*/btn_exit.addActionListener(this);btn_fresh.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventarg0)DefaultTableModelmod=newDe

32、faultTableModel(getDate(),columnName);loan_prop.setModel(mod);loan_prop.repaint();loan_prop.updateUI(););loan_prop.getSelectionModel().addListSelectionListener( newListSelectionListener() publicvoidvalueChanged(ListSelectionEvente) btn_del.addActionListener(newActionListener() publicvoidactionPerfor

33、med(ActionEventarg0) tryintj=loan_prop.getSelectedRow(); stat=conn.createStatement();Stringsql1="deletefromloan_infowhereprop_id="+""+data.get(j).get(0)+""stat.executeUpdate(sql1);catch(Exceptionee)finallytryif(rs1!=null)rs1.close();if(stat!=null)stat.close();if(conn!=n

34、ull)conn.close();catch(Exceptione2)e2.printStackTrace();DefaultTableModelmod=newDefaultTableModel(getDate(),columnName);loan_prop.setModel(mod); loan_prop.repaint();loan_prop.updateUI();););loan_prop.getSelectionModel().addListSelectionListener( newListSelectionListener()publicvoidvalueChanged(ListS

35、electionEvente) inti=loan_prop.getSelectedRow();txt01.setText(data.get(i).get(0).toString(); txt02.setText(String)data.get(i).get(1);txt03.setText(String)data.get(i).get(2); txt04.setText(data.get(i).get(3).toString();txt05.setText(data.get(i).get(4).toString(); txt06.setText(data.get(i).get(5).toSt

36、ring(););publicVectorselectDate()data=newVector<Vector>();trystat=conn.createStatement(); intx=Integer.parseInt(text.getText().trim();rs1=stat.executeQuery("select*fromloan_infowhereprop_id="+x);while(rs1.next()Vectoral=newVector();al.add(rs1.getInt("prop_id"); al.add(rs1.g

37、etString("prop_name");al.add(rs1.getString("prop_type");al.add(rs1.getDate("loan_time");al.add(rs1.getInt("loan_num");al.add(rs1.getString("u_name"); data.add(al);catch(Exceptione)e.printStackTrace();finallytryif(rs1!=null)rs1.close();if(stat!=null)s

38、tat.close();if(conn!=null)conn.close();catch(Exceptione2)e2.printStackTrace();returndata;publicVectorgetDate()data=newVector<Vector>();trystat=conn.createStatement(); rs1=stat.executeQuery("select*fromloan_info"); while(rs1.next()Vectoral=newVector();al.add(rs1.getInt("prop_id&q

39、uot;); al.add(rs1.getString("prop_name");al.add(rs1.getString("prop_type");al.add(rs1.getDate("loan_time");al.add(rs1.getInt("loan_num");al.add(rs1.getString("u_name");data.add(al);catch(Exceptione)finallytryif(rs1!=null)rs1.close();if(stat!=null)sta

40、t.close();if(conn!=null)conn.close();關(guān)閉失敗 ");catch(Exceptione2)e2.printStackTrace();returndata;publicstaticvoidmain(Stringargs)newloan_prop_manage().show();publicvoidactionPerformed(ActionEvente)/System.exit(0);this.setVisible(false);/資產(chǎn)借出查詢/ / importjava.sql.*;publicclassLoan_prop_selectextend

41、sJFrameimplementsActionListenerConnectionconn=null;Statementstat=null;ResultSetrs=null;JTabletable=null;JLabellabel;JTextFieldtext;JButtonbtn_ok=null,btn_exit=null;JPanelp1=null,p2=null;Vector<String>columnName=newVector();publicLoan_prop_select()this.setTitle(" 資產(chǎn)借出查詢 ");columnName.

42、add(" 流水號 ");columnName.add(" 資產(chǎn)編號 ");columnName.add(" 借用人 ");columnName.add(" 借出數(shù)量 ");columnName.add(" 借出時(shí)間 ");p1=newJPanel();p2=newJPanel();text=newJTextField();text=newJTextField(5);btn_ok=newJButton(" 查詢 ");btn_exit=newJButton(" 退出

43、 ");p1.add(newJLabel(" 資產(chǎn)編號 ");p1.add(text);p1.add(btn_ok);p1.add(btn_exit); 數(shù)據(jù)查詢");p1.setBorder(BorderFactory.createTitledBorder(" btn_exit.addActionListener(this);table=newJTable(this.getDate(),columnName); this.setLayout(newBorderLayout();this.add(p1,BorderLayout.NORTH);t

44、his.add(newJScrollPane(table),BorderLayout.CENTER);this.setBounds(400,300,500,400); this.setDefaultCloseOperation(EXIT_ON_CLOSE);btn_ok.addActionListener(newActionListener()Override publicvoidactionPerformed(ActionEventarg0)DefaultTableModeldtm=newDefaultTableModel(selectDate(),columnName);table.set

45、Model(dtm);table.repaint();table.updateUI(););publicVectorselectDate()Vector<Vector>data=newVector<Vector>();trystat=conn.createStatement();intx=Integer.parseInt(text.getText().trim();rs=stat.executeQuery("select*fromloan_infowhereprop_id="+x);while(rs.next()Vectoral=newVector(

46、);al.add(rs.getString("loan_id");al.add(rs.getString("prop_id");al.add(rs.getString("u_id");al.add(rs.getString("loan_num");al.add(rs.getString("loan_time");data.add(al);catch(Exceptione)finally/ 關(guān)閉tryif(rs!=null)rs.close();if(stat!=null)stat.close()

47、;if(conn!=null)conn.close();catch(Exceptione2)e2.printStackTrace();returndata;publicVectorgetDate() Vector<Vector>data=newVector<Vector>(); trystat=conn.createStatement(); rs=stat.executeQuery("select*fromloan_Info"); while(rs.next()Vectoral=newVector();al.add(rs.getString(&quo

48、t;loan_id");al.add(rs.getString("prop_id"); al.add(rs.getString("u_id");al.add(rs.getString("loan_num"); al.add(rs.getString("loan_time"); data.add(al);catch(Exceptione)finally/ 關(guān)閉tryif(rs!=null)rs.close();if(stat!=null)stat.close();if(conn!=null)conn.clo

49、se();catch(Exceptione2)e2.printStackTrace();returndata;publicstaticvoidmain(Stringargs) newLoan_prop_select().show(); publicvoidactionPerformed(ActionEvente)/System.exit(0);this.setVisible(false);/資產(chǎn)歸還查詢/importjava.sql.*;publicclassback_prop_selectextendsJFrameimplementsActionListenerVector<Vecto

50、r>data=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 ()columnName.add( " 流水號

51、 " ) ;columnName.add( " 資產(chǎn)編號") ;columnName.add( " 借用人 " )columnName.add( " 借用數(shù)量") ;columnName.add( " 借用時(shí)間") ;columnName.add( " 歸還數(shù)量") ;columnName.add( " 歸還時(shí)間") ;pa1=newJPanel ();pa2=newJPanel ();btn1=newJButton( " 確定 " ) ;btn

52、2=newJButton " 退出 " ;lab1=newJLabel " 查詢字段： "lab2=newJLabel " 借用人 "tex=newJTextField 5 ;tab=newJTable this.getDate ,columnName txt1=newJTextField 10 ;txt2=newJTextField 10 ;txt3=newJTextField(10);txt4=newJTextField(10);txt5=newJTextField(10);pa1.add(lab1);pa1.add(lab2);

53、pa1.add(tex);pa1.add(btn1);pa1.add(btn2);pa2.add(tab);查詢參數(shù)model=newDefaultTableModel(getDate(),columnName);tab=newJTable(model);pa1.setBorder(BorderFactory.createTitledBorder("pa2.add(newJScrollPane(tab);this.setTitle(" 資產(chǎn)歸還查詢 ");this.setLayout(newBorderLayout();this.add(pa1,BorderLay

54、out.NORTH);this.add(newJScrollPane(tab);this.setBounds(300,200,500,300); this.setDefaultCloseOperation(EXIT_ON_CLOSE);/ 查詢btn1.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)/1 、定義一個(gè)方法/2 、更新表格的顯示DefaultTableModeldtm=newDefaultTableModel(selectDate(),columnName);tab.setModel(dtm);tab.repaint();tab.updateUI(););/*tab.getSelectionModel().addListSelectionListener( newListSelectionListener()publicvoidvalueChanged(ListSelectionEvente) intx=tab.getSelectedRow();txt1.setText(String)data.get(x).get(0);txt2.setText(String)data.get(x).get(1);txt3.setText(String)da