Oracle 调用 Java 代码过程
步骤一:
【加载 DB2 数据库的 JDBC 驱动程序至 Oracle 数据库服务器中】
loadjava -r -f -verbose -genmissing -user DGSBKF_GGYW/a
/ora10g/oracle/product/10.2.5/lib/db2jcc.jar
(参考 https://forums.oracle.com/forums/thread.jspa?threadID=293096&tstart=-
1)
步骤二:
【编写 Java 代码】
create or replace and compile java source named connect_2_db2 as
importjava.sql.*;
publicclassUtil2DB2 {
publicstaticfinalString CLASS_FOR_NAME ="com.ibm.db2.jcc.DB2Driver";
publicstaticfinalString URL ="jdbc:db2://192.168.14.11:50007/jmsbsj";
publicstaticfinalString USER ="jmkfybdy";
publicstaticfinalString PASSWORD ="a";
publicstaticvoidentry() {
}
publicstaticString queryJyxx(String args) {
String result ="";
try{
Class.forName(CLASS_FOR_NAME).newInstance();
Connection conn = DriverManager.getConnection(URL, USER,
PASSWORD);
Statement ps = conn.createStatement();
String sql ="select aac002 from ac01 where aac001 in ("+ args
+")";
ResultSet rs = ps.executeQuery(sql);
while(rs.next()) {
result = result +","+ rs.getString("aac002");
}
rs.close();
ps.close();
conn.close();
returnresult;
}catch(Exception ex) {
returnex.toString();
}
}
评论1