sysuserproxy.java

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

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

import dbAccessLayer.*;
import modules.*;
public class SysUserProxy {
	private AccessTableData userDataset = new AccessTableData();
	public Vector getAllSysUsers(){
		Vector userList = new Vector();
		ResultSet userSet = userDataset.DMLOperation("SELECT * FROM SYSUSER");
		try
		{
			while( userSet.next() ){
				SysUser user = new SysUser();
				user.setSysUserId( userSet.getString("SYSUSERID") );
				user.setName( userSet.getString("NAME"));
				user.setPassword( userSet.getString("PASSWORD"));
				user.setGender( userSet.getString("GENDER"));
				user.setRoleId( userSet.getString("ROLEID") );
				user.setVoid( userSet.getString("VOID"));
				userList.add(user);
			}			
		}
		catch(SQLException sqlEx){
			JOptionPane.showMessageDialog(null,"鏁版嵁杞