在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();
	}
	
	}
%>

大概就这样吧