JDBC Exercise

Create a JSP page which accepts student regd.no. and prints the result of that student by retrieving the results from the database.

Source Code

result.html

result.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
	<head>
		<title>Student Result</title>
	</head>
	<body>
		<%
			String regdno = request.getParameter("txtregdno");
			try
			{
				Class.forName("oracle.jdbc.driver.OracleDriver");
				Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "123456");
				Statement st = con.createStatement();
				String query = "select *from students where regno=" + regdno;
				ResultSet rs = st.executeQuery(query);
				response.getWriter().write("Result of " + regdno + ": ");
				rs.next();
				response.getWriter().write("ACN: " + rs.getInt(2) + " ");
				response.getWriter().write("AJWT: " + rs.getInt(3) + " ");
				response.getWriter().write("UP: " + rs.getInt(4) + " ");
				response.getWriter().write("DAA: " + rs.getInt(5) + " ");
				response.getWriter().write("CA: " + rs.getInt(6) + " ");
				response.getWriter().write("MS: " + rs.getInt(7) + " ");
				response.getWriter().write("AJWT LAB: " + rs.getInt(8) + " ");
				response.getWriter().write("CN and UNIX LAB: " + rs.getInt(9) + " ");
				con.close();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
		%>
	</body>
</html>

Starter Tutorials

Problem Statement

Source Code

result.html

result.jsp