goadd.java~3~

java语言做的教务管理系统

package java_教务管理系统;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JOptionPane;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class goadd extends JDialog {
    JPanel panel1 = new JPanel();
    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField txtuseid = new JTextField();
    JButton btnok = new JButton();
    JLabel jLabel2 = new JLabel();
    JLabel lblmima = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel lblmimaok = new JLabel();
    JLabel jLabel7 = new JLabel();
    Date obj = new Date();
    String str = obj.toString();
    SimpleDateFormat sdfObj = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
    JTextField txtRegister = new JTextField(sdfObj.format(obj));
    JLabel jLabel8 = new JLabel();
    JTextArea txaRemarks = new JTextArea();
    JPasswordField pwdmima = new JPasswordField();
    JPasswordField pwdmimaok = new JPasswordField();
    JPanel jPanel2 = new JPanel();
    JButton btngoadd = new JButton();
    JButton btnexit = new JButton();
    public goadd(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public goadd() {
        this(new Frame(), "goadd", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(4, 4, 238, 169));
        jPanel1.setLayout(null);
        jLabel1.setText("用 户 名：");
        jLabel1.setBounds(new Rectangle(5, 11, 60, 15));
        txtuseid.setBounds(new Rectangle(70, 8, 77, 20));
        btnok.setBounds(new Rectangle(152, 7, 81, 23));
        btnok.setText("检测账号");
        btnok.addActionListener(new goadd_btnok_actionAdapter(this));
        jLabel2.setText("密    码：");
        jLabel2.setBounds(new Rectangle(6, 37, 60, 15));
        lblmima.setBorder(BorderFactory.createEtchedBorder());
        lblmima.setBounds(new Rectangle(154, 35, 79, 20));
        jLabel4.setText("密码确认：");
        jLabel4.setBounds(new Rectangle(6, 62, 60, 15));
        lblmimaok.setBorder(BorderFactory.createEtchedBorder());
        lblmimaok.setBounds(new Rectangle(154, 60, 79, 20));
        jLabel7.setText("注册时间：");
        jLabel7.setBounds(new Rectangle(7, 86, 60, 15));
        txtRegister.setEditable(false);
        txtRegister.setHorizontalAlignment(SwingConstants.CENTER);
        txtRegister.setBounds(new Rectangle(70, 83, 163, 20));
        jLabel8.setText("备    注：");
        jLabel8.setBounds(new Rectangle(9, 108, 60, 15));
        txaRemarks.setBounds(new Rectangle(71, 107, 162, 55));
        pwdmima.setBounds(new Rectangle(70, 32, 77, 22));
        pwdmimaok.setBounds(new Rectangle(70, 58, 77, 21));
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(4, 180, 237, 42));
        btngoadd.setText("注册");
        btngoadd.addActionListener(new goadd_btngoadd_actionAdapter(this));
        btnexit.setText("退出");
        getContentPane().add(panel1);
        panel1.add(jPanel1);
        panel1.add(jPanel2);
        jPanel2.add(btngoadd);
        jPanel2.add(btnexit);
        jPanel1.add(jLabel1);
        jPanel1.add(txtuseid);
        jPanel1.add(btnok);
        jPanel1.add(lblmima);
        jPanel1.add(lblmimaok);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel4);
        jPanel1.add(pwdmima);
        jPanel1.add(pwdmimaok);
        jPanel1.add(txtRegister);
        jPanel1.add(jLabel7);
        jPanel1.add(txaRemarks);
        jPanel1.add(jLabel8);
    }

    public void btngoadd_actionPerformed(ActionEvent e) {
        try {
            String password = String.valueOf(this.pwdmima.getPassword());
            String ok = String.valueOf(this.pwdmimaok.getPassword());
            if (this.txtuseid.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入学号");
                return;
            }
            if (password.equals("")) {
                JOptionPane.showMessageDialog(this, "请输入密码");
                return;
            }
            if (ok.equals("")) {
                JOptionPane.showMessageDialog(this, "请输入确认密码");
                return;
            }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sql = conn.prepareStatement(
                    "insert into go (useid,mima,Register,Remarks) values(?,?,?,?)");
            sql.setString(1, this.txtuseid.getText());
            sql.setString(2, password);
            sql.setString(3, this.txtRegister.getText());
            sql.setString(4, this.txaRemarks.getText());
            int row = sql.executeUpdate();
            if (row > 0) {
                JOptionPane.showMessageDialog(this, "添加成功！");
            } else {
                JOptionPane.showMessageDialog(this, "添加失败！");
            }
            sql.close();
            conn.close();
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "添加失败！");
        }
    }

    public void btnok_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection nod = DriverManager.getConnection(
                    "jdbc:odbc:studer");
            String daima =
                    "select useid from go where useid = " +
                    this.txtuseid.getText() +
                    "";
            PreparedStatement sql = nod.prepareStatement(
                    daima);
            ResultSet i = sql.executeQuery();
            String no = this.txtuseid.getText();
            if (i.next()) {
                if (i.getString(1).equals(no)) {
                    JOptionPane.showMessageDialog(this, "已有的账号");
                }
            } else {
                JOptionPane.showMessageDialog(this, "可用账号");
            }
            i.close();
            sql.close();
            nod.close();
        } catch (Exception ex) {
        }
    }
}


class goadd_btnok_actionAdapter implements ActionListener {
    private goadd adaptee;
    goadd_btnok_actionAdapter(goadd adaptee) {
        this.adaptee = adaptee;
    }

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


class goadd_btngoadd_actionAdapter implements ActionListener {
    private goadd adaptee;
    goadd_btngoadd_actionAdapter(goadd adaptee) {
        this.adaptee = adaptee;
    }

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