var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-20738293-1']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script')"/>
jutleo
欢迎走进有风的地方~~
posts - 63,  comments - 279,  trackbacks - 0
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();
                }

            }

    }

}

/*
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| date     | date     | YES  |     | NULL    |       |
| time     | time     | YES  |     | NULL    |       |
| datetime | datetime | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
 
*/

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

只有注册用户登录后才能发表评论。


网站导航:
 

<2007年12月>
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

常用链接

留言簿(11)

我参与的团队

随笔分类

随笔档案

文章分类

文章档案

新闻分类

新闻档案

收藏夹

围脖

最新随笔

搜索

  •  

最新评论

阅读排行榜

评论排行榜