roleaccessproxy.java

来自「《Java课程设计案例精编（第二版）》-黄晓东-源代码-4450」· Java 代码 · 共 24 行

package proxyLayer;
import java.util.*;
import java.sql.*;
import javax.swing.*;

import dbAccessLayer.*;
import modules.*;
public class RoleAccessProxy {
	private AccessTableData userDataset = new AccessTableData();
	public boolean ValidateUserExist(String UserName,String Password,String RoleId){
		ResultSet userSet = userDataset.DMLOperation(
				"SELECT * FROM sysuser WHERE  NAME='"+ UserName + "' " + 
				"AND Password='"+ Password + "' AND ROLEID='"+ RoleId + "'");
				
		try
		{
			if( userSet.next() ){
				return true;
			}
			else
				return false;
		}
		catch(SQLException sqlEx){
			JOptionPane.showMessageDialog(null,"鏁版嵁杞