connectoracle2.jsp

来自「JSP课件以及一个网上书店系统程序,带数据库」· JSP 代码 · 共 27 行

<!--connectOracle2.jsp-->
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%
  Connection conn=null;
  try{
     //加载JDBC-ODBC桥驱动程序
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     //建立连接
     String URL = "jdbc:odbc:myOracleDb";
     conn = DriverManager.getConnection(URL,"SYSMAN","oracle10g");
     if(!conn.isClosed())out.print("已成功连接oracle数据库<br>");
  }
  catch(SQLException ex){
  out.println(ex.getMessage());
  }
  finally{
    //总是会关闭连接
    try{
      if(conn!=null)
      conn.close();
    }
    catch(Exception ex){
    }
  }
%>