还有一个bean,是父类 /* *文件名:DBCon2.java *创建时间:2002-12-15 by chen *修改时间: *功能描述:创建数据库连接,且为其它Bean的父类。 */package com.bitc; import java.sql.*; import java.io.*;public abstract class DBCon2 { Connection con = null; public DBCon2() {
} public void BuildConnection() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AuditDB","system","manager"); }catch(Exception e){} } public abstract void cleanup() throws Exception; public void takeDown() throws Exception { cleanup(); con.close(); } }
String funcString = "{?= call MyFunction(?)}"; CallableStatement cstmt = m_conn.prepareCall(funcString); cstmt.registerOutParameter(1, Types.INTEGER);//set return value, the first ?. cstmt.setString(2, Param);//set param second ?,Param1 is the param you defined. cstmt.execute(); int iRet = cstmt.getInt(1);
*文件名:NewAuAccTarget.java
*创建时间:2002-12-23 by chen
*修改时间:
*功能描述:
*/package com.bitc;import java.sql.*;
import com.bitc.*;
import java.io.*;public class NewAuAccTarget extends DBCon2
{
CallableStatement stmt=null;
String sql="{call Au_NewAccSort(?,?,?)}";
String AccNa="";
String AccId=""; public NewAuAccTarget()
{
super();
} public void getParameter(String AccNa,String AccId)
{
this.AccNa=AccNa;
this.AccId=AccId;
} public String getResult() throws Exception
{
stmt=con.prepareCall(sql);
stmt.setString(1,AccNa);
stmt.setString(2,AccId);
stmt.registerOutParameter(3,Types.VARCHAR);
stmt.executeUpdate();
//clearParameters();
String cMessage=stmt.getString(3);
return cMessage;
} public void cleanup() throws Exception
{
if(stmt!=null)stmt.close();
}
}
/*
*文件名:DBCon2.java
*创建时间:2002-12-15 by chen
*修改时间:
*功能描述:创建数据库连接,且为其它Bean的父类。
*/package com.bitc;
import java.sql.*;
import java.io.*;public abstract class DBCon2
{
Connection con = null;
public DBCon2()
{
}
public void BuildConnection()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AuditDB","system","manager");
}catch(Exception e){}
}
public abstract void cleanup() throws Exception;
public void takeDown() throws Exception
{
cleanup();
con.close();
}
}
CallableStatement cstmt = m_conn.prepareCall(funcString);
cstmt.registerOutParameter(1, Types.INTEGER);//set return value, the first ?.
cstmt.setString(2, Param);//set param second ?,Param1 is the param you defined.
cstmt.execute();
int iRet = cstmt.getInt(1);
在代码中进行调用!