java 调用存储过程

java 调用存储过程的简单例子：

 

 

public String temp( org.hibernate.Session s,String date,  String config) throws KnowledgeReportException  {
		ResultSet rs = null;
		Connection conn = s.connection();
		CallableStatement proc = null; 
		try{
			proc = conn.prepareCall("{ call 存储过程名(?,?,?) }"); 
			proc.setString(1, date);
			proc.setString(2, config); 
			proc.registerOutParameter(3, Types.VARCHAR);//为输出参数注册类型
			proc.execute(); 
			String flowid = proc.getString(5);
			if(rs != null)
				rs.close();
			if(proc != null){
				proc.close();
			}
			return flowid;
		}catch(SQLException e) {
			throw e;
	}