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

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; imp

2、ort 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=_Prop

3、erty; 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( 加载驱动失败 ); e.pri

4、ntStackTrace(); public user_land() this.setTitle( 固定资产及设备用户登录 ); 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(

5、10); btn1=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)

6、; this.add(p5); 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) if(txt_name.getText().equals()=false) if(txt

7、_name.getText().equals()=true) if(is_Property() new Sys_interface().show(); else if(txt_name.getText().equals()=false) ); btn1.addActionListener(this); /清空用户名和密码 btn2.addActionListener( new ActionListener() public void actionPerformed(ActionEvent e) txt_name.setText(null); txt_pwd.setText(null); lbl

8、4.setText(null); ); /退出 btn3.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); /Sy

9、stem.out.println( 连接成功 ); stat=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(); if(name.equals(rs.getString(A_name) pwd.equals(rs.getString(A_pwd) /S

10、ystem.out.println( 登录成功！ ); return true; catch(SQLException e) System.out.println( 连接失败 !); e.printStackTrace(); /关闭数据库 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 false; p

11、ublic 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.Font;

12、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.JTextField;

13、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( 固定资产及设备管理系统 ); text=new JLab

14、el( 欢迎进入固定资产及设备管理系统 ); text.setFont(new Font( 宋体 ,1,28); text.setForeground(Color.blue); p=new JPanel(); jmb=new JMenuBar(); jm_1=new JMenu( 系统功能 ); jm_2=new JMenu( 资产管理 ); jm_3=new JMenu( 系统查询 ); jm_4=new JMenu( 帮助 ); jmi_1=new JMenuItem( 用户登录 ); jmi_2=new JMenuItem( 注销用户 ); jmi_3=new JMenuItem( 用户

15、添加 ); 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 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

16、); 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(new BorderLayout(); /this.add(p,BorderLayout.NORTH); jmi_1.addActionListener( new

17、 ActionListener() public void 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 v

18、oid actionPerformed(ActionEvent 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.a

19、ddActionListener( new ActionListener() 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 action

20、Performed(ActionEvent e) new 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

21、.setBounds(200,200,500,400); 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(); / 资产借出管理 / package perty; import java.awt.*; import java.awt.ev

22、ent.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.ListSelectio

23、nEvent; 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 class loan_prop_manage extends JFrame implements ActionListener Vecto

24、r data=null; 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=n

25、ull,lb2=null,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 columnName=new Vector(); public loan_prop_manage() text=new JTextField(); columnName.add( 资产编号 ); columnName.add( 资产名称 ); columnNa

26、me.add( 资产型号 ); columnName.add( 借出时间 ); columnName.add( 借出数量 ); 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( 资产编号 ); lb2=new JLabel( 资产

27、名称 ); lb3=new JLabel( 资产型号 ); lb4=new JLabel( 借出时间 ); lb5=new JLabel( 借出数量 ); 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 JTex

28、tField(5); c1.add( 资产编号 ); 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( 输入数据 ); p1.add(text); p1.add

29、(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

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

31、; this.add(p9); this.add(p2); this.add(p10); this.setBounds(400,300,500,400); this.setDefaultCloseOperation(EXIT_ON_CLOSE); this.setTitle( 资产借出管理 ); btn_save.addActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerD

32、river); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_prop erty,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.executeU

33、pdate(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(Exc

34、eption 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

35、_exit.addActionListener(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_p

36、rop.setModel(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=

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

38、(sql1); catch(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);

39、loan_prop.setModel(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(S

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

41、LServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_prop erty,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 al

42、=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!

43、=null) stat.close(); if(conn!=null) conn.close(); catch(Exception e2) System.out.println( 关闭失败 ); e2.printStackTrace(); return data; public Vector getDate() data=new Vector(); try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:

44、1433;DatabaseName=_prop erty,sa,); stat=conn.createStatement(); rs1=stat.executeQuery(select * from loan_info); while(rs1.next() Vector 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

45、_num); al.add(rs1.getString(u_name); data.add(al); catch(Exception e) System.out.println(e.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(); return data; public static v

46、oid main(String args) new loan_prop_manage().show(); public void actionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); / 资产借出查询 / package perty; import java.sql.*; import java.util.ArrayList; import javax.swing.JButton; import java.awt.event.*; import javax.swing.JText

47、Field; 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

48、.swing.table.DefaultTableModel; public class Loan_prop_select extends JFrame implements ActionListener Connection conn=null; Statement stat=null; ResultSet rs=null; JTable table=null; JLabel label; JTextField text; JButton btn_ok=null,btn_exit=null; JPanel p1=null,p2=null; Vector columnName=new Vect

49、or(); public Loan_prop_select() this.setTitle( 资产借出查询 ); columnName.add( 流水号 ); columnName.add( 资产编号 ); columnName.add( 借用人 ); columnName.add( 借出数量 ); columnName.add( 借出时间 ); p1=new JPanel(); p2=new JPanel(); text=new JTextField(); text=new JTextField(5); btn_ok=new JButton( 查询 ); btn_exit=new JButt

50、on( 退出 ); p1.add(new JLabel( 资产编号 ); p1.add(text); p1.add(btn_ok); p1.add(btn_exit); p1.setBorder(BorderFactory.createTitledBorder( 数据查询 ); btn_exit.addActionListener(this); table=new JTable(this.getDate(),columnName); this.setLayout(new BorderLayout(); this.add(p1,BorderLayout.NORTH); this.add(new

51、JScrollPane(table),BorderLayout.CENTER); this.setBounds(400,300,500,400); this.setDefaultCloseOperation(EXIT_ON_CLOSE); btn_ok.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) DefaultTableModel dtm=new DefaultTableModel(selectDate(),columnName); table.set

52、Model(dtm); table.repaint(); table.updateUI(); ); public Vector selectDate() Vector data=new V ector(); try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_prop erty,sa,); stat=conn.createStatement(); int x=In

53、teger.parseInt(text.getText().trim(); /System.out.println(x); rs=stat.executeQuery(select * from loan_info where prop_id=+x); while(rs.next() Vector al=new Vector(); 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.getStr

54、ing(loan_time); data.add(al); catch(Exception e) System.out.println(e.getMessage(); 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 data; public Vector getDate() Vector dat

55、a=new V ector(); try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); conn=DriverManager.getConnection(jdbc:sqlserver:/:1433;DatabaseName=_prop erty,sa,); stat=conn.createStatement(); rs=stat.executeQuery(select * from loan_Info); while(rs.next() Vector al=new Vector(); al.add(r

56、s.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(Exception e) System.out.println(e.getMessage(); finally /关闭 try if(rs!=null) rs.close(); if(stat!=null) stat.close(); if(conn!=null) conn.

57、close(); catch(Exception e2) System.out.println( 关闭失败 ); e2.printStackTrace(); return data; public static void main(String args) new Loan_prop_select().show(); public void actionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); / 资产归还查询 / package perty; import java.sql.*

58、; 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.BorderFac

59、tory; 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.s

60、wing.event.ListSelectionEvent; import javax.swing.event.ListSelectionListener; import javax.swing.event.TableModelEvent; import javax.swing.event.TableModelListener; public class back_prop_select extends JFrame implements ActionListener Vector data=null; DefaultTableModel model=null; Connection conn