数据库表
create table dt(
d date,
t time,
ts timestamp
);
package com.m.domain;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Date;
import com.m.JDBCUtils.JDBCUtils;
public class Dt {
public static void main(String[] args) throws IOException, Exception {
Connection conn = JDBCUtils.getConnection();
String sql="insert into dt values(?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
//创建数据,先使用Data 获取毫秒值
Date d=new Date();//java.util
//转换成 日期时间等
java.sql.Date D=new java.sql.Date(d.getTime());
Time t=new Time(d.getTime());
Timestamp ts=new Timestamp(d.getTime());
ps.setDate(1, D);
ps.setTime(2, t);
ps.setTimestamp(3, ts);
int rs = ps.executeUpdate();
if(rs>0) {
System.out.println("插入成功");
}else {
System.out.println("插入失败");
}
}
}