servlet+easyui显示

servlet返回数据easyUI前台展示

servlet代码

 

@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/easyui", "root", "000000");
			Statement stat=conn.createStatement();
			String sql="select * from users";
			ResultSet rs=stat.executeQuery(sql);
			List<Users>userList=new ArrayList<Users>();
			resp.setContentType("text/html;charset=utf-8");
			while(rs.next()){
				Users users=new Users();
				users.setId(rs.getInt("id"));
				users.setFirstname(rs.getString("firstname"));
				users.setLastname(rs.getString("lastname"));
				users.setPhone(rs.getString("phone"));
				users.setEmail(rs.getString("email"));
				userList.add(users);
			}
			String str="{\"total\":"+userList.size()+" ,\"rows\":"+net.sf.json.JSONArray.fromObject(userList).toString()+"}";
			resp.getWriter().write(str);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

后台不拼接total和rows前台数据就是不展示

 

jsp页面

 

 $(function(){
    	$('#dg').datagrid({
    	    url:"${pageContext.request.contextPath}/userServlet.do",
    	    columns:[[
    	        {field:'id',title:'编号',width:100},
    	        {field:'firstname',title:'首次名',width:100},
    	        {field:'lastname',title:'最后名',width:100},
    	        {field:'phone',title:'手机',width:100},
    	        {field:'email',title:'邮箱',width:150}
    	    ]]
    	});