adduserframe.java

学生档案管理系统

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package 学生档案管理系统;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
/**
 *
 * @author Administrator
 */
public class AddUserFrame extends JDialog{
    Statement ps;
    ResultSet rs;
    Connection con;
    String url;
    
    JPanel panel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField userF = new JTextField();
    JLabel jLabel2 = new JLabel();
    JButton sure = new JButton();
    JButton cancel = new JButton();
    JLabel jLabel3 = new JLabel();
    JPasswordField pwd = new JPasswordField();
    JPasswordField pwd1 = new JPasswordField();
    JLabel jLabel4 = new JLabel();
    
    public AddUserFrame(Frame frame, String title, boolean modal) {
        super(frame, title, modal);
        try {
            jbInit();
            pack();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    
    public AddUserFrame() {
        this(null, "", true);
    }
    
    private void jbInit() throws Exception {
        panel1.setLayout(null);
        this.getContentPane().setLayout(null);
        panel1.setBounds(new Rectangle(10, 10, 452, 369));
        jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
        jLabel1.setText("请输入用户名");
        jLabel1.setBounds(new Rectangle(2, 17, 101, 35));
        userF.setText("");
        userF.setBounds(new Rectangle(113, 19, 121, 31));
        jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
        jLabel2.setText("请输入密码");
        jLabel2.setBounds(new Rectangle(7, 69, 101, 35));
        sure.setBounds(new Rectangle(12, 204, 90, 35));
        sure.setFont(new java.awt.Font("Dialog", 0, 15));
        sure.setText("确  定");
        sure.addActionListener(new adduser_sure_actionAdapter(this));
        cancel.setBounds(new Rectangle(132, 204, 90, 38));
        cancel.setFont(new java.awt.Font("Dialog", 0, 15));
        cancel.setText("取 消");
        cancel.addActionListener(new adduser_cancel_actionAdapter(this));
        this.setTitle("添加用户");
        jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
        jLabel3.setText("请再次输入密码");
        jLabel3.setBounds(new Rectangle(3, 109, 106, 35));
        pwd.setBounds(new Rectangle(114, 68, 120, 32));
        pwd1.setText("");
        pwd1.setBounds(new Rectangle(115, 108, 120, 32));

        jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
        getContentPane().add(panel1, null);
        panel1.add(jLabel1, null);
        panel1.add(sure, null);
        panel1.add(cancel, null);
        panel1.add(jLabel3, null);
        panel1.add(jLabel2, null);
        panel1.add(pwd, null);
        panel1.add(pwd1, null);
        panel1.add(userF, null);
        panel1.add(jLabel4, null);
    //   power.addItem("系统管理员");
    //  power.addItem("普通用户");
        this.setBounds(300, 300, 300, 300);
        this.setVisible(true);
    }
    void cancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }
    void sure_actionPerformed(ActionEvent e) {
        if(pwd.getText().trim().endsWith(pwd1.getText().trim())){
            JOptionPane.showConfirmDialog(null,"确定添加？", "添加用户", JOptionPane.YES_NO_OPTION);
            try {
                try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");
                    ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                }
                catch (Exception err) {
                    String error = err.getMessage();
                    JOptionPane.showMessageDialog(null, "连接数据库错误!");
                }
                try {
                    String s1 = "'"+userF.getText().trim()+"'";
                    String s2 = "'"+pwd.getText().trim()+"'";
                    String sqlStr = "Insert Into 用户表(用户名,用户密码) values(" + s1 + "," + s2 + ")";
                    ps.execute(sqlStr);                    
                    ps.close();                   
                    JOptionPane.showMessageDialog(null, "添加成功");
                    this.dispose();
                }
                catch (SQLException sqle) {
                    String error = sqle.getMessage();
                    JOptionPane.showMessageDialog(null, error);
                    sqle.printStackTrace();
                }

            }
            catch (Exception ex) {
                ex.getMessage();
                String error = ex.getMessage();
                JOptionPane.showMessageDialog(null, error);
                ex.printStackTrace();
            }
        }
    }
}
class adduser_cancel_actionAdapter
    implements java.awt.event.ActionListener {
    AddUserFrame adaptee;

    adduser_cancel_actionAdapter(AddUserFrame adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class adduser_sure_actionAdapter
    implements java.awt.event.ActionListener {
    AddUserFrame adaptee;

    adduser_sure_actionAdapter(AddUserFrame adaptee) {
        this.adaptee = adaptee;
    }

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