Search This Blog

Sunday, 16 September 2012

Practical 29) Develop a Java application to perform the database driven operation like insert, Delete, Update and selection using PreparedStatement. To perform the above operations use the table from above exercise.


Filename-Input.jsp

<html>
<title>
Connection Example
 </title>
<body>
<h3>
Select the Query which u want to fier.
</h3>
<form action="http://localhost:8090/wtad/Send">
select
<input type="radio" name="select" value="select"/>
<br>
insert
<input type="radio" name="select" value="insert"/>
<br>
update
<input type="radio" name="select" value="update"/>
<br>
delete
<input type="radio" name="select" value="delete"/>
<br>
<input type="submit" />
</form>
</body>
</html>

Filename-Send.java

package def29;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Send extends HttpServlet
{
          public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException
          {
                   res.setContentType("text/html");
                   PrintWriter out=res.getWriter();

                   String select=req.getParameter("select");
                   out.println("usr page select for this operation="+select);

                   if(select.equals("select"))
                   {
                             res.sendRedirect("http://localhost:8090/wtad/def29/select.jsp");
                   }
                   else if(select.equals("insert"))
                    {
                                                res.sendRedirect("http://localhost:8090/wtad/def29/insert.jsp");
                   }
                   else if(select.equals("update"))
                   {
                                                res.sendRedirect("http://localhost:8090/wtad/def29/update.jsp");
                   }
                   else
                   {
                                                res.sendRedirect("http://localhost:8090/wtad/def29/delete.jsp");
                   }
          }
}


Filaname-select.jsp

<html>
<body>
<form action="http://localhost:8090/wtad/Select">
Enter Student Id
<input type="text" name="id"/>
<br>
<input type="submit" />
</form>
</body>
</html>

Filename-Select.java

package def29;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Select 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 stdid,name,address,result from student where stdid="+id+"");
                             ResultSet rs=ps.executeQuery();

                             while(rs.next())
                             {
                                      out.println("Id:"+" "+rs.getInt(1)+"<br>");
                                      out.println("Name:"+" "+rs.getString(2)+"<br>");
                                      out.println("Address:"+" "+rs.getString(3)+"<br>");
                                      out.println("Result:"+" "+rs.getString(1)+"<br>");
                             }
                   }
                   catch(Exception e)
                   {
                             out.println(e);
                   }

          }
}


Filename-insert.jsp

<html>
<body>
<form action="http://localhost:8090/wtad/Insert">
<h2>
Enter data to insert
</h2>
<br>
Id
<input type="text" name="id" />
<br>
Name
<input type="text" name="name"/>
<br>
Address
<input type="text" name="add"/>
<br>
Result
<input type="text" name="result"/>
<br>
<input type="submit"/>
</form>
</body>
</html>

Filename-Insert.java

package def29;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Insert 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"));
                   String name=req.getParameter("name");
                   String add=req.getParameter("add");
                   String result=req.getParameter("result");

                   try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/powerise@localhost:1521:XE");
                             PreparedStatement ps=conn.prepareStatement("insert into student values("+id+",'"+name+"','"+add+"','"+result+"')");
                             ResultSet rs=ps.executeQuery();

                             out.println("Your Record is inserted"+"<br>");

                             PreparedStatement ps1=conn.prepareStatement("select stdid,name,address,result from student where stdid="+id+"");
                             ResultSet rs1=ps1.executeQuery();

                             while(rs1.next())
                             {
                                      out.println("Id:"+" "+rs1.getInt(1)+"<br>");
                                      out.println("Name:"+" "+rs1.getString(2)+"<br>");
                                      out.println("Address:"+" "+rs1.getString(3)+"<br>");
                                      out.println("Result:"+" "+rs1.getString(4)+"<br>");
                             }
                   }
                   catch(Exception e)
                   {
                             out.println(e);
                   }

          }
}

Filename-update.jsp

<html>
<body>
Update operation
<form action="http://localhost:8090/wtad/Update">
Enter data to update
<br>
Id
<input type="text" name="id"/>
<br>
Name
<input type="text" name="name"/>
<br>
Address
<input type="text" name="add"/>
<br>
Result
<input type="text" name="result"/>
<br>
<input type="submit" />
</form>
</body>
</html>

Filename-Update.java

package def29;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Update 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"));
                   String name=req.getParameter("name");
                   String add=req.getParameter("add");
                   String result=req.getParameter("result");

                   try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/powerise@localhost:1521:XE");
                             PreparedStatement ps=conn.prepareStatement("update student set name='"+name+"',address='"+add+"',result='"+result+"' where stdid="+id+"");



                             ResultSet rs=ps.executeQuery();

                             out.println("Your Record is Updated"+"<br>");

                             PreparedStatement ps1=conn.prepareStatement("select stdid,name,address,result from student where stdid="+id+"");
                             ResultSet rs1=ps1.executeQuery();

                             while(rs1.next())
                             {
                                      out.println("<br>");
                                      out.println("<br>"+"Id:"+" "+rs1.getInt(1)+"<br>");
                                      out.println("Name:"+" "+rs1.getString(2)+"<br>");
                                      out.println("Address:"+" "+rs1.getString(3)+"<br>");
                                      out.println("Result:"+" "+rs1.getString(4)+"<br>");
                                      out.println("<br>"+"<br>");
                             }
                   }
                   catch(Exception e)
                   {
                             out.println(e);
                   }

          }
}

Filename-delete.jsp

<html>
<body>
<form action="http://localhost:8090/wtad/Delete">
Enter Id for Delete
<br>
Id
<input type="text" name="id"/>
<br>
<input type="submit"/>
</form>
</body>
</html>

Filename-Delete.java

package def29;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Delete 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("delete student where stdid="+id+"");
                             ResultSet rs=ps.executeQuery();

                             out.println("Record is delete id="+id);

                             PreparedStatement ps1=conn.prepareStatement("select * from student");
                             ResultSet rs1=ps1.executeQuery();

                             while(rs1.next())
                             {
                                      out.println("Id:"+" "+rs1.getInt(1)+"<br>");
                                      out.println("Name:"+" "+rs1.getString(2)+"<br>");
                                      out.println("Address:"+" "+rs1.getString(3)+"<br>");
                                      out.println("Result:"+" "+rs1.getString(4)+"<br>");
                             }
                   }
                   catch(Exception e)
                   {
                             out.println(e);
                   }


          }
}

Output

Select the Query which u want to fier.

select  
insert  
update  
delete  
------------------------------------------------------------------------------------------------


Enter Student Id  

Id: 1001
Name: ccd
Address: bbb
Result: 1001
Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)