DOMINIO 访问 oracle数据库

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
public class DBConnectionManager
{

 private static DBConnectionManager dbc = null;

  
    public Connection getOraConn()
    {
        try
        {
         
         Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   //连接字符串，oratest为数据库的SID
   String url="jdbc:oracle:thin:@10.69.0.12:1521:f1wip01";
   //String url="jdbc:oracle:thin:@10.69.0.40:1521:wiptest";
   String username="fdt";
   String password="fdt";
   //获得连接
   Connection conn= DriverManager.getConnection(url,username,password);
   return conn;
        }
        catch (Exception ex)
        {
            System.out.println("get sql Connection failure : " + ex.getMessage());
        }
        return null;
    }
   
}

/*
代理中安全性等级要选择 2允许受限制的操作
MSSQL驱动包括三个包：msbase.jar、mssqlserver.jar、msutil.jar
在notes.ini中设置javaUserClasses=D:/Lotus/Domino/jvm/lib/jt400.jar;//AS400驱动
D:/Lotus/Domino/jvm/lib/classes12.jar;//Oracle驱动
D:/Lotus/Domino/jvm/lib/mssqlserver.jar;D:/Lotus/Domino/jvm/lib/msbase.jar;D:/Lotus/Domino/jvm/lib/msutil.jar;//SQL驱动
数据库操作完毕之后要释放资源，否则可能产生异常
*****Date:207-01-24****
测试程序的执行时间
long start=System.currentTimeMillis(); //获取最初时间
long end=System.currentTimeMillis(); //获取运行结束时间
System.out.println("程序运行时间： "+(end-start)+"ms");
*/
import lotus.domino.*;
import java.io.PrintWriter;
import java.sql.*;
import java.util.Date;
import java.text.*;
import java.util.*;

public class JavaAgent extends AgentBase {

 public void NotesMain()
 {
  
  try
  {
   Session session = getSession();
   AgentContext agentContext = session.getAgentContext();
   Database db = agentContext.getCurrentDatabase();
   Agent agent = agentContext.getCurrentAgent();
         
   Document doc =db.getDocumentByID(agent.getParameterDocID());
   //去掉可TEST
         
         
    String return_date=replace(doc.getItemValueString("mySelDate2")+" 00:00:00");
   String return_man=doc.getItemValueString("pwcCreatorNo").substring(1);
   String return_operator=doc.getItemValueString("AssignImplementNo").substring(1);
   String doc_no=doc.getItemValueString("pwcDocSeqNo");
   
   //String PanelID=doc.getItemValueString("PanelID");
   
   //split split1=new split();
   //String [] PanelIDarr=split1.split(PanelID,"*");
   
   DBConnectionManager  ora=new DBConnectionManager ();
   Connection conn=ora.getOraConn();
   conn.setAutoCommit(false);
       PreparedStatement pstm = null;
       String update_sql="update lend_input set trans_type='1',return_man=?,return_date=?,return_operator=? where doc_no=?";
       pstm = conn.prepareStatement(update_sql);
   
   try
   {
    pstm.setString(1,return_man);
    pstm.setString(2,return_date);
    pstm.setString(3,return_operator);
    pstm.setString(4,doc_no);
    //for(int i=0;i<PanelIDarr.length;i++)
    //{
    //pstm.setString(5,PanelIDarr[i]);
    pstm.executeUpdate();
    //}
    conn.commit();
             
   }
    
   catch (SQLException e)
   {
    try
    {

            //出现异常，回滚事务
     conn.rollback();
     conn.setAutoCommit(true);
    }
    catch (SQLException e1)
    {
     System.out.println(" rollback error!" + e1);
    
    }  
    e.printStackTrace();
   }
   finally
   {
    try
        {
         if (pstm != null){pstm.close();pstm = null;}
         if (conn != null){conn.close();conn = null;}
     if(doc!=null){doc.recycle();doc=null;}
     if(agent!=null){agent.recycle();agent=null;}
     if(db!=null){db.recycle();db=null;}
     if(db!=null){db.recycle();db=null;}
        }
        catch (Exception e)
        {
         System.out.println("关闭数据库连接失败 : " +e.getMessage());
        }
          }
  }
   
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }