Filename-input.jsp
<html>
<title>
Input
page
</title>
<body>
<form
action="http://localhost:8090/wtad/Marksheet">
Id:
<input
type="text" name="id"/>
<input
type="submit"/>
</form>
</body>
</html>
Filename-Marksheet.java
package def16;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Marksheet extends
HttpServlet
{
public
void doGet(HttpServletRequest req,HttpServletResponse res) throws
IOException,ServletException
{
res.setContentType("text/html");
PrintWriter
out=res.getWriter();
int
id=Integer.parseInt(req.getParameter("id"));
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:system/powerise@localhost:1521:XE");
PreparedStatement
ps=conn.prepareStatement("select id,name,sub1,sub2,sub3,sub4,sub5 from
student2 where id="+id+"");
ResultSet
rs=ps.executeQuery();
while(rs.next())
{
out.println("<table
border=1 align=center > ");
out.println("<tr>");
out.println("<td>");
out.println("Id:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(1));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Name:");
out.println("</td>");
out.println("<td>");
out.println(rs.getString(2));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Sub1:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(3));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Sub2:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(4));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Sub3:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(5));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Sub4:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(6));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("Sub5:");
out.println("</td>");
out.println("<td>");
out.println(rs.getInt(7));
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
int
total=rs.getInt(3)+rs.getInt(4)+rs.getInt(5)+rs.getInt(6)+rs.getInt(7);
if(total>=50)
{
out.println("<font
color=green />");
out.println("Congratulation
you have passed.");
}
else
{
out.println("<font
color=red />");
out.println("Sorry
you failed Try again.");
}
out.println("</td>");
out.println("</tr>");
out.println("</table>");
}
}
catch(Exception
e)
{
out.println(e);
}
}
}
Output
Id:
|
Id:
|
101
|
|
Name:
|
krunal
|
|
Sub1:
|
98
|
|
Sub2:
|
99
|
|
Sub3:
|
100
|
|
Sub4:
|
97
|
|
Sub5:
|
95
|
|
Congratulation you have passed.
|
|
No comments:
Post a Comment