JAVA如何插入MySql的datetime类型的简单的例子

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Timestamp;
public class DataBaseTest {
private Connection conn;
PreparedStatement pStmt=null;
private void test(){
try{
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
String url =”jdbc:mysql://localhost:3306/rhino?user=root&password=&useUnicode=true&characterEncoding=UTF-8″;
Connection conn= DriverManager.getConnection(url);
System.out.println(“connect to database successfully!”);

pStmt=conn.prepareStatement(“INSERT INTO RH_ENTRY”+
“(id,allow_comments,category_id,comment_count,content,create_on,name,status)”+
“values(?,?,?,?,?,?,?,?)”);
conn.setAutoCommit(false);
java.util.Date date=new java.util.Date();
Timestamp tt=new Timestamp(date.getTime());
pStmt.setInt(1,1);
pStmt.setInt(2,1);
pStmt.setInt(3,1);
pStmt.setInt(4,5);
pStmt.setString(5,”shit!!!!!”);
pStmt.setTimestamp(6,tt);
pStmt.setString(7,”jordan”);
pStmt.setInt(8,1);
int j=pStmt.executeUpdate();
conn.commit();
if(j!=0)
System.out.println(“ok”);
}catch(Exception e){
try{
conn.rollback();
}catch(Exception e1){
e1.printStackTrace(System.out);
}
e.printStackTrace();
}finally{
try{
pStmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
}

public static void main(String args[]){
DataBaseTest dt=new DataBaseTest();
dt.test();
}
}

 
插入data类型的数据：使用SimpleDateFormat转化一下即可，括号里可以精确到日期或者时间
SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);
Date now = new Date();
String abcValue = sdf.format(now);
数值型
整型 JDBC
tinyint java.lang.Integer
smallint
mediumint java.lang.Long
int
bigint java.math.BigInteger

单精度浮点型 JDBC
float java.lang.Float

双精度浮点型 JDBC
double java.lang.Double

其他 JDBC
decimal java.math.BigDecimal

字符型 JDBC
char java.lang.String
varchar
tinytext
text
mediumtext
longtext

日期型 JDBC
date java.sql.Date
datetime java.sql.Timestamp
timestamp java.sql.Timestamp
time java.sql.Time
year java.sql.Date

http://blog.sina.com.cn/s/blog_64e467d60100w0yp.html