Write a Program using Servlet and JDBC for developing online application for displaying the details of Cars owned by the residents in XYZ society.
Run in SQL
CREATE TABLE Student
( student_id INT NOT NULL AUTO_INCREMENT, student_name VARCHAR(25), student_enrol VARCHAR(10), student_add VARCHAR(70), student_prog VARCHAR(10), student_prog_start VARCHAR(5), student_prog_end VARCHAR(5), PRIMARY KEY(student_id) );
CREATE TABLE Course ( course_id INT NOT NULL AUTO_INCREMENT, course_code VARCHAR(10), course_name VARCHAR(20), course_prog VARCHAR(10), PRIMARY KEY(course_id) );
CREATE TABLE Result ( ID INT NOT NULL AUTO_INCREMENT, course_code VARCHAR(10), student_id VARCHAR(10), marks_assign_got VARCHAR(5), marks_pract_got VARCHAR(5), marks_theory_got VARCHAR(5), result_status VARCHAR(10), PRIMARY KEY(ID), FOREIGN KEY(course_code,student_id,marks_assign_got,marks_pract_got,marks_theory_got) REFERENCES Course (course_code) ,Student(student_id),Marks(marks_assign_got,marks_pract_got,marks_pract_got) );
Java Editor use for Result Servlet Code
package ignou;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.URL;
public class Result extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("<HTML><HEAD><TITLE>IGNOU MCA TEE Result:::</TITLE>");
out.println("</HEAD>");
out.println("<BODY >");
out.println("<P align=center>MCA TEE Result</P>");
out.println("<TABLE align=center border=1 width=\"65%\">");
Connection con=null;
Statement stm = null;
try{
Class.forName("org.gjt.mm.mysql.Driver");
String dbURL="jdbc:mysql://localhost/MCA";
String username="root";
String password="";
con=DriverManager.getConnection(dbURL,username,password);
stm=con.createStatement();
ResultSet rs=stm.executeQuery("SELECT student_name,course_code,marks_assign_got,marks_theory_got,marks_pract_got,result_status FROM Student,Result WHERE Result.student_id =Student.student_id");
while(rs.next()) //retreive all the records into the table
{
out.println("<TR>");
out.println("<TD>Name</TD><TD>" + rs.getString("student_name") + "</TD></TR>");
out.println("<TR><TD>Course code</TD><TD>" + rs.getString("course_code") + "</TD></TR>");
out.println("<TR><TD>Assignments marks</TD><TD>" + rs.getString("marks_assign_got") + "</TD></TR>");
out.println("<TR><TD>Theory marks</TD><TD>" + rs.getString("marks_theory_got") + "</TD></TR>");
out.println("<TR><TD>Practical marks</TD><TD>" + rs.getString("marks_pract_got") + "</TD></TR>");
out.println("<TR><TD>Result</TD><TD>" + rs.getString("result_status") + "</TD>");
out.println("</TR>");
rs.close();
stm.close();
con.close();
}}catch(Exception e){
out.println(e.getMessage());
}
out.println("<P> </P></FONT></BODY></HTML>");
}
}