Online Software Educational Training - IT Tutorials - Online Education Training for Computer Software

Home

JAVA JDBC

Modifying Records

Here is a sample code to modify the records

import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class modification extends HttpServlet
{
Connection con;
String name;
String dsn;
String strsql;
Statement stmt;
ResultSet rs;
boolean fnd;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
dsn = "Jdbc:Odbc:dsninfo";
name = request.getParameter("txtname");
response.setContentType("text/html");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException cfe) {}
try{
PrintWriter pw=response.getWriter();
con=DriverManager.getConnection(dsn);
stmt = con.createStatement();
strsql="select *from userinfo where name='" + name + "'";
rs=stmt.executeQuery(strsql);
while(rs.next())
{
pw.println("<html> <body bgcolor=gray>");
pw.println("<h2> Update Your Data </h2>");
pw.println("<form name=sv method=post action=http://localhost:8080/servlet/update>");
pw.println("<pre>");
pw.println("Name    <input type=text name=txtname value = " + rs.getString("name") + " onFocus=\"this.blur();\">");
pw.println("<br>");
pw.println("Age     <input type=text name=txtage value = " + rs.getInt("age") + ">");
pw.println("<br>");
pw.println("Email   <input type=text name=txtemail value = " + rs.getString("email") + ">");
pw.println("<br>");
pw.println("        <input type=submit name=btnupd value=\"Update\">");
pw.println("<br>");
pw.println("</form>");
pw.println("</pre>");
pw.println("</body></html>");
}
stmt.close();
pw.close();
con.close();
}catch (SQLException se )
{
System.out.println("file not found");
}
}
}

import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class update extends HttpServlet
{
Connection con;
String name,email;
int age;
String dsn;
String strsql;
Statement stmt;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
PrintWriter pw = response.getWriter();
dsn = "Jdbc:Odbc:dsninfo";
name = request.getParameter("txtname");
age = Integer.parseInt(request.getParameter("txtage"));
email=request.getParameter("txtemail");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException cfe) {}
try{
con=DriverManager.getConnection(dsn);
stmt = con.createStatement();
strsql = "update userinfo set age = " + age + "  where name = '" + name +"'";
stmt.executeUpdate(strsql);
strsql = "update userinfo set email = '" + email + "' where name = '" + name +"'";
stmt.executeUpdate(strsql);
pw.println("Succesfully Updated");
stmt.close();
pw.close();
con.close();
}catch (SQLException se)
{
System.out.println(se);
}
}
}


Previous		Next