adduser.java

用java写的固定资产管理系统原代码 这可是自己小组做的哦

package com.cn.szhaccp.landing;

/*
 * AddUser.java
 *
 * Created on 2007年4月28日, 上午11:56
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import javax.swing.JDialog;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
/**
 *
 * @author Admin
 */
public class AddUser {
    
    /** Creates a new instance of AddUser */
    public AddUser() {        
    }
    
    public void addUser(JDialog parent,String username,String name,String pass1,String pass2) {
        if(username.equalsIgnoreCase("") || name.equalsIgnoreCase("") || pass1.equalsIgnoreCase("") || pass2.equalsIgnoreCase("")) {
            JOptionPane.showMessageDialog(parent,"请填写完所有项!","错误",JOptionPane.ERROR_MESSAGE);
        } else if(!pass1.equals(pass2)) {
            JOptionPane.showMessageDialog(parent,"两次密码不一致!请重新输入!","错误",JOptionPane.ERROR_MESSAGE);
        } else {
            try {
                dbc = new DatabaseConnection();
                stmt = dbc.getConn().createStatement();
                rs = stmt.executeQuery("SELECT *FROM Users WHERE UserName = '" + username + "'");
                if(rs.next()) {
                    JOptionPane.showMessageDialog(parent,"该用户名已被人注册!请重新填写一个","警告",JOptionPane.WARNING_MESSAGE);
                } else {
                    int i = stmt.executeUpdate("INSERT Users(UserName,Name,PassWord) VALUES('" + username + "','" + name + "','" + pass1 + "')");
                    rs = stmt.executeQuery("SELECT *FROM Users WHERE UserName = '" + username + "'");
                    if(rs.next()) {
                        JOptionPane.showMessageDialog(parent,"恭喜!注册成功!你的ID为: " + rs.getString("ID") + " 请记牢!","恭喜",JOptionPane.INFORMATION_MESSAGE);
                        parent.dispose();
                    }
                }
            } catch(ClassNotFoundException e) {
                e.printStackTrace();
            } catch(SQLException e) {
                System.out.println(e);
            }
        }
    }
    
    private DatabaseConnection dbc;
    private Statement stmt;
    private ResultSet rs;
}