To store date
View Answers
September 27, 2008 at 11:56 AM
Hi friend,
Code to store date in database :
<%@ page import="java.sql.*,java.util.*,java.text.*,java.text.SimpleDateFormat" %>
<html>
<%
Connection con=null;
PreparedStatement pstatement = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "file_upload";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url+dbName,userName,password);
java.util.Date now = new java.util.Date();
String DATE_FORMAT = "yyyy-MM-dd";
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
String strDateNew = sdf.format(now) ;
String queryString = "INSERT INTO file_tbl set file_date='"+strDateNew+"'";
//out.println(queryString);
pstatement=con.prepareStatement(queryString);
val = pstatement.executeUpdate();
if(val>0)
{
%>
<br><br>
<b><%=strDateNew%> Inserted into Database .</b>
<%
}
}
catch(Exception e)
{}
}
%>
</html>
For read more in details :
http://www.roseindia.net/jsp/fileupload.shtml
Thanks
Code to store date in database :
<%@ page import="java.sql.*,java.util.*,java.text.*,java.text.SimpleDateFormat" %>
<html>
<%
Connection con=null;
PreparedStatement pstatement = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "file_upload";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url+dbName,userName,password);
java.util.Date now = new java.util.Date();
String DATE_FORMAT = "yyyy-MM-dd";
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
String strDateNew = sdf.format(now) ;
String queryString = "INSERT INTO file_tbl set file_date='"+strDateNew+"'";
//out.println(queryString);
pstatement=con.prepareStatement(queryString);
val = pstatement.executeUpdate();
if(val>0)
{
%>
<br><br>
<b><%=strDateNew%> Inserted into Database .</b>
<%
}
}
catch(Exception e)
{}
}
%>
</html>
For read more in details :
http://www.roseindia.net/jsp/fileupload.shtml
Thanks
Ads
Related Tutorials/Questions & Answers:
store
store i want to store data in (.dat) file format using swing and perform operation on that insertion,deletion and update
store i want to store data in (.dat) file format using swing and perform operation on that insertion,deletion and update
store
store hi i want store some information in my program and use them in other method. what shoud i do
store hi i want store some information in my program and use them in other method. what shoud i do
Advertisements
date
date how to store in database (oracle 10 g) using JDBC and servlets... database table name birthday (DOB date); dob with DATE data type in database while...=d.getTime(); java.sql.Date date = new java.sql.Date(t); try
date how to store in database (oracle 10 g) using JDBC and servlets... database table name birthday (DOB date); dob with DATE data type in database while...=d.getTime(); java.sql.Date date = new java.sql.Date(t); try
date
date can u tell me how to calculate difference between a user provided date and the system date in java
date can u tell me how to calculate difference between a user provided date and the system date in java
date
date can u tell me how to calculate difference between a user provided date and the system date in java
date can u tell me how to calculate difference between a user provided date and the system date in java
DATE
DATE I have the following as my known parameter Effective Date... of calcultion starts My question is how to find the date of Thursday This cycle... the date of all the thursdays of the given year. import java.util.*; import
DATE I have the following as my known parameter Effective Date... of calcultion starts My question is how to find the date of Thursday This cycle... the date of all the thursdays of the given year. import java.util.*; import
convert current date into date format
convert current date into date format How to get current date and convert into date format in Java or PHP
convert current date into date format How to get current date and convert into date format in Java or PHP
date convertion
date convertion How to convert the string date format 23/11/2009 to original date format in asp.net
date convertion How to convert the string date format 23/11/2009 to original date format in asp.net
Mysql Date from Date
Mysql Date from Date Mysql Date from Date Time in Mysql return the Current date. Understand with Example The Tutorial illustrate an example from 'DateTime
Mysql Date from Date Mysql Date from Date Time in Mysql return the Current date. Understand with Example The Tutorial illustrate an example from 'DateTime
Java Date
Java Date Hi, What is the API for Date management in Java? How use the Java Date API for manipulating date object in Java? Provide some... of API for working with date and time objects in Java. You can also use third
Java Date Hi, What is the API for Date management in Java? How use the Java Date API for manipulating date object in Java? Provide some... of API for working with date and time objects in Java. You can also use third
Date Picker
Date Picker "I want to set default calendar date when using datepicker. This date means auto-loaded date when the calendar appears. The default date is the current date. I want to change it. How could I do
Date Picker "I want to set default calendar date when using datepicker. This date means auto-loaded date when the calendar appears. The default date is the current date. I want to change it. How could I do
date print
date print how can i print the date in jsp page in the following formate month-date-year. (example. march 8 2012
date print how can i print the date in jsp page in the following formate month-date-year. (example. march 8 2012
date print
date print how can i print the date in jsp page in the following formate month-date-year. (example. march 8 2012
date print how can i print the date in jsp page in the following formate month-date-year. (example. march 8 2012
PHP Date
PHP Date Hi, How to use PHP Date functions in my PHP program? Thanks Hi, PHP Date functions is very handy. It is used to progracess, format and create date objects in PHP. There are many ways to use PHP Date
PHP Date Hi, How to use PHP Date functions in my PHP program? Thanks Hi, PHP Date functions is very handy. It is used to progracess, format and create date objects in PHP. There are many ways to use PHP Date
date function
date function Write a JavaScript program to read a date from user and perform the following, if entered value is date then perform the following 1. Display the day no from the date 2. Display the year from the date 3. Display
date function Write a JavaScript program to read a date from user and perform the following, if entered value is date then perform the following 1. Display the day no from the date 2. Display the year from the date 3. Display
Java Xml Data Store
phone number, nature and date of the enquiry, and the name of the salesperson... enquiries sorted by date (ascending or descending) depending if they have be followed up and/or purchased. You will need to store the data in a local binary
phone number, nature and date of the enquiry, and the name of the salesperson... enquiries sorted by date (ascending or descending) depending if they have be followed up and/or purchased. You will need to store the data in a local binary
Date Validation
Date Validation Hi, I need Date Validation using java in spring framework. Please Anyone help me... Thanks in advance
Date Validation Hi, I need Date Validation using java in spring framework. Please Anyone help me... Thanks in advance
Version of excalibur-store>excalibur-store dependency
List of Version of excalibur-store>excalibur-store dependency
List of Version of excalibur-store>excalibur-store dependency
SQl Date
; Date : The format used to store the Date is YYYY-MM-DD Once your table... SQL Date The SQL Date is used when you are working with dates. This include
; Date : The format used to store the Date is YYYY-MM-DD Once your table... SQL Date The SQL Date is used when you are working with dates. This include
Finding A Date
Finding A Date My Frequency Start Date is 24-08-2012 My frequency end date - not defined Calculation Frequency is Weekly(Sunday) My calculation... the following date of sunday
Finding A Date My Frequency Start Date is 24-08-2012 My frequency end date - not defined Calculation Frequency is Weekly(Sunday) My calculation... the following date of sunday
Date prorblem
Date prorblem HI all, i have date comming from one text file into string filed in java code. once the date is available in filed ( of type String... to insert the date into oracle DB. my code is as below: String DATEADDED
Date prorblem HI all, i have date comming from one text file into string filed in java code. once the date is available in filed ( of type String... to insert the date into oracle DB. my code is as below: String DATEADDED
date validation
date validation sir, pls provide date validation code in javascript..we want to include it into our master form.. Please visit the following link: http://www.roseindia.net/mysql/datevalidation.shtml
date validation sir, pls provide date validation code in javascript..we want to include it into our master form.. Please visit the following link: http://www.roseindia.net/mysql/datevalidation.shtml
Date validation
Date validation How to validate date in jsp? That is i have a textbox which will have the value from the date picker. How to validate the date that should be entered in a specified format? Hi Friend, Please visit
Date validation How to validate date in jsp? That is i have a textbox which will have the value from the date picker. How to validate the date that should be entered in a specified format? Hi Friend, Please visit
