role.java

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

package com.newsIssueSystem.javaBean;

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

public class Role {
	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;
	}
	
	public String getRoleName(int roleid)
	{
		DBConnection con = new DBConnection();
		String sql = "select * from Roles where roleid="+roleid+"";
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				Role a = new Role();
				a.setId(con.rs.getInt(1));				
				a.setRoleName(con.rs.getString(2));
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		Role role =(Role)lst.get(0);
		return role.getRoleName(roleid);
	}
}