mysql datetime转换java string_如何将java中Date存入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();

}

}

数值型

整型 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

其他

tinyblob         待定

blob

mediumblob

longblob

enum

set

-------------------------------------------------------------------------------------------------------

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

Timestamp timeStamp = new Timestamp(date.getTime());

music.setTime(timeStamp);

-------------------------------------------------------------------------------------------------------

private Date time = null;

public Date getTime() {

return time;

}

public void setTime(Date time) {

this.time = time;

}

字符串类型如何转换为日期类型

publicstaticvoidmain(String[] args) {

String d ="2008-10-13 15:20:25";

SimpleDateFormat sdf =newSimpleDateFormat("yyyy-MM-dd hh:mm:ss");

try{

System.out.println(sdf.parse(d));

}catch(Exception e) {

}

}

附一句

Timestamp t=new Timestamp(Calendar.getInstance().getTime().getTime());