update and delete record using JSP

how to update and delete record using JSP and Servlets?

View Answers

April 23, 2012 at 12:03 PM

Please visit the following link:

http://www.roseindia.net/servlets/web-application.shtml

April 23, 2012 at 12:04 PM

JSP Insert and Delete in single page

1)application.jsp:

<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">
function editRecord(id){
    var f=document.form;
    f.method="post";
    f.action='edit.jsp?id='+id;
    f.submit();
}
function deleteRecord(id){
    var f=document.form;
    f.method="post";
    f.action='delete.jsp?id='+id;
    f.submit();
}
</script>
</head>
<body>

<br><br>
<form method="post" name="form">
<table border="1">
<tr><th>Name</th><th>Address</th><th>Contact No</th><th>Email</th></tr>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";

int sumcount=0;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from employee";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>

<%
while(rs.next()){
%>
<tr><td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><input type="button" name="edit" value="Edit" style="background-color:#49743D;font-weight:bold;color:#ffffff;" onclick="editRecord(<%=rs.getString(1)%>);" ></td>
<td><input type="button" name="delete" value="Delete" style="background-color:#ff0000;font-weight:bold;color:#ffffff;" onclick="deleteRecord(<%=rs.getString(1)%>);" ></td>
</tr>
<%
}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

2)edit.jsp:

<%@page language="java"%>
<%@page import="java.sql.*"%>
<form method="post" action="update.jsp">
<table border="1">
<tr><th>Name</th><th>Address</th><th>Contact No</th><th>Email</th></tr>
<%
String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
String query = "select * from employee where id='"+no+"'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>
<tr>
<td><input type="text" name="name" value="<%=rs.getString("name")%>"></td>
<td><input type="text" name="address" value="<%=rs.getString("address")%>"></td>
<td><input type="text" name="contact" value="<%=rs.getInt("contactNo")%>"></td>
<td><input type="text" name="email" value="<%=rs.getString("email")%>"></td>
<td><input type="hidden" name="id" value="<%=rs.getString(1)%>"></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Update" style="background-color:#49743D;font-weight:bold;color:#ffffff;"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>
</form>
</form>

April 23, 2012 at 12:05 PM

continue..

3)update.jsp:

<%@page import="java.sql.*"%>

<%
String ide=request.getParameter("id");
int num=Integer.parseInt(ide);
String name=request.getParameter("name");
String address=request.getParameter("address");
int contact=Integer.parseInt(request.getParameter("contact"));
String email=request.getParameter("email");
try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
Statement st=null;
st=conn.createStatement();
st.executeUpdate("update employee set name='"+name+"',address='"+address+"',contactNo="+contact+",email='"+email+"' where id='"+num+"'");
response.sendRedirect("/examples/jsp/application.jsp");
}
catch(Exception e){
System.out.println(e);
    }
%>

4)delete.jsp:

<%@page import="java.sql.*"%>
<%

String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st = conn.createStatement();
st.executeUpdate("DELETE FROM employee WHERE id = '"+no+"'");
response.sendRedirect("application.jsp");
}
catch(Exception e){}
%>

Advertisements

update excel sheet using jsp::
update excel sheet using jsp:: Hi Sir,... I have a excel... given excel sheet and display it into another excel sheet using jsp" i am using 'session' to get the empid from one page to another jsp

delete record
delete record how to delete record using checkbox and button in php We are providing you the jsp code that displays the database table...=conn.createStatement(); for(int a=0;a<10;a++){ st.executeUpdate("delete from book where

Update Record using Prepared Statement
JDBC: Update Record using Prepared Statement In this section, you...) { System.out.println("Update Record using PreparedStatement..."); Connection...) { e.printStackTrace(); } } } Output : Update Record using

JDBC: Delete Record using Prepared Statement
JDBC: Delete Record using Prepared Statement In this section, we will discuss... statement. You can delete any specific record under some condition using WHERE...) { System.out.println("Delete Record using PreparedStatement..."); Connection con = null

Update Database Table using JDBC in JSP
Update Database Table using JDBC in JSP This example shows how to update the existing record of mysql table using jdbc connectivity in the jsp page

using insert and delete in a single page in jsp
using insert and delete in a single page in jsp I am using the following code in jsp to declare two javascript functions to insert and delete in a single jsp page but insert function doesn't works only delete function works even

Delete and edit data in xml file using JSP
Delete and edit data in xml file using JSP I want to know how to delete and edit data from an XML file by use of JSP. I have XML file having tasks... in the xml file,I want to delete and edit some tasks using task id then how can i do

fetch record from oracle database using jsp-servlet?
fetch record from oracle database using jsp-servlet? how can i fetch data from oracle database by using jsp-servlet. i'm using eclipse, tomcat server and oracle database and creating jsp pages and also using servlet

How to make a CRUD without using SQL Server? by just using your GUI? (CRUD = Creating, Register, Update, Delete)
How to make a CRUD without using SQL Server? by just using your GUI? (CRUD = Creating, Register, Update, Delete) well I got a Program that can Register Update and delete a account to SQL Server. from now on we have to make

How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail form

Read Excel data using JSP and update MySQL databse
Read Excel data using JSP and update MySQL databse HOw to read excel data using JSP and update MySQl database

Read data from excel file and update database using jsp
Read data from excel file and update database using jsp read data from excel file and update database using jsp Hi, I am using a MySQL database... upload excel file and update database using JSP ? Thanks in Advance

create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?
create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper? I have a project ie create an application for users to create,edit and delete tasks: taskid, taskname, date, project in JSP and struts

Update after delete
..... and i am deleting 3 record using id column of database mysql so now id will be 1,2,4,..... now i want to reassign id column 1,2,3,.... using ResultSet...Update after delete sir,i am working on online examination project

Problem in record viewing in jsp - JSP-Servlet
Problem in record viewing in jsp hai i have developed the application using jsp,servlets in eclipse ide i have to insert,delete,update and view... it is i cannot view the record after eclipse ide is closed and reopen

create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?
create,edit and delete in JSP using struts and SQL server2005 as database... to create,edit and delete tasks: taskid, taskname, date, project in JSP and struts... example using struts.if anyone knows how to do it..please help me.. thanks a lot

Hibernate Delete Query
In this section we will discuss how to delete record of table using HQL

Jsp code for disabling record.
Jsp code for disabling record. I want a Jsp and servlet code for the mentioned scenario. Q. A cross sign appears in front of each record, click to disable the record.System marks the record as disabled.The record

How to insert or delete records in MS access database using jsp - JSP-Servlet
How to insert or delete records in MS access database using jsp Hi friends please provide me a solution that i insert or delete record from a database using java server pages. I used the microsoft access 2003 database. PlZ

delete jsp
;<br/> <input type="submit" value="Delete record"/></center>...delete jsp <%@ page language="java" contentType="text/html...; charset=ISO-8859-1"> <title>Delete Student</title> </head>

hibernate delete orphan
In this section, you will learn to delete mapped record using cascade delete-orphan in Hibernate

Write a query to delete a record from a table
Write a query to delete a record from a table Write a query to delete a record from a table Hi, The query string for the delete operation is as follows-ADS_TO_REPLACE_1 delete from employee where id='35'; Thanks

delete an entry using JavaScript
delete an entry using JavaScript How to delete an entry using JavaScript

update jsp
update jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC...;/Controller"> <center> <input type="hidden" name="page" value="update"/>

sort a record in jsp - JSP-Servlet
it displays the next 10 pages and so on. Im using jsp and mysql database. thx priya...sort a record in jsp hello, can i get a code that displays 10...: Pagination of JSP page Roll No Name Marks Grade

Record and Save Video using Java
Record and Save Video using Java How to record video(webcam) and save it using Java.?? Its really urgent

Delete All Records
Delete All Records In this section, you will learn how to delete all record using jpa... Student st"), @NamedQuery(name="updateRecord",query="UPDATE Student st SET

How to delete objects using Hibernate?
How to delete objects using Hibernate? Hi, How to delete objects using Hibernate? I want to delete an object (record) in table. Thanks Hi, Hibernate Session API provides function to delete object. For deleting

how to write a program to search a record using mvc2
how to write a program to search a record using mvc2 how can we write a code to search a record in table by using java bean as model, servlet as contoller and jsp as view

Delete Query using HQL
Delete Query using HQL Can we write 'AND' with 'WHERE' clause in delete query using HQL? For example: delete from table name where field1... is "delete from table where field1 = 'value1' and field2 = 'value2'. Have

delete row using id
delete row using id package pkg2; import org.hibernate.Query; import... = "delete from Insurance insurance where id = 2"; Query query = sess.createQuery...()); } } } this is the code m using . Error is -query must begin with SELECT or FROM

How to update record to database? I have trouble with the following code
How to update record to database? I have trouble with the following code I have written the update statement but it still not work to update the record,what is the missing of the following code ?I need help,thankyou <?php

using case in update statement
using case in update statement i want to use case in update clause... syntax is not working for update stmt.my problem is update emp set case deptno... working but for first condition only update emp set deptno=(case when 10 then 20

Add and Delete Element Using Javascript in JSP
Add and Delete Element Using Javascript in JSP... developed an application to add and delete element using javascript . We created two...;TITLE>Add/Delete Person</TITLE> <script> function validate

callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp iam a fresher newbie to softparsing i... for update also thank you

Update delete perticular row from brower on link - Struts
Update delete perticular row from brower on link how can update... patel 34334 mumbai update delete smita kadam 45454 new york update delete when i click on update than that perticular row are display on another

delete multiple row using checkbox
delete multiple row using checkbox how to delete multiple row in a table which is connected to database using checkbox

Update value of database using hibernate.
Update value of database using hibernate. How to update value of database using hibernate? Hibernate provides facility to update the existing record. Here is an example Example- package net.roseindia.main

delete a file - JSP-Servlet
delete a file Correct question::::How can we delete a file which is stored in a server when read write operations for this particular file is closed. http://www.communigate.com/CommuniGatePro/WebFiles.html

problem in record viewing in jsp - JSP-Servlet
the record after eclipse ide is closed and reopen it i have used the jsp...problem in record viewing in jsp hai i send the code can you please... refresh the viewing record link i.e Click here to view all the records link

how to record qvga video using j2me - Applet
how to record qvga video using j2me hello if it is possible how i can record qvga video usin j2me

delete a file - JSP-Servlet
delete a file How can we read a file which is stored in a server when read write operations for this particular file is closed

how to delete a row in sql without using delete command.
how to delete a row in sql without using delete command. how to delete a row in sql without using delete command. thanks in advance

how to fetch the record using AJAX? - Ajax
how to fetch the record using AJAX? Can anyone tell me how to fetch the records from database using Ajax

how to make JTable to add delete and update sql database table
how to make JTable to add delete and update sql database table Hello all I want to know how to make JTable to act actively to add delete and update database table. i am struck ed here from long time please help me

Update Database from jsp
Update Database from jsp I want to update my oracle database... UPDATE button the database field should be updated . I have a drop down menu...= null; st=conn.createStatement(); st.executeUpdate("UPDATE TEST_LINKS SET

how to record qvga video using j2me - Applet
how to record qvga video using j2me hello if it is possible how i can record qvga video usin j2me? Hi Friend, Please visit the following links: http://www.roseindia.net/j2me/video-midlet.shtml http

Ads