jsp用thin模式连接Oracle数据库

<%@ 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>
热门搜索

jsp用thin模式连接Oracle数据库
