Delete.java
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Delete extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throwsServletException, IOException {
response.setContentType("text/html");
PrintWriterpw = response.getWriter();
String rollno=request.getParameter("roll");
int roll=Integer.valueOf(rollno);
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","manager");
PreparedStatementps=con.prepareStatement("delete from students where rno=?");
ps.setInt(1,roll);
inti = ps.executeUpdate();
if(i!=0)
pw.println("Deleting row...");
else if (i==0)
{
pw.println("<br>Row has been deleted successfully.");
}
}
catch (Exception e2) {e2.printStackTrace();}
finally{pw.close();}
}
}
Insert.java
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class insert extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throwsServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String rno,sn,brn,pg,adr;
rno=(String)request.getParameter("rn");
sn=(String)request.getParameter("un");
brn=(String)request.getParameter("br");
pg=(String)request.getParameter("pr");
adr=(String)request.getParameter("ad");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","manager");
Statement st=con.createStatement();
// PreparedStatementpst=(PreparedStatement) con.prepareStatement();
String sql = "insert into students values('"+rno+"','"+sn+"','"+brn+"','"+pg+"','"+adr+"')" ;
int x = st.executeUpdate(sql);
if(x>0)
{
out.println("1 row inserted successfully");
}
else
{
out.println("not inserted");
}
st.close();
con.close();
}
catch (Exception e2)
{e2.printStackTrace();}
finally{out.close();}
} }
Search.java
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Search extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String rollno=request.getParameter("roll");
int roll=Integer.valueOf(rollno);
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","manager");
PreparedStatement ps = con.prepareStatement("select * from students where rno=?");
ps.setInt(1,roll);
out.print("<table width=50% border=1>");
out.print("<caption>Student Info:</caption>");
ResultSet rs = ps.executeQuery();
/* Printing column names */
ResultSetMetaData rsmd = rs.getMetaData();
int total = rsmd.getColumnCount();
out.print("<tr>");
for(inti=1;i<=total;i++)
{
out.print("<th>"+rsmd.getColumnName(i)+"</th>");
}
out.print("</tr>");
/* Printing result */
while(rs.next())
{
out.print("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getInt(4)+"</td><td>"+rs.getString(5)+"</td></tr>");
}
out.print("</table>");
}catch (Exception e2) {e2.printStackTrace();}
finally{out.close();}
} }
Select.java
import java.io.*;
import java.sql.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class Select extends HttpServlet
{
public void service(HttpServletRequestreq,HttpServletResponse res)throws IOException,ServletException
{
PrintWriter pw=res.getWriter();
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","manager");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from students");
pw.println("<html><body><table border=1>");
pw.println("<tr><td>Rno</td><td>Sname</td><td>Branch</td><td>Percentage</td><td>Address</td>");
while(rs.next())
{
pw.println("<tr><td>");
pw.println(rs.getString("rno")+"</td><td>");
pw.println(rs.getString("sname")+"</td><td>");
pw.println(rs.getString("branch")+"</td><td>");
pw.println(rs.getInt("per")+"</td><td>");
pw.println(rs.getString("addr")+"</td></tr>");
pw.println("</body>");
}
}
catch(Exception e)
{
pw.println(e);
}
}
}
Update.java
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Update extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriterpw = response.getWriter();
String rollno=request.getParameter("roll");
Statement stmt = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","manager");
stmt = con.createStatement();
String sql = "update table students set addr=? whererno=?";
//count will give you how many records got updated
//String sql = "update people set firstname=? ,lastname=? where id=?";
PreparedStatementpreparedStatement = null;
preparedStatement = con.prepareStatement(sql);
preparedStatement.setString(5, "nrt");
preparedStatement.addBatch();
int[] affectedRecords = preparedStatement.executeBatch();
}
catch (Exception e2) {e2.printStackTrace();}
finally{pw.close();}
} }
Web.xml
<web-app>
<servlet>
<servlet-name>register</servlet-name>
<servlet-class>insert</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>register</servlet-name>
<url-pattern>/reg</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>retrieve</servlet-name>
<servlet-class>Select</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>retrieve</servlet-name>
<url-pattern>/Select</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>Check</servlet-name>
<servlet-class>Search</servlet-class>
</servlet>
<servlet>
<servlet-name>remove</servlet-name>
<servlet-class>Delete</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>remove</servlet-name>
<url-pattern>/del</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>modify</servlet-name>
<servlet-class>Update</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>modify</servlet-name>
<url-pattern>/upd</url-pattern>
</servlet-mapping>
</web-app>
Delete.html
<html>
<body>
<form action="./del">
Enter your Rollno:<input type="text" name="roll"/><br/>
<input type="submit" value="Delete"/>
</form>
</body>
</html>
Register.html
<html>
<body bgcolor=lightblue>
<div align="center">
<table cellspacing=10 >
<form method="POST" action="./reg">
<tr>
<td>RollNo</td>
<td><input type="text" name="rn"><br></td>
</tr>
<tr>
<td>User name</td>
<td><input type="text" name="un"><br></td>
</tr>
<tr>
<td>Branch</td>
<td><input type="password" name="br"></td>
</tr>
<tr>
<td>Percentage</td>
<td><input type="text" name="pr"></td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="ad"></td>
</tr>
<tr>
<td>Submit the data:</td>
<td><input type="submit" value="SUBMIT" >
<input type="reset" value="RESET"></td>
</tr>
</form>
</table>
</div>
</body>
</html>
Search.html
<html>
<body>
<form action="./Srch">
Enter your Rollno:<input type="text" name="roll"/><br/>
<input type="submit" value="Search"/>
</form>
</body>
</html>
Update.html
<html>
<body>
<form action="./upd">
Enter your Rollno:<input type="text" name="roll"/><br/>
Address:<input type="text" name="ad"/><br/>
<input type="submit" value="Update"/>
</form>
</body>
</html>
