dcyde

post sql

Oct 26th, 2017
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.12 KB | None | 0 0
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6.  
  7. import java.io.IOException;
  8. import java.io.PrintWriter;
  9. import java.sql.Connection;
  10. import java.sql.DriverManager;
  11. import java.sql.SQLException;
  12. import java.sql.Statement;
  13. import java.util.logging.Level;
  14. import java.util.logging.Logger;
  15. import javax.servlet.ServletException;
  16. import javax.servlet.http.HttpServlet;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  19.  
  20. /**
  21. *
  22. * @author Dell
  23. */
  24. public class NewServlet extends HttpServlet {
  25.  
  26. /**
  27. * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
  28. * methods.
  29. *
  30. * @param request servlet request
  31. * @param response servlet response
  32. * @throws ServletException if a servlet-specific error occurs
  33. * @throws IOException if an I/O error occurs
  34. */
  35. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  36. throws ServletException, IOException {
  37. response.setContentType("text/html;charset=UTF-8");
  38.  
  39. String user = request.getParameter("user");
  40. String pass = request.getParameter("pass");
  41.  
  42. System.out.println(user+" "+pass);
  43.  
  44. String res;
  45.  
  46. Connection connection = null;
  47.  
  48. try {
  49. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  50. } catch (ClassNotFoundException ex) {
  51. Logger.getLogger(NewServlet.class.getName()).log(Level.SEVERE, null, ex);
  52. }
  53.  
  54.  
  55. try {
  56.  
  57. connection = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=usertable;integratedSecurity=true;");
  58. Statement statement = connection.createStatement();
  59.  
  60. statement.executeUpdate("INSERT INTO dbo.employee ([USER],PASS) VALUES ('"+user+"','"+pass+"')");
  61.  
  62. connection.close();
  63.  
  64. } catch (SQLException ex) {
  65. Logger.getLogger(NewServlet.class.getName()).log(Level.SEVERE, null, ex);
  66. }
  67. try (PrintWriter out = response.getWriter()) {
  68. /* TODO output your page here. You may use following sample code. */
  69. out.println("<!DOCTYPE html>");
  70. out.println("<html>");
  71. out.println("<head>");
  72. out.println("<title>Servlet NewServlet</title>");
  73. out.println("</head>");
  74. out.println("<body>");
  75. out.println("<h1>Servlet NewServlet at " + request.getContextPath() + "</h1>");
  76. out.println("</body>");
  77. out.println("</html>");
  78. }
  79. }
  80.  
  81. // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
  82. /**
  83. * Handles the HTTP <code>GET</code> method.
  84. *
  85. * @param request servlet request
  86. * @param response servlet response
  87. * @throws ServletException if a servlet-specific error occurs
  88. * @throws IOException if an I/O error occurs
  89. */
  90. @Override
  91. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  92. throws ServletException, IOException {
  93. processRequest(request, response);
  94. }
  95.  
  96. /**
  97. * Handles the HTTP <code>POST</code> method.
  98. *
  99. * @param request servlet request
  100. * @param response servlet response
  101. * @throws ServletException if a servlet-specific error occurs
  102. * @throws IOException if an I/O error occurs
  103. */
  104. @Override
  105. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  106. throws ServletException, IOException {
  107. processRequest(request, response);
  108. }
  109.  
  110. /**
  111. * Returns a short description of the servlet.
  112. *
  113. * @return a String containing servlet description
  114. */
  115. @Override
  116. public String getServletInfo() {
  117. return "Short description";
  118. }// </editor-fold>
  119.  
  120. }
Add Comment
Please, Sign In to add comment