Hello everyone,
I am new in java. I am making a simple java project. I just want to display stored data from database on html page.
Here is my code:-
The JAVA code
package home;
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Profile extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String s1 = request.getParameter("name");
String s2 = request.getParameter("number");
String s3 = request.getParameter("state");
String s4 = request.getParameter("country");
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","admin");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select name,number,state and country from REGISTRATION");
while(rs.next()){
String name = rs.getString("name");
String number = rs.getString("number");
String state = rs.getString("state");
String country = rs.getString("country");
out.print(name);
out.print(number);
out.print(state);
out.print(country);
}
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
and the HTML page code is :-
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Profile</title>
</head>
<body>
<form action="profile" method="get">
<section>
Name:<input type="text" name="name">
Mobile:<input type="text" name="number">
State:<input type="text" name="state">
Country:<input type="text" name="country">
</section>
</form>
</body>
</html>