java的输入输出函数_java程序中调用带有输入输出值的SQL函数

public class GetTvbMessageUtil {

private static final Log log = LogFactory.getLog(GetTvbMessageUtil.class);

public static String GetTvbLoginId(String input) {

log.info("start Get TvbLoginId!");

Session session = null;

Connection conn = null;

CallableStatement cs = null;

StringBuffer sql = new StringBuffer();

String result = "";

try {

session = DBUtil.currentSession();

conn = session.connection();

conn.setAutoCommit(false); // for preformance

conn.setReadOnly(true); // for preformance

sql.append("{?=call TVB_PKG.sf_get_TVB_login_ID@dsbs_prd(?)}");

cs = conn.prepareCall(sql.toString());

cs.setString(2, input);

cs.registerOutParameter(1, Types.VARCHAR);

log.info("loginID=" + input);

cs.execute();

conn.commit();

log.info("return=" + cs.getString(1));

log.info("Get Tvb LoginId End!");

result = cs.getString(1);

}

catch (Exception ex) {

log.error("Exception: " + ex.toString(), ex);

throw new AcctAssociateException(ex.getMessage());

} finally {

DBUtil.closeStatement(cs);

DBUtil.closeSession(session);

}

return result;

}

}