indexmanager.java

来自「Ajax自动提示功能 实现类似google suggest的功能」· Java 代码 · 共 40 行

package cn.edu.auto;


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



/**
 * @author Administrator
 *
 */
public class IndexManager {
        public ArrayList getManagerList(String param) throws Exception{
                String query = "select * from qindex where Content like '%" + param + "%'" ;
                System.out.println(query);
                DataQuery dq = new DataQuery();
                Connection conn = dq.getConnection();
                ArrayList al = new ArrayList();
                try{
                        Statement stmt = conn.createStatement();
                        ResultSet rs = stmt.executeQuery(query);
                        while(rs.next()){
                                int id = rs.getInt("ID");
                                String content = rs.getString("Content");
                                Gindex gindex = new Gindex(id,content);
                                al.add(gindex);
                        }
                        rs.close();
                        stmt.close();
                        conn.close();
                        return al;
                }catch(Exception e){
                        e.printStackTrace();
                        return null;
                }
        }
}