java - 在 oracle 10g 快速版中获取 ClassCastException。

Question

我正在尝试连接到数据库表并获取java.lang.ClassCastException: oracle.jdbc.driver.T4CStatement cannot be cast to java.beans.Statement在 oracle 10g express edition 中

        Class.forName("oracle.jdbc.driver.OracleDriver");
        System.out.println("Driver loaded.");

        Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","toushif");
        System.out.println("Connection Established.");
        String sql = "SELECT * FROM  TOUSHIF";

        Statement st = (Statement) con.createStatement();
        ResultSet rs = ((java.sql.Statement) st).executeQuery(sql);

        while(rs.next())
        {
            System.out.println(rs.getString(1));
        }

Answer 1

con.createStatement() 应该返回 java.sql.Statement 而不是 java.beans.Statement 的实现。

也许您导入了 java.beans.Statement 而不是 java.sql.Statement 导致转换失败？