validateuser.java

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

package com.cn.szhaccp.landing;

import com.cn.szhaccp.set.*;
import com.cn.szhaccp.sill.MainFrame;
import java.sql.SQLException;
/*
 * ValidateUser.java
 *
 * Created on 2007年4月28日, 上午11:20
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
/**
 *
 * @author Admin
 */
public class ValidateUser {
    sillClass sill = new sillClass();

    public ValidateUser() {        
    }
    
    /** Creates a new instance of ValidateUser */
    public void Validate(JFrame parent,String userid,String password) {
        if(userid.equalsIgnoreCase("") || password.equalsIgnoreCase("")) {
            JOptionPane.showMessageDialog(parent,"请完整填写账号和密码!","错误",JOptionPane.ERROR_MESSAGE);
        } else {       
            try {
                dbc = new DatabaseConnection();
                stmt = dbc.getConn().createStatement();
                rs = stmt.executeQuery("SELECT *FROM Users WHERE ID = '" + userid + "' AND PassWord = '" + password + "'");
                if(rs.next()) {
                    stmt.executeUpdate("UPDATE Users SET State = 1 WHERE ID = '" + userid + "'");
                    JFrame.setDefaultLookAndFeelDecorated(true);                    
                    MainFrame mf = new MainFrame(sill);                    
                    mf.setVisible(true);
                    parent.dispose();
                } else {
                    JOptionPane.showMessageDialog(parent,"账号或密码错误!请重新输入!","错误",JOptionPane.ERROR_MESSAGE);                    
                }
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    }
    
    private DatabaseConnection dbc;
    private Statement stmt;
    private ResultSet rs;
}