管理系统:查询用户列表"/>
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();} }
更多推荐
CRM管理系统:查询用户列表
发布评论