package DAO;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.sql.Timestamp;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Date;

public class TestDate {

	public static void main(String[] args) throws Exception{

		Class.forName("com.mysql.jdbc.Driver").newInstance();

		Connection conn =  DriverManager.getConnection("jdbc:mysql://109.110.100.56/tsdr_project?user=root");

		Statement stmt=conn.createStatement();

		ResultSet rs =  stmt.executeQuery("select distinct UpdateTime from defects_infor_daily");

		while(rs.next()){

			Date d = rs.getDate("UpdateTime");

			Timestamp ts=rs.getTimestamp("UpdateTime");

			//SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");

			SimpleDateFormat sdf = new SimpleDateFormat("yyyy.MM.dd G 'at' HH:mm:ss z");

			System.out.println(sdf.format(d));  //2016.04.11 公元 at 00:00:00 CST

			System.out.println(sdf.format(ts));  //2016.04.11 公元 at 07:30:35 CST

			Calendar c= Calendar.getInstance();

			c.setTime(d);

			System.out.println(c.get(Calendar.MONTH));	 //3

		}

		rs.close();

		stmt.close();

		conn.close();

	}

}

package DAO;

import java.sql.Timestamp;

import java.util.Calendar;

import java.util.Date;

import java.util.GregorianCalendar;

import java.util.TimeZone;

public class TestDateAndTime {

	public static void main(String[] args) throws Exception{

		System.out.println(System.currentTimeMillis());   //1460360597062

		Date d = new Date();

		System.out.println(d);  //Mon Apr 11 15:43:17 CST 2016

		Calendar c = Calendar.getInstance();

		System.out.println(c.get(Calendar.YEAR));   //2016

		String s = "1970-12-30 08:24:37.0";

		Timestamp ts = Timestamp.valueOf(s);

		System.out.println(ts);     //1970-12-30 08:24:37.0

		Calendar cts = Calendar.getInstance();

		cts.setTime(ts);

		System.out.println(cts.get(Calendar.MONTH)+1);   //12

		Calendar cJapan = new GregorianCalendar(TimeZone.getTimeZone("Japan"));   //参数是日本的时区

		System.out.println(cJapan.get(Calendar.HOUR_OF_DAY));  //16  比中国晚1个小时

		for(String str:TimeZone.getAvailableIDs()){

			System.out.println(str);          //显示所有时区, 替代Japan

		}

	}

}