update.java~78~

一個模仿ATM自動提款机功能的系統,

package MainFrame;
import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;
import java.awt.Dimension;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;

public class Update extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField jTextField7 = new JTextField();
    String q2[] = {"请选择联系方式", "手机号", "座机号"};
    JComboBox jComboBox1 = new JComboBox(q2);
    JTextField jTextField8 = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField jTextField9 = new JTextField();
    String q1[] = {"请选择证件", "身份证", "学生证"};
    JComboBox jComboBox2 = new JComboBox(q1);
    JTextField jTextField10 = new JTextField();
    JLabel jLabel11 = new JLabel();
    JTextField jTextField11 = new JTextField();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JPasswordField jPasswordField1 = new JPasswordField();
    JPasswordField jPasswordField2 = new JPasswordField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    public Update() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(xYLayout1);
        xYLayout1.setWidth(544);
        xYLayout1.setHeight(460);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel2.setText("用户ID");
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel3.setText("姓名");
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel4.setText("余额");
        jLabel1.setFont(new java.awt.Font("华文彩云", Font.BOLD, 18));
        jLabel1.setForeground(Color.green);
        jLabel1.setText("用户查询删除栏");
        jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel6.setText("证件号");
        jLabel7.setFont(new java.awt.Font("华文彩云", Font.BOLD, 18));
        jLabel7.setForeground(Color.green);
        jLabel7.setText("用户创建栏");
        jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel8.setText("用户ID");
        jTextField2.setForeground(Color.red);
        jTextField2.setEditable(false);
        jTextField3.setForeground(Color.red);
        jTextField3.setEditable(false);
        jTextField4.setForeground(Color.red);
        jTextField4.setEditable(false);
        jTextField5.setForeground(Color.red);
        jTextField5.setEditable(false);
        jLabel9.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel9.setText("姓名");
        jLabel10.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel10.setText("住址");
        jLabel11.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel11.setText("联系电话");
        jTextField11.setForeground(Color.red);
        jTextField11.setEditable(false);
        jLabel13.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel13.setText("密码");
        jLabel14.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel14.setText("确认密码");
        jButton1.setFont(new java.awt.Font("华文彩云", Font.BOLD, 12));
        jButton1.setText("查询");
        jButton1.addActionListener(new Update_jButton1_actionAdapter(this));
        jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton2.setText("删除");
        jButton2.addActionListener(new Update_jButton2_actionAdapter(this));
        jButton3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton3.setText("创建");
        jButton3.addActionListener(new Update_jButton3_actionAdapter(this));
        jButton4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton4.setText("取消");
        jButton4.addActionListener(new Update_jButton4_actionAdapter(this));
        jButton5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton5.setText("取消");
        jButton5.addActionListener(new Update_jButton5_actionAdapter(this));
        this.addWindowListener(new Update_this_windowAdapter(this));
        this.getContentPane().setBackground(UIManager.getColor(
                "InternalFrame.activeTitleGradient"));
        this.setForeground(UIManager.getColor(
                "CheckBoxMenuItem.selectionBackground"));
        jButton6.setFont(new java.awt.Font("宋体", Font.BOLD, 17));
        jButton6.setText("退出");
        jButton6.addActionListener(new Update_jButton6_actionAdapter(this));
        this.getContentPane().add(jLabel1, new XYConstraints(27, 5, 165, 33));
        jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel5.setText("住址");
        this.getContentPane().add(jLabel4, new XYConstraints(5, 125, 60, 35));
        this.getContentPane().add(jLabel5, new XYConstraints(5, 170, 60, 35));
        this.getContentPane().add(jLabel2, new XYConstraints(5, 40, 60, 35));
        this.getContentPane().add(jLabel3, new XYConstraints(5, 80, 60, 35));
        this.getContentPane().add(jTextField1,
                                  new XYConstraints(74, 44, 137, 32));
        this.getContentPane().add(jTextField2,
                                  new XYConstraints(74, 81, 136, 32));
        this.getContentPane().add(jTextField3,
                                  new XYConstraints(74, 126, 136, 33));
        this.getContentPane().add(jTextField4,
                                  new XYConstraints(74, 165, 136, 35));
        this.getContentPane().add(jTextField8,
                                  new XYConstraints(328, 122, 144, 36));
        this.getContentPane().add(jLabel11, new XYConstraints(4, 263, 69, 36));
        this.getContentPane().add(jTextField10,
                                  new XYConstraints(330, 216, 147, 38));
        this.getContentPane().add(jLabel7, new XYConstraints(271, 7, 149, 26));
        this.getContentPane().add(jTextField6,
                                  new XYConstraints(330, 40, 140, 30));
        this.getContentPane().add(jTextField7,
                                  new XYConstraints(330, 77, 142, 33));
        this.getContentPane().add(jLabel6, new XYConstraints(5, 220, 60, 35));
        this.getContentPane().add(jTextField9,
                                  new XYConstraints(353, 169, 123, 35));
        this.getContentPane().add(jLabel10, new XYConstraints(240, 120, 60, 35));
        this.getContentPane().add(jLabel9, new XYConstraints(240, 80, 60, 35));
        this.getContentPane().add(jLabel8, new XYConstraints(240, 40, 60, 35));
        this.getContentPane().add(jLabel14, new XYConstraints(232, 310, 65, 32));
        this.getContentPane().add(jPasswordField1,
                                  new XYConstraints(332, 265, 141, 34));
        this.getContentPane().add(jPasswordField2,
                                  new XYConstraints(332, 309, 141, 33));
        this.getContentPane().add(jLabel12, new XYConstraints(238, 166, 136, 37));
        this.getContentPane().add(jComboBox1,
                                  new XYConstraints(229, 170, 120, 35));
        this.getContentPane().add(jComboBox2,
                                  new XYConstraints(230, 220, 90, 35));
        this.getContentPane().add(jButton1, new XYConstraints(5, 365, 70, 30));
        this.getContentPane().add(jButton4, new XYConstraints(400, 365, 70, 30));
        this.getContentPane().add(jButton3, new XYConstraints(280, 365, 70, 30));
        this.getContentPane().add(jButton2, new XYConstraints(80, 365, 70, 30));
        this.getContentPane().add(jButton5, new XYConstraints(155, 365, 70, 30));
        this.getContentPane().add(jLabel13, new XYConstraints(233, 270, 85, 37));
        this.getContentPane().add(jButton6, new XYConstraints(203, 414, 95, 34));
        this.getContentPane().add(jTextField5,
                                  new XYConstraints(73, 265, 139, 35));
        this.getContentPane().add(jTextField11,
                                  new XYConstraints(73, 217, 137, 36));

    }

    public static void main(String[] args) {
        Update u = new Update();
        u.setBounds(200, 200, 500, 500);
        u.setTitle("管理员操作界面");
        u.setVisible(true);
    }

    public void this_windowClosing(WindowEvent e) {
        System.exit(0);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try {

            Connection con;
            Statement stmt;
            ResultSet rs1;
            String a = jTextField1.getText();
            int b = Integer.parseInt(a);
            if (a.equals("")) {
                JOptionPane.showMessageDialog(null, "沒有輸入用戶ID！", "輸入錯誤",
                                              JOptionPane.ERROR_MESSAGE);
            } else {
                try {
                    Class.forName(
                            "com.microsoft.jdbc.sqlserver.SQLServerDriver");
                    Connection conn = DriverManager.getConnection(
                            "jdbc:microsoft:sqlserver://localhost:1433;databaseName=ATM",
                            "sa", "huang100");
                    Statement Stat = conn.createStatement();
                    rs1 = Stat.executeQuery(
                            "select * from userTable where userid='" + b + "'");
                    if (rs1.next()) {
                        jTextField2.setText(rs1.getString(3));
                        jTextField3.setText(rs1.getString(4));
                        jTextField4.setText(rs1.getString(5));
                        jTextField5.setText(rs1.getString(6));
                        jTextField11.setText(rs1.getString(7));
                    } else {
                        JOptionPane.showMessageDialog(null, "没有" + a + "   用户");
                        jTextField2.setText("");
                        jTextField3.setText("");
                        jTextField4.setText("");
                        jTextField5.setText("");
                        jTextField11.setText("");
                    }
                } catch (Exception ex) {
                    System.out.println("数据库连接失败");

                }
            }