Question

java.util.Date类型插入sqlserver数据库的datetime时怎么转换?

Answer 1

Date date=new Date();
SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:MM:ss");
String date_str=df.format(date);
int isUpdate=0;
Connection conn=null;
PreparedStatement pstmt=null;
String sql="insert into test_A(table_time) values('"+date_str+"')";