-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathContactUs.java
More file actions
47 lines (38 loc) · 1.71 KB
/
Copy pathContactUs.java
File metadata and controls
47 lines (38 loc) · 1.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ContactUs extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
request.getRequestDispatcher("index.html").include(request, response);
try {
Statement stmt;
// Initialize the database
Connection con = Database.initializeDatabase();
stmt = con.createStatement();
String nm = request.getParameter("name");
String em = request.getParameter("email");
String qr= request.getParameter("query");
String st = "Insert into contact us values(" + nm + "," + em + "," + qr + ")";
ResultSet rs = stmt.executeQuery(st);
while (rs.next())
{
String Name = rs.getString("name");
String Email = rs.getString("email");
String Query=rs.getString("query");
}
}
catch (Exception e) {
e.printStackTrace();
}
}
}