JAVA简单从数据库获得单条数据并从前台提示

?自动提示账号输入
前端JS：
//自动提示账号输入JS，绑定keyup事件


Servlet:
//往后传数据
System.out.println("进入servlet，将传入后台："+request.getParameter("accountName"));
//获得DAO服务
ZhglManage manage = serviceSession.getService(ZhglManage.class);
//获得前台数据并往后台发送，同时接收返回的结果
String account = manage.searchAccountInOneResult(request.getParameter("accountName"));
//往前端发送
PrintWriter out = response.getWriter();
System.out.println("返回servlet，即将返回获得的结果："+account+" 给页面");
/*如果是大量数据如分页，则启用
* 为你的数据设置变量如String msg = null;
* msg = 回来的结果;
* request.setAttribute("result",msg);
* request.getRequestDispatcher("跳转至你要处理结果的页面如/result.jsp").forward(request,response);
*/
out.print(account);
out.close();

接口：
/**
* 根据输入框模糊查找用户账号
* @author Raiden
* 2015.5.13
* @throws Throwable
* return
*/
public abstract String searchAccountInOneResult(String inputing) throws Throwable;


DAO:
/**
* 通过后台查询账户并返回单条类似结果
* @author Raiden
* 2015.5.15
* @return String
*/
@Override
public String searchAccountInOneResult(String inputing) throws Throwable {
System.out.println("进入DAO，传入的参数是："+inputing);
String account = "";
//StringBuilder sb = null;
//获得连接
Connection conn = getConnection();
//准备SQL语句
String sql = "select F02 From S61.T6110 WHERE F02 like '"+inputing+"%' limit 10";
PreparedStatement pstm = conn.prepareStatement(sql);
//执行SQL
ResultSet rs = pstm.executeQuery();
//获得结果
while(rs.next()){
account = account + rs.getString(1)+"
";
// sb.append(account);
System.out.println("这次的结果是:"+account);
}
//以String方式返回结果
// account = sb.toString();
return account;
}