- package com.zhc;
- import java.sql.Timestamp;
- import java.util.Calendar;
- import java.util.Date;
- import java.util.GregorianCalendar;
- import java.util.TimeZone;
- public class TestCalender {
- /**
- * @zhc
- * 日期类测试
- */
- public static void main(String[] args) {
- //java得到当前时间的方式
- //1.拿到当前系统的时间点,距1970年以后的秒数
- System.out.println(System.currentTimeMillis());
- //2.用Date类直接来取得时间
- Date date = new Date();
- System.out.println(date);
- //3.用Calendar日历类
- Calendar cal = Calendar.getInstance();
- int d =cal.get(Calendar.DATE);//通过各种方法拿到时间元素
- System.out.println(d);//打印日期
- //Calendar类中月份从0开始,当前月份得加1
- //把Date类型转换为Calendar类型
- Date date1 = new Date();
- Calendar cal1 = Calendar.getInstance();
- cal1.setTime(date1);//日期类拿到了date类的时间
- System.out.println(cal1.get(Calendar.DATE));
- //将字符转换为日期
- String s = "1970-12-30 08:24:37.0";
- //将一个字符串格式化为Date类型的数
- Timestamp ts = Timestamp.valueOf(s);
- System.out.println(ts);//接着可以用Calendar来进一步格式化
- //带时区的时间获得
- Calendar cal2 = new GregorianCalendar(TimeZone.getTimeZone("Japan"));
- System.out.println(cal2.get(Calendar.HOUR_OF_DAY));
- //得到世界时区TimeZone.getAvailableIDs();
- //java.util.Date 类 分三个分支
- //1.用于跟数据库打交道的三个类java.sql.Date java.sql.Time java.sql.Timestamp
- //2.用户格式化日期的 java.text.DateFormat java.text.SimpleDateFormat
- //3.日历类.用户格式化日期 java.util.Canlendar java.util.TimeZone java.util.GregorianCanlendar
- }
- }
- package com.zhc;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.text.DateFormat;
- import java.text.SimpleDateFormat;
- import java.util.Date;
- /**
- *
- * @author zhc
- * 测试日期类
- */
- public class TestData {
- public static void main(String[] args) {
- new TestData().testdate();
- System.out.println(new Date());
- String str = DateFormat.getDateInstance().format(new Date());
- System.out.println(str);
- }
- public void testdate(){
- String url = "jdbc:mysql://localhost:3306/fyiweb";
- String user = "root";
- String password = "";
- Connection con =null;
- ResultSet rs = null;
- Statement stmt = null;
- //String sql = "select create_time from common_topic;";
- //用count来计数
- //String sql = "select count(create_time) as mycount from common_topic";
- String sql = "select create_time from common_topic;";
- try {
- Class.forName("org.gjt.mm.mysql.Driver");
- con = DriverManager.getConnection(url,user,password);
- stmt =con.createStatement();
- rs = stmt.executeQuery(sql);
- while(rs.next()){
- Date date = rs.getTimestamp("create_time");
- //按照自己的格式打印时间
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒");
- System.out.println(sdf.format(date));
- //从数据库中读取的日期.如果用Date类型表示只能有日期.没有时间
- //应该用TimeStamp类来表示 用rs.getTimestamp("create_time");方法
- //打印select count的计数
- //System.out.println(rs.getInt("mycount"));
- }
- } catch (ClassNotFoundException e) {
- System.out.println("没有找到驱动文件");
- System.out.println(e.getMessage());
- } catch (SQLException e) {
- System.out.println("实例化连接错误");
- System.out.println(e.getMessage());
- //e.printStackTrace();
- }finally{
- try {
- if(rs!=null){rs.close();}
- if(con!=null){con.close();}
- if(stmt!=null){stmt.close();}
- } catch (SQLException e) {
- System.out.println("数据库关闭错误");
- }
- }
- }
- }