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

1、Java固定资产管理系统源代码/ 用户登录/package com.newer.property;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;

2、import 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:/127.0.0.1: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(加载驱动失败); e.prin

4、tStackTrace(); 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(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.getText().equals()=false)&(txt_pw

8、d.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); ); /退出 btn3.addActionListener( new ActionList

9、ener() 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(连接成功); stat=conn.createStatement(); String sq

10、l=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.getString(A_pwd) /System.out.println(登录成功！); return

11、 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; public static void main(String args) ne

12、w user_land(); public void actionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); / 主界面/package com.newer.property;import java.awt.BorderLayout;import java.awt.Color;import java.awt.Dialog;import java.awt.FlowLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.

13、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;public class Sys_interface extends JFrame implements Act

14、ionListener 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 JLabel( 欢迎进入固定资产及设备管理系统); text.setFont(new Font(宋体,1,28); text

15、.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(用户添加); jmi_4=new JMenuItem(退出系统); jmi_5=new JMenuItem(资产借出管理); jmi_6=new JMe

16、nuItem(资产信息管理); 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); 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);

17、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 void actionPerformed(ActionEvent e) new user_land().show(); ); j

18、mi_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(ActionEvent e) new Pass_word().show(); ); jmi_4.addActionListener( ne

19、w 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 ActionListener() public void actionPerformed(ActionEvent e) new pro

20、perty_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) new Loan_prop_select().show(); ); jmi_9.addActionListener( new A

21、ctionListener() 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); this.setDefaultCloseOperation(EXIT_ON_CLOSE); public void ac

22、tionPerformed(ActionEvent e) /System.exit(0); this.setVisible(false); public static void main(String args) new Sys_interface().show(); / 资产借出管理/package com.newer.property; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import java.util.

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

24、Listener; 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 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=