save.java

界面不错的东西

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
class Save extends JFrame implements ActionListener{
   Connection Con=null;
   Statement  Stmt=null;
   JLabel lb=new JLabel("尊敬的储户你好! ");
   JLabel lb_msg=new JLabel("感谢你选择光大银行!");
   JLabel lb_input_account_no=new JLabel("请输入储户账号:");  //刷卡机自动读取
   JTextField con_acco=new JTextField(15);
   JLabel lb_input_save_sum=new JLabel("请输入你要存入的金额:");
   JTextField save_sum=new JTextField(15);
   JButton bt_ack=new JButton("确认");
   JButton bt_can=new JButton("取消");
   Save(){  
   super("光大银行欢迎你!感谢你对光大银行的支持!");
   this.setBounds(250,250,450,200);
   this.setVisible(true);
   Container con=getContentPane();
   con.setLayout(new FlowLayout());
   con.setBounds(250,250,450,200);
   JPanel p=new JPanel();
   p.setLayout(new GridLayout(5,2));
   p.add(lb); p.add(lb_msg);
   p.add(lb_input_account_no); p.add(con_acco);
   p.add(lb_input_save_sum);   p.add(save_sum);
   p.add(bt_ack);
   p.add(bt_can);
   bt_ack.addActionListener(this);
   bt_can.addActionListener(this);
   con.add(p,"CENTER");
   validate();
  }
  public void actionPerformed(ActionEvent e){
   if(e.getSource()==bt_ack)
   {
     if(con_acco.getText().trim().equals("")||save_sum.getText().trim().equals(""))
       {
       JOptionPane.showMessageDialog(this,"账号与存款金额不能为空!","警告",JOptionPane.WARNING_MESSAGE);
       }
     else{
         con_saving();
         }
   }
   if(e.getSource()==bt_can)
   {
    dispose();
   }
 }
  private void con_saving(){
    //con_saving 函数完成用户存款操作，将用户存款的金额存入用户帐户中
   String _con_acco,_con_savesum,temp;
    _con_savesum=save_sum.getText().trim();
    float _savesum,remain;
    _con_acco="'"+con_acco.getText().trim()+"'";
    _savesum=Float.parseFloat(_con_savesum); //可能出现问题
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");} 
    catch(ClassNotFoundException e){System.out.println("DBClassNotFoundException:"+e.getMessage());}
   try{
        Con=DriverManager.getConnection("jdbc:odbc:Bankdb","","");
        Stmt=Con.createStatement();
        temp="select * from consumer where con_acco='"+con_acco.getText().trim()+"'";                ResultSet rs=Stmt.executeQuery(temp); 
        boolean boo=false;
     if(rs.next())  //查到该用户，否则该用户不存在，提示出错信息。
        {//查到的数据为有效数据的前一行,首先读取用户的账户现余金额；
          boo=true;
          remain=Float.parseFloat(rs.getString("con_rema"));
          remain=remain + _savesum;
          String tmp="update consumer set con_rema='"+remain+"'"+"WHERE con_acco="+_con_acco;   //一定要仔细认真，账户号写错:con_rema写成了con_remain
          System.out.println(tmp);
          Stmt.executeUpdate(tmp);
         JOptionPane.showMessageDialog(this,"存款成功!\n 你当前的余额是:'"+remain+"'","恭喜",JOptionPane.WARNING_MESSAGE);
         dispose();
        }
      else
        {
        JOptionPane.showMessageDialog(this,"你输入的用户不存在!请查证!","警告",JOptionPane.WARNING_MESSAGE);
        }
    Con.close();
      }catch(SQLException e_6){System.out.println("SQLException:"+e_6.getMessage());}
  }
}