BlogJava-Java Programing Language-最新评论http://www.blogjava.net/billzhang88169/CommentsRSS.aspxJava Onezh-cnThu, 25 Sep 2008 09:06:59 GMTThu, 25 Sep 2008 09:06:59 GMTcnblogsre: JAVA 连接MYSQLhttp://www.blogjava.net/billzhang88169/archive/2007/12/31/171633.html#171812凌晨风凌晨风Mon, 31 Dec 2007 02:21:00 GMThttp://www.blogjava.net/billzhang88169/archive/2007/12/31/171633.html#171812package 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 | |
+----------+----------+------+-----+---------+-------+
*/


凌晨风 2007-12-31 10:21 发表评论
]]>re: JAVA 连接MYSQLhttp://www.blogjava.net/billzhang88169/archive/2007/12/30/171633.html#171742梁文政梁文政Sun, 30 Dec 2007 10:56:00 GMThttp://www.blogjava.net/billzhang88169/archive/2007/12/30/171633.html#171742

梁文政 2007-12-30 18:56 发表评论
]]>re: JAVA 连接MYSQL[未登录]http://www.blogjava.net/billzhang88169/archive/2007/12/29/171633.html#171637xmlspyxmlspySat, 29 Dec 2007 14:58:00 GMThttp://www.blogjava.net/billzhang88169/archive/2007/12/29/171633.html#171637

xmlspy 2007-12-29 22:58 发表评论
]]>