Hi friend,

First to create table in database

CREATE TABLE tablename (
`id` bigint(20) NOT NULL auto_increment,
current_date_time datetime default NULL,
PRIMARY KEY (`id`)
)

To insert current date and time in database :

import java.io.*;
import java.sql.*;
import java.util.*;
import java.text.*;
import java.text.SimpleDateFormat;

public class insertDateTime{

public static void main(String args[]){

String url = "jdbc:mysql://localhost:3306/";;
String dbName = "database";
String driver = "com.mysql.jdbc.Driver";
String userName = "";
String password = "";

Statement stmt = null;
Connection con;
int val;
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 hh:mm:ss";
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);


String current_date_time = sdf.format(now) ;

String queryString = "INSERT INTO tablename set current_date_time='"+current_dateTime+"'";

//out.println(queryString);

stmt=con.createStatement();


val = stmt.executeUpdate(queryString);


}
catch(Exception e)
{}
}




}


To show the date and time :

import java.io.*;
import java.sql.*;
import java.util.*;
import java.text.*;
import java.text.SimpleDateFormat;


public class showDateTime {

public static void main(String args[]){


String url = "jdbc:mysql://localhost:3306/";;
String dbName = "database";
String driver = "com.mysql.jdbc.Driver";
String userName = "";
String password = "";



Statement stmt = null;
Connection con;
int val;
ResultSet rs;
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 hh:mm:ss";
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);


String current_dateTime = sdf.format(now) ;

String queryString = "select * from tablename";



//out.println(queryString);

stmt=con.createStatement();


rs = stmt.executeQuery(queryString);

while(rs.next())
{
System.out.println(rs.getString("current_date_time"));

}


}
catch(Exception e)
{}
}
}

For read more information to visit :

http://www.roseindia.net/

Thanks

Hello i tried the above insert code bt am getting the following error com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sysdate(date)value('2012-04-01 05:45:43')' at line 1

bt when inserted the same query in mysql its working fine.

plzz tell me how to resolve it.

herz my code:

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
    {
        // TODO Auto-generated method stub
        try
        {

            System.out.println("Hello");
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection= DriverManager.getConnection("jdbc:mysql://localhost/test","root","sayali");
            PreparedStatement pst = null;

            java.util.Date now = new java.util.Date();

            String DATE_FORMAT = "yyyy-MM-dd hh:mm:ss";
            SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);


            String current_date_time = sdf.format(now) ;

            String query = "INSERT INTO sysdate(date)value(?)";
            pst = connection.prepareStatement(query);
            pst.setString(1,current_date_time);
            System.out.println(pst);

        //out.println(queryString);

            int UpdateQuery = pst.executeUpdate();
            System.out.println(UpdateQuery);


        }
        catch(Exception e)
        {
            e.printStackTrace();
            System.out.println("error");
        }
    }