数据在java中加时间,Java：插入表日期时间数据

I am trying to insert into a variable in MS- SQL database the current date and the time.

I use this format:

DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");

Calendar cal = Calendar.getInstance();

System.out.println(dateFormat.format(cal.getTime()));

and I get this as a result 2013-01-28 09:29:37.941

My field in the database is defined datetime and as I have seen in other tables which have the same field, the date and the time is written exactly like this 2011-07-05 14:18:33.000.

I try to insert into the database with a query that I do inside a java program, but I get this error

SQL Exception: State : S0003 Message: The conversion of a varchar

data type to a datetime data type of the value is out of range. Error

: 242

My query is like that:

query = "INSERT INTO Companies CreatedOn"+

"VALUES ('" + dateFormat.format(cal.getTime()) + "')"

but I don't understand what I am doing wrong.

解决方案

According to the error description, you are inserting an incorrect type into the database. See JDBC to MSSQL. You should convert Calendar to Timestamp.

Try using:

PrepareStatement statement

= connection.prepareStatement("INSERT INTO Companies CreatedOn VALUES(?)");

java.sql.Timestamp timestamp = new java.sql.Timestamp(cal.getTimeInMillis());

statement.setTimestamp(1, timstamp);

int insertedRecordsCount = statement.executeUpdate();