usertypemanager.java

jsp制作的一个信息管理系统源码,完整实用版

package user;

import java.io.*;
import java.sql.*;
import common.DBManager;

/**
 * Title:UserTypeManager
 * Description:管理系统用户类型
 * Copyright: Copyright (c) 2002
 * Company:
 * @author pwbell
 * @version 1.0
 */

public class UserTypeManager {
	
	public UserTypeManager() {
		// default constructor
	}	
	
	public String getTypeName(int tid) {
		
		ResultSet rs = (new DBManager()).execQuery("select typename from UserType where tid=" + tid);
		
		String typename = null;
		try {
			if(rs != null && rs.next()) {
				typename = rs.getString(1);
				rs.close();
			}
		} catch(SQLException ex) {
			System.err.println("UserTypeManager.getUserLoginName():" + ex.getMessage());
		}
		return typename;
	}
	
	public static void main(String args[]) {
		
		UserTypeManager userTypeManager = new UserTypeManager();
		System.out.println(userTypeManager.getTypeName(4));		
	}		

}