roles.java

新闻发布系统 jsp制作。可应用与毕业设计

package com.newsIssueSystem.javaBean;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Roles {
	private int id;
	private String rolename;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getRolename() {
		return rolename;
	}
	public void setRolename(String rolename) {
		this.rolename = rolename;
	}
	/*
	 * 根据roleid 取rolename
	 * */
	public String getRoleName(int roleid)
	{
		DBConnection con = new DBConnection();
		String sql = "select * from Roles where roleid="+roleid;
		ArrayList lst=new ArrayList();
		String rolename=null;
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				Roles a = new Roles();
				a.setId(con.rs.getInt(1));
				a.setRolename(con.rs.getString(2));		
				lst.add(a);
				rolename=a.getRolename();
				return rolename;
			}
		
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return rolename;
	}
}