1.OLEDB,协议webservice
lr_db_connect("StepName=aaaa",
//connextionSring中,data source 是在
oracle中配置的oracle网路服务名称,userid:用户名,passowrd:密码
"ConnectionString=Provider=OraOLEDB.Oracle.1;Data Source=TEST211; Persist Security Info=True; User ID=test; Password=test",
"ConnectionName=db1",
"ConnectionType=OLEDB", LAST );
//此部分可以单独放到init中
lr_db_executeSQLStatement("StepName=PerformQuery",
//connectionName与lr_db_connect中要相同
"ConnectionName=db1",
"SQLStatement=select * from table",
"DatasetName=ORCL",//所连接的oracle的示例名称
LAST );
2.java vuser,jdbc链接,oci8
/*
*
* Script. Description:
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.UUID;
import lrapi.lr;
public class Actions
{
private Connection conn;
public int init() throws Throwable {
Class.forName("oracle.jdbc.driver.OracleDriver");
//jdbc链接 classes12-10.2.0.1.0.jar//this.conn = DriverManager.getConnection("jdbc:oracle:thin:@172.16.13.228:1521:orcl", "test", "test");
//oci8链接方式ojdbc5.jar
this.conn = DriverManager.getConnection("jdbc:oracle:oci8:@test228", "test", "test");
return 0;
}//end of init
public int action() throws Throwable {
insert(this.conn);
return 0;
}//end of action
public int end() throws Throwable {
conn.close();
return 0;
}//end of end
public static void insert(Connection conn) throws SQLException{
long begin = System.currentTimeMillis();
PreparedStatement psmt = null;
try{
psmt = conn.prepareStatement("insert into t_cert (CERTSN ,subject,notbefore,notafter,ctml_name,CERTSTATUS,OLDCERTSN,ENCCERTSN, signCertEntity,encCertEntity) values (?,?,?,?,?,?,?,?,?,?)");
psmt.setString(1, "<NO1>-<NO2>-<time>-<NO2>");
psmt.setString(2, "subject");
psmt.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
psmt.setTimestamp(4, new Timestamp(System.currentTimeMillis()));
psmt.setString(5, "ctml_name");
psmt.setString(6, "CERTSTATUS");
psmt.setString(7, "OLDCERTSN");
psmt.setString(8, "ENCCERTSN");
psmt.setString(9, "signCertEntity");
psmt.setString(10, "encCertEntity");
psmt.executeUpdate();
System.out.println( (System.currentTimeMillis() - begin));
}finally{
if(psmt != null){
try{
psmt.close();
}catch(SQLException ex){
}
}
}
}
}
3.ODBC
include "lrd.h"
static LRD_INIT_INFO InitInfo = {LRD_INIT_INFO_EYECAT};
static LRD_DEFAULT_DB_VERSION DBTypeVersion[] =
{
{LRD_DBTYPE_ODBC, LRD_DBVERSION_ODBC_30},
{LRD_DBTYPE_NONE, LRD_DBVERSION_NONE}
};
static LRD_CONTEXT FAR * Ctx1;
static LRD_CONNECTION FAR * Con1;
static LRD_CURSOR FAR * Csr1;
unsigned long row_count=0;
vuser_init()
{
lrd_init(&InitInfo,DBTypeVersion);
lrd_open_context(&Ctx1,LRD_DBTYPE_ODBC,0,0,0);
lrd_alloc_connection(&Con1,LRD_DBTYPE_ODBC,Ctx1,0,0);
lrd_open_connection(&Con1,LRD_DBTYPE_ODBC,"","","","DRIVER=Microsoft ODBC for Oracle;Server=test228;Uid=test;Pwd=test;",Ctx1,1,0);
//lrd_open_connection(&Con1,LRD_DBTYPE_ODBC,"","","","DRIVER=Oracle in OraDb11g_home2;Server=test2282;Uid=test;Pwd=test;",Ctx1,1,0);
lrd_open_cursor(&Csr1,Con1,0);
}
#include "lrd.h"
Action()
{
lr_start_transaction("aa");
//lrd_stmt(Csr1,"insert into t_cert values('rrere5456445fdsfdsfdsfd','CN=TES856618673095919436C=CN',sysdate,sysdate,'default','success','2cabb715-043a-41dd-8d4a-6abed92d3068','2cabb715-043a-41dd-8d4a-6abed92d3068','MIIBczCCARegAwIBAgIISSld5b7TQwwDAYIKoEcz1UBg3UFADA','MIIBczCCARegAwIBAgIISSld5b7T')",-1,1,0,0);
lrd_stmt(Csr1,"insert into t_cert values('{NO1}-{NO2}-{time}-{NO2}','CN=TEST_-856618673095919436 C=CN',sysdate,sysdate,'default','success','2cabb715-043a-41dd-8d4a-6abed92d3068','2cabb715-043a-41dd-8d4a-6abed92d3068','MIIBczCCARegAwIBAgIISSld5b7TQ/wwDAYIKoEcz1UBg3UFADAsMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMQ8wDQYDVQQDDAZERU1PQ0EwHhcNMTYwMjI5MTE0OTE4WhcNMTYwMzAzMTE0OTE4WjAwMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMRMwEQYDVQQDDAp0ZXN0MDIyOTA1MFkwEwYHKoZIzj0CAQYIKoEcz1UBgi0DQgAECA4SOo81KDSpuCG3wE4osvH6eH8R6WaxO3+d2j6bxbH8gQz2ViW64TLMHbHkpMBdMY78LSf8qXIy0mOuB/S5bqMdMBswDAYDVR0TBAUwAwEB/zALBgNVHQ8EBAMCB4AwDAYIKoEcz1UBg3UFAANIADBFAiEAj5XssZojUro/Yjn4Gc+dtc/49TgQcmQEwDZ3M15WhgUCIACq2VtGeYKTrS6JicTvu2i1Qyp1rzzemmxT14UkoToR','MIIBczCCARegAwIBAgIISSld5b7TQ/wwDAYIKoEcz1UBg3UFADAsMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMQ8wDQYDVQQDDAZERU1PQ0EwHhcNMTYwMjI5MTE0OTE4WhcNMTYwMzAzMTE0OTE4WjAwMQswCQYDVQQGEwJDTjEMMAoGA1UECgwDSklUMRMwEQYDVQQDDAp0ZXN0MDIyOTA1MFkwEwYHKoZIzj0CAQYIKoEcz1UBgi0DQgAECA4SOo81KDSpuCG3wE4osvH6eH8R6WaxO3+d2j6bxbH8gQz2ViW64TLMHbHkpMBdMY78LSf8qXIy0mOuB/S5bqMdMBswDAYDVR0TBAUwAwEB/zALBgNVHQ8EBAMCB4AwDAYIKoEcz1UBg3UFAANIADBFAiEAj5XssZojUro/Yjn4Gc+dtc/49TgQcmQEwDZ3M15WhgUCIACq2VtGeYKTrS6JicTvu2i1Qyp1rzzemmxT14UkoToR')",-1,1,0,0);
//lrd_stmt(Csr1,"insert into aaa values('aadfd','dfsdfs')",-1,1,0,0);
//lrd_row_count(Csr1,&row_count,0);
//lr_output_message("row_count= %d",row_count);
lr_end_transaction("aa", LR_AUTO);
}
#include "lrd.h"
vuser_end()
{
lrd_close_cursor(&Csr1,0);
lrd_close_connection(&Con1,0,0);
lrd_free_connection(&Con1,0,0);
lrd_close_context(&Ctx1,0,0);
}