?? wagemanage.java
字號:
//家庭理財管理類import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.util.*;import java.sql.*;public class WageManage extends JInternalFrame{ private JLabel lbl7=new JLabel("身份證號："); private JLabel lbl1=new JLabel("成員姓名："); private JLabel lbl2=new JLabel("股 票："); private JLabel lbl4=new JLabel("存 款："); private JLabel lbl3=new JLabel("基 金："); private JLabel lbl5=new JLabel("債 券："); private JLabel lbl6=new JLabel("外 匯："); private JTextField stid=new JTextField(10); private JTextField stname=new JTextField(10); private JTextField stsalary=new JTextField(10); private JTextField stboon=new JTextField(10); private JTextField stprize=new JTextField(10); private JTextField stcounter=new JTextField(10); private JTextField stfact=new JTextField(10); ImageIcon icon1=new ImageIcon("image//up.gif"); ImageIcon icon2=new ImageIcon("image//down.gif"); private JButton btnadd=new JButton("添加"); private JButton delete=new JButton("刪除"); private JButton updete=new JButton("修改"); private JButton save=new JButton("保存"); private JButton up=new JButton("<<"); private JButton next=new JButton(">>"); public WageManage(){ initComponents(); } private void initComponents() { setTitle("家庭理財信息管理"); Font f=new Font("宋體",Font.PLAIN,12); getContentPane().setLayout(null); lbl7.setBounds(120,30,80,25); lbl7.setFont(f); getContentPane().add(lbl7); stid.setBounds(190,30,100,25); stid.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stid); lbl1.setBounds(120,70,80,25); lbl1.setFont(f); getContentPane().add(lbl1); stname.setBounds(190,70,100,25); stname.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stname); lbl2.setBounds(300,70,80,25); lbl2.setFont(f); getContentPane().add(lbl2); stsalary.setBounds(390,70,100,25); stsalary.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stsalary); lbl3.setBounds(120,110,80,25); lbl3.setFont(f); getContentPane().add(lbl3); stboon.setBounds(190,110,100,25); stboon.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stboon); lbl4.setBounds(300,110,80,25); lbl4.setFont(f); getContentPane().add(lbl4); stprize.setBounds(390,110,100,25); stprize.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stprize); lbl5.setBounds(120,150,80,25); lbl5.setFont(f); getContentPane().add(lbl5); stcounter.setBounds(190,150,100,25); stcounter.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stcounter); lbl6.setBounds(300,150,80,25); lbl6.setFont(f); getContentPane().add(lbl6); stfact.setBounds(390,150,100,25); stfact.setBorder(BorderFactory.createLineBorder(Color.black)); getContentPane().add(stfact); //按鈕 btnadd.setBounds(120,220,60,25); btnadd.setFont(f); btnadd.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(btnadd); delete.setBounds(200,220,60,25); delete.setFont(f); delete.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(delete); updete.setBounds(270,220,60,25); updete.setFont(f); updete.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(updete); save.setBounds(350,220,60,25); save.setFont(f); save.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(save); up.setBounds(430,218,60,15); up.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(up); next.setBounds(430,232,60,15); next.setBorder(BorderFactory.createRaisedBevelBorder()); getContentPane().add(next); Database.joinDB(); //初始化數(shù)據(jù) String sqlw="select * from WageInformation"; try{ if(Database.query(sqlw)){ Database.rs.next(); String wNumber=(""+Database.rs.getInt("W_Number")); String wName=Database.rs.getString("W_Name"); String wBasicWage=Database.rs.getString("W_BasicWage"); String wBoon=Database.rs.getString("W_Boon"); String wBonus=Database.rs.getString("W_Bonus"); String wCountMethod=Database.rs.getString("W_CountMethod"); String wFactWage=Database.rs.getString("W_FactWage"); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); } } catch(Exception esql){ System.out.println("薪資信息管理-初始化數(shù)據(jù)失敗!"); } //按鈕事件 up.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ try{ if(Database.rs.previous()){ String wNumber=(""+Database.rs.getString("W_Number")); String wName=Database.rs.getString("W_Name"); String wBasicWage=Database.rs.getString("W_BasicWage"); String wBoon=Database.rs.getString("W_Boon"); String wBonus=Database.rs.getString("W_Bonus"); String wCountMethod=Database.rs.getString("W_CountMethod"); String wFactWage=Database.rs.getString("W_FactWage"); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); } } catch(Exception eup){ System.out.println("以到最前一條!"); } } }); next.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ try{ if(Database.rs.next()){ String wNumber=(""+Database.rs.getString("W_Number")); String wName=Database.rs.getString("W_Name"); String wBasicWage=Database.rs.getString("W_BasicWage"); String wBoon=Database.rs.getString("W_Boon"); String wBonus=Database.rs.getString("W_Bonus"); String wCountMethod=Database.rs.getString("W_CountMethod"); String wFactWage=Database.rs.getString("W_FactWage"); stid.setText(wNumber); stname.setText(wName); stsalary.setText(wBasicWage); stboon.setText(wBoon); stprize.setText(wBonus); stcounter.setText(wCountMethod); stfact.setText(wFactWage); } } catch(Exception enext){ System.out.println("以到最后一條"); } } }); //添加事件 btnadd.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ save.setEnabled(true); stid.setText(""); stname.setText(""); stsalary.setText(""); stboon.setText(""); stprize.setText(""); stcounter.setText(""); stfact.setText(""); } }); //保存 save.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ if(stname.getText().equals("")||stsalary.getText().equals("")||stboon.getText().equals("")|| stprize.getText().equals("")||stcounter.getText().equals("")||stfact.getText().equals("")){ System.out.println("以上信息必須填寫!"); } else{ String wNumber=stid.getText(); String wName=stname.getText(); String wBasicWage=stsalary.getText(); String wBoon=stboon.getText(); String wBonus=stprize.getText(); String wCountMethod=stcounter.getText(); String wFactWage=stfact.getText(); String Insert="insert WageInformation values('"+wNumber+"','"+wName+"','"+wBasicWage+"','"+wBoon+"','"+wBonus+"','"+wCountMethod+"','"+wFactWage+"')"; try{ if(Database.executeSQL(Insert)){ stid.setEditable(true); save.setEnabled(false); new JOptionPane().showMessageDialog(null,"添加數(shù)據(jù)成功！"); Database.joinDB(); String sql="select * from WageInformation"; Database.query(sql); Database.rs.last(); String wNumber1=(""+Database.rs.getString("W_Number")); String wName1=Database.rs.getString("W_Name"); String wBasicWage1=Database.rs.getString("W_BasicWage"); String wBoon1=Database.rs.getString("W_Boon"); String wBonus1=Database.rs.getString("W_Bonus"); String wCountMethod1=Database.rs.getString("W_CountMethod"); String wFactWage1=Database.rs.getString("W_FactWage"); stid.setText(wNumber1); stname.setText(wName1); stsalary.setText(wBasicWage1); stboon.setText(wBoon1); stprize.setText(wBonus1); stcounter.setText(wCountMethod1); stfact.setText(wFactWage1); } else{ new JOptionPane().showMessageDialog(null,"添加數(shù)據(jù)不成功！"); } } catch(Exception esave){ new JOptionPane().showMessageDialog(null,"添加數(shù)據(jù)不成功！"); } } } }); //刪除事件 delete.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent edel){ try{ String sqle="delete from WageInformation where W_Number ='"+stid.getText()+"'"; System.out.println(sqle); if(Database.executeSQL(sqle)){ new JOptionPane().showMessageDialog(null,"數(shù)據(jù)刪除成功！"); Database.joinDB(); String sqll="select * from WageInformation"; Database.query(sqll); Database.rs.last(); String wNumber1=(""+Database.rs.getString("W_Number")); String wName1=Database.rs.getString("W_Name"); String wBasicWage1=Database.rs.getString("W_BasicWage"); String wBoon1=Database.rs.getString("W_Boon"); String wBonus1=Database.rs.getString("W_Bonus"); String wCountMethod1=Database.rs.getString("W_CountMethod"); String wFactWage1=Database.rs.getString("W_FactWage"); stid.setText(wNumber1); stname.setText(wName1); stsalary.setText(wBasicWage1); stboon.setText(wBoon1); stprize.setText(wBonus1); stcounter.setText(wCountMethod1); stfact.setText(wFactWage1); } } catch(Exception edelete){ System.out.println("數(shù)據(jù)刪除失敗!"); } } }); //修改事件 updete.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent eupd){ try{ String supdate="update WageInformation set W_Name='"+ stname.getText()+"',W_BasicWage='"+ stid.getText() +"',W_Boon='"+stboon.getText()+"',W_Bonus='"+stprize.getText()+"',W_CountMethod='"+stcounter.getText()+"',W_FactWage='"+stfact.getText()+"' where W_Number='"+ stid.getText()+"'"; if(Database.executeSQL(supdate)){ new JOptionPane().showMessageDialog(null,"數(shù)據(jù)修改成功！"); Database.joinDB(); String sqll="select * from WageInformation"; Database.query(sqll); Database.rs.last(); String wNumber1=(""+Database.rs.getString("W_Number")); String wName1=Database.rs.getString("W_Name"); String wBasicWage1=Database.rs.getString("W_BasicWage"); String wBoon1=Database.rs.getString("W_Boon"); String wBonus1=Database.rs.getString("W_Bonus"); String wCountMethod1=Database.rs.getString("W_CountMethod"); String wFactWage1=Database.rs.getString("W_FactWage"); stid.setText(wNumber1); stname.setText(wName1); stsalary.setText(wBasicWage1); stboon.setText(wBoon1); stprize.setText(wBonus1); stcounter.setText(wCountMethod1); stfact.setText(wFactWage1); } } catch(Exception eupdete){ System.out.println("修改數(shù)據(jù)失敗!"); } } }); setSize(688,470); this.setClosable(true); setVisible(true); } }?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -