QuestionAsk Questions?
pavithra kannan
doubt about retrieve dates from Database
3 Answer(s) 5 years and 4 months ago
Posted in : Date-Calendar
3 Answer(s) 5 years and 4 months ago
Posted in : Date-Calendar
Retrieve dates from the database with some condition in dates in JSP
View Answers
February 27, 2008 at 9:16 PM
i want to retrieve datas from the database with some condition in dates in jsp
February 28, 2008 at 3:20 PM
Retrieve data from Database using JSP
JSP Example Code for retrieving Data from Database
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Date retrive value from database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Date retrive value from database</center></h1>
<form method="POST" >
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Date:</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
// out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
String query = "SELECT date FROM user_details where username='amardeep'";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
// out.println(rs.getString(3) + "<br>");%>
<td width="50%" valign="right">
<%=rs.getString("date")%><br/></td>
<%}
rs.close();
con.close();
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
For more JSP and Servlet Example codes
Inserting Data into Database using JSP
http://www.roseindia.net/answers/viewanswers/272.html
Storing Date into database
http://www.roseindia.net/answers/viewanswers/304.html
Neelam ;)
JSP Example Code for retrieving Data from Database
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Date retrive value from database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Date retrive value from database</center></h1>
<form method="POST" >
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Date:</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
// out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
String query = "SELECT date FROM user_details where username='amardeep'";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
// out.println(rs.getString(3) + "<br>");%>
<td width="50%" valign="right">
<%=rs.getString("date")%><br/></td>
<%}
rs.close();
con.close();
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
For more JSP and Servlet Example codes
Inserting Data into Database using JSP
http://www.roseindia.net/answers/viewanswers/272.html
Storing Date into database
http://www.roseindia.net/answers/viewanswers/304.html
Neelam ;)
February 28, 2008 at 3:21 PM
Retrieve data from Database using JSP
JSP Example Code for retrieving Data from Database
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Date retrive value from database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Date retrive value from database</center></h1>
<form method="POST" >
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Date:</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
// out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
String query = "SELECT date FROM user_details where username='amardeep'";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
// out.println(rs.getString(3) + "<br>");%>
<td width="50%" valign="right">
<%=rs.getString("date")%><br/></td>
<%}
rs.close();
con.close();
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
For more JSP and Servlet Example codes
Inserting Data into Database using JSP
http://www.roseindia.net/answers/viewanswers/272.html
Storing Date into database
http://www.roseindia.net/answers/viewanswers/304.html
Neelam ;)
JSP Example Code for retrieving Data from Database
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Date retrive value from database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Date retrive value from database</center></h1>
<form method="POST" >
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Date:</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
// out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
String query = "SELECT date FROM user_details where username='amardeep'";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
// out.println(rs.getString(3) + "<br>");%>
<td width="50%" valign="right">
<%=rs.getString("date")%><br/></td>
<%}
rs.close();
con.close();
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
For more JSP and Servlet Example codes
Inserting Data into Database using JSP
http://www.roseindia.net/answers/viewanswers/272.html
Storing Date into database
http://www.roseindia.net/answers/viewanswers/304.html
Neelam ;)
Related Pages:
