1、Java固定資產管理系統源代碼Java固定資產管理系統源代碼Java固定資產管理系統源代碼Java固定資產管理系統源代碼編制僅供參考審核批準生效日期地址： 電話：傳真: 郵編:;import public class user_land extends JFrame implements ActionListenerstatic Connection conn=null;static Statement stat=null;static ResultSet rs=null;static String url=jdbc:;static String user=sa;static String p

2、assword=;JPanel p1,p2,p3,p4,p5;JLabel lbl1,lbl2,lbl3,lbl4;JTextField txt_name;JPasswordField txt_pwd;JButton btn1,btn2,btn3;statictry();catch(Exception e)加載驅動失敗);();public user_land()(固定資產及設備用戶登錄);p1=new JPanel();p2=new JPanel();p3=new JPanel();p4=new JPanel();p5=new JPanel();lbl1=new JLabel(歡迎登錄);l

3、bl2=new JLabel(用戶名：);lbl3=new JLabel(密 碼：);lbl4=new JLabel();txt_name=new JTextField(10);txt_pwd=new JPasswordField(10);btn1=new JButton(登錄);btn2=new JButton(清空);btn3=new JButton(退出);(lbl1);(lbl2);(txt_name);(lbl3);(txt_pwd);(btn1);(btn2);(btn3);(lbl4);(new GridLayout(5,1);(p1);(p2);(p3);(p4);(p5);(

4、400, 300, 400, 300);(EXIT_ON_CLOSE);(true);quals()=true)&().equals()=false) (登錄失敗，用戶名不能為空); if().equals()=false)&().equals()=true) (登錄失敗，密碼不能為空); if().equals()=true)&().equals()=true) (登錄失敗，用戶名/密碼不能為空);if(is_Property() new Sys_interface().show(); else if().equals()=false)&().equals()=false) (登錄失敗，用戶

5、名/密碼錯誤););(this);how(););(this);(new ActionListener() Overridepublic void actionPerformed(ActionEvent arg0) new user_land().show(););(new ActionListener()public void actionPerformed(ActionEvent e) new Pass_word().show(););(new ActionListener()public void actionPerformed(ActionEvent e) (0););(new Act

6、ionListener()public void actionPerformed(ActionEvent e) new loan_prop_manage().show(););(new ActionListener()public void actionPerformed(ActionEvent e) new property_Info().show(););(new ActionListener()public void actionPerformed(ActionEvent e) new prop_info_select().show(););(new ActionListener()pu

7、blic void actionPerformed(ActionEvent e) new Loan_prop_select().show(););(new ActionListener()public void actionPerformed(ActionEvent e) new back_prop_select ().show(););(new ActionListener()public void actionPerformed(ActionEvent e) new about().show(););(200,200,500,400);(EXIT_ON_CLOSE);public void

8、 actionPerformed(ActionEvent e) how();import import import .*;import import .*;import import import import import import import import import import public class loan_prop_manage extends JFrame implements ActionListenerVector data=null;DefaultTableModel model = null;Connection conn=null;Statement st

9、at=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,lb3=null,lb4=null,lb5=null,lb6=null;JButton btn_ok=null;JButton btn_exit=

10、null;JButton btn_fresh=null;JButton btn_save=null;JButton btn_del=null;Vector columnName=new Vector();public loan_prop_manage()text=new JTextField();(資產編號);(資產名稱);(資產型號);(借出時間);(借出數量);(借出人);p1=new JPanel();p2=new JPanel();p3=new JPanel();p4=new JPanel();p5=new JPanel();p6=new JPanel();p7=new JPanel(

11、);p8=new JPanel();p9=new JPanel();p10=new JPanel();lb1=new JLabel(資產編號);lb2=new JLabel(資產名稱);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);tx

12、t06=new JTextField(8);c1=new Choice();c2=new Choice();text=new JTextField(5);(資產編號);(=);btn_ok=new JButton(確定);btn_exit=new JButton(退出);btn_fresh=new JButton(刷新);btn_save=new JButton(保存);btn_del=new JButton(刪除);(new JLabel(查詢字段);(c1);(new JLabel(運算符);(c2);(new JLabel(輸入數據);(text);(btn_ok); (btn_exit

13、);(請操作);(lb1);(txt01);(lb2);(txt02);(lb3);(txt03);(lb4);(txt04);(lb5);(txt05);(lb6);(txt06);(btn_fresh);(btn_save);(btn_del);(new GridLayout(3, 2);(p3);(p4);(p5);(p6);(p7);(p8);loan_prop=new JTable(),columnName);model = new DefaultTableModel(getDate(),columnName);(new JScrollPane(loan_prop);(new Gri

14、dLayout(4, 1);(p1);(p9);(p2);(p10);(400,300,500,400);(EXIT_ON_CLOSE);(資產借出管理);(new ActionListener()public void actionPerformed(ActionEvent arg0)try();conn=(jdbc:,sa,);stat=();String sql=insert into loan_info (prop_name,prop_type,loan_time,loan_num)+values(+()+,+()+,+()+,+()+);(sql);DefaultTableModel

15、 mod= new DefaultTableModel(getDate(),columnName);(mod);();();catch(Exception e)tryif(rs1!=null)();if(stat!=null)();if(conn!=null)();catch(Exception e2)關閉失敗);(););(new ActionListener()public void actionPerformed(ActionEvent e) DefaultTableModel dtb=new DefaultTableModel(selectDate(),columnName);(dtb

16、);();(););/*(new ActionListener()public void actionPerformed(ActionEvent arg0);*/(this);(new ActionListener()public void actionPerformed(ActionEvent arg0)DefaultTableModel mod = new DefaultTableModel(getDate(),columnName);(mod);();(););().addListSelectionListener(new ListSelectionListener()public vo

17、id valueChanged(ListSelectionEvent e)(new ActionListener()public void actionPerformed(ActionEvent arg0)tryint j= ();();conn=(jdbc:,sa,);stat=();String sql1=delete from loan_info where prop_id=+(j).get(0)+;(sql1);catch(Exception ee)finallytryif(rs1!=null)();if(stat!=null)();if(conn!=null)();catch(Exc

18、eption e2)關閉失敗);();DefaultTableModel mod = new DefaultTableModel(getDate(),columnName);(mod);();();););().addListSelectionListener(new ListSelectionListener()public void valueChanged(ListSelectionEvent e)int i= ();(i).get(0).toString();(String)(i).get(1);(String)(i).get(2);(i).get(3).toString();(i).

19、get(4).toString();(i).get(5).toString(););public Vector selectDate()data=new Vector();try();conn=(jdbc:,sa,);stat=();int x=().trim();how(); public void actionPerformed(ActionEvent e) ;import class Loan_prop_select extends JFrame implements ActionListenerConnection conn=null;Statement stat=null;Resul

20、tSet rs=null;JTable table=null;JLabel label;JTextField text;JButton btn_ok=null,btn_exit=null;JPanel p1=null,p2=null;Vector columnName=new Vector();public Loan_prop_select()(資產借出查詢);(流水號);(資產編號);(借用人);(借出數量);(借出時間);p1=new JPanel();p2=new JPanel(); text=new JTextField(); text=new JTextField(5);btn_ok

21、=new JButton(查詢);btn_exit=new JButton(退出);(new JLabel(資產編號); (text);(btn_ok);(btn_exit);(數據查詢);(this);table=new JTable(),columnName);(new BorderLayout();(p1,;(new JScrollPane(table),;(400,300,500,400);(EXIT_ON_CLOSE);(new ActionListener() Overridepublic void actionPerformed(ActionEvent arg0) Default

22、TableModel dtm=new DefaultTableModel(selectDate(),columnName);(dtm);();(););public Vector selectDate()Vector data=new Vector();try();conn=(jdbc:,sa,);stat=();int x=().trim();how();public void actionPerformed(ActionEvent e) ;import class back_prop_select extends JFrame implements ActionListener Vecto

23、r data=null;DefaultTableModel model=null;Connection conn=null;Statement stat=null;ResultSet rs=null;JPanel pa1,pa2;JButton btn1,btn2;JTable tab=null;JTextField tex=null;JTextField txt1,txt2,txt3,txt4,txt5;JLabel lab1,lab2,lab3;Vector columnName=new Vector();public back_prop_select()(流水號);(資產編號);(借用人

24、);(借用數量);(借用時間);(歸還數量);(歸還時間);pa1=new JPanel();pa2=new JPanel();btn1=new JButton(確定);btn2=new JButton(退出);lab1=new JLabel(查詢字段：);lab2=new JLabel(借用人);tex=new JTextField(5);tab=new JTable(),columnName);txt1=new JTextField(10);txt2=new JTextField(10);txt3=new JTextField(10);txt4=new JTextField(10);txt

25、5=new JTextField(10); (lab1); (lab2);(tex);(btn1);(btn2);(tab);model = new DefaultTableModel(getDate(),columnName);tab=new JTable(model);(查詢參數);(new JScrollPane(tab);(資產歸還查詢);(new BorderLayout();(pa1,;(new JScrollPane(tab);(300,200,500,300);(EXIT_ON_CLOSE);ddListSelectionListener(new ListSelectionLi

26、stener()public void valueChanged(ListSelectionEvent e) int x=();(String)(x).get(0);(String)(x).get(1);(String)(x).get(2);(String)(x).get(3);(x).get(4).toString(););*/ddListSelectionListener(new ListSelectionListener()public void valueChanged(ListSelectionEvent e) int x=();(String)(x).get(0);(String)

27、(x).get(1);(String)(x).get(2);(x).get(3).toString(););*/(this);public Vector getDate()Vector data=new Vector();try();conn=(jdbc:,sa,123);stat=();rs=(select * from loan_Info);while()Vector al=new Vector();(loan_id);(prop_id);(u_id);(loan_time);(loan_num);(al);catch(Exception e)finallyrim()+;rs=(lab1)

28、;while()Vector back=new Vector();(loan_id);(prop_id);(u_id);(loan_time);(loan_num);(back);catch(Exception e)finallyhow();public void tableChanged(TableModelEvent e) public void actionPerformed(ActionEvent e) (false);import .*;import .*;import .*;import class property_Info extends JFrame implements A

29、ctionListener Connection conn=null;Statement stat=null;ResultSet rs=null;JPanel p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12;JButton b1,b2,b3,b4,b5;JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10;JTextField t1,t2,t3,t4,t5,t6,t7,t8,t9,text_show;JTable table=null;JComboBox cob;String sql;Vector columnName=new Vector(

30、);public property_Info()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();p11=new JPanel();p12=new JPanel();b1=new JButton(刷新);b2=new JButton(存盤);b3=new JButton(退出);b4=new JButton(刪除);b5=ne

31、w JButton(確定);l1=new JLabel(產品編號);l2=new JLabel(產品名稱);l3=new JLabel(產品類型);l4=new JLabel(產品總量);l5=new JLabel(產品價格);l6=new JLabel(產品廠商);l7=new JLabel(購買日期);l8=new JLabel(出產日期);l9=new JLabel(購 買 人);l10=new JLabel(產品名稱);t1=new JTextField(10);t2=new JTextField(10);t3=new JTextField(10);t4=new JTextField(

32、10);t5=new JTextField(10);t6=new JTextField(10);t7=new JTextField(10);t8=new JTextField(10);t9=new JTextField(10);text_show=new JTextField(10);(產品編號);(產品名稱);(產品類型);(產品總量);(產品價格);(產品廠商);(購買時間);(出廠日期);(購 買 人);cob = new JComboBox();(l2);(t2);(l3);(t3);(l4);(t4);(l5);(t5);(l6);(t6);(l7);(t7);(l8);(t8);(

33、l9);(t9);(p4);(p5);(p6);(p7);(p8);(p9);(p10);(p11);(b1);(b2);(b3);(b4);(l10);(產品編號); (產品名稱); (產品類型);(cob);(text_show);(b5);(p12);(p1);(p2);(p3);table=new JTable(),columnName);(new FlowLayout();(new GridLayout(4,1);(new FlowLayout();(new GridLayout(4,2);(new JScrollPane(table);(400,400,600,400);(true);(資產信息管理表);(EXIT_ON_CLOSE);(new ActionListener() public void actionPerformed(ActionEvent arg0) oString();int y=().trim();import public class prop_info_select extends JFrame implements ActionListenerConnection conn=