java调用数据库存储过程_通过java 程序调用数据库中的存储过程

public boolean exepro(String proname) {

DataSource logdao = (DataSource) ComponentFactory.getBean("dataSource");

Connection con = null;

CallableStatement csmt = null;

try {

con = logdao.getConnection();

log.info("-----------kaishi"+proname);

con.setAutoCommit(true);

csmt = con.prepareCall(proname);

csmt.executeUpdate();

con.setAutoCommit(false);

con.commit();

log.info("-----------jieshu"+proname);  } catch (Exception e) {   log.error("resetRecord Error:" + e.getMessage());   return false;  } finally {   if (csmt != null) {    try {     csmt.close();    } catch (Exception e) {     log.error("关闭PreparedStatement出错:" + e.getMessage());    }   }   if (con != null) {    try {     con.close();    } catch (Exception e) {     log.error("关闭Connection出错:" + e.getMessage());    }   }  }  return true; }