[pro33index.jsp]
<html>
<body>
<form method="get" action="pro33showdetail.jsp">
<table align=center cellpadding=10>
<tr>
<td colspan=2 align=center> <img src="logo.jpg"/>
<tr>
<td align="center" colspan=2><h2><i>LOGIN PAGE</i></h2>
<tr>
<td>
<table align="center">
<tr>
<td>UserName
<td><input type="text" name="uname"><br/>
<tr>
<td>Password
<td><input type="password" name="pass"><br/>
<tr>
<td><input type="submit" value="LOGIN" >
<td><input type="reset" value="CLEAR">
</table>
<tr>
<td colspan=7 align="right"><i><a href="http://www.master-gtu.blogspot.com">master-gtu.blogspot.com</a></i>
</table>
</form>
</body>
</html>
[pro33showdetail.jsp]
<%@ page import="java.sql.*" %>
<%
String uname=request.getParameter("uname");
String pass=request.getParameter("pass");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pankaj");
PreparedStatement ps =con.prepareStatement("select * from student where uname=? and pass=?");
ps.setString(1,uname);
ps.setString(2,pass);
ResultSet rs=ps.executeQuery();
//out.println(rs.next()); return boolean
if(rs.next())
{
%>
<table align=center cellpadding=10>
<tr colspan=2>
<td colspan=2 align=center> <img src="logo.jpg"/>
<tr colspan=2>
<td align="center" colspan=2><h2><i>DETAILED INFORMATION</i></h2>
<tr>
<td>
<table border=5><tr><td>
<table cellpadding=5 cellspacing=0>
<caption> <h2>Personal Details</h2></caption>
<tr bgcolor="limegreen"><th>Name<th>Adress<th>Gender<th>Qualification<th>Contact No.
<tr>
<td><%=rs.getString(3)%>
<td><%=rs.getString(4)%>
<td><%=rs.getString(5)%>
<td><%=rs.getString(6)%>
<td><%=rs.getString(7)%>
</table>
</table>
<%
rs=ps.executeQuery();
rs.next();
int m1=java.lang.Integer.parseInt(rs.getString(8));
int m2=java.lang.Integer.parseInt(rs.getString(9));
int m3=java.lang.Integer.parseInt(rs.getString(10));
%>
<td>
<table border=5><tr><td>
<table cellpadding=5 cellspacing=1>
<caption> <h2>MarkSheet </h2></caption>
<tr bgcolor="limegreen">
<th>Physics<th>Chemistry<th>Math<th>Total Mark<th>Percentage
<tr><td><%=m1%>
<td><%=m2%>
<td><%=m3%>
<td><%=m1+m2+m3 %>
<td><%=(m1+m2+m3)/3 %>
</table>
</table>
<tr>
<td colspan=7 align="right"><i><a href="http://www.master-gtu.blogspot.com">master-gtu.blogspot.com</a></i>
</table>
<%
}
else
{
response.sendRedirect("pro33index.jsp");
}
%>
As we know there are many companies which are converting into Big data service providers. with the right direction we can definitely predict the future.
ReplyDelete