我正在嘗試學(xué)習(xí)連接到oracle數(shù)據(jù)庫(kù)當(dāng)我以這種方式登錄 sqlplus 時(shí)：sqlplus sys/Oracle_1@orcl as sysdba;我運(yùn)行這段代碼：connect hr/hr@orclpdbselect count(*) from employees;我得到這個(gè)輸出： COUNT(*)---------- 107但是當(dāng)我嘗試在 java 代碼中訪問該表時(shí)，出現(xiàn)此錯(cuò)誤：ORA-00942: table or view does not exist這是我的java代碼：class OracleCon{ public static void main(String args[]){ try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection( "jdbc:oracle:thin:hr/hr@localhost:1521/orclpdb","sys as sysdba","Oracle_1"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select count(*) from employees"); while(rs.next()) System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)); con.close(); }catch(Exception e){ System.out.println(e);} } } 我應(yīng)該怎么做才能解決這個(gè)問題？
2 回答
斯蒂芬大帝
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超8個(gè)贊
您正在嘗試使用 java 代碼中的用戶連接它sys，但表employee存在于hr架構(gòu)中。
您可以更改：
//Change this line from
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:hr/hr@localhost:1521/orclpdb","sys as sysdba","Oracle_1");
// to
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:hr/hr@localhost:1521/orclpdb","hr","hr");
或者
您可以更改從表中獲取數(shù)據(jù)的方式employee（使用其架構(gòu)查詢表）
//Change this line from
ResultSet rs=stmt.executeQuery("select count(*) from employees");
//to
ResultSet rs=stmt.executeQuery("select count(*) from hr.employees");
干杯！！
幕布斯7119047
TA貢獻(xiàn)1794條經(jīng)驗(yàn) 獲得超8個(gè)贊
請(qǐng)嘗試一下這段代碼。它必須工作
public static void conn() throws ClassNotFoundException, SQLException{
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orclpdb", "HR", "HR");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select count(*) from dual");
while(rs.next())
System.out.println(rs.getInt(1));
con.close();
}
添加回答
舉報(bào)
0/150
提交
取消