ID using get the databse latest value and displayed in jsp

function getRecord(){
    var id=document.form.id.value;
    alert(id);
    var f=document.form;
    f.method="post";
    f.action='preview.jsp?id='+id;
    f.submit();
}
<body id="page1" onload="getRecord();">
<form>
<%
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 Data where id='"+no+"'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>
<b>Start Date    :</b>> <%=rs.getString("start_date")%>
<b>Start Time    :</b>  <%=rs.getString("start_time")%> 
<b>End Date      :</b> <%=rs.getString("end_time")%>

<%
}
}
catch(Exception e){}
%>

I have done jsp page like this ....  I 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 also?

View Answers

Ads

Advertisements

Retrieve data from databse using where in JSP
Retrieve data from databse using where in JSP Hi, can somebody help me? I have a jsp page. in that i want to get data from the database where username is matched. i tried it. but can't get the output. here is the code. please

how to create a bar chart in jsp by fetching value from oracle databse?
how to create a bar chart in jsp by fetching value from oracle databse? i want to show the population of various states in a bar chart in my jsp page by fetching the data from my oracle table. i am using my eclipse as my IDE

how to get the checkbox value in jsp
how to get the checkbox value in jsp how to get the checkbox value in jsp? JSP CheckBox Example - how to get the checkbox value in jsp

add text box and select list dynamically and get its value to store it into database using jsp request parameter
add text box and select list dynamically and get its value to store it into database using jsp request parameter its very helpful when you have only dynamically added text field but want code to retrive value of dynamically

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 get Button Id ?
How to get Button Id ? How to get Button ID instead of its value in Servlet. (I am not using jsp right now

Get form value in same page - JSP-Servlet
Get form value in same page Hello friends, Can we get a form field value in the same to be processed in java coding... friend, For solving the problem visit to : http://roseindia.net/jsp/user

session value not get in many jsp page.
session value not get in many jsp page. I am using servlet to set...,response); and get session value on jsp page by follwing:- String user=(String)session.getAttribute("user"); this is work but when this code is use in other jsp

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

sorting and filtering the displayed table data using jsp and xml
sorting and filtering the displayed table data using jsp and xml I have created a xml file and a jsp file, which uses DOM parser to display... that is displayed in web page. How to do it ??? Please help as soon as possible

how to show effect (visual) on jsp page using value from database
how to show effect (visual) on jsp page using value from database I am making a ticket booking system. I have a databse with a clumn "booking status... as seats should be displayed red. when the value in booking status

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

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? Hi Friends, When i click combobox value in jsp form page, it will diplay related value.... I am using only this page.. not get value from another page

jsp :how to edit table of data displayed using jsp when clicked on edit button
jsp :how to edit table of data displayed using jsp when clicked on edit button i have a jsp program which displays data in the form of table ..now i...;"></td> <td><input type="hidden" name="id" value="<

how to get HTTP GET request value using javascript
how to get HTTP GET request value using javascript how to get HTTP GET request value using javascript how is how you can get HTTP GET request value using javascript: var parameter = window.location.search.replace

How to save and get value from JSP
How to save and get value from JSP Employee Name Time... 324 2012-12-12 save i want to save dis value jsp to action ...how can i get all value ..and store..how can its values goes

Get the error messages displayed
Get the error messages displayed How to get the error messages displayed

Finding MAX value from emp_id column using SQL query?
Finding MAX value from emp_id column using SQL query? I need to select maximum of the Emp_id values from SQL server 2005 table.I was using... of emp id from the table.(Actually it picks up Max value using by looking at 1st

how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp
how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp. I am inserting analysis report into a database using

How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server.
How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server. I am using postgresql-8.4.4-1-windows as database, jboss-4.0.5.GA as server and jdk-6-windows-i586 with IDE

how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp How to insert check box value to the oracle database using jsp? I want to create hotel's...; <td><input name="pack_id" type="type" value="<%= pack_id %>" size

get info from mysql using jsp and servlet
get info from mysql using jsp and servlet HELLO! I wanna create a jsp page which able to let me get its name, phone and other info by asking the user to key in their email address from mysql database by using servlet and jsp too

get data between date using jsp with msaccess
get data between date using jsp with msaccess hi, urgently i need program for get data between date using jsp with MsAccess database.plz any one can help me.thanks for anyone replay with regards c.b.chellappa

How to get the output of JSP program using Bean
How to get the output of JSP program using Bean Hi Kindly go...; <jsp:useBean id="counter" scope="session" class="CounterBean" /> <... visit the following link: http://www.roseindia.net/jsp/using-bean-counter.shtml

jsp :how to edit table of data displayed using jsp when clicked on edit button
jsp :how to edit table of data displayed using jsp when clicked on edit button i have a jsp program which displays data in the form of table ..now i want to delete this information in table when click on delete button and save

how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp how to insert check box value to the database using jsp my code is <link href..." name="pmanager" value="Enter" ></td> <td align

How to get the output of jsp program using Bean
How to get the output of jsp program using Bean Hello my Roseindia...; Next i created JSP program for the above one by using Bean and i opened the Tomcat webserver and clicked the JSP and i got the HTTP Status -500

list to be displayed in jsp page.
list to be displayed in jsp page. Can any one help me? Am developing the code in struts.I have a list in action class that has to be printed in the dropdownlist in another jsp page.Please help me in the code.. Thank u

Ads