update and delete record using JSP

Home Answers Viewqa JSP-Servlet update and delete record using JSP

QuestionAsk Questions?

Anamika Sharma

update and delete record using JSP
3 Answer(s) a year and 2 months ago
Posted in : JSP-Servlet

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){}
%>

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 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

delete
delete how delete only one row in the database using jsp.database.../jsp/deleteuser.jsp?id='+id,'mywindow','width=500, height=350,toolbar... type="button" name="edit" value="Delete" style="background-color:red;font-weight

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

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

JSP Delete Record From Table Using MySQL
JSP Delete Record From Table Using MySQL This tutorial explains you that how to write a JSP for deleting a record from database table. In this section you.... In this tutorial you will learn that how to delete a record of a database table in JSP

JDBC: Delete Record using Prepared Statement
JDBC: Delete Record using Prepared Statement In this section, we will discuss how to delete row of a table using Prepared Statements. Delete Record ... statement. You can delete any specific record under some condition using WHERE

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

update
update how can i update multiple records in database using jsp ,servlet and jdbc based on selection of checkbox in jsp

Using insert update and delete in the same servlet
Using insert update and delete in the same servlet How to write insert, update and delete coding in the same servlet

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

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

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>

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

Edit the record.
Edit the record. sir, I have a table consist of huge data.I have... to previous edited row or edit the previous record of the previously edited... are sending you a jsp edit application. It will be helpful for you. 1

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

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

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

textfields and update - SQL
to the textfields using jdbc?and at the same time update the items...; Hi friend, Code to update record retieve at the Same time: Some points to be remmeber: 1.Create a "process.jsp" file to update and retrieve 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

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

Implement JavaScript with JSP
; In this section we are going to implement insert data, delete data, and update data using with JDBC database and also using of JavaScript. Step 1: Create... Implement JavaScript with JSP

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

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

JDBC: Update Records Example
records of the table using JDBC API. Update Records : Update record is most... then you will not delete that record and reinsert after correction so for such situation you can use update statement to update particular value of record

delete and edit options in struts
delete and edit options in struts Hi, I am doing an web application using struts, jsp, tomcat server, oracle as a database in netbeans IDE 7.1.2, I... errors but the edit and delete operations were not working, so please modify my

Update / Edit data
field that i have prepared under the submit button. btw, im using jsp. thank you...Update / Edit data Hello, i want to create a page to edit or update... record, all the field will be filled with data from the database base

DELETE
DELETE I AM DOING IT IN MYSQL. DELETE FROM EMP WHERE SAL>(SELECT SAL FROM EMP WHERE ENAME='MILLAR') AND ENAME='ALLEN'; THIS IS GIVING...' for update in FROM clause ANY ONE PLEASE HELP ME. WITH REGARDS

Delete all rows using DBCP

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- delete from employee where id='35'; Thanks

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

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

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

simple web appllication to insert, update or display from database - JSP-Servlet
in which we can insert, update or delete data from database. i can also display...simple web appllication to insert, update or display from database hello sir i am using netbeans 5.5 ide with tomcat and oracle 9 i as database

how to create using jsp
;br/> <input type="submit" value="Delete record"/></center>...;%=request.getContextPath()%>/jsp/Delete.jsp">Delete </a></p> <...how to create using jsp code 1: <%@ page language="java

delete row
delete row how to delete row using checkbox and button in php...="delete" > <table width="100%" border="1"> <tr><td>...;/table> <input type="submit" name="delete" value="delete" /> <?php

Update statement
database is not update I write this program using 3 differfnt notepad pages MY...(new CarHandeler()); south.add(update); del=new JButton("Delete...Update statement I create a access database my program When I click

data update
the data and edit it based on subjectcode(varchar)this should be done using jsp...://www.roseindia.net/jsp/crud-application.shtml Here, you will see that how you can edit/update data and saved them into that table again

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

Latest
Frameworks
Category