Search This Blog

Tuesday, 18 September 2012

Practical 28) Develop a program to perform the database driven operation like insert, Delete, Update and select. To perform the above operations create one table named Employee. Field Name Field Type EmpId Integer Empname Varchar Emp_desig Varchar Emp_J_Date Varchar Emp_Salary Numeric


Filename-input.jsp

<html>
<title>
Enter data
</title>
<body>
          <form action="http://localhost:8090/wtad/def28/conn.jsp" align="center">
                   <h2>Select Which Query u want to FIER.</h2>
                   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-conn.jsp

<html>

<title>
Jsp Conn Example
</title>

<body>
<%! String sel; %>

<%
          sel=request.getParameter("select");
%>

<% out.println("<b>"+"Enter Data for "+sel+"<br>"); %>

<%
          if(sel.equals("select"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def28/select.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
                  
                            
          }
          else if(sel.equals("insert"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def28/insert.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             Name:
                             <input type="text"  name="name"/>
                             <br>
                             desg:
                             <input type="text"  name="desg"/>
                             <br>
                             Join_date:
                             <input type="text" name="jdate"/>
                             <br>
                             Salary:
                             <input type="text" name="sal"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
          }
          else if(sel.equals("update"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def28/update.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             Name:
                             <input type="text"  name="name"/>
                             <br>
                             desg:
                             <input type="text"  name="desg"/>
                             <br>
                             Join_date:
                             <input type="text" name="jdate"/>
                             <br>
                             Salary:
                             <input type="text" name="sal"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
          }
          else if(sel.equals("delete"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def28/delete.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
          }
%>
</body>
</html>

Filename-select.jsp

<html>
<title>
Selecting data
</title>
<body>
          <%@ page import="java.sql.*" %>
          <%@ page import="java.io.*" %>
                  
          <%
         
                   int id=Integer.parseInt(request.getParameter("id"));
                   try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
                             PreparedStatement ps=conn.prepareStatement("select id,name,desg,jdate,sal from employee where id="+id+"");
                             ResultSet rs=ps.executeQuery();

                             while(rs.next())
                             {
                                      out.println("Id:"+" "+rs.getInt(1)+"<br>");
                                      out.println("Name:"+" "+rs.getString(2)+"<br>");
                                      out.println("Designation:"+" "+rs.getString(3)+"<br>");
                                      out.println("Date:"+" "+rs.getDate(4)+"<br>");
                                      out.println("Salary:"+" "+rs.getInt(5)+"<br>");
                             }
                   }
                   catch(Exception e)
                   {
                             out.println(e);
                   }
          %>
         
</body>
</html>
Filename-insert.jsp


<%
          int id=Integer.parseInt(request.getParameter("id"));
          String name=request.getParameter("name");
          String desg=request.getParameter("desg");
          String sdt=request.getParameter("jdate");
          int sal=Integer.parseInt(request.getParameter("sal"));

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

                             out.println("Your Record is inserted"+"<br>");                            
          }
          catch(Exception e)
          {
                   out.println(e);
          }

Filename-update.jsp

<%
          int id=Integer.parseInt(request.getParameter("id"));
          String name=request.getParameter("name");
          String desg=request.getParameter("desg");
          String sdt=request.getParameter("jdate");
          int sal=Integer.parseInt(request.getParameter("sal"));

          try
          {
                   Class.forName("oracle.jdbc.OracleDriver");
                   Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
                   PreparedStatement ps=conn.prepareStatement("update employee set name='"+name+"',desg='"+desg+"',jdate='"+sdt+"',sal="+sal+" where id="+id+"");
                   ResultSet rs=ps.executeQuery();

                             out.println("Your Record is Update"+"<br>");
          }
          catch(Exception e)
          {
                   out.println(e);
          }

%>

Filename-delete.jsp
<%
          int id=Integer.parseInt(request.getParameter("id"));
         
          try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
                             PreparedStatement ps=conn.prepareStatement("delete employee where id="+id+"");
                             ResultSet rs=ps.executeQuery();

                             out.println("Record is delete id="+id+"<br><br>");
   
%>

Output

Select Which Query u want to FIRE.

Select  
Insert  
Update  
Delete  

Enter Data for select
Top of Form
ID: 
Id: 101
Name: krunal
Designation: manager
Date: 1989-07-30
Salary: 100000

Posted by at No comments:
Labels: , , ,

Sunday, 16 September 2012

Practical 31) Write a JSP page which uses tags availabe from the standard tag library JSTL.


Filename-jstlexam1.jsp

<html>
<title>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<c:out value="<c:out>example"/>
</title>
<body>
         
          <c:out value="Example"> </c:out>
          <c:out value="abc"/>
          <%
                   for(int i=0;i<10;i++)
                   {
                             out.println(i+"<br>");
                   }
          %>
         
          <hr color="green"/>
          <c:forEach var="i" begin="0" end="20">
          ${i}
          </c:forEach>
         
</body>
</html>
Posted by at No comments:
Labels: ,

Practical 34) Develop a JSP Page to perform database driven operations like insert, Delete, Update and selection with table named Student having fields like StudId, Name, Address, result.


Filename-Input.jsp

<html>
<form action="http://localhost:8090/wtad/def34/conn.jsp">
<h3>JSP Pages</h3>
<h2>
Select Which Query u want to FIER.
</h2>
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>
</html>

Filename-conn.jsp

<html>

<title>
Jsp Conn Example
</title>

<body>
<%! String sel; %>
<%
          sel=request.getParameter("select");
%>

<% out.println("<b>"+"Enter Data for "+sel+"<br>"); %>

<%
          if(sel.equals("select"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def34/select.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
                  
                            
          }
          else if(sel.equals("insert"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def34/insert.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             Name:
                             <input type="text"  name="name"/>
                             <br>
                             ddress:
                             <input type="text"  name="add"/>
                             <br>
                             Result:
                             <input type="text"  name="result"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
          }
          else if(sel.equals("update"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def34/update.jsp"/>
                             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>
                   <%
          }
          else if(sel.equals("delete"))
          {
                   %>
                   <form action="http://localhost:8090/wtad/def34/delete.jsp"/>
                             ID:
                             <input type="text" name="id"/>
                             <br>
                             <input type="submit"/>
                   </form>
                   <%
          }
%>
</body>
</html>

Filename-select.jsp

           <%
         
                   int id=Integer.parseInt(request.getParameter("id"));
                   try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@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
<%
          int id=Integer.parseInt(request.getParameter("id"));
          String name=request.getParameter("name");
          String add=request.getParameter("add");
          String result=request.getParameter("result");
         
          try
          {
                   Class.forName("oracle.jdbc.OracleDriver");
                   Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@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

 <%
          int id=Integer.parseInt(request.getParameter("id"));
          String name=request.getParameter("name");
          String add=request.getParameter("add");
          String result=request.getParameter("result");
         
          try
          {
                   Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@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

<%
          int id=Integer.parseInt(request.getParameter("id"));
         
          try
                   {
                             Class.forName("oracle.jdbc.OracleDriver");
                             Connection conn=DriverManager.getConnection("jdbc:oracle:thin:system/password@localhost:1521:XE");
                             PreparedStatement ps=conn.prepareStatement("delete student where stdid="+id+"");
                             ResultSet rs=ps.executeQuery();

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

                             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

JSP Pages

Select Which Query u want to FIER.

Select  
Insert  
Update  
Delete  


Enter Data for select
Top of Form
ID: 
Bottom of Form


Id: 1001
Name: ccd
Address: bbb
Result: pass
Posted by at 1 comment:
Labels: , , ,
Subscribe to: Posts (Atom)