Insert, update , delete inside a single function... with jsp & access....

//JDBC program with jsp ( makes easy to data manipulation )
//Insert, update , delete inside a single function... with jsp & access....

<html>
<body>
<form method=post>
<table>
    <tr>
        <td>Enter Roll No:
        <td><input type=text name=no>
    </tr>
    <tr>
        <td>Enter Name:
        <td><input type=text name=name>
    </tr>
    <tr>
        <td>Enter City:
        <td><input name=city>
    </tr>
    <tr>
        <td colspan=2><input type=submit name="Insert" value="Insert">
        <input type=submit name="Delete" value="Delete">
        <input type=submit name="Update" value="Update">
        <input type=submit name="Display" value="Display">
    </tr>
</table>
<br><br>
<table border=1 style="cellpedding:6px">
<tr>
    <th>Roll
    <th>Name
    <th>City
//package to use sql classes
<%@page import="java.sql.*"%>
<%!
Connection con;
PreparedStatement ps;
//to establish the connection
public void connect()
{
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:MyDb");
    }
    catch(Exception e){
        System.out.println(e);
    }
}
//single method to insert, update, delete
public void putData(String query)
{
    try{
    ps=con.prepareStatement(query);
    ps.executeUpdate();
    con.close();
    }
    catch(Exception e)
    {
        System.out.println(e);
    }
}
%>
<%
//calling the functions
if(request.getParameter("no")!=null && request.getParameter("name")!=null && request.getParameter("city")!=null)
{
    String roll=request.getParameter("no");
    String name=request.getParameter("name");
    String city=request.getParameter("city");
    connect();
    if(request.getParameter("Insert")!=null)
    {
        putData("insert into Stud values('"+roll+"','"+name+"','"+city+"')");
    }
    if(request.getParameter("Update")!=null)
    {
        putData("update Stud set name='"+name+"',city='"+city+"' where roll='"+roll+"'");
    }
    if(request.getParameter("Delete")!=null)
    {
        putData("delete from Stud where roll='"+roll+"'");
    }

}        ResultSet rs;
        try{
        ps=con.prepareStatement("select * from Stud");
        rs=ps.executeQuery();
        while(rs.next())
        {
        %>
          <tr>
            <td><%=rs.getString(1)%>
            <td><%=rs.getString(2)%>
            <td><%=rs.getString(3)%>
          </tr>
        <%}
        con.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
%>
</tr>
</table>
</form>
</body>
</html>﻿
A smart Developer

Insert, update , delete inside a single function... with jsp & access....

Share this
