当前页面: 开发资料首页 → JSP 专题 → 快速測試 Tomcat + Oracle 9i + JSP
摘要: 快速測試 Tomcat + Oracle 9i + JSP
<%
ResultSet rs = null;
String oracleURL="jdbc:oracle:thin:@Oracle主機ip:1521:SID";
String oracleUser="HR";
String oraclePass="xxxx";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}
catch (SQLException e){
out.print("Driver Error"); }
try {
Connection conn = DriverManager.getConnection(oracleURL,oracleUser,oraclePass); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from EMPLOYEES");
rs.last();
out.print("HR資料庫中有員工"+rs.getRow()+"個");
rs.close();
stmt.close();
conn.close();
}
catch (SQLException ce){
System.out.print(ce);
}
%>
</body>
將JSP檔案存成test.jsp放在 \webapps\examples\ 裡面
測試結果 http://localhost:8080/examples/test.jsp
(很懶惰所以把Driver還有jsp都放在examples底下,如果您會部署webapp請自行更改)