java - 使用 Eclipse 连接数据库 Oracle 11G () 的问题 :

Question

package oracleDBconnexion;

import java.sql.*;
public class jdbcConnexion {

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        try {
           Class.forName("oracle.jdbc.driver.OracleDriver");
           Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:iliassalilou","system","system");
           Statement st =con.createStatement();
           String  sql="select from DEPT *";
           ResultSet rs=st.executeQuery(sql);
           while (rs.next()) {
             System.out.println(rs.getInt(1)+" "+ rs.getString(2)+" "+rs.getInt(3)+" "+rs.getString(4)+" "+rs.getString(5));  
           }
           con.close();
        }
        catch(Exception e) {
            System.out.println(e);
            }
        }

}

在控制台中:

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Answer 1

您的 SQL 语法错误。 * 通配符应位于选择列表中:

String sql = "select * from DEPT";
// Here -------------^