Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String[] args) {
- Connection cone = new Conexion().obtenerConexion();
- String sql = "{call sp_listar_rol}";
- if (cone != null) {
- Rol r = new Rol();
- Permiso p = new Permiso();
- try {
- CallableStatement cs = cone.prepareCall(sql);
- cs.executeQuery();
- ResultSet rs = cs.executeQuery();
- if (rs.next()) {
- int id = rs.getInt(1);
- String perfil = rs.getString(2);
- String desc = rs.getString(3);
- int permiso = rs.getInt(4);
- p.setId(permiso);
- r.setId(id);
- r.setPerfil(perfil);
- r.setDescripcion(desc);
- r.setId_permiso(p);
- }
- System.out.println(r.getPerfil());
- } catch (SQLException ex) {
- Logger.getLogger(test.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement