import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class BaseDao {
	private final String USERNAME="root"; 
	private final String PASSWORD=""; 
	private final String DRIVER="com.mysql.jdbc.Driver"; 
	private final String URL="jdbc:mysql://localhost:3306/test_home?characterEncoding=utf-8"; 
	
	protected Connection con;
	protected PreparedStatement ps;
	protected ResultSet rs;
	
	/**
	 * 建立连接
	 * @return
	 */
	public Connection getCon(){
		try {
			Class.forName(DRIVER);//反射机制,加载驱动
			con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}
	
	/**
	 *关闭连接
	 */
	public void close(){
		try {
			if(rs!=null){
				rs.close();
			}
			if(ps!=null){
				ps.close();
			}
			if(con!=null){
				con.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public List<Search> querySearch(){
		List<Search> datas=new ArrayList<Search>();
		try {
			con=getCon();
			String sql="select * from search";
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Search s=new Search(rs.getInt("id"), rs.getString("search"));
				datas.add(s);
			}
		} catch (Exception e) {
			e.printStackTrace();
			
		}
		return datas;
		
	}
	
}