最典型的链接语句，写这里，方便查找
import java.sql.Connection;import java.sql.Date;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.Time;public class TestDate { /** * @param args */ public static void main(String[] args) { Connection conn = null; Statement stmt = null; ResultSet rs = null; String url = new String("jdbc:mysql://localhost:3306/BLOG_MUTIL_FUNCTION"); String sql = new String("select M_PUBLISH_TIME from Message where ID =1"); try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(url, "root", "mysql" ); stmt = conn.createStatement(); rs=stmt.executeQuery(sql); String dateStr = null; if(rs.next()) { dateStr = rs.getString("M_PUBLISH_TIME"); } dateStr = dateStr.substring(0, dateStr.lastIndexOf(".")); System.out.println(dateStr); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException se) { // TODO Auto-generated catch block se.printStackTrace(); } }}
相关资源：JDBCAPI数据库编程实作教材
