代理要先引入classes12.jar 文件
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import oracle.jdbc.driver.*;
public class JavaAgent extends AgentBase {
public void NotesMain() {
Connection sqlCon = null;
try {
Session session = getSession();
AgentContext agentContext = session.getAgentContext();
Database db = session.getCurrentDatabase();
Document doc = db.createDocument();
doc.replaceItemValue("Form", "Code");
// (Your code goes here)
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String strCon ="jdbc:oracle:thin:@Server Address:Port:DBName";
sqlCon = DriverManager.getConnection(strCon,UserName,Password);
CallableStatement cs = sqlCon.prepareCall("{call get_item_list1(?,?)}");
cs.setString(1,Par1);
cs.registerOutParameter(2,OracleTypes.CURSOR);
cs.executeQuery();
ResultSet rs = (ResultSet)cs.getObject(2);
String str = "";
while(rs.next()) {
str = str + ";" + rs.getString(1);
System.out.println(rs.getString(1));
}
System.out.println(str);
doc.replacedoc.replaceItemValue("Codes", rs.getString(1));
doc.save();
sqlCon.close();
} catch(SQLException e1){
e1.printStackTrace();
sqlCon.close();
}
} catch(Exception e) {
e.printStackTrace();
}
}
}
转载于:https://blog.51cto.com/subform/951337