Getting the last inserted id using jsp

Home Answers Viewqa JSP-Servlet Getting the last inserted id using jsp

QuestionAsk Questions?

Godwin

Getting the last inserted id using jsp
1 Answer(s) a year and 7 months ago
Posted in : JSP-Servlet

Pls how can i retrieve the last inserted id after submitting a form to mysql using jsp

View Answers

November 17, 2011 at 3:26 PM

1)form.jsp:

<html>
<form method="post" action="insert.jsp">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insert.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
String name=request.getParameter("name");
String address=request.getParameter("address");
        try{
         Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into data(name,address) values('"+name+"','"+address+"')");
           out.println("Data is successfully inserted!");
           int id=0;
           ResultSet rs=st.executeQuery("select * from data");
           if(rs.last()){
               id=rs.getInt("id");
           }
           out.println("Last inserted Id: "+id);


        }
        catch(Exception e){
        System.out.print(e);
        e.printStackTrace();
        }
        %>

Getting the last inserted id using jsp
Getting the last inserted id using jsp Pls how can i retrieve the last inserted id after submitting a form to mysql using jsp

JDBC: Last Inserted Id Example
JDBC: Last Inserted Id Example In this tutorial, you will learn how to find last inserted record ID using JDBC API. Getting Last Inserted ID : Last... insertion. you can get the last inserted id by using MAX(), writing

To Display the 'Last Modified' message in JSP
To Display the 'Last Modified' message in JSP I have to display the "Last Modified" auto save message in a portlet page at the right end corner using JSP I have used this below coding but I'm not getting the solution can anyone

Getting the ID of the element that fired an event using JQuery
Getting the ID of the element that fired an event using JQuery Hello sir I want to know-Is there any way to get the ID of the element that fires the event? Please mention the code with your reply. This will make easy for me

value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <..."> <title>JSP Page</title> <style type

the last data entered into database is getting stored again after refreshing
the last data entered into database is getting stored again after refreshing hey all i made a shout box using php and mysql but the last data... if the data is deleted from the database the last data entered is getting posted plz help

How to get an Id vaue - JSP-Servlet
a respected cases.In that case i am calling a jsp by using a response.sendRedirect("./jsp/delete1.jsp"); then it sis going to that jsp where i need a id values and getting from strId = request.getParameter("Id"); But i am getting a null

How to get an Id vaue - JSP-Servlet
How to get an Id vaue Dear Sir , How to get an Id value of a column when it is select ,i have to get an perticular rows Id value .I have a table with attributes like select,Id,subject,matter,status...If i select a one

Insert text into database table using JSP & jQuery
Insert text into database table using JSP & jQuery In this tutorial , the text is inserted into database table using JSP & jQuery. In the below... using "fadeIn" effect. The second JSP page contains code

id creation
id creation CREATE TABLE mohan2 ( sno bigint(20) NOT NULL AUTO... is inserted"); else System.out.println("data is not inserted"); } } how can write this program in jsp its working on console

id generation
id generation CREATE TABLE `mohan2` ( `sno` bigint(20) NOT NULL...; <title>My JSP 'index.jsp' starting page</title> <... JSP 'insert.jsp' starting page</title> <meta http-equiv="pragma

Getting error java.lang.ClassNotFoundException: com.mysql.jdbc.Driver.
Getting error java.lang.ClassNotFoundException: com.mysql.jdbc.Driver. I am doing project in JSP with database WampServer and glassfish as server..., port number and database name. Here machine name id localhost and database name

JDBC ResultSet last() Example
JDBC ResultSet last() Example: The ResultSet last() are use to moves the cursor to the last row in the ResultSet object. It return true if the cursor pointed last row in the ResultSet and return false if the ResultSet object does

Getting NumberFormatException
Getting NumberFormatException Hello Sir, I'm using Integer.parseInt.... I used the same type of code in a simple .java program but when I.m using it in a JSP it continuously throws the exception. below is the code I used. Please

Retrieving newly inserted records and displaying in jsp forever
Retrieving newly inserted records and displaying in jsp forever Sir... a table and display in jsp(Each row contains a field called as "session... of every record which is displayed on the jsp (not in database) and immediately i have

JQuery-Selecting class or ID
JQuery-Selecting class or ID Hi Guys, I am new to JQuery. I am getting little trouble in selecting an item using class or ID in jQuery

need to generate ID
into database. In the given code, we have fetched the last id from the database table and by adding 1, we have generated the next id and inserted into database...need to generate ID hai, i need to generate ID i.e when i select

Getting a Property value in jsp
Getting a Property value in jsp ... a Property Value</H1> <jsp:useBean id="bean" class="form.GetProperties" />... GetProperties() {} } In the above example, we are using bean with <jsp

JQuery-Selecting class or ID
am getting little trouble in selecting an item using class or ID in jQuery? Given below code selects an element of id name "element1" : $('#element1') Since IDs are unique, so it will select only the element of particular id

ID using get the databse latest value and displayed in jsp
ID using get the databse latest value and displayed in jsp I have... in the form (it means latest values) ... how to retrive that values using ID... in preview jsp page. the id will shown in end of the url also

last question
last question Input the name and marks of 25 students and compute the average. Print out the name and average of each student. (You can do this using an array or without using an array

ID using get the databse latest value and displayed in jsp
ID using get the databse latest value and displayed in jsp function... want to get the latest value using id and displayed in that start date end date etc,... How to get latest values in my jsp page and id will be shown in url

JSP Getting Started, Getting Started With JSP
Getting Started with JSP This page is all about getting started with JSP language. Java Server Pages or JSP for short is Sun specification for developing web applications using Java technologies. The JSP allows the developers

Session ID - Java Beginners
Session ID Do we get new session id for a new domain after clicking..." + " Info TypeValue\n" + "\n" + " ID\n...(session.getCreationTime()) + "\n" + "\n" + " Time of Last

I am getting Undefined in Text Box Very Urgent - JSP-Servlet
I am getting Undefined in Text Box Very Urgent Respected Sir/Madam... and clicking select button, The pop up window gets closes. But, i am getting the value "Undefined" in Emp ID text box which is present in the main page.. Here's

getting int values from form and insert it in data base in jsp
getting int values from form and insert it in data base in jsp how can i get form input such as id convert it to int insert it into database ... inserted into database."); } catch(Exception e){ System.out.println(e

JSP Tutorials, Getting started with JSP
Getting started with JSP The JSP getting started tutorial will help you... technology for developing the dynamic web application using Java. JSP is good... and provides good performance for high traffic website. Getting Started with JSP You

getting html list in a array
getting html list in a array hi i want to get html unordered list in a array using jsp

Validate Domain of an Email Id - JSP-Servlet
Validate Domain of an Email Id How to validate the domain name in an Email id before sending a mail for an application using Mail API. ex: a@a.com in the above email id i want to validate whether a.com is present

Further advice needed on my last question - JSP-Servlet
Further advice needed on my last question Dear Experts, I refer to your last solution regarding my matching codes. After I tried out your...:\Documents and Settingsapache\jsp\enter_jsp.java:132: ')' expected } catch

Still getting the http 404 error - Java Beginners
Still getting the http 404 error Dear experts, I refer to the last solution given to me. A few clarification:- 1. I must stress... mapping.Put the jsp code in the webapplication_folder and call the servlet from

Getting IP Address
Getting IP Address Hi... i want to get the ip address of the current machine running my jsp program.... example: my ip is 172.16.11.247... from other system if i run my jsp program using my ip like 172.16.11.247/myfile.jsp i

Passing td cell id to servlet
Passing td cell id to servlet Hi all, I am new to JSP/Servlet .Please help. I need to send the table cell index in servlet using javascript... method="post" action="TicTacToeGame"> <table id="board" border=1 align=center

Last modified time of a webpage
Last modified time of a webpage how can we get the last modified time of a webpage using java

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

MySQL Generate AlphaNumberic Id In JSP
numeric id using MySQL as database, tomcat 7 as a server for deploying the JSP...MySQL Generate AlphaNumberic Id In JSP In this section we will discus about how to generate id in specific format in MySQL and JSP. This example explains

getting and storing dropdown list in database in jsp
getting and storing dropdown list in database in jsp i have a drop down list to select book from database. i'm able to retrieve dropdown list from... is inserted successfully"); %> thanx for the quick response. i tried just

Getting File path error - JSP-Servlet
Getting File path error I have a requirement where i need to get certain properties on application login page start itself. I an currently using String str = request.getRealPath("/")+"a" + System.getProperty( "file.separator

page is not getting loaded when refreshing???
page is not getting loaded when refreshing??? I am loading an image section(image,demo link,Zoom) in a webpage by using javascript function in JSP. It will get all details of image section from database. I am getting header

How to store data entered in JSP page by a user in XML file & later retrieval of data using id at other page
How to store data entered in JSP page by a user in XML file & later retrieval of data using id at other page I have made a form in JSP having emp id... in another jsp page using retrieve submit button.Please tell step by step instructions

Creating, getting, and setting content using jQuery
Creating, getting, and setting content using jQuery Creating, getting, and setting content using jQuery Using jQuery , you can add(create) html content

Generator Tag (Control Tags) Using an Iterator with Id Attributes
Generator Tag (Control Tags) Using an Iterator with Id Attributes... the generator tag using the id attributes. Add the following code...;} } Create a jsp page where the generator tag <s:generator>

jsp
jsp hai good morning all jsp beginner myself is sathishkumar i am developing a web application jsp. in this application i generate id card.how... an id of some format using the following code. public class GenerateSerialNumber

getting a problem in execution - Development process
getting a problem in execution hi friends i have a problem in imcms... to the installation procedure all the procedure is completed but it is getting the error as ERROR : (Access denied for user 'root'@'localhost' (using

how to create using jsp
how to create using jsp code 1: <%@ page language="java..."/><br/> <input type="text" name="fname" id=""/><br/> <input type="text" name="lname" id=""/><br/> <input type

Popup Window using Ajax In JSP
Popup Window using Ajax In JSP ... Window application using Ajax in JSP. For this, we will create the following... will display the employee id and employee name. Import getuser.jsp to display

Printing Session Id Using Variable
Printing Session Id Using Variable Hi, I am a learner in PHP language. Could any one guide me, how to print session Id using variable in PHP. Thanks

Latest
Frameworks
Category