java数据库日期处理用法

JDBC日期处理用法详解,可以作为一个连接JDBC的标准类

package JDBC;

import java.sql.Connection;

import java.sql.Date;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.Time;

import java.sql.Timestamp;

import java.text.SimpleDateFormat;

import java.util.Calendar;

/**

* @author oakertree

public class TestJDBCDate {

public static void main(String[] args) {

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

try {

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

// new com.mysql.jdbc.Driver();

con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "admini");

stmt = con.createStatement();

rs = stmt.executeQuery("SELECT * FROM time");

while(rs.next()) {

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

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

System.out.println(sdf.format(d));

Time t = rs.getTime("time");

SimpleDateFormat sdf = new SimpleDateFormat("HH时mm分ss秒");

System.out.println(sdf.format(t));

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

Time t = rs.getTime("datetime");

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

SimpleDateFormat sdftime = new SimpleDateFormat("HH时mm分ss秒");

System.out.println(sdfdate.format(d) + sdftime.format(t));

Timestamp dt = rs.getTimestamp("datetime");

SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒");

System.out.println(sdf.format(dt));

//得到日期中的月

Calendar c = Calendar.getInstance();

c.setTime(d);

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

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} finally {

try {

if(rs != null) {

rs.close();

rs = null;

}

if(stmt != null) {

stmt.close();

stmt = null;

}

if(con != null) {

con.close();

con = null;

}

} catch (SQLException e) {

e.printStackTrace();

}

+----------+----------+------+-----+---------+-------+

+----------+----------+------+-----+---------+-------+

+----------+----------+------+-----+---------+-------+

posted on 2007-12-22 16:07 凌晨风阅读(283) 评论(0) 编辑收藏所属分类: Java学习笔记

常用链接

留言簿

我参与的团队

随笔分类

随笔档案

文章分类

文章档案

新闻分类

新闻档案

收藏夹

最新随笔

搜索

最新评论

阅读排行榜

评论排行榜