ID using get the databse latest value and displayed in jsp

I have some text box like name address city ,I have submit button and preview button ... once click the submit button the data will be stored in mysql database ... after i click the preview button it should show the values you have entered in the form (it means latest values) ... how to retrive that values using ID and displayed in preview.jsp page . so technically pass the new id and display the values in preview jsp page. the id will shown in end of the url also..

View Answers

April 29, 2011 at 11:20 AM

1)form5.jsp:

<%@page import="java.sql.*"%>
<html>
<script>
function sub(){
    var name=document.form.name.value;
    var address=document.form.address.value;
    window.location.replace("insert.jsp?name="+name+"&&address="+address);
}
function pre(id){

    window.location.replace("form2.jsp?id="+id);
}
    </script>
<form name="form">
<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><input type="button" value="Submit" onclick="sub();"></td>
<%
Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("Select * from data");
int id=0;
    if(rs.last()){
id=rs.getInt("id");
System.out.println(id);
        }
%>
<td><input type="button" value="Preview" onclick="pre(<%=id%>);"></td></tr>
</table>
</html>

2)insert.jsp:

<%@page import="java.sql.*"%>
<table>
<%
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/test", "root", "root");
        Statement st=con.createStatement();
        int i=st.executeUpdate("insert into data(name,address) values('"+name+"','"+address+"')");
        out.println("Data is successfully inserted!");
        }
        catch(Exception e){
        System.out.print(e);
        e.printStackTrace();
        }
        %>
<a href="form5.jsp">Go Back</a>

3)form2.jsp:

<%@page import="java.sql.*"%>
<%
int id= Integer.parseInt(request.getParameter("id"));

Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("Select * from data where id="+id+"");
        String name="",address="";
        while(rs.next()){
            name=rs.getString("name");
            address=rs.getString("address");
        }
        System.out.println(name+address);
        %>
<html>
<form>
<table>
<tr><td>Your Name is:</td><td><input type="text" value="<%=name%>"></td></tr>
<tr><td>Your Address is:</td><td><input type="text" value="<%=address%>"></td></tr>
</table>
</form>
</html>
<a href="form5.jsp">Go Back</a>

ID using get the databse latest value and displayed in jsp

Questions by Category