src/sanrenxing/right/dao/RoleDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package sanrenxing.right.dao;


import sanrenxing.right.entity.RoleEntity;
import sanrenxing.right.entity.RoleTreeEntity;
import sanrenxing.right.entity.UserEntity;
import sanrenxing.utils.JdbcUtils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
/**
 * 角色数据库操作类
 */
public class RoleDao {

    /**
     * 查询所有角色信息
     * @return List<RoleEntity> 角色信息的集合
     */
    public List<RoleEntity> selectRole(){
        List<RoleEntity> roleList =new ArrayList<>();
        Connection con= null;
        PreparedStatement pst = null;
        ResultSet rs=null;
        try {
            con = JdbcUtils.getConnection();
            //查询所有角色
            String sql="select * from role";
            pst = con.prepareStatement(sql);
            rs = pst.executeQuery();
            while (rs.next()) {
                RoleEntity roleEntity=new RoleEntity();
                roleEntity.setRoleId(rs.getInt("roleId"));
                roleEntity.setRoleName(rs.getString("roleName"));
                roleList.add(roleEntity);//添加到集合
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            JdbcUtils.close(rs,pst,con);
        }
        return  roleList;
    }
    /**
     * 查询所有父功能
     * @return List<RoleTreeEntity> 获取所有父功能树的实体对象集合
     */
    public List<RoleTreeEntity> selectRoleRight(int roleId){
        List<RoleTreeEntity> roleTreeList =new ArrayList<>();
        Connection con= null;
        PreparedStatement pst = null;
        ResultSet rs=null;
        try {
            con = JdbcUtils.getConnection();

            //查询权限编号、权限名、权限-角色流水编号，并保存到数集合当中