java数据库日期处理用法
JDBC日期处理用法详解,可以作为一个连接JDBC的标准类<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee;">http://www.blogjava.net/Images/OutliningIndicators/None.gifpackage JDBC;http://www.blogjava.net/Images/OutliningIndicators/None.gif
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.Connection;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.Date;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.ResultSet;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.SQLException;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.DriverManager;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.Statement;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.Time;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.sql.Timestamp;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.text.SimpleDateFormat;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.util.Calendar;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif/** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @author oakertree
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gifpublic class TestJDBCDate http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif public static void main(String[] args) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Connection con = null;
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Statement stmt = null;
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif ResultSet rs = null;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif try http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Class.forName("com.mysql.jdbc.Driver");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif// new com.mysql.jdbc.Driver();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "admini");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif stmt = con.createStatement();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif rs = stmt.executeQuery("SELECT * FROM time");
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif while(rs.next()) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /**//*
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Date d = rs.getDate("date");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif// SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif System.out.println(sdf.format(d));
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /**//*
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Time t = rs.getTime("time");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif SimpleDateFormat sdf = new SimpleDateFormat("HH时mm分ss秒");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif System.out.println(sdf.format(t));
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Date d = rs.getDate("datetime");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Time t = rs.getTime("datetime");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif SimpleDateFormat sdfdate = new SimpleDateFormat("yyyy年MM月dd日");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif SimpleDateFormat sdftime = new SimpleDateFormat("HH时mm分ss秒");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif System.out.println(sdfdate.format(d) + sdftime.format(t));
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /**//*
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Timestamp dt = rs.getTimestamp("datetime");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒");
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif System.out.println(sdf.format(dt));
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif //得到日期中的月
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /**//*
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Calendar c = Calendar.getInstance();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif c.setTime(d);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif System.out.println(c.get(Calendar.MONTH));
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif } catch (ClassNotFoundException e) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif e.printStackTrace();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif } catch (SQLException e) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif e.printStackTrace();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif } finally http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif try http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif if(rs != null) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif rs.close();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif rs = null;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif if(stmt != null) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif stmt.close();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif stmt = null;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif if(con != null) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif con.close();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif con = null;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif } catch (SQLException e) http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif e.printStackTrace();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif}
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif/**//*
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif+----------+----------+------+-----+---------+-------+
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif| Field | Type | Null | Key | Default | Extra |
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif+----------+----------+------+-----+---------+-------+
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif| date | date | YES | | NULL | |
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif| time | time | YES | | NULL | |
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif| datetime | datetime | YES | | NULL | |
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif+----------+----------+------+-----+---------+-------+
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/None.gif
页:
[1]