connectoracle.jsp

JSP课件以及一个网上书店系统程序,带数据库

<!--connectOracle.jsp-->
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%
  Connection conn=null;
  try{
  //加载JDBC驱动程序
  Class.forName("oracle.jdbc.driver.OracleDriver");
  //建立连接
  String URL = "jdbc:oracle:thin:@192.168.0.50:1521:oraGloba";
  conn = DriverManager.getConnection(URL,"SYSMAN","oracle10g");
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
  ResultSet rs=stmt.executeQuery("select * from  emp");
  if(!conn.isClosed())out.print("已成功连接oracle数据库<br>");
  while(rs.next()){%>
     员工姓名：<%=rs.getString(2)%>
	 员工职务：<%=rs.getString(3)%><br>
  <%}
  rs.close();
  stmt.close();   
  }
  catch(ClassNotFoundException ex){
     out.println(ex.getMessage());
  }
  catch(SQLException ex){
     out.println(ex.getMessage());
  }
  finally{
    //总是会关闭连接
    try{
      if(conn!=null)
      conn.close();
    }
    catch(Exception ex){
    }
  }
%>