servelet and jdbc programming

View Answers

March 21, 2009 at 4:17 AM

Hi friend,

Some steps to be remember for solving the problem :

1.Create a html page "stud.html".

<html>

<head>
<title>New Page 1</title>
</head>

<body>

<form method="POST" action="/student">

<p>Student Name:<input type="text" name="student_name" size="20"></p>
<p>Enrollment No: <input type="text" name="enrollment_no" size="20"></p>
<p>Course Code: <input type="text" name="course_code" size="20"></p>
<p>Regional Center Code: <input type="text" name="regional_center_code" size="20"></p>
<p>E-mail Id: <input type="text" name="email_id" size="20"></p>
<p>          
               
<input type="submit" value="Submit" name="submit"></p>
</form>

</body>

</html>

March 21, 2009 at 4:18 AM

Step 2 : create a servlet class "Student.java"

import java.io.*;
import java.lang.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Student extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/zulfiqar";;
Connection connection;
try{

String student_name = request.getParameter("student_name");
String enrollment_no = request.getParameter("enrollment_no");
String course_code = request.getParameter("course_code");
String regional_center_code = request.getParameter("regional_center_code");
String email_id = request.getParameter("email_id");

Class.forName("org.gjt.mm.mysql.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "admin");
PreparedStatement pst = connection.prepareStatement("insert into emp_info values(?,?,?,?,?)");

pst.setString(1,student_name);
pst.setString(2,enrollment_no);
pst.setString(1,course_code);
pst.setString(2,regional_center_code);
pst.setString(1,email_id);

int i = pst.executeUpdate();
if(i!=0){
pw.println("<br>Record has been inserted");
}
else{
pw.println("failed to insert the data");
}
}
catch (Exception e){
pw.println(e);
}
}
}

March 21, 2009 at 4:20 AM

3.In web.xml action mapping of servlet.

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">;

<web-app>
<servlet>
<servlet-name>abc</servlet-name>
<servlet-class>Student</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>abc</servlet-name>
<url-pattern>/student</url-pattern>
</servlet-mapping>
</web-app>

Thanks