package org.news.dao.util;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.news.dao.BaseDao;
import org.news.dao.UserDao;

public class UserDaoImpl extends BaseDao implements UserDao {

	@Override
	public List<String> findUser(String uname) {
		List<String> list=new ArrayList<String>();
		String sql="SELECT tname FROM topic WHERE tname LIKE ?";
		ResultSet rs= executeQuery(sql,"%"+uname+"%");
		try {
			while (rs.next()) {
				list.add(rs.getString(1));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	public List<String> findList() {
		List<String> list=new ArrayList<String>();
		String sql="SELECT tname FROM topic";
		ResultSet rs= executeQuery(sql);
		try {
			while (rs.next()) {
				list.add(rs.getString(1));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
}