getlist.java

java web开发宝典源代码

package com.yxq.bean;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.yxq.menu.MenuSingle;

public class GetList {
	private boolean RsTrue(ResultSet rs){
		try{
			if(rs==null)
				return false;
			else
				if(rs.next())
					return true;
				else
					return false;
		}catch(Exception e){
			System.out.println("GetList类中RsTrue()方法出错！");
			e.printStackTrace();
			return false;
		}
	}
	
	public List getMenuList(ResultSet rs){
		List<MenuSingle> menulist=new ArrayList<MenuSingle>();
		if(RsTrue(rs)){
			try{
				rs.previous();
				while(rs.next()){
					MenuSingle menusingle=new MenuSingle();
					menusingle.setId(rs.getInt("id"));
					menusingle.setMenuId(rs.getString("menu_id"));
					menusingle.setMenuName(rs.getString("menu_name"));
					menusingle.setMenuParentId(rs.getString("menu_parentid"));
					menusingle.setMenuDoOp(rs.getString("menu_doOp"));
					menusingle.setMenuLevel(rs.getInt("menu_level"));
					menusingle.setMenuOrder(rs.getInt("menu_order"));
					menusingle.setMenuPic(rs.getString("menu_pic"));
					menulist.add(menusingle);
				}			
			}catch(Exception e){
				System.out.println("获取功能菜单列表出错！");
				e.printStackTrace();
			}			
		}
		return menulist;
	}
}