Filename-inputform.jsp
<html>
<body>
<form
action="http://localhost:8090/wtad/ResultController">
Student ID
<input type="text"
name="enno" />
<br>
<input type="submit"
/>
</form>
</body>
</html>
Filename-ResultController.java
package def33;
import def33.Beanclass;
import java.io.*;
import java.util.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
public class ResultController extends
HttpServlet
{
public
void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException,
ServletException
{
res.setContentType("text/html");
PrintWriter
out=res.getWriter();
out.println("Result
Controller is call");
int
enno=Integer.parseInt(req.getParameter("enno"));
Beanclass
b =new Beanclass(enno);
out.println("Ur
result is"+b.result());
int
total=0;
total=b.result();
if(total==0)
{
RequestDispatcher
dis=req.getRequestDispatcher("/WEB-INF/classes/def33/Unknownstudent.jsp");
dis.forward(req,res);
}
else
if(total>=250)
{
req.setAttribute("total",total);
RequestDispatcher
dis=req.getRequestDispatcher("/WEB-INF/classes/def33/Passedstudent.jsp");
dis.forward(req,res);
}
else
{
req.setAttribute("total",total);
RequestDispatcher
dis=req.getRequestDispatcher("/WEB-INF/classes/def33/Failedstudent.jsp");
dis.forward(req,res);
}
/*try
{
Class.forName("oracle.jdbc.OracleDriver");
String
url="192.168.1.1:1521:password";
String
username="username";
String
password="password";
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:@"+url,username,password);
PreparedStatement
ps=conn.prepareStatement("select * from student where
stdid="+enno+"");
ResultSet
rs=ps.executeQuery();
while(rs.next())
{
int
s1=rs.getInt(3);
int s2=rs.getInt(4);
int
s3=rs.getInt(5);
int
s4=rs.getInt(6);
int
s5=rs.getInt(7);
out.println(s1+s2+s3+s4+s5);
}
}
catch(Exception
e)
{
out.println(e);
}
/*if(enno==1)
{
//RequestDispatcher
dispatcher=request.getRequestDispatcher("\WEB-INF\classes\def33\Passedstudent.jsp");
//dispacher.forward(req);
}*/
}
}
Filename-BeanClass.java
package def33;
import java.io.*;
import java.util.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
public class Beanclass
{
int
total;
Beanclass(int
enno)
{
try
{
Class.forName("oracle.jdbc.OracleDriver");
String
url="192.168.1.1:1521:mcaora";
String
username="mc1016";
String
password="mc1016";
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:@"+url,username,password);
PreparedStatement
ps=conn.prepareStatement("select * from student where
stdid="+enno+"");
ResultSet
rs=ps.executeQuery();
while(rs.next())
{
int
s1=rs.getInt(3);
int
s2=rs.getInt(4);
int
s3=rs.getInt(5);
int
s4=rs.getInt(6);
int
s5=rs.getInt(7);
total=s1+s2+s3+s4+s5;
}
}
catch(Exception
e)
{
System.out.println(e);
}
}
public
int result()
{
return
total;
}
}
Filename-Passedstudent.jsp
<html>
<body>
<h1>Congratulation You are
Passed.</h1>
Your mark is=${total}
</body>
</html>
Filename-FailedStudent.jsp
<html>
<body>
<h1>Sorry You are
Failed.</h1>
Your mark is=${total}
</body>
</html>
Filename-UnknownStudent.jsp
<html>
<body>
<h1>Student data are not
available.</h1>
</body>
</html>
Output
Student
ID
No comments:
Post a Comment