date

Ads
 

date

how to insert date in database? i need coding for that

View Answers

February 7, 2012 at 3:09 PM

import java.sql.*;

class  InsertDate{
    public static void main(String[] args){
    try{

        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );

        Statement pstmt = conn.createStatement();
        java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
        String INSERT_RECORD = "insert into person(dob) values('"+sqlDate+"')";
        pstmt.executeUpdate(INSERT_RECORD);
        pstmt.close();
        conn.close();
    }
    catch(Exception e){
        e.printStackTrace();
    }
  }
}

Ads









Related Tutorials/Questions & Answers:
date
date   how to insert date in database? i need coding
date
date  can u tell me how to calculate difference between a user provided date and the system date in java
Advertisements
date
date  can u tell me how to calculate difference between a user provided date and the system date in java
date
date  i want difference between the date entered in a jtextfield and the system date in java
date
date  how to insert date using html through the combobox
date
date  how to insert date using html through the combobox
date
date  how to insert date using html through the combobox
date
date  how to insert date using html through the combobox
date
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 { System.out.println(date); Class.forName("oracle.jdbc.OracleDriver"); con
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
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
date convertion
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
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
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 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
date print  how can i print the date in jsp page in the following formate month-date-year. (example. march 8 2012
Date & Time
Date & Time  How to insert System Date & Time in MS-ACCESS using Java
Date & Time
Date & Time  How to insert System Date & Time in MS-ACCESS using Java
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 Validation
Date Validation  Hi, I need Date Validation using java in spring framework. Please Anyone help me... Thanks in advance
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
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 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
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 picker
date picker  where i have to kept javascript ,css files and images in eclipse... please tell me the location
Date comparison
Date comparison  Hi..i have developed an application in which i pop up a message by comparing the dates.the comparison is done by the current date and the date previously stored in the database.the database value is first
date program
date program  I have to differentiate my activities as todays... todays task if(dt==1){ //something to restrict date for today only using the 2variables else if(dt==10) //10days before task { //something to restrict date
date retriving
date retriving  my name is subbareddy.sir i was implementing attendance management .In this project i faced one problem that is when i print date stored in the database displays time with date.but i want print only date.please
Date Picker
Date Picker   Hi Java Developers ! I came across the coding for date.... But our requirement is a little different one . After the start date is selected in the calendar( by using date picker ) it needs to get updated/highlighted

Ads