save.java~64~

做太久,忘了什么功能了!好象取款机的功能..冒似...

package bankmanager;

import java.awt.BorderLayout;
import java.awt.Frame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Color;
import javax.swing.UIManager;
import java.awt.SystemColor;
import java.net.URL;
import javax.swing.ImageIcon;
import javax.swing.JTextField;
import java.awt.Font;
import javax.swing.JButton;
import javax.swing.*;
import java.text.SimpleDateFormat;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
//import netbarprj.SqlClass;
//import java.beans.Statement;
import java.sql.ResultSet;
import java.sql.*;

public class Save extends JDialog {
    JPanel panel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField text1 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField text2 = new JTextField();
    JButton refer = new JButton();
    JButton return1 = new JButton();
    JLabel jLabel4 = new JLabel();
    java.util.Date nowTime;
    JLabel jLabel5 = new JLabel();
    JComboBox CB1 = new JComboBox();
    public Save(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public Save() {
        this(new Frame(), "正进行存款ING....", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);

        jLabel1.setBounds(new Rectangle(357, 15, 335, 344));
          //插入图片
        URL pic=this.getClass().getResource("/saving.jpg");
        jLabel1.setIcon(new ImageIcon(pic));


        panel1.setBackground(new Color(255, 255, 210));
        text1.setBounds(new Rectangle(56, 112, 215, 28));
        jLabel2.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        jLabel2.setText("请输入需存款金额：");
        jLabel2.setBounds(new Rectangle(12, 79, 165, 39));
        jLabel3.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        jLabel3.setText("交易时间：");
        nowTime = new java.util.Date();
        SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String dispalyNowTime = HMFromat.format(nowTime);
         text2.setText(dispalyNowTime);

        jLabel3.setBounds(new Rectangle(12, 226, 86, 31));
        text2.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        text2.setEditable(false);
        text2.setBounds(new Rectangle(56, 266, 217, 31));
        refer.setBounds(new Rectangle(21, 318, 106, 36));
        refer.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        refer.setText("提交");
        refer.addActionListener(new Save_refer_actionAdapter(this));
        return1.setBounds(new Rectangle(225, 316, 106, 36));
        return1.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        return1.setText("返回");
        return1.addActionListener(new Save_return1_actionAdapter(this));
        jLabel4.setFont(new java.awt.Font("方正姚体", Font.BOLD, 20));
        jLabel4.setForeground(Color.red);
        jLabel4.setToolTipText("");
        jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel4.setHorizontalTextPosition(SwingConstants.CENTER);
        jLabel4.setText("您正在进行存款功能......");
        jLabel4.setBounds(new Rectangle(32, 0, 291, 72));
        jLabel5.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        jLabel5.setText("货币类型：");
        jLabel5.setBounds(new Rectangle(12, 152, 109, 35));
        CB1.setFont(new java.awt.Font("方正姚体", Font.BOLD, 15));
        CB1.setBounds(new Rectangle(56, 195, 142, 27));
//       CB1.addActionListener(new Save_CB1_actionAdapter(this));
        getContentPane().add(panel1);
        panel1.add(jLabel4);
        panel1.add(text1);
        panel1.add(return1);
        panel1.add(refer);
        panel1.add(jLabel2);
        panel1.add(jLabel3);
        panel1.add(CB1);
        panel1.add(text2);
        panel1.add(jLabel5);
        panel1.add(jLabel1);
        CB1.addItem("人民币");
//        CB1.addItem("美圆");
//        CB1.addItem("欧圆");
//        CB1.addItem("新台币");
//        CB1.addItem("日圆");

    }

    public void return1_actionPerformed(ActionEvent e) {
        dispose();
       MainAppBank.frame.setContentPane(new LogoIn());
       MainAppBank.frame.setVisible(true);

    }

    public void refer_actionPerformed(ActionEvent e) {
        //在数据库transInfo表里插入交易数据
        int  text=Integer.parseInt(this.text1.getText());

        String s=this.CB1.getSelectedItem().toString();

        String txtkno=MainAppBank.logo.txt;
        MethodClass c = new MethodClass();
//        c.getConnection();
        String st="insert transinfo(transdate,cardid,transtype,transmoney,curtype)values (getdate(),'"+txtkno+"','存款',"+text+",'"+s+"')";
        System.out.println(st);
        c.Update(st);
        try {
            c.Close();
        } catch (SQLException ex) {
        }
        //在cardid表里提取数据
         c.getConnection();
         ResultSet tt=c.Query("select balance from cardinfo where cardid='"+txtkno+"'");
          int sal=0;
        try {
            tt.next();
             sal=tt.getInt(1);
            c.Close();
        } catch (SQLException ex1) {
        }
//        System.out.println(sal);
       //更新cardInfo表里的balance余额的数据
        int ss=sal+text;
       c.getConnection();

       String up="update cardinfo set balance="+(ss)+"";
       JOptionPane.showMessageDialog(this,"存储成功!");
       c.Update(up);

    }


}


class Save_refer_actionAdapter implements ActionListener {
    private Save adaptee;
    Save_refer_actionAdapter(Save adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.refer_actionPerformed(e);
    }
}


//class Save_CB1_actionAdapter implements ActionListener {
//    private Save adaptee;
//    Save_CB1_actionAdapter(Save adaptee) {
//        this.adaptee = adaptee;
//    }
//
//    public void actionPerformed(ActionEvent e) {
//        adaptee.CB1_actionPerformed(e);
//    }



class Save_return1_actionAdapter implements ActionListener {
    private Save adaptee;
    Save_return1_actionAdapter(Save adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.return1_actionPerformed(e);
    }
}