JDBC调存储过程

/*
	    create proc pro_shoping
		as 
	    select * from shoping
	    go
	 */
	// 调用普通存储过程
	public List<String> executeProc() {
		List<String> list = new ArrayList<String>();
		ResultSet rs = null;
		String procName = "{ call pro_shoping }";
		try {
			CallableStatement cs = conn.prepareCall(procName);
			rs = cs.executeQuery();
			while (rs.next()) {
				list.add(rs.getString(2));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	/*
	    create proc pro_shoping
	  	@t int output 
		as 
	    select * from shoping
		set @t = 10 
		go
	*/

	// 调用带返回值 的存储过程
	public List<String> executeProc2() {
		List<String> list = new ArrayList<String>();
		ResultSet rs = null;
		String procName = "{ call pro_shoping(?) }";
		try {
			CallableStatement cs = conn.prepareCall(procName);
			cs.registerOutParameter(1, Types.INTEGER);
			rs = cs.executeQuery();
			while (rs.next()) {
				list.add(rs.getString(2));
			}
			p = cs.getInt(1);   //取出output所返回的值 
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}