在jsp中用jdbc连接数据库

<%@ page import="java.sql.*,java.util.*"%><%!private static String driverName = "oracle.jdbc.driver.OracleDriver";private static String url = "jdbc:oracle:thin:@172.16.1.97:1521:ora9";private static String userName = "account";private static String passwordName = "test";%><%Class.forName(driverName).newInstance();    Connection conn= DriverManager.getConnection(url,userName,passwordName);try{Statement stmt=conn.createStatement(); String sql= "select * from table ";ResultSet rs=stmt.executeQuery(sql);while(rs.next()){String id = rs.getString(1);.......}catch(Exception e){out.write("");}finally{rs.close();stmt.close();coon.close();}}%>

大概就这样吧