< contentType="text/html;charset=gb2312"%>
< import="java.sql.*"%>
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:数据库id";
String user="用户名";
String password="密码";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select xm,cj from student "; //sql语句
ResultSet rs=stmt.executeQuery(sql); //执行
%>第一个字段内容为:
第二个字段内容为:
stmt.close();
conn.close();
%>
[@more@]