JDBC_时间处理_Date_Time_Timestamp区别

package com.lzy.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;

public class Demo05 {
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testjdbc", "root", "123456");
			
			ps=conn.prepareStatement("insert into t_user (username,pwd,regTime,lastLoginTime) values (?,?,?,?)");
			ps.setObject(1, "lzy");
			ps.setObject(2, "123456");
			java.sql.Date date=new java.sql.Date(System.currentTimeMillis());
			Timestamp stamp=new Timestamp(System.currentTimeMillis());
			ps.setDate(3, date);
			ps.setTimestamp(4, stamp);
			ps.execute();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(ps!=null){
					ps.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				if(conn!=null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

运行结果：

Date不带时分秒
Timestamp带时分秒

            java.sql.Date date=new java.sql.Date(System.currentTimeMillis());
			Timestamp stamp=new Timestamp(System.currentTimeMillis());

使用Date和Timestamp的构造方式，其中“System.currentTimeMillis()”表示当前时间。

随机写入1000条日期随机的数据“

public class Demo07 {
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			//加载驱动类
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testjdbc","root","123456");
			
			for(int i=0;i<1000;i++){
				
				ps = conn.prepareStatement("insert into t_user (username,pwd,regTime,lastLoginTime) values (?,?,?,?)");
				ps.setObject(1, "lzy"+i);
				ps.setObject(2, "123456");
				int rand =  100000000+new Random().nextInt(1000000000);				
				java.sql.Date date = new java.sql.Date(System.currentTimeMillis()-rand);
				Timestamp stamp = new Timestamp(System.currentTimeMillis()-rand);  //如果需要插入指定日期，可以使用Calendar、DateFormat
				
				ps.setDate(3, date);
				ps.setTimestamp(4, stamp);
				ps.execute();		
			}			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(ps!=null){
					ps.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				if(conn!=null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}