diaryframe.java

ACCP 软件工程java 教程学生用书

package diary;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.UIManager;
import javax.swing.JOptionPane;


public class DiaryFrame extends JFrame {
    JPanel contentPane;
    JPanel pnlDisplay = new JPanel();
    JLabel lblFirstName = new JLabel();
    JLabel lblLastName = new JLabel();
    JLabel lblAddress = new JLabel();
    JLabel lblTel = new JLabel();
    JLabel lblMobileNo = new JLabel();
    JLabel lblEmailId = new JLabel();
    JTextField txtFirstName = new JTextField();
    JTextField txtLastName = new JTextField();
    JTextArea txaAddress = new JTextArea();
    JTextField txtTel = new JTextField();
    JTextField txtMobile = new JTextField();
    JTextField txtEmailID = new JTextField();
    JPanel pnlAction = new JPanel();
    JButton btnAdd = new JButton();
    JButton btnDelete = new JButton();
    JButton btnExit = new JButton();
    JPanel pnlNavigation = new JPanel();
    JPanel pnlNavigations = new JPanel();
    JButton btnNext = new JButton();
    JButton btnPrevious = new JButton();
    JButton btnFirst = new JButton();
    JButton btnLast = new JButton();
    Connection con;
    Statement stmt;
    ResultSet rsContacts;
    String url;
    String serverName;
    String portNumber;
    String databaseName;
    String userName;
    String password;
    String sqlString;
    boolean flag = true;

    public DiaryFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
            this.getConnection();
            sqlString = "Select * from Contacts";
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                       ResultSet.CONCUR_UPDATABLE);
            rsContacts = stmt.executeQuery(sqlString);
            rsContacts.next();
            rsToText();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private String getConnectionUrl() {
        url = "jdbc:microsoft:sqlserver://";
        serverName = "127.0.0.1";
        portNumber = "1433";
        databaseName = "test";
        userName = "sa";
        password = "sa";
        return url + serverName + ":" + portNumber
            + ";databaseName=" + databaseName + ";";

    }

    private void rsToText() {
        try {
            txtFirstName.setText(rsContacts.getString(1));
            txtLastName.setText(rsContacts.getString(2));
            txaAddress.setText(rsContacts.getString(3));
            txtMobile.setText(rsContacts.getString(5));
            txtTel.setText(rsContacts.getString(4));
            txtEmailID.setText(rsContacts.getString(6));
        } catch (Exception e) {
            System.out.println(e);
        }
    }

    private void clearText() {
        txtFirstName.setText("");
        txtLastName.setText("");
        txaAddress.setText("");
        txtTel.setText("");
        txtMobile.setText("");
        txtEmailID.setText("");
    }

    private Connection getConnection() {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            con = java.sql.DriverManager.getConnection(getConnectionUrl(),
                    userName, password);

            if (con != null) {
                System.out.println("连接成功!");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;

    }


    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(375, 325));
        setTitle(" ");
        pnlDisplay.setBounds(new Rectangle(2, 55, 354, 196));
        pnlDisplay.setLayout(null);
        lblFirstName.setToolTipText("");
        lblFirstName.setText("名字:");
        lblFirstName.setBounds(new Rectangle(4, 11, 62, 31));
        lblLastName.setText("姓氏:");
        lblLastName.setBounds(new Rectangle(179, 12, 74, 24));
        lblAddress.setText("地址:");
        lblAddress.setBounds(new Rectangle(1, 58, 90, 40));
        lblTel.setText("电话号码:");
        lblTel.setBounds(new Rectangle(1, 126, 90, 25));
        lblMobileNo.setText("手机号码:");
        lblMobileNo.setBounds(new Rectangle(182, 127, 61, 23));
        lblEmailId.setText("电子邮件地址:");
        lblEmailId.setBounds(new Rectangle(1, 165, 65, 20));
        txtFirstName.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txtFirstName.setText("");
        txtFirstName.setBounds(new Rectangle(63, 17, 110, 24));
        txtLastName.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txtLastName.setText("");
        txtLastName.setBounds(new Rectangle(253, 15, 92, 24));
        txaAddress.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txaAddress.setText("");
        txaAddress.setBounds(new Rectangle(65, 47, 106, 64));
        txtTel.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txtTel.setText("");
        txtTel.setBounds(new Rectangle(65, 127, 110, 23));
        txtMobile.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txtMobile.setText("");
        txtMobile.setBounds(new Rectangle(257, 125, 92, 22));
        txtEmailID.setFont(new java.awt.Font("", Font.PLAIN, 11));
        txtEmailID.setText("");
        txtEmailID.setBounds(new Rectangle(64, 163, 112, 24));
        pnlAction.setBounds(new Rectangle(2, 16, 353, 36));
        btnAdd.setFont(new java.awt.Font("", Font.PLAIN, 11));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new DiaryFrame_btnAdd_actionAdapter(this));
        btnDelete.setFont(new java.awt.Font("", Font.PLAIN, 11));
        btnDelete.setText("删除");
        btnDelete.addActionListener(new DiaryFrame_btnSearch_actionAdapter(this));
        btnExit.setFont(new java.awt.Font("", Font.PLAIN, 11));
        btnExit.setText("退出");
        btnExit.addActionListener(new DiaryFrame_btnExit_actionAdapter(this));
        pnlNavigation.setBounds(new Rectangle( -2, 196, 327, 39));
        pnlNavigations.setBounds(new Rectangle(2, 254, 354, 37));
        btnNext.setText(">");
        btnPrevious.setEnabled(false);
        btnPrevious.setText("<");
        btnPrevious.addActionListener(new DiaryFrame_btnPrevious_actionAdapter(this));
        btnFirst.setEnabled(false);
        btnFirst.setText("<<");
        btnFirst.addActionListener(new DiaryFrame_btnFirst_actionAdapter(this));
        btnLast.setFont(new java.awt.Font("", Font.PLAIN, 11));
        btnLast.setText(">>");
        btnLast.addActionListener(new DiaryFrame_btnLast_actionAdapter(this));
        btnNext.addActionListener(new DiaryFrame_btnNext_actionAdapter(this));
        pnlAction.add(btnAdd);
        pnlAction.add(btnDelete);
        pnlAction.add(btnExit);
        contentPane.add(pnlNavigations);
        contentPane.add(pnlDisplay);
        pnlDisplay.add(txtLastName);
        pnlDisplay.add(txtTel);
        pnlDisplay.add(txaAddress);
        pnlDisplay.add(txtEmailID);
        pnlDisplay.add(txtMobile);
        pnlDisplay.add(lblEmailId);
        pnlDisplay.add(lblAddress);
        pnlDisplay.add(lblLastName);
        pnlDisplay.add(txtFirstName);
        pnlDisplay.add(lblMobileNo);
        pnlDisplay.add(lblFirstName);
        pnlDisplay.add(pnlNavigation);
        pnlDisplay.add(lblTel);
        contentPane.add(pnlAction);
        pnlNavigations.add(btnFirst);
        pnlNavigations.add(btnPrevious);
        pnlNavigations.add(btnNext);
        pnlNavigations.add(btnLast);
    }

    public void btnExit_actionPerformed(ActionEvent e) {
        System.exit(0);
    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        try {
            if (btnAdd.getText().equals("添加")) {
                clearText();
                btnAdd.setText("保存");
                btnDelete.setText("取消");
                btnNext.setEnabled(false);
                btnPrevious.setEnabled(false);
                btnLast.setEnabled(false);
                btnFirst.setEnabled(false);