java调用存储过程的方法

在java中执行一条SQL语句

//查询

SqlRuturn result = Executer.getInstance().ExecSeletSQL("select personname from g_personinfo where personid=1");

//在bw中执行要这样

//Connection conn = DBConnectionManager.getInstance().getConnection("bw");

//SqlRuturn result = Executer.getInstance().ExecSeletSQL("select personname from g_personinfo where personid=1", conn);

// DBConnectionManager.getInstance().freeConnection("bw", conn);

//更新

SqlRuturn result = Executer.getInstance().ExecUpdateSQL("update g_personinfo set personname='' where peronid=1");

//在bw中执行要这样

//Connection conn = DBConnectionManager.getInstance().getConnection("bw");

//SqlRuturn result = Executer.getInstance().ExecUpdateSQL("update g_personinfo set personname='' where peronid=1", conn);

// DBConnectionManager.getInstance().freeConnection("bw", conn);

第一种：

优点：不用一个个的set参数，参数存在form中

CallHelper helper1 = initializeCallHelper("getComInterfaceCompanyList", form, request, false);

helper1.setParam("personId",getPersonId(request));

helper1.setParam("companyId",companyIdSet);

helper1.execute();

//helper1.execute(“bw”);//在bw库中执行

第二种：

CallHelper helper = new CallHelper("PMS_saveTransDataByStoreLog");

helper.setParam("personid", 0);

helper.setParam("logdata", log);

helper.setParam("method", "addAnyPoint");

helper.execute();

//helper.execute(“bw”);//在bw库中执行

第三种：

优点：不用tomcat启动可执行

int length = 7;--设置参数的个数

SpParam[] params1 = new SpParam[length];

// 0表示输入参数,1表示输出参数

for (int j = 0; j < length1; j++) {

params1[j] = new SpParam();

}

params1[0].setAll(0, Types.INTEGER, "0");

params1[1].setAll(0, Types.CHAR, planYear);

params1[2].setAll(0, Types.CHAR, planMonth);

params1[3].setAll(0, Types.CHAR, "");

params1[4].setAll(0, Types.CHAR, "");

params1[5].setAll(0, Types.CHAR, "");

params1[6].setAll(1, Types.CHAR, "");

/** 第3.1种 **/

SpRuturn helper = ProcedureLauncher.execute("I_ImportComInterfaceCompanyData2",params1);

//调bw库时，要这样

Connection conn = DBConnectionManager.getInstance().getConnection("bw");

SpRuturn helper = ProcedureLauncher.execute("I_ImportComInterfaceCompanyData2",params1, conn);

// DBConnectionManager.getInstance().freeConnection("bw", conn);

/** 第3.2种 **/

Executer.getInstance().ExecStoreProcedure( "I_ImportComInterfaceCompanyData2",params1);

//调bw库时，要这样

//Executer exec = Executer.getInstance();

//exec.setDataSouce("bw");

//exec . ExecStoreProcedure("I_ImportComInterfaceCompanyData2",params1);