package com;

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

import net.sf.json.JSONArray;

public class BaiduSuggestionUtil {


	public JSONArray getBaiduRelateWord(String input) throws Exception {

		List<BaiduSuggestionUtil> list = new ArrayList<BaiduSuggestionUtil>();
		Connection conn = null;
		PreparedStatement smt = null;
		ResultSet rs = null;
		JSONArray jsonArray = null;
		BaiduSuggestionUtil bd=null;
		try{
		String sql = "select * from client_mobile_card where name like ?";
		conn = DBUtil.getConnection();
		smt = conn.prepareStatement(sql);
		smt.setString(1, "%"+input+"%");
		rs = smt.executeQuery();
		while (rs.next()) {
			bd=new BaiduSuggestionUtil();
			bd.setName(rs.getString("name"));
			list.add(bd);
		}
		jsonArray = JSONArray.fromObject(list);
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			DBUtil.close(rs, smt, conn);
		}
		
		return jsonArray;
	}

	public static void main(String args[]) {
		try {
			System.out.println(new BaiduSuggestionUtil().getBaiduRelateWord("王"));
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/** 91 * 百度联想词 92 */
	private String name;

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}
}