Java调用存储过程

最新推荐文章于 2024-09-21 10:38:43 发布

ouou009

最新推荐文章于 2024-09-21 10:38:43 发布

阅读量257

点赞数

文章标签：存储 java session integer string sql

本文链接：https://blog.csdn.net/ouou009/article/details/7402638

版权

public synchronized int createTempForPretreatmentRep()
    {
        //调用存储过程语句.
        String sql = "{call create_temp_sumsystem()}";
        return this.createTempForReport(sql, null);

}

createTempForReport(){

//获取session.
        Session session = super.getHibernateTemplate().getSessionFactory().openSession();
        //开始事务.
        Transaction tx = session.beginTransaction();
        //获取连接.
        @SuppressWarnings("deprecation")
        Connection conn = session.connection();

        //执行状态码
        int state = -1;

CallableStatement cstmt = null;

//执行存储过程,并返回状态码
cstmt = conn.prepareCall(sql);

if (null != param){
                for (int i = 0; i < param.length; i++) {
                    if (param[i] instanceof Integer)cstmt.registerOutParameter(1, java.sql.Types.INTEGER); cstmt.setInt(i + CONSTANT_TWO, Integer.valueOf(param[i].toString()));
}
                    else if (param[i] instanceof String)
                    {
                        cstmt.setString(i + 1, param[i].toString().replaceAll("'", ""));}
}

state = cstmt.executeUpdate();

if (CONSTANT_ZERO != state){ tx.rollback(); } else{ tx.commit(); }

return state;