Code-Vault/Java Servlet/Sidpro/WEB-INF/classes/Display_Info.java at main · sidpro-hash/Code-Vault · GitHub

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

import java.io.IOException;
import java.io.PrintWriter;


import javax.servlet.ServletException;
import javax.servlet.ServletConfig;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.RequestDispatcher;
import java.util.regex.Pattern;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;

// First method of creating servlet
public class Display_Info extends HttpServlet{
	private String message;

	public void init() throws ServletException{
		message = "Displaying Employee information";
	}

	public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		//String ppath = request.getContextPath();


		out.println("<!DOCTYPE html>");
		out.println("<html>");

		out.println("<head>");
			out.println("<title> Servlet By Sid </title>");
			out.println("<meta charset=\"utf-8\">");
			out.println("<meta name=\"author\" content=\"SidPro\"/>");
			out.println("<meta name=\"viewport\" content=\"width=device-width,initial-scale=1\">");
			out.println("<link type=\"text/css\" rel=\"stylesheet\" href=\"Display_Info.css\">");
		out.println("</head>");

		out.println("<body>");
			out.println("<h2> "+message+"<a href=\"/Sidpro/Collect_Info\" target=\"_self\"> Register Here</a></h2>");
			//out.println("<h3>Myservlet extends HttpServlet</h3>");
			ServletConfig config=getServletConfig();
				String classname =  config.getInitParameter("classname");
				String url =  config.getInitParameter("url");
				String uname = config.getInitParameter("username");
				String password = config.getInitParameter("password");

				try {
					Class.forName(classname);
				}catch(Exception e) {e.printStackTrace();}

				try(Connection con = DriverManager.getConnection(url,uname,password);){


					Statement stmt1 = con.createStatement();
					ResultSet rs = stmt1.executeQuery("SELECT * FROM emp10");
					out.println("<table>");
					out.println("<tr><td>EMAIL</th><th>LASTNAME</th><th>FIRSTNAME</th><th>GENDER</td><td>EXPERIENCE</td><td>PASSWORD</td></tr>");
					while(rs.next()){
						out.println("<tr>");
						out.println("<td>"+rs.getString(1)+"</td>"+"<td>"+rs.getString(2)+"</td>"+"<td>"+rs.getString(3)+"</td>"+"<td>"+rs.getString(4)+"</td>"+"<td>"+rs.getString(5)+"</td>"+"<td>"+rs.getString(6)+"</td>");
						out.println("</tr>");
					}
					stmt1.close();
					out.println("</table>");
				}
				catch(SQLException e){

					out.println("<p>"+e+"</p>");
				}
				catch(Exception e){

					out.println("<p>"+e+"</p>");
				}

		out.println("</body>");
		out.println("</html>");

	}

}