在jsp页面里取从数据库获取到的值

model：

public class AddressList extends BaseForm {
private String userName;
private String userId;
private String userRight;
private String orgName;

set  get.......

}

Service：

public AddressList queryByName(String userName,String userId) throws SQLException;

ServiceImpl：

@Override
public List<AddressList> querySearchAddr(long level, String userId)
throws SQLException {
return addressList.querySearchAddr(level, userId);
}

dao:

public List<AddressList>querySearchAddr(long level,String userId) throws SQLException{
StringBuilder sql = new StringBuilder();
sql.append("select id,user_name,phone_no,org_name from address_list where user_id=?");
sql.append(" union");
sql.append(" select id,user_name,phone_no,org_name from address_list where addr_type_id in(select id from address_type where addr_type=0)");
if(level==5){
sql.append(" and user_right in(2,3,4,5,6)");
}else if(level==6){
sql.append(" and user_right in(4,5,6)");
}
return super.queryForBeanList(sql.toString(), new Object[]{userId}, AddressList.class);
}

controller：

try {

List<AddressList> list =addressListService.querySearchAddr(user.getSendRight(), user.getUserId());
if(list!= null){
StringBuilder sb = new StringBuilder();
for(AddressList ad:list){
String orgname = ad.getOrgName();
if(orgname==null){
sb.append("'"+ad.getUserName()+"',");
}else{
sb.append("'"+ad.getUserName()+"("+orgname+")',");
}
}
request.setAttribute("searchAddr",sb.toString());
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();

}

jsp：

<input type="text" style="width:auto;height:auto;font-size:13px;" id="o" οnkeyup="autoComplete.start(event)">
<div class="auto_hidden" id="auto"><!--自动完成 DIV--></div>
<script>
var autoComplete=new AutoComplete('o','auto',[<%=request.getAttribute("searchAddr")%>]);
</script>

觉得有帮助的朋友

请收藏一下我的淘宝进口零食店：https://shop136022832.taobao.com

请多支持！谢谢！