conn.jsp

用jsp和Oracle数据库写的一个论坛系统

<%@ page contentType="text/html;charset=gb2312"%> 

<%@ page import="java.sql.*"%> 

<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 

String url="jdbc:oracle:thin:@localhost:1521:pp"; 

//orcl为你的数据库的SID 

String user="system"; 

String password="manager"; 

Connection conn= DriverManager.getConnection(url,user,password); 

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 

%>