welltreedao.java

三层架构实现左侧菜单

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

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


import database.DBConnectionManager;

public class WellTreeDAO {

	
	public Vector getObjects(String path){
		Vector v=new Vector();
		
			DBConnectionManager db=new DBConnectionManager();
			try {
				db.Open(path);			
				String sql="select JH,QK,YT,HINT,ICON,DATA,URL,TARGET,METHOD from welltree order by QK,JH";
				ResultSet rs=db.QueryRs(sql);
				while(rs.next()){
					WellTreeBean tree=new WellTreeBean();
					tree.setJh(rs.getString("JH"));
					tree.setQk(rs.getString("QK"));
					tree.setYt(rs.getString("YT"));
					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);
				}
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}finally{
				db.Close();
			}
			System.out.println(v.size());
			return v;

	}
	
	public Vector getQks(String path){
		Vector v=new Vector();
			DBConnectionManager db=new DBConnectionManager();
			try {
				db.Open(path);
				String sql="select distinct QK,YT from welltree order by YT";
				ResultSet rs=db.QueryRs(sql);
				while(rs.next()){
					v.add(rs.getString(2)+"油田_"+rs.getString(1)+"区块");
				}
				rs.close();

			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}finally{
				db.Close();
			}
			return v;

	}
	
	public Vector getYts(String path){
		Vector v=new Vector();
			DBConnectionManager db=new DBConnectionManager();
			try {
				db.Open(path);
				String sql="select distinct YT from welltree";
				ResultSet rs=db.QueryRs(sql);
				while(rs.next()){
					v.add(rs.getString(1));
				}
				rs.close();

			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}finally{
				db.Close();
			}
			return v;

	}
}