Guest User

Untitled

a guest
Nov 23rd, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.37 KB | None | 0 0
  1. <tr><td>
  2. <label>SQL Server</label>
  3. </td>
  4. <td>
  5. <input class="input" type="radio" id="base" name="base" value=2>
  6. </td></tr>
  7.  
  8. <tr><td>
  9. <label>PostgreSQL</label>
  10. </td>
  11. <td>
  12. <input class="input" type="radio" id="base" name="base" value=3>
  13. </td></tr>
  14. </table>
  15. <div class="btn__form">
  16. <input class="btn__submit" type="submit" value="ACEPTAR">
  17. </div>
  18. </form>
  19. </div>
  20. </center>
  21.  
  22. try (PrintWriter out = response.getWriter()) {
  23. /* TODO output your page here. You may use following sample code. */
  24. out.println("<!DOCTYPE html>");
  25. out.println("<html>");
  26. out.println("<head>");
  27. out.println("<title>Servlet Selecciona</title>");
  28. out.println("<link rel='stylesheet' href='CSS/cajasred.css'/>");
  29. out.println("</head>");
  30. out.println("<body>");
  31. out.println("<br>");
  32. int tb = Integer.parseInt(request.getParameter("base"));
  33. switch (tb) {
  34. case 1:
  35. out.println("<form class='form__reg' action='Login.jsp'>");
  36. out.println("<div class='box-blue'>");
  37. out.println("<center><input class='btn__submit' type='submit' style='font-size: 15pt;' value='INGRESAR AL SISTEMA MySQL'></center>");
  38. out.println("</div>");
  39. out.println("</form>");
  40. break;
  41. case 2:
  42. out.println("<form class='form__reg' action='Login.jsp'>");
  43. out.println("<div class='box-green'>");
  44. out.println("<center><input class='btn__submit' type='submit' style='font-size: 15pt;' value='INGRESAR AL SISTEMA SQL Server'></center>");
  45. out.println("</div>");
  46. out.println("</form>");
  47. break;
  48. default:
  49. out.println("<center><h2>EN MANTENIMIENTO</h2>");
  50. out.println("<a href='index.html'><font color = red style='font-size:25px'>Vuelva a Ingresar</font></a><br>");
  51. out.println("<img src='IMG/construccion.jpg' alt=''/></center>");
  52. break;
  53. }
  54. out.println("</body>");
  55. out.println("</html>");
  56. }
  57. }
  58.  
  59. ClaseCadena cad = new ClaseCadena();
  60. public Connection cn = null;
  61. public Connection conexionBd() {
  62. try {
  63. switch (tipoBase) {
  64. case 1:
  65. cad.setCadConDri("com.mysql.jdbc.Driver");
  66. cad.setCadConbd("jdbc:mysql://localhost/agenciabus");
  67. cad.setUsuario("root");
  68. cad.setPass("1234");
  69. break;
  70. case 2:
  71. cad.setCadConDri("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  72. cad.setCadConbd("jdbc:sqlserver://localhost;databaseName=agenciabus");
  73. cad.setUsuario("sa");
  74. cad.setPass("123456");
  75. break;
  76. default:
  77. break;
  78. }
  79. Class.forName(cad.getCadConDri());
  80. cn = DriverManager.getConnection(cad.getCadConbd(), cad.getUsuario(), cad.getPass());
  81. } catch (HeadlessException | ClassNotFoundException | SQLException e) {
  82. System.out.println("NO se conecto n" + e);
  83. }
  84. return cn;
  85. }
Add Comment
Please, Sign In to add comment