JavaScript 連Oracle 10.3

尚未使用過Jsp 連結Oracle 記錄備查
jsp需引進import="java.sql.*,oracle.jdbc.*"

ResultSet rs = null;
String oracleURL="jdbc:oracle:thin:@IP位置:PORT:SID";
String oracleUser="*****";
String oraclePWD="*****";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}catch (SQLException e){
out.print("Driver Error");
}
try {
Connection conn = DriverManager.getConnection(oracleURL,oracleUser,oraclePWD);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select sysdate from dual");

while(rs.next()) {
%>
now :<%=new String(rs.getString(1)) %>  
<%
}
out.print("connection Success !!!");
stmt.close();
conn.close();
}catch (SQLException ce){
System.out.print(ce);
}