package com.fgkj.dao.impl;

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

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.db.IDatabaseName;
import com.fgkj.dto.Vip_user;

public class Vip_userImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				Vip_user vuser=new Vip_user();
				vuser.setNum(rs.getInt("num"));
				vuser.setVipname(rs.getString("vipname"));
				vuser.setVipSnId(rs.getString("vipSnId"));
				vuser.setVipPassword(rs.getString("vipPassword"));
				list.add(vuser);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
   
	public boolean add(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}
    
	public boolean update(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	public List searchAll() {
		// TODO Auto-generated method stub
		return null;
	}
    //根据vip账号查询密码
	public List serchByCondition(Object obj) {
		Vip_user vuser=(Vip_user) obj;
		String sql="select num,vipname,vipSnId,vipPassword from web_site.tb_vip_user where vipname=? ";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{vuser.getVipname()}, new Vip_userImpl());
		return list;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
	public static void main(String[] args) {
		Vip_userImpl vimpl=new Vip_userImpl();
		Vip_user vuser=new Vip_user();
		vuser.setVipname("vip");
		//System.out.println(111);
		List<Vip_user> list=vimpl.serchByCondition(vuser);
		//System.out.println(list.size());
		for (Vip_user v : list) {
			System.out.println(v);
		}
	}
}