java.sql.Date 与 java.util.Date 的转换_徐军猛的博客

	@Test
	public void testAddMissingBigFile(){
		jdbcTemplate
				.update(" insert into juchao.tb_text_0042 ("
						+ "ob_textid_0042,"
						+ "f008v_0042,"
						+ "f001v_0042,"
						+ "f002d_0042,"
						+ "f003d_0042,"
						+ "f004v_0042,"
						+ "f006b_0042,"
						+ "f007n_0042,"
						+ "ob_object_id,"
						+ "ob_isvalid_0042,"
						+ "ob_rectime_0042,"
						+ "ob_modtime_0042,"
						+ "ob_memo_0042,"
						+ "ob_seq_id) "
						+ "values(?,?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'),?,?,?,?,?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'),to_date(?,'yyyy-mm-dd hh24:mi:ss'),?,?) ",
						new PreparedStatementSetter() {

							@Override
							public void setValues(PreparedStatement ps)
									throws SQLException {
								ps.setString(1, "1202164332");
								ps.setString(2, "PDF");
								ps.setString(3, null);
								try {
									ps.setDate(4, new java.sql.Date((new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").parse("2016-4-11 20:00:21")).getTime()));
								} catch (Exception e) {
									e.printStackTrace();
								}
								ps.setString(5, "2016-4-12");
								ps.setString(6, "艾华集团：审计报告");
								try {
									ps.setBlob(7, new FileInputStream(new File("E:\20160412\1202164332\艾华集团：审计报告.PDF")));
								} catch (FileNotFoundException e) {
									e.printStackTrace();
								}
								ps.setString(8, "50625");
								ps.setString(9, "1235588666");
								ps.setString(10, "1");
								try {
									ps.setDate(11, new java.sql.Date((new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").parse("2016-4-11 20:01:47")).getTime()));
								} catch (Exception e) {
									e.printStackTrace();
								}
								try {
									ps.setDate(12,  new java.sql.Date((new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").parse("2016-4-11 20:38:45")).getTime()));
								} catch (Exception e) {
									e.printStackTrace();
								}
								ps.setString(13, null);
								ps.setString(14, "2189177010");
							}

						});
	}	@Test
	public void testAddMissingBigFile(){