java jdbc 时间处理

package jdbc;

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



public class Demo07 {
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/jdbcTest?serverTimezone" +
			        "=UTC&characterEncoding=utf-8&useSSL=false","root","root");
			
			ps = conn.prepareStatement("insert into to_user (username,pwd,regTime,lastLoginTime) values (?,?,?,?)");
			ps.setString(1, "john");
			ps.setString(2, "55555");
			
			java.sql.Date date = new java.sql.Date(System.currentTimeMillis());
			Timestamp stamp = new Timestamp(System.currentTimeMillis());//如果要插入指定日期可以用calender类或者dateformat
			ps.setDate(3, date);//没有时分秒
			ps.setTimestamp(4, stamp);//插入时间戳
			ps.execute();
			
			
			} catch (Exception e) {
				try {
					conn.rollback();//出错则回滚数据
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}//
		}finally {
			//一定记住关闭数据库资源 顺序 resultset --->statment ----->connection 这三个try catch块要分开写
			try {
				if (rs != null) {
					rs.close();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			try {
				if (ps != null) {
					ps.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				if (conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}	
	}
}