searchsuggestdao.java

来自「ajax 入门小例. 实现仿 google 自动提示.」· Java 代码 · 共 54 行

/*************************************************
 @Copyright (C), 2008, lzpeng 
 @File name:      SearchSuggestDAO.java
 @Author:         lzpeng
 @CreateDate:     2008-6-28 
 *************************************************/
package cn.com.lzpeng.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import cn.com.lzpeng.entity.SuggestBean;

/**
 * 
 * 数据库访问实现类
 *
 */
public class SearchSuggestDAO {

	
	/**
	 * @param str 提示字符
	 * @return arr  ArrayList<SuggestBean>实体
	 * @throws exception
	 * 
	 */
	public ArrayList<SuggestBean> getSuggest(String str) throws Exception {
		ResultSet rs = null;
		Connection conn = null;
		PreparedStatement pstm = null;
		ArrayList<SuggestBean> arr = new ArrayList<SuggestBean>();

		String sql_query = "SELECT *  FROM suggest WHERE title like(?) ORDER BY title";

		conn = DBManager.getConn();
		pstm = conn.prepareStatement(sql_query);
		pstm.setString(1, str + "%");
		rs = pstm.executeQuery();

		while (rs.next()) {
			SuggestBean bean = new SuggestBean();
			bean.setSuggest_id(rs.getInt(1));
			bean.setTitle(rs.getString(2));
			arr.add(bean);
		}

		return arr;
	}

}