接口
package dao.Role; import com.mysql.jdbc.PreparedStatement; import po.role; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; public interface RoleList { //获取用户角色列表 public List<role> SelectRole(Connection conn) throws SQLException; }
实现类
package dao.Role; import dao.BaseDao; import po.role; import java.sql.*; import java.util.ArrayList; import java.util.List; public class RoleListimpl implements RoleList { public List<role> SelectRole(Connection conn) throws SQLException { PreparedStatement pr=null; ArrayList<role> rolelist = new ArrayList<role>(); ResultSet rs = null; Object[] past ={}; String sql = "SELECT * FROM smbms_role"; rs = BaseDao.ExEc((com.mysql.jdbc.Connection) conn, sql, past, pr); while (rs.next()){ role roles = new role(); roles.setId(rs.getLong("id")); roles.setRolecode(rs.getString("Rolecode")); roles.setCreatedby(rs.getLong("Createdby")); roles.setRolecode(rs.getString("Rolecode")); roles.setCreationdate(rs.getDate("Creationdate")); roles.setModifyby(rs.getLong("Modifyby")); roles.setModifydate(rs.getDate("Modifydate")); roles.setRolename(rs.getString("Rolename")); rolelist.add(roles); } BaseDao.ConnClose(null,rs,pr); return rolelist; } }