Guest User

Untitled

a guest
Jul 12th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. public class Servlet extends javax.servlet.http.HttpServlet {
  2.  
  3. private static final String URL = "jdbc:sqlserver://****";
  4. private static final String USERNAME = "****";
  5. private static final String PASSWORD = "****";
  6.  
  7. protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
  8.  
  9.  
  10.  
  11. }
  12.  
  13. protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
  14.  
  15. Connection conn = null;
  16.  
  17. try {
  18. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  19. conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
  20. Statement statement = conn.createStatement();
  21. statement.executeUpdate("INSERT into users (nickname, age, email) VALUES ('Mark', 16, 'markmark@gmail.com');");
  22. statement.close();
  23. conn.close();
  24. } catch (SQLException | ClassNotFoundException e) {
  25. e.printStackTrace();
  26. }
  27. }
Add Comment
Please, Sign In to add comment