Java Date 详解

Java Date 详解

1.java.sql.Date与java.util.Date比较
  ① java.sql.Date 只有日期,没有时间
  ② java.util.Date 时间日期都具备
  ③ ResultSet.getDate(columnInt)取得的值是java.sql.Date类型,只有日期,没有时间,就算转换为java.util.Date同样没有时间
  ④ java.sql.Timestamp 时间日期都具备,ResultSet.getTimestamp(columnInt) 时间日期都有
  ⑤ 建表 T1 用以测试,建表语句↓

create table t1(    
id number not null,    
charcol char default 'Y',    
datecol date default sysdate,    
intcol integer default 12);

insert into t1 values(1,'y',sysdate,12);
insert into t1 values(2,'n',sysdate,13);
insert into t1 values(3,null,sysdate,null);
commit;

  ⑥ DateTest 类(测试时间转换)

package com.date;

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.Statement;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;

public class DateTest {
	public static void main(String[] args) {
		Date date = new Date(System.currentTimeMillis());
		 System.out.println(date);
		java.util.Date date2 = new java.util.Date(System.currentTimeMillis());
		 System.out.println(date2);

		SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
		String a = sdf.format(date2);
		System.out.println(a);

		Timestamp t = new Timestamp(System.currentTimeMillis());

		String b = sdf.format(t);
		System.out.println(b);

		Calendar c = Calendar.getInstance();

		c.setTime(date);
		System.out.println(c.get(Calendar.MONTH));

		String ss = "1898-12-12 09:08:23";
		Timestamp t2 = Timestamp.valueOf(ss);
		System.out.println(t2);
		java.util.Date d1 = new java.util.Date();
		SimpleDateFormat q = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
		System.out.println(q.format(d1));
		java.sql.Date date3=new java.sql.Date(0);
		
		java.util.Date d2=new java.util.Date (date.getTime());
		
		Date sqlDate = new Date(date.getTime());
		java.util.Date d3 = new java.util.Date(sqlDate.getTime());
		System.out.println("utl获得秒数  "+d3.getSeconds());
		DateTest.getSqlDate();
	}
	public static void getSqlDate(){
		Connection con = DateTest.getConnection();
		ResultSet rs = null;
		PreparedStatement ps= null;
		try {
			 ps = con.prepareStatement("select * from t1 t where t.id = 1");
			 rs = ps.executeQuery();
			while (rs.next()) {
				java.sql.Date sqlDate = rs.getDate(3);
				java.util.Date utlDate = rs.getDate(3);
				Timestamp tDate = rs.getTimestamp(3);
				System.out.println("sqlDate  "+sqlDate);
				System.out.println("utlDate  "+utlDate);
				System.out.println("tDate  "+tDate);
				java.util.Date Date2 = new java.util.Date(sqlDate.getTime());
				System.out.println(Date2);
			}
		} catch (Exception e) {
		}finally{
			DateTest.closeJdbc(rs, con, ps);
		}
	}
	public static Connection getConnection(){
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
			String userName = "slt_plat";
			String passWord = "slt_plat";
			conn = DriverManager.getConnection(url, userName, passWord);
		} catch (Exception e) {
			e.printStackTrace();
		} 
		return conn;
	}
	public static void closeJdbc(ResultSet rs,Connection con,Statement pst){
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(con!=null){
			try {
				con.close();
			} catch (SQLException e) {
			}
		}
		if(pst!=null){
			try {
				pst.close();
			} catch (SQLException e) {
			}
		}
	}

}

2.数据库配置对应Date
  ① @Temporal(TemporalType.DATE)数据库只记录日期
  ② 字段中的Date的类型必须是java.uril.Date,如果是sql.Date时间精度设置无效
  ③ @Enumerated(EnumType.STRING)枚举存入数据库以String存入,EnumType.ORDINAL存入为枚举
  ④ 枚举Titl 类

package com.sf;

public enum Tile {
A,B,C
}

  ⑤ Entity

package com.sf;

import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity(name="teacher")
@Table(name = "teacher", catalog = "lportal")
public class Teacher {
@Id
/*
 * @GeneratedValue = native auto自动生成;
 */
@GeneratedValue
private int id;
private String name;
private String title;
/*
 * @Enumerated(EnumType.STRING)自定义类型;
 */
@Enumerated(EnumType.ORDINAL)
private Tile tile;
/**
 * @Temporal(value=)value可以默认不写,直接写入值;
 * @Temporal(TemporalType.DATE)数据库只记录日期;
 * java.sql.Date 时间精度只有日期,没有时间,下面的Date如果用这个类,时间精度设置无效;
 */

private Date birthDate;
@Temporal(TemporalType.TIME)
public Date getBirthDate() {
	return birthDate;
}
public void setBirthDate(Date birthDate) {
	this.birthDate = birthDate;
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getTitle() {
	return title;
}
public void setTitle(String title) {
	this.title = title;
}

public Tile getTile() {
	return tile;
}
public void setTile(Tile tile) {
	this.tile = tile;
}
public Teacher() {
}
public Teacher(int id,Date date, String name, String title,Tile tile) {
	this.id = id;
	this.name = name;
	this.title = title;
	this.tile = tile;
	this.birthDate = date;
}
}