mainframe.java

北大青鸟几次机试的试题

package My_Means;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.*;

public class mainFrame extends JFrame {
    Connection con;
    PreparedStatement ps;
    ResultSet rs;
    String sql;
    public mainFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    boolean search() {
        sql = "select * from addressList where name=?";
        con = ConnectToDB.getcon();
        try {
            ps = con.prepareStatement(sql);
            ps.setString(1, this.jTextField1.getText());
            rs = ps.executeQuery();
            while (rs.next()) {
                this.jTextField2.setText(rs.getString(3));
                this.jTextField3.setText(rs.getString(4));
                this.jTextField4.setText(rs.getString(5));
                ps.close();
                con.close();
                return true;
            }
            ps.close();
            con.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return false;
    }

    boolean insert() {
        sql =
                "insert into addressList(name,telephone,mobileTele,address) values(?,?,?,?)";
        con = ConnectToDB.getcon();
        try {
            ps = con.prepareStatement(sql);
            ps.setString(1, this.jTextField1.getText());
            ps.setString(2, this.jTextField2.getText());
            ps.setString(3, this.jTextField3.getText());
            ps.setString(4, this.jTextField4.getText());
            int c = ps.executeUpdate();
            while (c > 0) {
                ps.close();
                con.close();
                return true;
            }
            ps.close();
            con.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return false;
    }

    public static void main(String[] args) {
        mainFrame p = new mainFrame();

    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jLabel1.setText("联系人姓名:");
        jLabel1.setBounds(new Rectangle(58, 43, 94, 19));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jLabel4.setText("联系人地址:");
        jLabel4.setBounds(new Rectangle(58, 166, 105, 19));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jLabel3.setText("联系人手机:");
        jLabel3.setBounds(new Rectangle(58, 122, 102, 19));
        jButton1.addActionListener(new mainFrame_jButton1_actionAdapter(this));
        jButton2.addActionListener(new mainFrame_jButton2_actionAdapter(this));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        this.getContentPane().add(jLabel1);
        jButton2.setBounds(new Rectangle(201, 223, 82, 28));
        jButton2.setText("查询");
        jButton1.setBounds(new Rectangle(63, 223, 82, 28));
        jButton1.setText("添加");
        jTextField4.setBounds(new Rectangle(163, 162, 133, 24));
        jTextField3.setBounds(new Rectangle(163, 119, 131, 24));
        jTextField2.setBounds(new Rectangle(163, 78, 130, 24));
        jTextField1.setBounds(new Rectangle(163, 40, 129, 24));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jButton1);
        jLabel2.setText("联系人电话:");
        jLabel2.setBounds(new Rectangle(58, 80, 109, 19));
        this.setTitle("通讯录");
        this.setBounds(350, 150, 450, 400);
        this.show();
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
        if (this.jTextField1.getText().equals("")) {
            javax.swing.JOptionPane.showMessageDialog(this, "联系人姓名必须输入,请输入");
            return;
        } else {
            if (insert()) {
                javax.swing.JOptionPane.showMessageDialog(this, "插入成功");
            }

        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        if (search()) {

        } else {
            javax.swing.JOptionPane.showMessageDialog(this, "没有该联系人信息");
        }
    }
}


class mainFrame_jButton2_actionAdapter implements ActionListener {
    private mainFrame adaptee;
    mainFrame_jButton2_actionAdapter(mainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class mainFrame_jButton1_actionAdapter implements ActionListener {
    private mainFrame adaptee;
    mainFrame_jButton1_actionAdapter(mainFrame adaptee) {
        this.adaptee = adaptee;
    }

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