i have 2 jsp page(atm.jsp,delete.jsp) in atm.jsp: i have a table containing values, on click on id value, that number should paste/copy in delete.jsp textbox..

hi everyone ..i have 2 jsp page(atm.jsp,delete.jsp) in atm.jsp: i have a table containing values, on click on id value, that number should paste/copy in delete.jsp textbox..

View Answers

August 30, 2012 at 5:46 PM

Here is a jsp application that allow the user to click particular record to delete. As the user clicks the particular button, that record will get displayed into another page and allow the user to delete that record and move back to the main page.

1)application.jsp:

<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">

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="delete" value="Delete" style="background-color:red;font-weight:bold;color:white;" onclick="deleteRecord(<%=rs.getString(1)%>);" ></td>
</tr>
<%
}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

August 30, 2012 at 5:47 PM

continue..

2)delete.jsp:

<%@page language="java"%>
<%@page import="java.sql.*"%>
<form method="post" action="delete.jsp">
<table border="1">

<%
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);
if(rs.next()){
%>
<tr><td>ID: </td><td><input type="text" name="id" value="<%=rs.getString("id")%>"></td></tr>
<tr><td>Name:</td><td><input type="text" name="name" value="<%=rs.getString("name")%>"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address" value="<%=rs.getString("address")%>"></td></tr>
<tr><td>Contact:</td><td><input type="text" name="contact" value="<%=rs.getInt("contactNo")%>"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" value="<%=rs.getString("email")%>"></td></tr>

</tr>
<tr>
<td><input type="submit" name="Submit" value="Delete" style="background-color:#49743D;font-weight:bold;color:#ffffff;"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>
</form>
<%
int id = Integer.parseInt(request.getParameter("id"));
try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("delete from employee where id="+id+"");
           response.sendRedirect("application.jsp");
}
catch (Exception e){
System.out.println(e);
}
%>

Advertisements

JSP textbox autopopulation on basis of SQL table values
JSP textbox autopopulation on basis of SQL table values Hi, I need... CONTROL NEW ABC LEGAL Dept PENDING PQR There are 2 list box on JSP , one... , then a text box (name - 'responsible') on the same JSP should be populated with 'ABC

i have developed the application in jsp(front-end -jsp,business logic-jsp).it is very slow when accessing the page - JSP-Servlet
i have developed the application in jsp(front-end -jsp,business logic-jsp).it is very slow when accessing the page i have developed the application in jsp only.i did not use any classes.application is very slow when access

I have posted a number of question but no one has answered?
I have posted a number of question but no one has answered? No one has responded for ten days now. However my first question was answered on the same day. Is there a limit to the number of questions you can ask or am I doing

how to retreive values from MS Access Database based on the values entered in textbox values in jsp file
in textbox values in jsp file Hi am new to java. i need to create... following problem. My Project requirement is as follows: I have a table in batchlogs.mdb... in their issues in the textbox and click the submit button it should search

how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page
how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page actually i have to create dynamic...; in this fragment of jsp page i m accessing values of rating1,rating2.... which are names

change database values when click next button on jsp page
change database values when click next button on jsp page How to retrive database values rondomly and display jsp page ,when user click next and previous bottons change the values on jsp page

how to highlight the field in image,when i have entered into that corresponding field's textbox-any one help out
how to highlight the field in image,when i have entered into that corresponding field's textbox-any one help out how to highlight the field in image,when i have entered into that corresponding field's textbox. Here webpage

i have one txt field and one button.when i entere any test in testfield then only button should be enabled.
i have one txt field and one button.when i entere any test in testfield then only button should be enabled. i have one txt field and one button.when i entere any test in testfield then only button should be enabled. i need

I have crude application
I have crude application I have crude application, how to load into this roseindia.net

i have problem with classnofounderror
i have problem with classnofounderror import java.sql.*; public class Tyagi { public static void main (String args[])throws SQLException { ResultSet rs; try { Class.forName

I have need to help
I have need to help Write a program that, for four points A, B, C and P, draws a triangle formed by ABC and a small cross showing the position of P; and displays a line of text indicating which of the following three cases

i have one txt field and one button.when i entere any test in testfield then only button should be enabled. i need for this
i have one txt field and one button.when i entere any test in testfield then only button should be enabled. i need for this i have one txt field and one button.when i entere any test in testfield then only button should

ID using get the databse latest value and displayed in jsp
ID using get the databse latest value and displayed in jsp I have... ... after i click the preview button it should show the values you have entered... and displayed in preview.jsp page . so technically pass the new id and display the values

get a radio button click value - JSP-Servlet
get a radio button click value thanks sir for sending code ,but i have one probs that is i m getting a null value i m calling getParameter("id... servlet from another jsp i.e 'main.jsp', then you have to store the value of id

Retaining textBox values in java - Java Beginners
Retaining textBox values in java Hi all, i have a jsp screen where i have two actions . I have a single textbox and two buttons. My textbox value is becoming null once i click on any one button. I want the textbox value

I have problem in my Project
I have problem in my Project Dear Sir, i have problem in my project about Jtable i have EDIT JButton whenevery i was click on edit he is display all data from database but i want to select any row

how to display values from database into table using jsp
how to display values from database into table using jsp I want... to display that? For example i have some number of books in database but i want to display books based on either bookname or authorname, for this i created one jsp page

I have a tex box. in that i want user should enter data in the format specified(for eg--a_b_c_d_e_)how to write code for it.
I have a tex box. in that i want user should enter data in the format specified(for eg--a_b_c_d_e_)how to write code for it. I have a tex box. in that i want user should enter data in the format specified(for eg--abcde_)how

Click on Page Refresh - JSP-Servlet
Click on Page Refresh hi ,i am working on jsp with mysql. i m facing a problem whenever i click on page refresh or f5 button, the value on form... is click". If u have more problem then give error page code. Thanks

i want to store dynamic number of value on one jsp and retrieve them on other.
i want to store dynamic number of value on one jsp and retrieve them on other... of result processing i have dynamic number of drop downs on a single page which... these different variables value on next page. plz help me, my whole project have

i have problem in that program - JavaMail
i have problem in that program 1. Write a multi-threaded Java program to print all numbers below 100,000 that are both prime and fibonacci number...++){ int j; for(j=2; j<10; i++) { pw.write(f3+"\n"); f1 = f2

have no idea of doing it..... - JSP-Servlet
have no idea of doing it..... how to create an jsp program to simulate rolling of a pair of dice. when a number is clicked the dice should roll and display the corresponding number present

get value from multiple textbox in jsp
get value from multiple textbox in jsp how to get multiple textbox value in another jsp? If i using the following code <%for(int i=0;i<3;i++) {%> <td>name<input type="text" class="name" id="name">

how to display jsp page containing mysql query in particular division using ajax ?my code is below bt i cundt get it properly
how to display jsp page containing mysql query in particular division using...="displayFunction()" value="submit" /> </p> </form> <div id="ajaxDiv...(); alert("Please Select Employee Id"); document.getElementById("email").value

i have an ques. of advanced java
i have an ques. of advanced java write a wap to implement AWT by login form

i have a problem in spring - Spring
i have a problem in spring spring Aop: how to configure proxyfactorybean in xml file for providing advices for one particular class

should i learn jsp in 2018
should i learn jsp in 2018 Hi, I have just completed Java programming after my science graduation. I want to learn JSP and Servlet. Is it worth to learn JSP in 2018? should i learn jsp in 2018? Thanks Hello, Yes

binding data with textbox on dropdown click
binding data with textbox on dropdown click Hello friends,Divyesh here. i have jsp page and i would like to bind data with text box on dropdown click. in dropdown employee id are load.and when we select perticular id than how

sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out
sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out.I want to have a through knowledge

How to read a rows which have a values in a excel file using apache poi - JSP-Servlet
How to read a rows which have a values in a excel file using apache poi Dear sir, How to read excel file in that only a rows which are having some values using apache poi...please help me sir. Thanks and Regards

javascript for textbox - JSP-Servlet
).I need that reason to be displayed one next delete.jsp page so how to get...:",""); window.open('../delete.jsp?id=id&reason='+reason.value,'mywindow','width=500, height=350,toolbar=no,resizable=yes,menubar=yes'); In delete.jsp If i do

Selecting value from autocomplete textbox using jquery in jsp
Selecting value from autocomplete textbox using jquery in jsp hello Sir, I completed ur tutorial on autocompletion textbox from database using... of autosuggested value does not retrieve that value in textbox. Sir ,I need

HOW TO DISPLAY ID IN TEXTBOX BASED ON COMBOBOX SELECTION IN A SAME PAGE
HOW TO DISPLAY ID IN TEXTBOX BASED ON COMBOBOX SELECTION IN A SAME PAGE Dear sir, Am having one table called rolemaster. In that there are 2 fields... SystemAdmin 2 Office Bearer Am loading this Rolename into one page called

i have no programming knowledge is it possible for study java?
i have no programming knowledge is it possible for study java? hello sir i have no programming knowledge is it possible to study java and jsp and servlet and struts.if it is then how i schedule for this and how to study

Pass value from JSP to JavaScript
; In our this example of passing values from jsp page to java script we have created a function hello() which takes value from the jsp page on click of some button...; We can also pass the value from a JSP page to the java

How to create textbox on combo value selection using javacsript in jsp?
How to create textbox on combo value selection using javacsript in jsp? dynamically create textbox on combo value selection. when select multiple values then create multiple textboxes

depending on the form name i have to display the message
depending on the form name i have to display the message depending on the form name i have to display the message. for example, i have 3 jsp pages like contact us,suggest us, feed back and i have to use servlet, if user clicks

JSP view detail page on accept button click
JSP view detail page on accept button click i Have 1 jsp page in that there r 2 button accept and view details when we click on aceept button it will submit to next page and when click on view details page it will shown the data

use struts 1.0 to view sql table value on JSP page
use struts 1.0 to view sql table value on JSP page Here i am using struts 1.0 to view my sql table values on jsp page. But the problem is when i append the value in bean then i find the last row of table is shown repetedly. Any

Ads