treedao.java

三层架构实现左侧菜单

/*
   ┏━━━━━━━━━━━━━━━━━━━━━┓
   ┃             源 码 爱 好 者               ┃
   ┣━━━━━━━━━━━━━━━━━━━━━┫
   ┃                                          ┃
   ┃           提供源码发布与下载             ┃
   ┃                                          ┃
   ┃        http://www.codefans.net           ┃
   ┃                                          ┃
   ┃            互助、分享、提高              ┃
   ┗━━━━━━━━━━━━━━━━━━━━━┛
*/
package tree;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;


import database.DBConnectionManager;

public class TreeDAO {

	public Vector getObjects(String path){
		System.out.println(path);
		Vector v=new Vector();
			DBConnectionManager db=new DBConnectionManager();
			try {
				db.Open(path);
				String sql="select ID,PARENTID,TEXT,HINT,ICON,DATA,URL,TARGET,METHOD from treeview";
				ResultSet rs=db.QueryRs(sql);
				while(rs.next()){
					TreeBean tree=new TreeBean();
					tree.setId(rs.getInt("ID"));
					tree.setParentId(rs.getInt("PARENTID"));
					tree.setText(rs.getString("TEXT"));
					tree.setHint(rs.getString("HINT"));
					tree.setIcon(rs.getString("ICON"));
					tree.setData(rs.getString("DATA"));
					tree.setUrl(rs.getString("URL"));
					tree.setTarget(rs.getString("TARGET"));
					tree.setMethod(rs.getString("METHOD"));
					v.add(tree);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}finally{
				db.Close();
			}
			System.out.println(v.size());
			return v;

	}
}