[Java] 日期处理 03 Timestamp

来源：互联网发布：隆逸优化作品编辑：程序博客网时间：2024/06/05 15:59
Timestamp
import java.sql.*;import java.text.SimpleDateFormat;import java.util.Calendar;public class TestDate {    public static void main(String[] args) {        Connection conn = null;        Statement stmt = null;        ResultSet rs = null;        try {            Class.forName("com.mysql.jdbc.Driver");            conn = DriverManager                    .getConnection("jdbc:mysql://localhost/bbs?user=root&password=root");            stmt = conn.createStatement();            rs = stmt.executeQuery("select pdate from article");            while (rs.next()) {                Timestamp ts = rs.getTimestamp("pdate");                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 重点在于自学的过程                System.out.println(sdf.format(ts));            }        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException ex) {            // handle any errors            System.out.println("SQLException: " + ex.getMessage());            System.out.println("SQLState: " + ex.getSQLState());            System.out.println("VendorError: " + ex.getErrorCode());        } finally {            try {                if(rs != null) {                    rs.close();                    rs = null;                }                if(stmt != null) {                    stmt.close();                    stmt = null;                }                if(conn != null) {                    conn.close();                    conn = null;                }            } catch (SQLException e) {                e.printStackTrace();            }        }    }}
0 0