import java.sql.*;

class Oracle_Basic_Test1 {

    public static void main(String argv[]) throws ClassNotFoundException , SQLException{
            Class.forName("oracle.jdbc.driver.OracleDriver");

            Connection con =  DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "user08", "1111");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT empno,ename,job,to_char(hiredate,'yyyy-mm-dd') hiredate,sal,comm,deptno FROM emp2 order by empno");

            //基礎的-資料庫取值應注意事項:
            while (rs.next()) {
                //欄位型態- date:
                //String str4 = rs.getString(4);       //【Oracle查詢未用to_char時, 會有1981-11-17 00:00:00.0的結果】
                //Object str4 = rs.getObject(4);       //【Oracle查詢未用to_char時, 會有1981-11-17 00:00:00.0 或 1981-11-17的結果】
                //java.sql.Date str4 = rs.getDate(4);  //【1981-11-17  ●注意: 是java.sql.Date】
                java.util.Date str4 = rs.getDate(4);   //【1981-11-17  ●OK , why??】
                //java.sql.Date str4 = rs.getDate(4);

                System.out.println(" HIREDATE= " + str4);
            }

            rs.close();
            stmt.close();
            con.close();

    }
}