在data Connection中看到只有odbc和ole db这样的方法,请问高手有没有用jdbc连接的方法啊?或者怎么来做?
------解决方案--------------------
简单示例:
import lotus.domino.*;
import java.sql.*;
public class JavaAgent extends AgentBase {
public void NotesMain() {
try {
Session session = getSession();
AgentContext agentContext = session.getAgentContext();
Database db = agentContext.getCurrentDatabase();
String sDBDriver = "oracle.jdbc.driver.OracleDriver ";
String sConnStr = "jdbc:oracle:oci8:[email protected] ";
java.sql.Connection conn=null;
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
Statement stm = conn.createStatement();
String sqlStr = "Select * from ITEM ";
ResultSet result = stm.executeQuery(sqlStr);
System.out.println(result.getString(1));
conn.close();
}
catch (Exception e)
{
System.out.println( "ERROR: "+e.getMessage());
}
}
}