CRM管理系统:查询用户列表

管理系统:查询用户列表"/>

CRM管理系统:查询用户列表

一、前端HTML

1.1、通过axios发送请求到Servlet获取用户列表数据 

1.2、将Servlet响应的数据通过v-for指令显示到tale上

二、后端Servlet

2.1、DAO中添加查询全部用户的方法

public  class MangerImpl extends BaseDAO implements MangerDAO {public List<Manger> selectAll() {List<Manger> list=new ArrayList<Manger>();String sql="select * from t_user order by id desc";ResultSet rs =this.executeQuery(sql);try {while(rs.next()){int id=rs.getInt("id");String user_name=rs.getString("user_name");String  passwd=rs.getString("passwd");String nick_name=rs.getString("nick_name");int sex=rs.getInt("sex");String birth=rs.getString("birth");String img=rs.getString("img");String phone=rs.getString("phone");Manger m=new Manger();m.setId(id);m.setUser_name(user_name);m.setPasswd(passwd);m.setNick_name(nick_name);m.setSex(sex);m.setBirth(birth);m.setImg(img);m.setPhone(phone);list.add(m);}this.closeAll();} catch (SQLException throwables) {throwables.printStackTrace();}return list;

二、后端Servlet

2.1、DAO中添加查询全部用户的方法

package crmAppServlet;import com.alibaba.fastjson.JSON;
import dao.Impl.MangerImpl;
import dao.MangerDAO;
import entity.Manger;import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;@WebServlet("/user_list")public class crmServlet extends HttpServlet {@Overrideprotected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding("utf8");resp.setCharacterEncoding("utf8");resp.setContentType("application/json;charset=utf8");PrintWriter writer = resp.getWriter();MangerDAO mar=new MangerImpl();List<Manger> list = mar.selectAll();String s= JSON.toJSONString(list);writer.print(s);writer.close();}
}