categoryservice.java

树形菜单

package com.sdjs.tree.service;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import com.sdjs.tree.dao.CategoryDAO;
import com.sdjs.tree.db.ConnectionBean;

public class CategoryService
{
	private CategoryDAO categoryDAO;
	private ConnectionBean connbean;
	public CategoryService()
	{
		super();
		categoryDAO=new CategoryDAO();
		connbean=new ConnectionBean();
		// TODO 自动生成构造函数存根
	}
	
	public List getAllItems()
	{
		Connection conn=connbean.getConnection();
		List itemList=null;
		categoryDAO.setConn(conn);
		try {
			itemList=categoryDAO.getAllItems();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		finally
		{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		
		return itemList;
	}
	public List getRootChapters(int id)
	{
		Connection conn=connbean.getConnection();
		List chapterList=null;
		categoryDAO.setConn(conn);
		try {
			chapterList=categoryDAO.getTopChaptersByItemid(id);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		finally
		{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		
		return chapterList;
	}
	public List getChaptersByParentid(int id)
	{
		Connection conn=connbean.getConnection();
		List chapterList=null;
		categoryDAO.setConn(conn);
		try {
			chapterList=categoryDAO.getChaptersByParentid(id);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		finally
		{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		
		return chapterList;
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	public CategoryDAO getCategoryDAO()
	{
		return categoryDAO;
	}
	public void setCategoryDAO(CategoryDAO categoryDAO)
	{
		this.categoryDAO = categoryDAO;
	}
	public ConnectionBean getConnbean()
	{
		return connbean;
	}
	public void setConnbean(ConnectionBean connbean)
	{
		this.connbean = connbean;
	}
	public static void main(String[] args) 
	{
		CategoryService cs = new CategoryService();
		List itemList=cs.getAllItems();
		System.out.println(itemList.get(0));
	}

}