connect_odbc.jsp

以JSP与TOMCAT数据库连接池实现的订餐系统

<%@page import="java.lang.*"%>
<%@page import="java.util.*, java.sql.*" %>
<jsp:useBean id="pool" scope="application" class="connection.ConnPool"/>

<%
  //2004.12.05

  int rankid=0;
  Connection con = null;
  ResultSet rs = null;
  Statement stmt = null;

  String sql = null;
  try{
      if (pool.getDriver()==null){
	    pool.setDriver("oracle.jdbc.driver.OracleDriver");
	    pool.setURL("jdbc:oracle:thin:@172.16.11.246:1521:runa");
		pool.setUsername("user");
		pool.setPassword("123");
	    pool.setSize(3);
	    pool.initializePool();
	  }
      con = pool.getConnection();
      stmt = con.createStatement();
	  }
	 catch(SQLException e){
	  out.println("error is happend");
      out.println(e.getMessage());
   	  }
%>