java调用mysql方法

java 代码

public String findCompanyId(String deptId) throws Exception {
        String companyId = "";
        Query query = this.getSession().createSQLQuery("select queryCompanyId(?)");
        query.setParameter(0, deptId);
        List<String> list = query.list();
        if(list != null && list.size()>0) {
            companyId = list.get(0);
        }
        return companyId;
    }

java调用mysql方法

标签：except   ring   exception   div   string   where   blog   bsp   dep