Question

怎么在java代码中设置oracle存储过程中的入参和出参

Answer 1

public String insertJCSP(Map parmaters) {
// TODO Auto-generated method stub
String str=null;
Connection conn = null;
CallableStatement csm = null;
conn = (Connection) sqlSession.getSqlSessionFactory().openSession()
.getConnection();
try {
csm = conn
.prepareCall("{Call pr_insert_JcInfo(?,?,?)}"); //调用存储过程
csm.setString(1, (String) parmaters.get("lottId")); //第一个入参数
csm.setString(2, (String) parmaters.get("idata"));//第二个入参数
csm.registerOutParameter(3, java.sql.Types.VARCHAR);//返回参数
csm.execute();
str = csm.getString(3); //取得返回参数