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();
}
}