调用MS SQL存储过程实例

 

1. 存储过程：

文件:	procedure.rar
大小:	4KB
下载:	下载

2. spring + hibernate 调用

 

ProcedureMngImpl.java

 

@Service
@Transactional
public class ProcedureMngImpl extends BaseManagerImpl implements ProcedureMng {
    protected Logger log = LoggerFactory.getLogger(getClass());
    
    @Autowired
    public void setDao(ProcedureDao dao) {
        super.setDao(dao);
    }
    
    public ProcedureDao getDao(){
        return (ProcedureDao) super.getDao();
        
    }

    @Override
    public void execImportOrganization() {
        String proc = "{call mrpsWap.dbo.spUUM_ImportOrganization()}";
        execProcedure(proc);
    }

    @Override
    public void execImportUser() {
        String proc = "{call mrpsWap.dbo.spUUM_ImportUser()}";
        execProcedure(proc);
    }

}

ProcedureDaoImpl.java 

public void execProcedure(String proc) {
        Session s = null;
        Connection conn = null;
        CallableStatement st = null;
        try {
            s = getSession();
            conn = s.connection();
            st = conn.prepareCall(proc);
            st.execute();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (st != null)
                    st.close();
                if (conn != null)
                    conn.close();
            } catch (SQLException e) {
                log.error(e.getMessage());
                e.printStackTrace();
            }
        }
    }