数据库查询操作
<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*"%>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "system", "123456789");
// Statement stmt = conn.createStatement();
//String sql="select * from student";
Statement stmt = conn.createStatement(); //注意Statement与PreparedStatement的区别
String sql="select * from student";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
<table>
<tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.