roledao.java

包括所有开发文档以及数据库文件

package dao;

import java.sql.*;
import java.util.Vector;
//import java.util.Vector;

import bo.*;

public class RoleDAO {
		/**
		 * @author lizhenyan
		 * @param groupId
		 * @return role
		 */

	 public Vector selectRoleInGroup(String groupId) {
		
	    Vector<Role> vResult = new Vector<Role>(1, 1);
		Connection con = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "select * from role where roleId in (select roleId from group_role where groupId=?);";

		try {

			con = DB.getConnection();
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, groupId);
			rs = pstmt.executeQuery();
			int i = 0;
			while(rs != null && rs.next()&&i<20) {
				// 读到数据，生成实体类
				Role role = new Role();
				role.setRoleId(rs.getInt("roleId"));
				role.setRoleName(rs.getString("roleName"));
				role.setRoleDescription(rs.getString("roleDescription"));
				vResult.add(role);
				i++;
			}

			rs.close();
			pstmt.close();
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return vResult;
	}
	
	

}