将查询结果放入表格
我想要将查询的结果放入表格,大家帮帮我看看错在哪!
Conn.java
package sqlconn;
import java.sql.*;
import java.lang.*;
import java.util.*;
public class Conn
{
String sDBDriver="oracle.jdbc.driver.OracleDriver";
String sConnStr ="jdbc:oracle:thin:@10.1.25.22:1521:jwjc;user=jwjc;password=wanyue";
Connection conn=null;
ResultSet rs=null;
public Conn()
{
try {
Class.forName(sDBDriver);
}
catch(ClassNotFoundException e)
{
System.out.println("无法建立数据库连接!:"+e.getMessage());
}
}
public void executeUpdate(String sql) throws Exception
{
sql= new String(sql.getBytes("GBK"),"ISO8859_1");
try
{
conn= DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
stmt.close();
}
catch(SQLException ex)
{
System.out.println("更新数据操作失败!"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql) throws Exception
{
rs = null;
try
{
sql= new String(sql.getBytes("GBK"),"ISO8859_1");
conn= DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
conn.close();
stmt.close();
}
catch(SQLException ex)
{
System.out.println("执行查询出错!"+ex.getMessage());
}
return rs;
}
}
test.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*;" %>
<jsp:useBean id="Conn" scope="page" class="sqlconn.Conn"/>
<html>
<head>
<title>
test
</title>
<link rel=stylesheet
href="JSP-Styles.css"
type="text/css"
</head>
<body>
<table>
<%
String sql= "select * from jwjc";
ResultSet rs=Conn.executeQuery(sql);
while(rs.next())
{
out.println("<tr><td>"+rs.getString(1)+"</td>"+"<td>"+rs.getString(2)+"</td>"+"<td>"+rs.getString(3)+"</td></tr>");
}
rs.close();
%>
</table>
</body>
</html>
运行后报错:"test.jsp": Error #: 202 : 'class' or 'interface' expected