javaweb22/4/13

smbms登录功能

1.编写前端页面
2.设置欢迎页面

    <welcome-file-list>
        <welcome-file>login.jsp</welcome-file>
    </welcome-file-list>

3.编写用户登录接口

public interface UserDao {
    public User getuser(Connection connection, String userCode) throws SQLException;
}

4.编写用户登录实现类

public class UserDaoImpl implements UserDao{
    @Override
    public User getuser(Connection connection, String userCode) throws SQLException {

        User user = new User();

        if (connection!=null){
            String sql = "select * from smbms_user where userCode=?";
            Object[] params = {userCode};
            ResultSet execute = BaseDao.execute(connection, sql, params);
            if (execute.next()) {
                user.setId(execute.getInt("id"));
                user.setUserName(execute.getString("userName"));
                user.setUserPassword(execute.getString("userPassword"));
                user.setGender(execute.getInt("gender"));
                user.setBirthday(execute.getDate("birthday"));
                user.setPhone(execute.getString("phone"));
                user.setAddress(execute.getString("address"));
                user.setUserRole(execute.getInt("userRole"));
                user.setCreatedBy(execute.getInt("createdBy"));
                user.setCreationDate(execute.getDate("creationDate"));
                user.setModifyBy(execute.getString("modifyBy"));
                user.setModifyDate(execute.getDate("modifyDate"));

            }
        }

        return user;

    }
}

5.业务层接口

public interface UserService {
    public User login(String userCode,String userPassword);
}

6.业务层实现类

public class UserServiceImpl implements UserService{

    private UserDao userDao;
    public UserServiceImpl(){
        userDao=new UserDaoImpl();
    }
    @Override
    public User login(String userCode, String userPassword) {
        Connection connection = BaseDao.getConnection();
        User user = null;
        try {
            user = userDao.getuser(connection, userCode);

        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.close(connection,null,null);
            return user;
        }

    }
}

7.注销功能

 protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //移除Session
        req.getSession().removeAttribute(Constants.USER_SESSION);
        resp.sendRedirect("/login.jsp");
    }

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

8.注册后进行拦截，防止注册信息后还能进入首页

 public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest req = (HttpServletRequest) servletRequest;
        HttpServletResponse resp = (HttpServletResponse) servletResponse;
        //从Session中获取用户
        User user = (User)req.getSession().getAttribute(Constants.USER_SESSION);
        if (user==null){
            resp.sendRedirect("/error.jsp");
        }else{
            filterChain.doFilter(servletRequest,servletResponse);
        }
    }

<filter>
        <filter-name>LoginFilter</filter-name>
        <filter-class>com.wenping.filter.SysFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>LoginFilter</filter-name>
<!--        过滤所有jsp文件下的页面-->
        <url-pattern>/jsp/*</url-pattern>
    </filter-mapping>