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

//////////////////////////////////////////////////////////////////////////////////////////////////////用戶登錄/////////////////////////////////////////////////////////////////////////////////////////////////////packageperty;importjava.awt.GridLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.*;importjava.sql.Statement;importjava.sql.ResultSet;importjavax.swing.JButton;importjavax.swing.JLabel;importjavax.swing.JTextField;importjavax.swing.JPasswordField;importjavax.swing.JPanel;importjavax.swing.JFrame; publicclassuser_landextendsJFrameimplementsActionListener{ staticConnectionconn=null; staticStatementstat=null; staticResultSetrs=null; staticStringurl="jdbc:sqlserver://:1433;DatabaseName=_Property"; staticStringuser="sa"; staticStringpassword=""; JPanelp1,p2,p3,p4,p5; JLabellbl1,lbl2,lbl3,lbl4; JTextFieldtxt_name; JPasswordFieldtxt_pwd; JButtonbtn1,btn2,btn3; static{ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }catch(Exceptione){ System.out.println("加載驅(qū)動失敗"); e.printStackTrace(); } } publicuser_land(){ this.setTitle("固定資產(chǎn)與設(shè)備用戶登錄"); p1=newJPanel(); p2=newJPanel(); p3=newJPanel(); p4=newJPanel(); p5=newJPanel(); lbl1=newJLabel("歡迎登錄"); lbl2=newJLabel("用戶名："); 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); 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(){ publicvoidactionPerformed(ActionEvente){ if((txt_name.getText().equals("")==true)&&(txt_pwd.getText().equals("")==false)) lbl4.setText("登錄失敗，用戶名不能為空"); if((txt_name.getText().equals("")==false)&&(txt_pwd.getText().equals("")==true)) lbl4.setText("登錄失敗，密碼不能為空"); if((txt_name.getText().equals("")==true)&&(txt_pwd.getText().equals("")==true)) lbl4.setText("登錄失敗，用戶名/密碼不能為空"); if(is_Property()){ newSys_interface().show(); } elseif((txt_name.getText().equals("")==false)&&(txt_pwd.getText().equals("")==false)) lbl4.setText("登錄失敗，用戶名/密碼錯誤"); } } ); btn1.addActionListener(this); //清空用戶名和密碼 btn2.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ txt_name.setText(null); txt_pwd.setText(null); lbl4.setText(null); } } ); //退出 btn3.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ System.exit(0); } } ); } protectedvoiduser_land(ObjectsetVisible){ //TODOAuto-generatedmethodstub } publicbooleanis_Property(){ try{ conn=DriverManager.getConnection(url,user,password); //System.out.println("連接成功"); stat=conn.createStatement(); Stringsql="select*fromAdmin_Info"; rs=stat.executeQuery(sql); while(rs.next()){ //System.out.println(rs.getString("A_name")+"\t"+rs.getString("A_pwd")); Stringname=txt_name.getText(); Stringpwd=txt_pwd.getText(); if(name.equals(rs.getString("A_name"))&&pwd.equals(rs.getString("A_pwd"))){ //System.out.println("登錄成功??！"); returntrue; } } }catch(SQLExceptione){ System.out.println("連接失敗!!!"); e.printStackTrace(); } //關(guān)閉數(shù)據(jù)庫 finally{ try{ if(rs!=null){ rs.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returnfalse; } publicstaticvoidmain(String[]args){ newuser_land(); } publicvoidactionPerformed(ActionEvente){ //System.exit(0); this.setVisible(false); } }//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////主界面/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////packageperty;importjava.awt.BorderLayout;importjava.awt.Color;importjava.awt.Dialog;importjava.awt.FlowLayout;importjava.awt.Font;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JMenuBar;importjavax.swing.JMenuItem;importjavax.swing.JMenu;importjavax.swing.JPanel;importjavax.swing.JTextArea;importjavax.swing.JTextField;publicclassSys_interfaceextendsJFrameimplementsActionListener{ JPanelp=null; 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_interface(){ this.setTitle("固定資產(chǎn)與設(shè)備管理系統(tǒng)"); text=newJLabel("歡迎進入固定資產(chǎn)與設(shè)備管理系統(tǒng)"); text.setFont(newFont("宋體",1,28)); text.setForeground(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("用戶添加"); jmi_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.add(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.add(p,BorderLayout.NORTH); jmi_1.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ newuser_land().show(); } } ); jmi_2.addActionListener(this); jmi_2.addActionListener(newActionListener(){ @Override publicvoidactionPerformed(ActionEventarg0){ newuser_land().show(); } }); jmi_3.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ newPass_word().show(); } } ); jmi_4.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ System.exit(0); } } ); jmi_5.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ newloan_prop_manage().show(); } } ); jmi_6.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ newproperty_Info().show(); } } ); jmi_7.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ newprop_info_select().show(); } } ); jmi_8.addActionListener( newActionListener(){ publicvoidactionPerformed(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); this.setDefaultCloseOperation(EXIT_ON_CLOSE); } publicvoidactionPerformed(ActionEvente){ //System.exit(0); this.setVisible(false); } publicstaticvoidmain(String[]args){ newSys_interface().show(); }}////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////資產(chǎn)借出管理///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////packageperty; importjava.awt.*; importjava.awt.event.ActionEvent; importjava.awt.event.ActionListener; importjava.sql.*; importjava.util.Vector; importjavax.swing.*; importjava.awt.event.FocusEvent; importjava.awt.event.FocusListener; importjava.awt.event.MouseEvent; importjava.awt.event.MouseListener; importjavax.swing.event.ListSelectionEvent; importjavax.swing.event.ListSelectionListener; importjavax.swing.event.TableModelListener; importjavax.swing.event.TableModelEvent; importjavax.swing.table.DefaultTableModel; importjavax.swing.table.TableModel; publicclassloan_prop_manageextendsJFrameimplementsActionListener{ Vector<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; 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; Vector<String>columnName=newVector(); publicloan_prop_manage(){ text=newJTextField(); columnName.add("資產(chǎn)編號"); columnName.add("資產(chǎn)名稱"); columnName.add("資產(chǎn)型號"); columnName.add("借出時間"); columnName.add("借出數(shù)量"); columnName.add("借出人"); p1=newJPanel(); p2=newJPanel(); p3=newJPanel(); p4=newJPanel(); p5=newJPanel(); p6=newJPanel(); p7=newJPanel(); p8=newJPanel(); p9=newJPanel(); p10=newJPanel(); lb1=newJLabel("資產(chǎn)編號"); lb2=newJLabel("資產(chǎn)名稱"); lb3=newJLabel("資產(chǎn)型號"); lb4=newJLabel("借出時間"); lb5=newJLabel("借出數(shù)量"); lb6=newJLabel("借出人"); txt01=newJTextField(8); txt02=newJTextField(8); txt03=newJTextField(8); txt04=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=newJButton("保存"); btn_del=newJButton("刪除"); p1.add(newJLabel("查詢字段")); p1.add(c1); p1.add(newJLabel("運算符")); p1.add(c2); p1.add(newJLabel("輸入數(shù)據(jù)")); p1.add(text); p1.add(btn_ok); p1.add(btn_exit); p1.setBorder(BorderFactory.createTitledBorder("請操作")); 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(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_ON_CLOSE); this.setTitle("資產(chǎn)借出管理"); btn_save.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEventarg0){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); Stringsql="insertintoloan_info(prop_name,prop_type,loan_time,loan_num)"+"values('"+txt02.getText()+"','"+txt03.getText()+"','"+txt04.getText()+"','"+txt05.getText()+"')"; stat.executeUpdate(sql); DefaultTableModelmod=newDefaultTableModel(getDate(),columnName); loan_prop.setModel(mod); loan_prop.repaint(); loan_prop.updateUI(); }catch(Exceptione){ System.out.println(e.getMessage()); } try{ if(rs1!=null){ rs1.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } }); btn_ok.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ DefaultTableModeldtb=newDefaultTableModel(selectDate(),columnName); loan_prop.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=newDefaultTableModel(getDate(),columnName); loan_prop.setModel(mod); loan_prop.repaint(); loan_prop.updateUI(); } }); loan_prop.getSelectionModel().addListSelectionListener( newListSelectionListener(){ publicvoidvalueChanged(ListSelectionEvente){ btn_del.addActionListener(newActionListener(){ publicvoidactionPerformed(ActionEventarg0){ try{ intj=loan_prop.getSelectedRow(); Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); Stringsql1="deletefromloan_infowhereprop_id="+""+data.get(j).get(0)+""; stat.executeUpdate(sql1); }catch(Exceptionee){ System.out.println(ee.getMessage()); }finally{ try{ if(rs1!=null){ rs1.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } } catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } DefaultTableModelmod=newDefaultTableModel(getDate(),columnName); loan_prop.setModel(mod); loan_prop.repaint(); loan_prop.updateUI(); } }); } }); loan_prop.getSelectionModel().addListSelectionListener( newListSelectionListener(){ publicvoidvalueChanged(ListSelectionEvente){ 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).toString()); } }); } publicVectorselectDate(){ data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); intx=Integer.parseInt(text.getText().trim()); //System.out.println(x); rs1=stat.executeQuery("select*fromloan_infowhereprop_id="+x); while(rs1.next()){ Vectoral=newVector(); al.add(rs1.getInt("prop_id")); 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){ e.printStackTrace(); }finally{ try{ if(rs1!=null){ rs1.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicVectorgetDate(){ data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); rs1=stat.executeQuery("select*fromloan_info"); while(rs1.next()){ Vectoral=newVector(); al.add(rs1.getInt("prop_id")); 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){ System.out.println(e.getMessage()); }finally{ try{ if(rs1!=null){ rs1.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicstaticvoidmain(String[]args){ newloan_prop_manage().show(); } publicvoidactionPerformed(ActionEvente){ //System.exit(0); this.setVisible(false); } }///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////資產(chǎn)借出查詢////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////packageperty;importjava.sql.*;importjava.util.ArrayList;importjavax.swing.JButton;importjava.awt.event.*;importjavax.swing.JTextField;importjava.util.Vector;importjava.awt.BorderLayout;importjava.awt.Choice;importjava.awt.FlowLayout;importjavax.swing.BorderFactory;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.table.DefaultTableModel;publicclassLoan_prop_selectextendsJFrameimplementsActionListener{ Connectionconn=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.add("流水號"); columnName.add("資產(chǎn)編號"); columnName.add("借用人"); columnName.add("借出數(shù)量"); columnName.add("借出時間"); p1=newJPanel(); p2=newJPanel();text=newJTextField();text=newJTextField(5); btn_ok=newJButton("查詢"); btn_exit=newJButton("退出"); p1.add(newJLabel("資產(chǎn)編號"));p1.add(text); p1.add(btn_ok); p1.add(btn_exit); p1.setBorder(BorderFactory.createTitledBorder("數(shù)據(jù)查詢")); btn_exit.addActionListener(this); table=newJTable(this.getDate(),columnName); this.setLayout(newBorderLayout()); this.add(p1,BorderLayout.NORTH); this.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.setModel(dtm); table.repaint(); table.updateUI(); } }); } publicVectorselectDate(){ Vector<Vector>data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); intx=Integer.parseInt(text.getText().trim()); //System.out.println(x); rs=stat.executeQuery("select*fromloan_infowhereprop_id="+x); while(rs.next()){ Vectoral=newVector(); 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){ System.out.println(e.getMessage()); }finally{ //關(guān)閉 try{ if(rs!=null){ rs.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicVectorgetDate(){ Vector<Vector>data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_property","sa",""); stat=conn.createStatement(); rs=stat.executeQuery("select*fromloan_Info"); while(rs.next()){ Vectoral=newVector(); 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){ System.out.println(e.getMessage()); }finally{ //關(guān)閉 try{ if(rs!=null){ rs.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicstaticvoidmain(String[]args){ newLoan_prop_select().show(); } publicvoidactionPerformed(ActionEvente){ //System.exit(0); this.setVisible(false); }}/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////資產(chǎn)歸還查詢/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////packageperty;importjava.sql.*;importjava.util.Vector;importjava.awt.BorderLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.FocusEvent;importjava.awt.event.FocusListener;importjava.awt.event.MouseEvent;importjava.awt.event.MouseListener;importjavax.swing.BorderFactory;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JTextField;importjavax.swing.JButton;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.table.DefaultTableModel;importjavax.swing.table.TableModel;importjavax.swing.event.ListSelectionEvent;importjavax.swing.event.ListSelectionListener;importjavax.swing.event.TableModelEvent;importjavax.swing.event.TableModelListener;publicclassback_prop_selectextendsJFrameimplementsActionListener{ Vector<Vector>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("流水號"); columnName.add("資產(chǎn)編號"); columnName.add("借用人"); columnName.add("借用數(shù)量"); columnName.add("借用時間"); columnName.add("歸還數(shù)量"); columnName.add("歸還時間"); pa1=newJPanel(); pa2=newJPanel(); btn1=newJButton("確定"); btn2=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); pa1.add(tex); pa1.add(btn1); pa1.add(btn2); pa2.add(tab); model=newDefaultTableModel(getDate(),columnName); tab=newJTable(model); pa1.setBorder(BorderFactory.createTitledBorder("查詢參數(shù)")); pa2.add(newJScrollPane(tab)); this.setTitle("資產(chǎn)歸還查詢"); this.setLayout(newBorderLayout()); this.add(pa1,BorderLayout.NORTH); this.add(newJScrollPane(tab)); this.setBounds(300,200,500,300); this.setDefaultCloseOperation(EXIT_ON_CLOSE); //查詢 btn1.addActionListener( newActionListener(){ publicvoidactionPerformed(ActionEvente){ //1、定義一個方法 //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)data.get(x).get(2)); txt4.setText((String)data.get(x).get(3)); txt5.setText(data.get(x).get(4).toString()); } } );*/ //選中顯示 /*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)data.get(x).get(2)); txt4.setText(data.get(x).get(3).toString()); } } );*/ btn2.addActionListener(this); } publicVectorgetDate(){ Vector<Vector>data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=Property","sa","123"); stat=conn.createStatement(); rs=stat.executeQuery("select*fromloan_Info"); while(rs.next()){ Vectoral=newVector(); al.add(rs.getString("loan_id")); al.add(rs.getString("prop_id")); al.add(rs.getString("u_id")); al.add(rs.getString("loan_time")); al.add(rs.getString("loan_num")); data.add(al); } }catch(Exceptione){ System.out.println(e.getMessage()); }finally{ //關(guān)閉 try{ if(rs!=null){ rs.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicVectorselectDate(){ data=newVector<Vector>(); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=Property","sa","123"); stat=conn.createStatement(); Stringlab1="select*fromloan_infowhereu_id='"+tex.getText().trim()+"'"; rs=stat.executeQuery(lab1); while(rs.next()){ Vectorback=newVector(); back.add(rs.getString("loan_id")); back.add(rs.getString("prop_id")); back.add(rs.getString("u_id")); back.add(rs.getString("loan_time")); back.add(rs.getInt("loan_num")); data.add(back); } }catch(Exceptione){ System.out.println(e.getMessage()); }finally{ //關(guān)閉 try{ if(rs!=null){ rs.close(); } if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } }catch(Exceptione2){ System.out.println("關(guān)閉失敗"); e2.printStackTrace(); } } returndata; } publicstaticvoidmain(String[]args){ newback_prop_select().show(); } publicvoidtableChanged(TableModelEvente){ } publicvoidactionPerformed(ActionEvente){ this.setVisible(false); }}//////////////////////////////////////////////////////////////////////////