smbms項目核心功能實現

SMBMS

資料庫:

項目如何搭建?

考慮使用不使用Maven?依賴,Jar

1、項目搭建準備工作

  1. 搭建一個maven web項目

  2. 配置Tomcat

  3. 測試項目是否能夠跑起來

  4. 導入項目中會遇到的jar包;

    jsp,Servlet,mysql驅動,jstl,standard…

  5. 創建項目包結構

  6. 編寫實體類;

    ORM映射:表-類映射

  7. 編寫基礎公共類

    1. 資料庫配置文件

      driver=com.mysql.cj.jdbc.Driver
      url=jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=UTF-8&useSSL=true&setServiceTime=GMT
      username=root
      password=123456
      
    2. 編寫資料庫的公共類

      //操作資料庫的公共類
      public class BaseDao {
          private static String driver;
          private static String url;
          private static String username;
          private static String password;
      
          //靜態程式碼塊,類載入的時候就初始化了
          static {
              Properties properties = new Properties();
              //通過類載入器讀取對應的資源
              InputStream is = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");
      
              try {
                  properties.load(is);
              } catch (IOException e) {
                  e.printStackTrace();
              }
      
              driver = properties.getProperty("driver");
              url = properties.getProperty("url");
              username = properties.getProperty("username");
              password = properties.getProperty("password");
          }
          //獲取資料庫的連接
          public static Connection getConnection(){
              Connection connection = null;
              try {
                  Class.forName("driver");
                  connection = DriverManager.getConnection(url, username, password);
              } catch (Exception e) {
                  e.printStackTrace();
              }
              return connection;
          }
      
          //編寫查詢公共類
          public static ResultSet execute(Connection connection,String sql,Object[] params,ResultSet resultSet,PreparedStatement preparedStatement) throws SQLException {
              //預編譯的sql,在後面直接執行就可以了
              preparedStatement = connection.prepareStatement(sql);
      
              for (int i = 0; i < params.length; i++) {
                  //setObject,佔位符從1開始,但是我們的數組是從0開始!
                  preparedStatement.setObject(i+1,params[i]);
              }
      
              resultSet = preparedStatement.executeQuery();
              return resultSet;
          }
      
          //編寫增刪改公共方法
          public static int execute(Connection connection, String sql, Object[] params, PreparedStatement preparedStatement) throws SQLException {
              preparedStatement = connection.prepareStatement(sql);
      
              for (int i = 0; i < params.length; i++) {
                  //setObject,佔位符從1開始,但是我們的數組是從0開始!
                  preparedStatement.setObject(i+1,params[i]);
              }
      
              int updateRows = preparedStatement.executeUpdate();
              return updateRows;
          }
      
          //釋放資源
          public static boolean closeResource(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet){
              boolean flag = true;
      
              if (resultSet!=null){
                  try {
                      resultSet.close();
                      //GC回收
                      resultSet = null;
                  } catch (SQLException e) {
                      e.printStackTrace();
                      flag = false;
                  }
              }
      
              if (preparedStatement!=null){
                  try {
                      preparedStatement.close();
                      //GC回收
                      preparedStatement = null;
                  } catch (SQLException e) {
                      e.printStackTrace();
                      flag = false;
                  }
              }
      
              if (connection!=null){
                  try {
                      connection.close();
                      //GC回收
                      connection = null;
                  } catch (SQLException e) {
                      e.printStackTrace();
                      flag = false;
                  }
              }
      
              return flag;
          }
      }
      
    3. 編寫字元編碼過濾器

  8. 導入靜態資源

2、登錄功能實現

  1. 編寫前端頁面

  2. 設置首頁

    <!--設置歡迎頁面-->
    <welcome-file-list>
        <welcome-file>login.jsp</welcome-file>
    </welcome-file-list>
    
  3. 編寫dao層得到用戶登錄的介面

    DAO:data access object

    //得到要登錄的用戶
    public User getLoginUser(Connection connection,String userCode) throws SQLException;
    
  4. 編寫dao介面的實現類

    public class UserDaoImpl implements UserDao{
        public User getLoginUser(Connection connection, String userCode) throws SQLException {
    
            PreparedStatement pstm = null;
            ResultSet rs = null;
            User user = null;
    
            if (connection!=null){
                String sql = "select * from smbms_user where userCode=?";
                Object[] params = {userCode};
    
    
                rs = BaseDao.execute(connection, pstm, rs, sql, params);
    
                if (rs.next()){
                    user = new User();
                    user.setId(rs.getInt("id"));
                    user.setUserCode(rs.getString("userCode"));
                    user.setUserName(rs.getString("userName"));
                    user.setUserPassword(rs.getString("userPassword"));
                    user.setGender(rs.getInt("gender"));
                    user.setBirthday(rs.getDate("birthday"));
                    user.setPhone(rs.getString("phone"));
                    user.setAddress(rs.getString("address"));
                    user.setUserRole(rs.getInt("userRole"));
                    user.setCreatedBy(rs.getInt("createdBy"));
                    user.setCreationDate(rs.getTimestamp("creationDate"));
                    user.setModifyBy(rs.getInt("modifyBy"));
                    user.setModifyDate(rs.getTimestamp("modifyDate"));
                }
                BaseDao.closeResource(null,pstm,rs);
    
            }
    
            return user;
        }
    }
    
  5. 業務層介面

    //用戶登錄
    public User login(String userCode,String password);
    
  6. 業務層實現類

    public class UserServiceImpl implements UserService {
    
        //業務層都會調用dao層,所以我們要引入Dao層;
        private UserDao userDao;
    
        public UserServiceImpl() {
            userDao = new UserDaoImpl();
        }
    
        public User login(String userCode, String password) {
            Connection connection = null;
            User user = null;
    
            connection = BaseDao.getConnection();
            try {
                user = userDao.getLoginUser(connection, userCode);
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                BaseDao.closeResource(connection, null, null);
            }
            return user;
        }
    }
    
  7. 編寫Servlet

    public class LoginServlet extends HttpServlet {
    
        //Servlet:控制層,調用業務層程式碼
    
        @Override
        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
            System.out.println("LoginServlet--start....");
    
            //獲取用戶名和密碼
            String userCode = req.getParameter("userCode");
            String userPassword = req.getParameter("userPassword");
    
            //和資料庫中的密碼進行對比,調用業務層;
            UserService userService = new UserServiceImpl();
            User user = userService.login(userCode, userPassword); //這裡已經把登錄的人給查出來了
    
            if (user!=null){ //查有此人,可以登錄
                //將用戶的資訊放到Session中;
                req.getSession().setAttribute(Constants.USER_SESSION,user);
                //跳轉到主頁
                resp.sendRedirect("jsp/frame.jsp");
            }else {//查無此人,無法登錄
                //轉發回登錄頁面,順帶提示它,用戶名或者密碼錯誤
                req.setAttribute("error","用戶名或者密碼不正確");
                req.getRequestDispatcher("login.jsp").forward(req,resp);
            }
        }
    
        @Override
        protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
            doGet(req, resp);
        }
    }
    
  8. 註冊Servlet

    <!--Servlet-->
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.kuang.servlet.user.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login.do</url-pattern>
    </servlet-mapping>
    
  9. 測試訪問,確保以上功能成功!

3、登錄功能優化

註銷功能:

思路:移除Session,返回登錄頁面

public class LogoutServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //移除用戶的Constants.USER_SESSION
        req.getSession().removeAttribute(Constants.USER_SESSION);
        resp.sendRedirect(req.getContextPath()+"/login.jsp");//返回登錄頁面
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

註冊xml

<servlet>
    <servlet-name>LogoutServlet</servlet-name>
    <servlet-class>com.kuang.servlet.user.LogoutServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>LogoutServlet</servlet-name>
    <url-pattern>/jsp/logout.do</url-pattern>
</servlet-mapping>

登錄攔截優化

編寫一個過濾器並註冊

public class SysFilter implements Filter {
    public void init(FilterConfig filterConfig) throws ServletException {
    }

    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws IOException, ServletException {
        HttpServletRequest request = (HttpServletRequest) req;
        HttpServletResponse response = (HttpServletResponse) resp;

        //過濾器,從Session中獲取用戶,
        User user = (User) request.getSession().getAttribute(Constants.USER_SESSION);

        if (user==null){ //已經被移除或者註銷了,或者未登錄
            response.sendRedirect("/smbms/error.jsp");
        }else {
            chain.doFilter(req,resp);
        }
    }

    public void destroy() {
    }
}
<!--用戶登錄過濾器-->
<filter>
    <filter-name>SysFilter</filter-name>
    <filter-class>com.kuang.filter.SysFilter</filter-class>
</filter>
<filter-mapping>
    <filter-name>SysFilter</filter-name>
    <url-pattern>/jsp/*</url-pattern>
</filter-mapping>

測試,登錄,註銷許可權,都要保證OK!

4、密碼修改

  1. 導入前端素材

    <li><a href="${pageContext.request.contextPath }/jsp/pwdmodify.jsp">密碼修改</a></li>
    
  2. 寫項目,建議從底層向上寫

  3. UserDao介面

    //修改當前用戶密碼
    public int updatePwd(Connection connection,int id,int password) throws SQLException;
    
  4. UserDao介面實現類

    //修改當前用戶密碼
    public int updatePwd(Connection connection, int id, int password) throws SQLException {
    
        PreparedStatement pstm = null;
        int execute = 0;
        if (connection!=null){
            String sql = "update smbms_user set userPassword = ? where id = ?";
            Object params[] = {password,id};
            execute = BaseDao.execute(connection, pstm, sql, params);
            BaseDao.closeResource(null,pstm,null);
        }
        return execute;
    }
    
  5. UserService層

    //根據用戶ID修改密碼
    public boolean updatePwd(int id, int pwd);
    
  6. UserService實現類

    public boolean updatePwd(int id, int pwd) {
        Connection connection = null;
        boolean flag = false;
        //修改密碼
        try {
            connection = BaseDao.getConnection();
            if (userDao.updatePwd(connection,id,pwd)>0){
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.closeResource(connection,null,null);
        }
        return flag;
    }
    
  7. Servlet記得實現復用,需要提取出方法!

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String method = req.getParameter("method");
        if (method.equals("savepwd")&&method!=null){
            this.updatePwd(req, resp);
        }
    }
    
    public void updatePwd(HttpServletRequest req, HttpServletResponse resp){
        //從Session裡面拿ID;
        Object o = req.getSession().getAttribute(Constants.USER_SESSION);
        String newpassword = req.getParameter("newpassword");
    
        System.out.println("UserServlet"+newpassword);
    
        boolean flag = false;
    
        //if (o!=null && !StringUtils.isNullOrEmpty(newpassword)){
        if (o!=null && newpassword!=null){
            UserService userService = new UserServiceImpl();
            flag = userService.updatePwd(((User) o).getId(), newpassword);
            if (flag){
                req.setAttribute("message","修改密碼成功,請退出,使用新密碼登錄");
                //密碼修改成功,移除當前Session
                req.getSession().removeAttribute(Constants.USER_SESSION);
            }else {
                req.setAttribute("message","密碼修改失敗");
                //密碼修改成功,移除當前Session
            }
        }else {
            req.setAttribute("message","新密碼有問題");
        }
        try {
            req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);
        } catch (ServletException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    <servlet>
        <servlet-name>UserServlet</servlet-name>
        <servlet-class>com.kuang.servlet.user.UserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>UserServlet</servlet-name>
        <url-pattern>/jsp/user.do</url-pattern>
    
  8. 測試

優化密碼修改使用Ajax;

  1. 阿里巴巴的fastjson

    <!-- //mvnrepository.com/artifact/com.alibaba/fastjson -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.79</version>
    </dependency>
    
  2. 後台程式碼修改

    //修改密碼
    public void updatePwd(HttpServletRequest req, HttpServletResponse resp){
        //從Session裡面拿ID;
        Object o = req.getSession().getAttribute(Constants.USER_SESSION);
        String newpassword = req.getParameter("newpassword");
    
        System.out.println("UserServlet"+newpassword);
    
        boolean flag = false;
    
        //if (o!=null && !StringUtils.isNullOrEmpty(newpassword)){
        if (o!=null && newpassword!=null){
            UserService userService = new UserServiceImpl();
            flag = userService.updatePwd(((User) o).getId(), newpassword);
            if (flag){
                req.setAttribute("message","修改密碼成功,請退出,使用新密碼登錄");
                //密碼修改成功,移除當前Session
                req.getSession().removeAttribute(Constants.USER_SESSION);
            }else {
                req.setAttribute("message","密碼修改失敗");
                //密碼修改成功,移除當前Session
            }
        }else {
            req.setAttribute("message","新密碼有問題");
        }
        try {
            req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);
        } catch (ServletException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    //驗證舊密碼,session中有用戶的密碼
    public void pwdModify(HttpServletRequest req, HttpServletResponse resp){
        //從Session裡面拿oldpassword;
        Object o = req.getSession().getAttribute(Constants.USER_SESSION);
        String oldpassword = req.getParameter("oldpassword");
    
        //萬能的Map : 結果集
        HashMap<String, String> resultMap = new HashMap<String,String>();
        if (o==null){ //Session失效了,session過期了
            resultMap.put("result","sessionerror");
        }else if (StringUtils.isNullOrEmpty(oldpassword)){ //輸入的密碼為空
            resultMap.put("result","error");
        }else {
            String userPassword = ((User) o).getUserPassword(); //Session中用戶的密碼
            if (oldpassword.equals(userPassword)){
                resultMap.put("result","true");
            }else {
                resultMap.put("result","false");
            }
        }
    
        try {
            resp.setContentType("application/json");
            PrintWriter writer = resp.getWriter();
            //JSONArray 阿里巴巴的JSON工具類,轉換格式
            /*
                resultMap = ["result","sessionerror","result","error"]
                Json格式 = {key:value}
                 */
            writer.write(JSONArray.toJSONString(resultMap));
            writer.flush();
            writer.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
  3. 測試

5、用戶管理實現

思路:

  1. 導入分頁的工具類

  2. 用戶列表頁面導入

    userlist.jsp

    rollpage.jsp

1、獲取用戶數量

  1. UserDao

    //根據用戶名或者角色查詢用戶總數
    public int getUserCount(Connection connection,String username,int userRole) throws SQLException;
    
  2. UserDaoImpl

    //根據用戶名或者角色查詢用戶總數【最難理解的SQL】
    public int getUserCount(Connection connection, String username, int userRole) throws SQLException {
        PreparedStatement pstm = null;
        ResultSet rs = null;
        int count = 0;
    
        if (connection!=null){
            StringBuffer sql = new StringBuffer();
            sql.append("select count(1) as count from smbms_user u,smbms_role r where u.userRole = r.id");
            ArrayList<Object> list = new ArrayList<Object>();//存放我們的參數
    
            if (!StringUtils.isNullOrEmpty(username)){ //拼接sql語句
                sql.append(" and u.userName like ?");
                list.add("%"+username+"%"); //index:0
            }
            if (userRole>0){
                sql.append(" and u.userRole = ?");
                list.add(userRole); //index:1
            }
    
            //怎麼把list轉換為數組
            Object[] params = list.toArray();
    
            System.out.println("UserDaoImpl->getUserCount"+sql.toString()); //輸出最後完整的SQL語句
    
            rs = BaseDao.execute(connection, pstm, null, sql.toString(), params);
    
            if (rs.next()){
                count = rs.getInt("count");//從結果集中獲取最終的數量
            }
            BaseDao.closeResource(null,pstm,rs);
        }
    
        return count;
    }
    
  3. UserService

    //查詢記錄數
    public int getUserCount(String username, int userRole);
    
  4. UserServiceImpl

    //查詢記錄數
    public int getUserCount(String username, int userRole) {
        Connection connection = null;
        int count = 0;
        try {
            connection = BaseDao.getConnection();
            count = userDao.getUserCount(connection, username, userRole);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            BaseDao.closeResource(connection,null,null);
        }
    
        return count;
    }
    

2、獲取用戶列表

  1. userdao

    //通過條件查詢-userList
    public List<User> getUserList(Connection connection, String username, int userRole, int currentPageNo, int pageSize) throws Exception;
    
  2. userdaoImpl

    public List<User> getUserList(Connection connection, String username, int userRole, int currentPageNo, int pageSize) throws Exception {
        PreparedStatement pstm = null;
        ResultSet rs = null;
        List<User> userList = new ArrayList<User>();
    
        if (connection!=null){
            StringBuffer sql = new StringBuffer();
            sql.append("select u.*,r.roleName as userRoleName from smbms_user u,smbms_role r where u.userRole = r.id");
            List<Object> list = new ArrayList<Object>();//存放我們的參數
    
            if (!StringUtils.isNullOrEmpty(username)){ //拼接sql語句
                sql.append(" and u.userName like ?");
                list.add("%"+username+"%"); //index:0
            }
            if (userRole>0){
                sql.append(" and u.userRole = ?");
                list.add(userRole); //index:1
            }
    
            //在資料庫中,分頁使用  limit startIndex,pageSize;  總數
            //當前頁    (當前頁-1)*頁面大小
            //0,5    1    0    01234
            //5,5    2    5    56789
            //10,5   3    10
    
            sql.append(" order by creationDate DESC limit ?,?");
            currentPageNo = (currentPageNo-1)*pageSize;
            list.add(currentPageNo);
            list.add(pageSize);
    
            //怎麼把list轉換為數組
            Object[] params = list.toArray();
    
            System.out.println("sql-->"+sql.toString()); //輸出最後完整的SQL語句
    
            rs = BaseDao.execute(connection, pstm, null, sql.toString(), params);
    
            while (rs.next()){
                User user = new User();
                user.setId(rs.getInt("id"));
                user.setUserCode(rs.getString("userCode"));
                user.setUserName(rs.getString("userName"));
                user.setGender(rs.getInt("gender"));
                user.setBirthday(rs.getDate("birthday"));
                user.setPhone(rs.getString("phone"));
                user.setUserRole(rs.getInt("userRole"));
                user.setUserRoleName(rs.getString("userRoleName"));
                userList.add(user);
            }
            BaseDao.closeResource(null,pstm,rs);
        }
        return userList;
    }
    
  3. userService

    //通過條件查詢-userList
    public List<User> getUserList(String queryUserName, int queryUserRole, int currentPageNo, int pageSize);
    
  4. userServiceImpl

    public List<User> getUserList(String queryUserName, int queryUserRole, int currentPageNo, int pageSize) {
        Connection connection = null;
        List<User> userList = null;
        try {
            connection = BaseDao.getConnection();
            userList = userDao.getUserList(connection, queryUserName, queryUserRole,currentPageNo,pageSize);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            BaseDao.closeResource(connection,null,null);
        }
    
        return userList;
    }
    

3、獲取角色操作

為了我們職責統一,可以把角色的操作單獨放在一個包中,和POJO類對應

RoleDao

public interface RoleDao {
    //獲取角色列表
    public List<Role> getRoleList(Connection connection) throws SQLException;
}

RoleDaoImpl

public List<Role> getRoleList(Connection connection) throws SQLException {

    PreparedStatement pstm = null;
    ResultSet resultSet = null;
    ArrayList<Role> roleList = new ArrayList<Role>();

    if (connection!=null){
        String sql = "select * from smbms_role";
        Object[] params = {};
        resultSet = BaseDao.execute(connection, pstm, resultSet, sql, params);

        while (resultSet.next()){
            Role _role = new Role();
            _role.setId(resultSet.getInt("id"));
            _role.setRoleCode(resultSet.getString("roleCode"));
            _role.setRoleName(resultSet.getString("roleName"));
            roleList.add(_role);
        }
        BaseDao.closeResource(null,pstm,resultSet);
    }
    return roleList;
}

RoleService

//獲取角色列表
public List<Role> getRoleList();

RoleServiceImpl

public class RoleServiceImpl implements RoleService{

    //引入Dao
    private RoleDao roleDao = null;
    public RoleServiceImpl(){
        roleDao = new RoleDaoImpl();
    }

    public List<Role> getRoleList() {
        Connection connection = null;
        List<Role> roleList = null;
        try {
            connection = BaseDao.getConnection();
            roleList = roleDao.getRoleList(connection);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            BaseDao.closeResource(connection,null,null);
        }
        return roleList;
    }
}

4、用戶顯示的Servlet

  1. 獲取用戶前端的數據(查詢)
  2. 判斷請求是否需要執行,看參數的值判斷
  3. 為了實現分頁,需要計算出當前頁面和總頁面,頁面大小…
  4. 用戶列表展示
  5. 返回前端
//重點,難點
public void query(HttpServletRequest req, HttpServletResponse resp){
    //查詢用戶列表
    //從前端獲取數據:
    String queryUserName = req.getParameter("queryname");
    String temp = req.getParameter("queryUserRole");
    String pageIndex = req.getParameter("pageIndex");
    int queryUserRole = 0;

    //獲取用戶列表
    UserServiceImpl userService = new UserServiceImpl();
    List<User> userList = null;

    //第一次走這個請求,一定是第一頁,頁面大小固定的;
    int pageSize = 5;//可以把這個寫到配置文件中,方便後期修改;
    int currentPageNo = 1;

    if (queryUserName == null){
        queryUserName = ""; //不手動賦值會產生空指針異常
    }
    if (temp != null && !temp.equals("")){
        queryUserRole = Integer.parseInt(temp); //給查詢賦值!0,1,2,3
    }
    if (pageIndex != null){
        currentPageNo = Integer.parseInt(pageIndex);
    }

    //獲取用戶的總數(分頁:上一頁,下一頁的情況)
    int totalCount = userService.getUserCount(queryUserName,queryUserRole);
    //總頁數支援
    PageSupport pageSupport = new PageSupport();
    pageSupport.setCurrentPageNo(currentPageNo);
    pageSupport.setPageSize(pageSize);
    pageSupport.setTotalCount(totalCount);

    int totalPageCount = pageSupport.getTotalPageCount(); //總共有幾頁

    //控制首頁和尾頁
    //如果頁面要小於1了,就顯示第一頁的東西
    if (totalPageCount<1){
        currentPageNo = 1;
    }else if (currentPageNo>totalPageCount){ //當前頁面大於了最後一項;
        currentPageNo = totalPageCount;
    }

    //獲取用戶列表展示
    userList = userService.getUserList(queryUserName, queryUserRole, currentPageNo, pageSize);
    req.setAttribute("userList",userList);

    RoleServiceImpl roleService = new RoleServiceImpl();
    List<Role> roleList = roleService.getRoleList();
    req.setAttribute("roleList",roleList);
    req.setAttribute("totalCount",totalCount);
    req.setAttribute("currentPageNo",currentPageNo);
    req.setAttribute("totalPageCount",totalPageCount);
    req.setAttribute("queryUserName",queryUserName);
    req.setAttribute("queryUserRole",queryUserRole);

    //返回前端
    try {
        req.getRequestDispatcher("userlist.jsp").forward(req,resp);
    } catch (ServletException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
}

小黃鴨調試法

6、SMBMS架構分析

Tags: