Convert Date from util to sql

最新推荐文章于 2021-07-26 21:33:39 发布

solaris_navi

最新推荐文章于 2021-07-26 21:33:39 发布

阅读量530

点赞数

分类专栏： Java 文章标签： date calendar string class sql

本文链接：https://blog.csdn.net/solaris_navi/article/details/6761879

版权

Java 专栏收录该内容

63 篇文章 0 订阅

订阅专栏

package io.hause.utils;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;

public final class Converter {

	private static final DateFormat utilDateFormat = new SimpleDateFormat("yyyy-mm-dd");
	private static final DateFormat sqlDateFormat = new SimpleDateFormat("yyyy-mm-dd");
	
	public static java.sql.Date convertDateFromUtilToSqlComplex(java.util.Date d)
	{
		Calendar cal = Calendar.getInstance();
		cal.setTime(d);
		cal.set(Calendar.HOUR_OF_DAY, 0);
		cal.set(Calendar.MINUTE, 0);
		cal.set(Calendar.SECOND, 0);
		cal.set(Calendar.MILLISECOND, 0);
		
		return new java.sql.Date(cal.getTimeInMillis());
	}
	
	public static final java.sql.Date convertDateFromUtilToSql(java.util.Date d)
	{
		return new java.sql.Date(d.getTime());
	}
	
	public static final java.sql.Time convertTimeFromUtilToSql(java.util.Date d)
	{
		return new java.sql.Time(d.getTime());
	}
	
	public static final java.sql.Timestamp convertTimeStampFromUtilToSql(java.util.Date d)
	{
		return new java.sql.Timestamp(d.getTime());
	}
	
	public static final java.util.Date convertDateFromSqlToUtil(java.sql.Date d)
	{
		return new java.util.Date(d.getTime());
	}
	
//	public static java.sql.Date convertDateFromUtilToSqlDF(java.util.Date d)
//	{
//		return java.sql.Date.valueOf(sqlDateFormat.format(d));
//	}
//	
//	public static java.util.Date convertDateFromSqlToUtilDF(java.sql.Date d) throws ParseException
//	{
//		return (java.util.Date) utilDateFormat.parse(utilDateFormat.format(d));
//	}
	
	public static void main(String[] args)
	{
		
		java.util.Date d = new java.util.Date();
		new Converter();
		java.sql.Date d2 = Converter.convertDateFromUtilToSql(d);
		
		System.out.println(d);
		System.out.println(d2);
		
		d = Converter.convertDateFromSqlToUtil(d2);
		System.out.println(d);
	}
}