QuestionAsk Questions?
View Answers
January 12, 2009 at 1:47 AM
Hi friend,
I am sending adding, deleting and updating code. Please implement following code.
<html>
<title>User information</title>
<head>
<script type="text/javascript">
function validateForm(theForm){
if(theForm.name.value==""){
//Please enter username
alert("Please enter User Name.");
theForm.name.focus();
return false;
}
if(theForm.lsname.value==""){
//please enter passward
alert("Please enter Last Name.");
theForm.lsname.focus();
return false;
}
return true;
}
</script>
</head>
<body >
<br><br><br>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" width="400px" height="69" bgcolor="pink">
<tr>
<td width="859" height="69">
<form method="GET" action="Insertdata" onsubmit="return validateForm(this);">
<h1 align="center"> User Information Form</h1>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" width="400px">
<tr>
<td width="50%"><b>First Name:</b></td>
<td width="50%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="50%"><b>Last Name:</b></td>
<td width="50%"><input type="text" name="lsname" size="30">
</td>
</tr>
</table>
</div>
<p align="center"><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
<a href="ShowDataAction"><b>Click for show data</b></a>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
I am sending adding, deleting and updating code. Please implement following code.
<html>
<title>User information</title>
<head>
<script type="text/javascript">
function validateForm(theForm){
if(theForm.name.value==""){
//Please enter username
alert("Please enter User Name.");
theForm.name.focus();
return false;
}
if(theForm.lsname.value==""){
//please enter passward
alert("Please enter Last Name.");
theForm.lsname.focus();
return false;
}
return true;
}
</script>
</head>
<body >
<br><br><br>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" width="400px" height="69" bgcolor="pink">
<tr>
<td width="859" height="69">
<form method="GET" action="Insertdata" onsubmit="return validateForm(this);">
<h1 align="center"> User Information Form</h1>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" width="400px">
<tr>
<td width="50%"><b>First Name:</b></td>
<td width="50%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="50%"><b>Last Name:</b></td>
<td width="50%"><input type="text" name="lsname" size="30">
</td>
</tr>
</table>
</div>
<p align="center"><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
<a href="ShowDataAction"><b>Click for show data</b></a>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
January 12, 2009 at 1:49 AM
ShowDataAction file
package javacode;
import java.io.*;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ShowDataAction extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select id,name,lsname from userinform");
out.println("<html><head><title>show data</title></head>");
out.println("<body>");
out.println("<br><br><br>");
out.println("<center>");
out.println("<h2>Display data from Database<h2>");
out.println("</center>");
out.println("<center>");
out.println("<table border=1 width=400px cellspacing=0 cellpadding=0>");
out.println("<tr>");
out.println("<td><b>Id<b></td>");
out.println("<td><b>Name<b></td>");
out.println("<td><b>Last Name<b></td>");
out.println("<td><b>Delete<b></td>");
out.println("<td><b>Edit<b></td>");
out.println("</tr>");
int sno=0;
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String lsname = rs.getString("lsname");
String action = "DeletedataServlet/"+id;
String action1 = "EditdataServlet/"+id;
out.println("<tr>");
out.println("<td>");
out.println(++sno);
out.println("</td>");
out.println("<td>");
out.println(name);
out.println("</td>");
out.println("<td>");
out.println(lsname);
out.println("</td>");
out.println("<td>");
out.println("<a href="+action+">Delete</a>");
out.println("</td>");
out.print ("<td><a href=Updaterecord.jsp?id="+id+">Edit</a></td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body></html>");
}
catch (Exception e){
out.println(e);
}
}
}
package javacode;
import java.io.*;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ShowDataAction extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select id,name,lsname from userinform");
out.println("<html><head><title>show data</title></head>");
out.println("<body>");
out.println("<br><br><br>");
out.println("<center>");
out.println("<h2>Display data from Database<h2>");
out.println("</center>");
out.println("<center>");
out.println("<table border=1 width=400px cellspacing=0 cellpadding=0>");
out.println("<tr>");
out.println("<td><b>Id<b></td>");
out.println("<td><b>Name<b></td>");
out.println("<td><b>Last Name<b></td>");
out.println("<td><b>Delete<b></td>");
out.println("<td><b>Edit<b></td>");
out.println("</tr>");
int sno=0;
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String lsname = rs.getString("lsname");
String action = "DeletedataServlet/"+id;
String action1 = "EditdataServlet/"+id;
out.println("<tr>");
out.println("<td>");
out.println(++sno);
out.println("</td>");
out.println("<td>");
out.println(name);
out.println("</td>");
out.println("<td>");
out.println(lsname);
out.println("</td>");
out.println("<td>");
out.println("<a href="+action+">Delete</a>");
out.println("</td>");
out.print ("<td><a href=Updaterecord.jsp?id="+id+">Edit</a></td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body></html>");
}
catch (Exception e){
out.println(e);
}
}
}
January 12, 2009 at 1:50 AM
Delete action file:
package javacode;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class DeletedataServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
//String id=request.getParameter("id");
System.out.println( "uri : "+ request.getRequestURI());
String strurl = request.getRequestURI().toString();
int strIndex = strurl.lastIndexOf("/");
String strId = strurl.substring(strIndex+1);
int id = Integer.parseInt(strId);
System.out.println("strId" + strId);
System.out.println("id:"+id);
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery ="delete from userinform where id="+id;
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}
package javacode;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class DeletedataServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
//String id=request.getParameter("id");
System.out.println( "uri : "+ request.getRequestURI());
String strurl = request.getRequestURI().toString();
int strIndex = strurl.lastIndexOf("/");
String strId = strurl.substring(strIndex+1);
int id = Integer.parseInt(strId);
System.out.println("strId" + strId);
System.out.println("id:"+id);
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery ="delete from userinform where id="+id;
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}
January 12, 2009 at 1:52 AM
edit action file:
package javacode;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.ServletException;
public class EditdataServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println( "uri : "+ request.getRequestURI());
int id = Integer.parseInt(request.getParameter("id"));
System.out.println("id:"+id);
String name = request.getParameter("name");
String lsname = request.getParameter("lsname");
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery ="update userinform set name='"+name+"',lsname='"+lsname+"' where id="+id;
System.out.println("sqlQuery "+ sqlQuery);
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}
------------------------------------
Visit for more information:
http://www.roseindia.net/servlets/
Thanks.
package javacode;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.ServletException;
public class EditdataServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println( "uri : "+ request.getRequestURI());
int id = Integer.parseInt(request.getParameter("id"));
System.out.println("id:"+id);
String name = request.getParameter("name");
String lsname = request.getParameter("lsname");
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery ="update userinform set name='"+name+"',lsname='"+lsname+"' where id="+id;
System.out.println("sqlQuery "+ sqlQuery);
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}
------------------------------------
Visit for more information:
http://www.roseindia.net/servlets/
Thanks.
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
