Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Servlet extends javax.servlet.http.HttpServlet {
- private static final String URL = "jdbc:sqlserver://****";
- private static final String USERNAME = "****";
- private static final String PASSWORD = "****";
- protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
- }
- protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
- Connection conn = null;
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
- Statement statement = conn.createStatement();
- statement.executeUpdate("INSERT into users (nickname, age, email) VALUES ('Mark', 16, 'markmark@gmail.com');");
- statement.close();
- conn.close();
- } catch (SQLException | ClassNotFoundException e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment