关于JDBC,如何执行嵌套数据库的查询

2025-05-15 10:18:50
推荐回答(1个)
回答1:

这个能通过了:
import java.sql.*;

class MyLogger {
public static void main(String args []){
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@172.18.8.4:1526:oracle9i", "scott", "tiger");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select * from eddie_fee");
while (rset.next ()){
String aa=rset.getString(1);
Statement stmt1 = conn.createStatement ();
ResultSet rset2 = stmt1.executeQuery ("select * from eddie_fee where name='" + aa+ "'" );
}
}
catch(Exception e)
{
System.out.print("error");
}
}
}