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

1、 / 用戶登錄 / package perty; 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; im

2、port javax.swing.JPasswordField; import javax.swing.JPanel; import javax.swing.JFrame; public class user_land extends JFrame implements ActionListener static Connection conn=null; static Statement stat=null; static ResultSet rs=null; static String url=jdbc:sqlserver:/:1433;DatabaseName=_Pro

3、perty; static String user=sa; static String password=; JPanel p1,p2,p3,p4,p5; JLabel lbl1,lbl2,lbl3,lbl4; JTextField txt_name; JPasswordField txt_pwd; JButton btn1,btn2,btn3; static try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); catch(Exception e) System.out.println(加載驅(qū)動失敗); e.prin

4、tStackTrace(); public user_land() this.setTitle(固定資產(chǎn)及設備用戶登錄); p1=new JPanel(); p2=new JPanel(); p3=new JPanel(); p4=new JPanel(); p5=new JPanel(); lbl1=new JLabel(歡迎登錄); lbl2=new JLabel(用戶名：); lbl3=new JLabel(密 碼：); lbl4=new JLabel(); txt_name=new JTextField(10); txt_pwd=new JPasswordField(10); btn1

5、=new JButton(登錄); btn2=new JButton(清空); btn3=new JButton(退出); 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(new GridLayout(5,1); this.add(p1); this.add(p2); this.add(p3); this.add(p4); this.add(p5);

6、 this.setBounds(400, 300, 400, 300); this.setDefaultCloseOperation(EXIT_ON_CLOSE); this.setVisible(true); /添加按鈕登錄事件 btn1.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) if(txt_name.getText().equals()=true)&&(txt_pwd.getText().equals()=false) lbl4.setText(登錄

7、失敗，用戶名不能為空); 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() new Sys_interface().show(); else if(txt_name.getTex

8、t().equals()=false)&&(txt_pwd.getText().equals()=false) lbl4.setText(登錄失敗，用戶名/密碼錯誤); ); btn1.addActionListener(this); /清空用戶名和密碼 btn2.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) txt_name.setText(null); txt_pwd.setText(null); lbl4.setText(null); ); /退出 bt

9、n3.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) System.exit(0); ); protected void user_land(Object setVisible) / TODO Auto-generated method stub public boolean is_Property() try conn=DriverManager.getConnection(url, user, password); /System.out.println(連接成功); st

10、at=conn.createStatement(); String sql=select * from Admin_Info; rs=stat.executeQuery(sql); while(rs.next() /System.out.println(rs.getString(A_name)+t+rs.getString(A_pwd); String name=txt_name.getText(); String pwd=txt_pwd.getText(); if(name.equals(rs.getString(A_name) && pwd.equals(rs.getStr

11、ing(A_pwd) /System.out.println(登錄成功！); return true; catch(SQLException e) System.out.println(連接失敗!); e.printStackTrace(); /關閉數(shù)據(jù)庫 finally try if(rs!=null) rs.close(); if(stat!=null) stat.close(); if(conn!=null) conn.close(); catch(Exception e2) System.out.println(關閉失敗); e2.printStackTrace(); return f

12、alse; public static void main(String args) new user_land(); public void actionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); / 主界面 / package perty; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Dialog; import java.awt.FlowLayout; import java.awt

13、.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.JMenuItem; import javax.swing.JMenu; import javax.swing.JPanel; import javax.swing.JTextArea; import javax.swing.JText

14、Field; public class Sys_interface extends JFrame implements ActionListener JPanel p=null; JMenuItem jmi_1,jmi_2,jmi_3,jmi_4,jmi_5,jmi_6,jmi_7,jmi_8,jmi_9,jmi_10; JMenuBar jmb=null; JMenu jm_1=null,jm_2=null,jm_3=null,jm_4=null; JLabel text; public Sys_interface() this.setTitle(固定資產(chǎn)及設備管理系統(tǒng)); text=new

15、 JLabel( 歡迎進入固定資產(chǎn)及設備管理系統(tǒng)); text.setFont(new Font(宋體,1,28); text.setForeground(Color.blue); p=new JPanel(); jmb=new JMenuBar(); jm_1=new JMenu(系統(tǒng)功能); jm_2=new JMenu(資產(chǎn)管理); jm_3=new JMenu(系統(tǒng)查詢); jm_4=new JMenu(幫助); jmi_1=new JMenuItem(用戶登錄); jmi_2=new JMenuItem(注銷用戶); jmi_3=new JMenuItem(用戶添加); jmi_4=

16、new JMenuItem(退出系統(tǒng)); jmi_5=new JMenuItem(資產(chǎn)借出管理); jmi_6=new JMenuItem(資產(chǎn)信息管理); jmi_7=new JMenuItem(資產(chǎn)信息查詢); jmi_8=new JMenuItem(資產(chǎn)借出查詢); jmi_9=new JMenuItem(資產(chǎn)歸還查詢); jmi_10=new JMenuItem(關于); 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.a

17、dd(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(new BorderLayout(); /this.add(p,BorderLayout.NORTH); jmi_1.addActionListener( new ActionListener() public v

18、oid actionPerformed(ActionEvent e) new user_land().show(); ); jmi_2.addActionListener(this); jmi_2.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) new user_land().show(); ); jmi_3.addActionListener( new ActionListener() public void actionPerformed(Action

19、Event e) new Pass_word().show(); ); jmi_4.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) System.exit(0); ); jmi_5.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) new loan_prop_manage().show(); ); jmi_6.addActionListener( new Acti

20、onListener() public void actionPerformed(ActionEvent e) new property_Info().show(); ); jmi_7.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) new prop_info_select().show(); ); jmi_8.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) n

21、ew Loan_prop_select().show(); ); jmi_9.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) new back_prop_select ().show(); ); jmi_10.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) new about().show(); ); this.setBounds(200,200,500,400

22、); this.setDefaultCloseOperation(EXIT_ON_CLOSE); public void actionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); public static void main(String args) new Sys_interface().show(); / 資產(chǎn)借出管理 / package perty; import java.awt.*; import java.awt.event.ActionEvent; import ja

23、va.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

24、.event.ListSelectionListener; import javax.swing.event.TableModelListener; import javax.swing.event.TableModelEvent; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; public class loan_prop_manage extends JFrame implements ActionListener Vector<Vector> data=null;

25、 DefaultTableModel model = null; Connection conn=null; Statement stat=null; ResultSet rs1=null; JTable loan_prop=null; JLabel label; JTextField text; JTextField txt01,txt02,txt03,txt04,txt05,txt06; JPanel p1=null,p2=null,p3=null,p4,p5,p6,p7,p8,p9,p10; Choice c1=null,c2=null; JLabel lb1=null,lb2=null

26、,lb3=null,lb4=null,lb5=null,lb6=null; JButton btn_ok=null; JButton btn_exit=null; JButton btn_fresh=null; JButton btn_save=null; JButton btn_del=null; Vector<String> columnName=new Vector(); public loan_prop_manage() text=new JTextField(); columnName.add(資產(chǎn)編號); columnName.add(資產(chǎn)名稱); columnName

27、.add(資產(chǎn)型號); columnName.add(借出時間); columnName.add(借出數(shù)量); columnName.add(借出人); p1=new JPanel(); p2=new JPanel(); p3=new JPanel(); p4=new JPanel(); p5=new JPanel(); p6=new JPanel(); p7=new JPanel(); p8=new JPanel(); p9=new JPanel(); p10=new JPanel(); lb1=new JLabel(資產(chǎn)編號); lb2=new JLabel(資產(chǎn)名稱); lb3=new

28、JLabel(資產(chǎn)型號); lb4=new JLabel(借出時間); lb5=new JLabel(借出數(shù)量); lb6=new JLabel(借 出 人); txt01=new JTextField(8); txt02=new JTextField(8); txt03=new JTextField(8); txt04=new JTextField(8); txt05=new JTextField(8); txt06=new JTextField(8); c1=new Choice(); c2=new Choice(); text=new JTextField(5); c1.add(資產(chǎn)編號

29、); c2.add(=); btn_ok=new JButton(確定); btn_exit=new JButton(退出); btn_fresh=new JButton(刷新); btn_save=new JButton(保存); btn_del=new JButton(刪除); p1.add(new JLabel(查詢字段); p1.add(c1); p1.add(new JLabel(運算符); p1.add(c2); p1.add(new JLabel(輸入數(shù)據(jù)); p1.add(text); p1.add(btn_ok); p1.add(btn_exit); p1.setBorder

30、(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(new GridLayout(3, 2);

31、p2.add(p3); p2.add(p4); p2.add(p5); p2.add(p6); p2.add(p7); p2.add(p8); loan_prop=new JTable(this.getDate(),columnName); model = new DefaultTableModel(getDate(),columnName); p9.add(new JScrollPane(loan_prop); this.setLayout(new GridLayout(4, 1); this.add(p1); this.add(p9); this.add(p2); this.add(p10

32、); this.setBounds(400,300,500,400); this.setDefaultCloseOperation(EXIT_ON_CLOSE); this.setTitle(資產(chǎn)借出管理); btn_save.addActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); conn=DriverManager.getConnection(jdb

33、c:sqlserver:/:1433;DatabaseName=_property,sa,); stat=conn.createStatement(); String sql=insert into loan_info (prop_name,prop_type,loan_time,loan_num)+values('+txt02.getText()+','+txt03.getText()+','+txt04.getText()+','+txt05.getText()+'); stat.executeUpdate(

34、sql); DefaultTableModel mod= new DefaultTableModel(getDate(),columnName); loan_prop.setModel(mod); loan_prop.repaint(); loan_prop.updateUI(); catch(Exception e) System.out.println(e.getMessage(); try if(rs1!=null) rs1.close(); if(stat!=null) stat.close(); if(conn!=null) conn.close(); catch(Exception

35、 e2) System.out.println(關閉失敗); e2.printStackTrace(); ); btn_ok.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) DefaultTableModel dtb=new DefaultTableModel(selectDate(),columnName); loan_prop.setModel(dtb); loan_prop.repaint(); loan_prop.updateUI(); ); /*btn_exit.ad

36、dActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) );*/ btn_exit.addActionListener(this); btn_fresh.addActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) DefaultTableModel mod = new DefaultTableModel(getDate(),columnName); loan_prop.setM

37、odel(mod); loan_prop.repaint(); loan_prop.updateUI(); ); loan_prop.getSelectionModel().addListSelectionListener( new ListSelectionListener() public void valueChanged(ListSelectionEvent e) btn_del.addActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) try int j= loan_pro

38、p.getSelectedRow(); Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_property,sa,); stat=conn.createStatement(); String sql1=delete from loan_info where prop_id=+data.get(j).get(0)+; stat.executeUpdate(sql1); c

39、atch(Exception ee) System.out.println(ee.getMessage(); finally try if(rs1!=null) rs1.close(); if(stat!=null) stat.close(); if(conn!=null) conn.close(); catch(Exception e2) System.out.println(關閉失敗); e2.printStackTrace(); DefaultTableModel mod = new DefaultTableModel(getDate(),columnName); loan_prop.s

40、etModel(mod); loan_prop.repaint(); loan_prop.updateUI(); ); ); loan_prop.getSelectionModel().addListSelectionListener( new ListSelectionListener() public void valueChanged(ListSelectionEvent e) int i= loan_prop.getSelectedRow(); txt01.setText(data.get(i).get(0).toString(); txt02.setText(String)data.

41、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(); ); public Vector selectDate() data=new Vector<Vector>(); try Class.forName(com.microsoft.sqlserver.jdbc

42、.SQLServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_property,sa,); stat=conn.createStatement(); int x=Integer.parseInt(text.getText().trim(); /System.out.println(x); rs1=stat.executeQuery(select * from loan_info where prop_id=+x); while(rs1.next() Vector

43、al=new Vector(); 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(Exception e) e.printStackTrace(); finally try if(rs1!=null) rs1.close(); if(stat!=null) stat.close(); if(conn!=null) conn.close(); catch(Exception e2) System.out.