jsp数据库连大全.docVIP

一、jsp连接Oracle8/8i/9i数据库（用thin模式）testOracle.jsp如下： %@ page contentType=text/html;charset=gb2312%%@ page import=java.sql.*%%????String result = ; // 查询结果字符串????String sql = select * from test; // SQL 字符串????// 连接字符串，格式： jdbc:数据库驱动名称:连接模式:@数据库服务器ip:端口号:数据库SID????String url = jdbc:oracle:thin:@localhost:1521:orcl;????String username = scott; // 用户名????String password = tiger; //密码????// 创建oracle数据库驱动实例????Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();????// 获得与数据库的连接????Connection conn = DriverManager.getConnection(url, username, password);?????// 创建执行语句对象????Statement??stmt = conn.createStatement();????// 执行sql语句，返回结果集????ResultSet? rs?? = stmt.executeQuery(sql);????while ( rs.next() ) ????{????????result += \n 第一个字段内容： + rs.getString(1) + BR;????}????rs.close();?// 关闭结果集????stmt.close(); // 关闭执行语句对象????conn.close(); // 关闭与数据库的连接%HTMLBODY??%=result%/BODY/HTML 二、jsp连接Sql Server7.0/2000数据库testSqlServer.jsp如下 %@ page contentType=text/html;charset=gb2312%%@ page import=java.sql.*%%????String sql = select * from test;????// 连接字符串，格式： jdbc:公司名称:数据库驱动名称://数据库服务器ip:端口号;DatabaseName=数据库名称????String url = jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;????String username = scott;????String password = tiger;????Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInstance();????Connection conn = DriverManager.getConnection(url, username, password);?????Statement??stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);????ResultSet? rs?? = stmt.executeQuery(sql);%HTMLBODY% ????while ( rs.next() ) ????{????????%????????第一个字段内容为：%=rs.getStrisng(1)%BR????????%????}????rs.close();????stmt.close();????conn.close();%/BODY/HTML 三、jsp连接DB2数据库testDB2.jsp如下： %@ page contentType=text/html;charset=gb2312%%@ page import=java.sql.*%%????String sql = select * from test;????// 连接字符串，格式： jdbc:数据库驱动名称://数据库服务器ip:端口号/数据库名称????String url = jdbc: