获取角色列表

1.创建角色Dao接口

package com.kuang.dao.role;

import com.kuang.pojo.Role;

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

public interface RoleDao {
    //查询Role表的列表
    public List<Role> getRoleList(Connection connection) throws SQLException;
}

2.创建角色Dao接口实现类

package com.kuang.dao.role;

import com.kuang.dao.BaseDao;
import com.kuang.pojo.Role;

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 RoleDaoImp implements RoleDao{
    @Override
    public List<Role> getRoleList(Connection connection) throws SQLException {
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;
        List<Role> roles = new ArrayList<Role>();;
        if (connection != null) {
            String sql = "select * from smbms_role";
            Object[] param = {};
            rs = BaseDao.execute(connection, preparedStatement, rs, sql, param);
            while (rs.next()) {
                Role _role = new Role();
                _role.setId(rs.getInt("id"));
                _role.setRoleCode(rs.getString("roleCode"));
                _role.setRoleName(rs.getString("roleName"));
                roles.add(_role);
            }
            BaseDao.closeResource(null, preparedStatement, rs);
        }
        return roles;
    }
}

3.创建角色业务层接口

package com.kuang.service.role;

import com.kuang.pojo.Role;

import java.sql.Connection;
import java.util.List;

public interface RoleService {
    //查询Role表
    public List<Role> getRoleList();
}

4.创建角色业务层接口实现类

package com.kuang.service.role;

import com.kuang.dao.BaseDao;
import com.kuang.dao.role.RoleDao;
import com.kuang.dao.role.RoleDaoImp;
import com.kuang.pojo.Role;
import org.junit.Test;

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

public class RoleServiceIml implements  RoleService{
    private RoleDao roleDao;
    public RoleServiceIml(){
        roleDao=new RoleDaoImp();
    }


    @Override
    public List<Role> getRoleList() {
        Connection connection=null;
        List<Role> roles=null;
        try {
            connection= BaseDao.getConnection();
            roles = roleDao.getRoleList(connection);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.closeResource(connection,null,null);
        }
        return roles;
    }


}