java 调用存储过程

1.jdbc
System.out.println("jdbc 调用-------------");
Connection conn = session.connection();   
ResultSet rs =null;  
CallableStatement call;
try {
call = conn.prepareCall("{Call proc_stuInfo()}");
rs = call.executeQuery(); 
  while(rs.next()){
  System.out.println(rs.getString(1));
  System.out.println(rs.getString(2));
  System.out.println(rs.getString(3));
  System.out.println(rs.getString(4));
  System.out.println(rs.getString(5));
  System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
  System.out.println("------------------");
  }
} catch (SQLException e) {
e.printStackTrace();
}  


2
SQLQuery query =  session.createSQLQuery("{call proc_stuInfo()}").addEntity(StuInfo.class);  
List list =query.list(); 
System.out.println(list.get(0));
注：若需要调用的存储过程返回查询数据，则addEntity(Clazz.class) 不能缺


3
public String companyDetail() {
String id = getRequest().getParameter("id");
this.company = (Company) baseDAO.get(Company.class, id);
List<Object> param = new ArrayList<Object>();
param.add(1);
List<Company> comlist = baseDAO.callProc("proc_company(?)", Company.class, param);
System.out.println(comlist.size());
return SUCCESS;
}




public List<T> callProc(String procName,Class<T> clazz,Object... param ){
Query q = null;
if (clazz != null) {
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}").addEntity(clazz);
}else{
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}");
}
if (param != null ) {
for (int i = 0; i < param.length; i++) {
q.setParameter(i, param[i]);
}
}
if (clazz!=null) {
return q.list();
}
else{
q.executeUpdate();
return null;
}
}