查询和增加日期格式

package com;

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



import utils.DBConnection;

public class demo {
	public void add(String content, Date lastTime) throws SQLException {

		Connection conn = DBConnection.getConn();
		PreparedStatement ps = conn.prepareStatement("insert into daily(content,lasttime) values(?,?)");
		ps.setString(1, content);
		ps.setDate(2, new java.sql.Date(lastTime.getTime())); // 只存储年月日
		ps.setTimestamp(2, new Timestamp(lastTime.getTime()));
		int i = ps.executeUpdate();
		System.out.println(i);
	}
	public void queryAll() throws SQLException{
		Connection conn = DBConnection.getConn();
		PreparedStatement ps = conn.prepareStatement("select content,submitTime,lastTime from daily");
		ResultSet rs = ps.executeQuery();
	//	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		while(rs.next())
		{
			String content = rs.getString("content");
			Date d1 = rs.getTimestamp("submitTime");
			Date d2 = rs.getTimestamp("lastTime");
			System.out.println(content+"--"+d1+"--"+d2);
		}
	}
	public static void main(String[] args) throws SQLException {
		new demo().add("sdsa", new Date());
		new demo().queryAll();
	}
}