[Java] 日期处理 01 SimpleDataFormat 学习

来源：互联网发布：mac 程序编辑器编辑：程序博客网时间：2024/06/10 20:47

SimpleDataFormat Learning.

import java.sql.*;import java.text.SimpleDateFormat;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()) {                Date d = rs.getDate("pdate");                SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日"); // 重点在于自学的过程                System.out.println(sdf.format(d));            }        } 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