/** * Consulta la base de datos para obtener una lista con las secciones. * * @return Una lista con las secciones en la base de datos. */ public LinkedList<Seccion> consultarSecciones() { LinkedList<Seccion> secciones = new LinkedList<Seccion>(); String sql = "SELECT id, nombre FROM sections order by id"; try { conexion.consultar(sql); while (conexion.getRes().next()) { secciones.add( new Seccion( Integer.parseInt(conexion.getRes().getString(1).toString()), conexion.getRes().getString(2).toString())); } } catch (SQLException | NumberFormatException e) { System.out.println(e.toString()); } return secciones; }
@SuppressWarnings({"unchecked", "unused"}) protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String s = request.getParameter("data"); if (s == null || s.equals("")) { return; } Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); if (conn == null) conn = DriverManager.getConnection(Global.jdbcUrl); } catch (ClassNotFoundException | SQLException e) { throw new RuntimeException("Cannot find the driver in the classpath!", e); } JSONObject json = null; String op = null; String uid = null; try { json = new JSONObject(s); op = json.getString("OP"); uid = json.getString("userid"); } catch (JSONException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } if (op.equals("insert")) { Statement writeStatement = null; try { writeStatement = conn.createStatement(); writeStatement.execute( "INSERT INTO User (userid,isblock,isactive) VALUES('" + uid + "','0','1');"); writeStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } else if (op.equals("select")) { Statement stmt; String sendingText; JSONObject rt = new JSONObject(); try { stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM User WHERE userid = '" + uid + "';"); while (rs.next()) { rt.put("isactive", (Integer.parseInt(rs.getString("isactive")) == 1) ? true : false); rt.put("isblock", (Integer.parseInt(rs.getString("isblock")) == 1) ? true : false); } rs.close(); stmt.close(); } catch (SQLException | NumberFormatException | JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } OutputStreamWriter writer = new OutputStreamWriter(response.getOutputStream()); writer.write(rt.toString()); writer.flush(); } else if (op.equals("block")) { Statement writeStatement = null; try { writeStatement = conn.createStatement(); writeStatement.execute("UPDATE User SET isblock = 1 WHERE userid='" + uid + "';"); writeStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } else if (op.equals("unblock")) { Statement writeStatement = null; try { writeStatement = conn.createStatement(); writeStatement.execute("UPDATE User SET isblock = 0 WHERE userid='" + uid + "';"); writeStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } else { System.err.println("Operation does not match anything!"); } try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return; }