一个关于struts的离奇问题~~在线等

Question

ResultSet rs=db.executeQuery(sql);？？？你的db是什么？是Connection，不是Statement or PreparedStatement

Answer 1

这是我的db。
package javabean;import java.sql.*;public class dbconnect
{    static String serverName;
    static String sDBDriver;
    static String sConnStr;
    Connection con=null;
    ResultSet rs;    public dbconnect()
    {
        serverName = "211.67.55.208";
        sDBDriver = "oracle.jdbc.driver.OracleDriver";
        sConnStr = "jdbc:oracle:thin:@" + serverName + ":1521:dbora04";
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println(classnotfoundexception.getMessage());
        }
    }    public ResultSet executeQuery(String sql)
    {
        try
        {
            con =java.sql.DriverManager.getConnection(sConnStr, "system", "oracle");
            Statement statement = con.createStatement();
            rs = statement.executeQuery(sql);
        }
        catch(SQLException sqlexception)
        {
            System.err.println(sqlexception.getMessage());
        }
        return rs;
    }}