//用户实体类
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);
}
}
我这里就只提供登录(其中登录就没有验证)和主页显示数据到表格,关键是数据显示到表格上
<