清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | <%@ 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> |