zjYc4xmX

1import java.io.IOException;
2import java.io.PrintWriter;
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.SQLException;
6import java.sql.Statement;
7
8import javax.servlet.ServletException;
9import javax.servlet.annotation.WebServlet;
10import javax.servlet.http.HttpServlet;
11import javax.servlet.http.HttpServletRequest;
12import javax.servlet.http.HttpServletResponse;
13
14@WebServlet(urlPatterns = {"/NewServlet"})
15public class NewServlet extends HttpServlet {
16
17
18protected void processRequest(HttpServletRequestrequest,HttpServletResponse response) throws ServletException, IOException {
19
20response.setContentType("text/html;charset=UTF-8");
21
22String url = "jdbc:sqlite:/Users/akshayoct13/Desktop/ncp/test1.db";
23
24// SQL statement for creating a new table
25String sql = "CREATE TABLE IF NOT EXISTS warehouses (n"
26+ " id integer PRIMARY KEY,n"
27+ " name text NOT NULL,n"
28+ " capacity realn"
29+ ");";
30
31try (Connection conn = DriverManager.getConnection(url);
32Statement stmt = conn.createStatement()) {
33// create a new table
34stmt.execute(sql);
35} catch (SQLException e) {
36System.out.println(e.getMessage());
37}
38
39
40}