jsp页面连接oracle,JSP中连接oracle

首先在web-inf/lib下添加oracle数据库驱动class12.jar

appList = new ArrayList();         String app = "";         try{                 stmt = conn.createStatement();                   String sql = "select FEATURECODE from TBDICGISFEATURE where FEATUREID in (select FEATUREID from TBRELAPPFEATURE where APPID=8)";                   rs = stmt.executeQuery(sql);                   while(rs.next()) {                         app = rs.getString("FEATURECODE");                         appList.add(app);                         System.out.println(app);                 }         }catch(Exception e){                 System.out.print(e);         }finally{                 rs.close();                   stmt.close();                 conn.close();         }     %>