Extjs+jsp+Servlet完整前台与后台交换并显示到表格

//用户实体类
public class user(){
	//数据库表省略，类型应该都知道，构造方法有参无参自己要记得加，示例我就省略。
	public int useid; 
	public String usename; 
	public String usepwd; 
	public String sex; 
	public int age;
}

//dao，里面写的是查询数据库的sql语句
public class UsersDao{
	private Connection con;
 	public DBHelper dbh;//连接数据库帮助类 提供通用增删改方法
    
    	public UsersDao(){}
    	public UsersDao(Connection con){
      		  this.con=con;
   	 }

	/**
	 * 查询所有用户对象，特别提供无参查询方法，有参的网上很多我就不写，无参真的少
	 * @return
	 */
	public List<Usersa> selectUsersInfo(){
		con=dbh.getConnection();//连接数据库
		List<Usersa> list=new ArrayList<Usersa>();
        String sql="select * from USERSA";


        ResultSet rs=null;
        try {
            Statement statement=(Statement)con.createStatement();
            rs=statement.executeQuery(sql); //执行sql语句
            Usersa stu=null;
            while(rs.next()){
                stu=new Usersa();
                stu.setUseid(rs.getInt("useid"));
                stu.setUsename(rs.getString("usename"));
                stu.setUsepwd(rs.getString("usepwd"));
                stu.setSex(rs.getString("sex"));
                stu.setAge(rs.getInt("age"));
                list.add(stu);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            try {
                if(rs!=null){
                    rs.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
		return list;
	}
}

//servlet,由于extjs普遍支持get方式的url传递,所有也写成get,当然也可以写成post

public class QueryUseServlet extends HttpServlet {
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) 
			throws ServletException, IOException {
	 resp.setContentType("text/html;charset=utf-8");
	 resp.setCharacterEncoding("utf-8");
	 req.setCharacterEncoding("utf-8");
		
         UsersDao usersdao=new UsersDao();
         List<Usersa> list  = usersdao.selectUsersInfo();
         //迭代器   
         Iterator it = list.iterator();   
         while(it.hasNext()){   
             System.out.println(it.next()+"content");   
         }   
         JSONObject obj = new JSONObject();
         JSONArray js = new JSONArray();
         obj.put("data", js.fromObject(list));
         //obj.put("count", 10); //统计数量，这里写死10条
         resp.getWriter().write(obj.toString());//json格式化后输出
	}

	protected void doPost(HttpServletRequest req, HttpServletResponse resp) 
			throws ServletException, IOException {
		doGet(req,resp);
	}
}

我这里就只提供登录（其中登录就没有验证）和主页显示数据到表格，关键是数据显示到表格上

<