Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

Java Servlet :Updating data in database table
Previous Home Next

This program shows you how to update the name in the database table by using the JDBC and the servlet.

index.html:-


<html>
<head>
<title>Update Row Data</title>
</head>
<body>
<form action="update">
Old Name<input type="text" name="name"><br>
Name<input type="text" name="txtName"><br>
Password<input type="password" name="pass"><br>
<input type="submit" value="submit">
</form>
</body>
</html>

 

web.xml:-

class  
{
	public static void main(String[] args) 
	{
		System.out.println("Hello World!");
	}
}
a
<web-app>
<servlet>
<servlet-name>s1</servlet-name>
<servlet-class>Update</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>s1</servlet-name>
<url-pattern>update</url-pattern>
</servlet-mapping>
</web-app>

Update.java:-



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

public class Update extends HttpServlet
{

public void doGet(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
{
	String name=request.getParameter("name");
String name1=request.getParameter("txtName");
String password=request.getParameter("pass");
response.setContentType("text/html");
PrintWriter out=response.getWriter();

try
{
	Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
	("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
PreparedStatement stmt=con.prepareStatement
	("update emp set name=?,pass=? where name=?");
stmt.setString(1, name1);
stmt.setString(2, password);
stmt.setString(3, name);

stmt.executeUpdate();
if(true)
out.println("<b>You are successfully update</b>");
con.close();
}
catch(Exception e)
{
out.println("<b> failed</b>");
out.println("<b>Error:</b>" +e);
}
}
}
Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: