package jdbc;
import java.sql.*;
import java.text.SimpleDateFormat;
public class Ex02 {
public static void main(String[] args) throws Exception{
String sql = "select sysdate from dual";
String driverName = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.1.100:1521:xe";
String user = "c##itbank";
String password = "it";
Date today = null;
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
today = rs.getDate("sysdate");
}
SimpleDateFormat sdf = new SimpleDateFormat("yyyy년 MM월 dd일 a hh시 mm분 ss초");
String result = sdf.format(today);
long ln = today.getTime();
System.out.println(ln);
System.out.println(result);
rs.close();
stmt.close();
conn.close();
}
}