easyui03(后台工作)

最新推荐文章于 2024-01-18 04:10:25 发布

Aur ora

最新推荐文章于 2024-01-18 04:10:25 发布

阅读量93

点赞数

分类专栏： easyui 文章标签： java

本文链接：https://blog.csdn.net/qq_65345936/article/details/124627073

版权

easyui 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

今天我们做的是搭建后台

三层结构模式：

Dao方法

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.zking.entity.Module;
import com.zking.util.DBHelper;

public class ModuleDao implements IModuleDao{

   private Connection con = null;
   private PreparedStatement ps = null;
   private ResultSet rs = null;

   @Override
   public List<Module> getAll(int pid) {
       List<Module> list = new ArrayList<Module>();
       try {
           con = DBHelper.getcon();
           String sql = "select * from tb_module where pid="+pid+"order by sort";
           ps=con.prepareStatement(sql);
           rs=ps.executeQuery();
           while(rs.next()) {
               Module m = new Module();
               m.setId(rs.getInt(1));
               m.setPid(rs.getInt(2));
               m.setText(rs.getString(3));
               m.setIconCls(rs.getString(4));
               m.setUrl(rs.getString(5));
               m.setSort(rs.getInt(6));
               list.add(m);
           }
       } catch (Exception e) {
           e.printStackTrace();
       }finally {
           DBHelper.myClose(con, ps, rs);
       }
       return list;
   }

Servlet包类

package com.zking.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

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 com.alibaba.fastjson.JSON;
import com.zking.biz.IModuleBiz;
import com.zking.biz.impl.ModuleBizimpl;
import com.zking.entity.Module;

@WebServlet("/s.do")
public class ModuleServlet extends HttpServlet {

   protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       doPost(request, response);
   }

   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       //设置编码方式
       request.setCharacterEncoding("utf-8");
       response.setCharacterEncoding("utf-8");
       response.setContentType("text/html; charset=UTF-8");

       PrintWriter out = response.getWriter();
       IModuleBiz m = new ModuleBizimpl();
       List<Module> list = m.getAll(-1);
       String str = JSON.toJSONString(list);
       out.write(str);
       out.flush();
       out.close();

   }

}