jsp用thin模式连接Oracle数据库，thinoracle,<%@ page con
分享于 点击 17323 次 点评：273
jsp用thin模式连接Oracle数据库，thinoracle,<%@ page con
<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html> <body> <% Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为你的数据库的SID String user = "scott"; String password = "tiger"; Connection conn = DriverManager.getConnection(url, user, password); Statement stmt = conn .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from test"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { %> 您的第一个字段内容为：<%=rs.getString(1)%> 您的第二个字段内容为：<%=rs.getString(2)%> <% } %> <% out.print("数据库操作成功，恭喜你"); %> <% rs.close(); stmt.close(); conn.close(); %> </body></html>
用户点评