bm系统的案例

1、用户登录

这里用户登录只是个查询操作；
根据姓名来查询；如果查到了，返回用户；
如果没有查到，则返回null;
登录成功条件需要：姓名和密码都匹配上才成功

public class UserDaoImp implements UserDao{
    public User getUser(String username) throws SQLException, ClassNotFoundException {
        User user = new User();
        String sql = "select * from t_user where username = ? ";
        Connection connection = BaseDao.getConnection();
        PreparedStatement preparedStatement=connection.prepareStatement(sql);
        preparedStatement.setString(1,username);
        ResultSet resultSet = preparedStatement.executeQuery();
        if(resultSet.next()){ user.setId(resultSet.getInt("id"));
           user.setPassword(resultSet.getString("password"));
           user.setCreat_by_time(resultSet.getDate("creat_by_time"));
           user.setUsername(resultSet.getString("username"));
           user.setCreat_by_user(resultSet.getString("creat_by_user"));
           user.setUpdate_by_last(resultSet.getDate("update_by_last"));
           user.setCreat_by_time(resultSet.getDate("creat_by_time"));
            user.setUsertype(resultSet.getInt("usertype"));
            return user;
        }

        BaseDao.close(connection,preparedStatement,resultSet);
        return null;

    }
    @Test()
    public void test() throws SQLException, ClassNotFoundException {
        UserDaoImp userDaoImp = new UserDaoImp();
        User user = userDaoImp.getUser("admin1");
        if(user==null){
            System.out.println("用户不存在");
        }else{
            System.out.println("用户存在");
            System.out.println(user.getPassword());
        }
    }
}

@WebServlet(name = "LoginController",value = "/LoginController")
public class LoginController extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String username = req.getParameter("username");
        String password = req.getParameter("password");

        UserService userService = new UserServiceImp();
        try{
            User user = userService.getUser(username);
            if(user!=null){
                if(user.getPassword().equals(password)){
                    //登录成功
                    req.getSession().setAttribute("user",user);
                    req.getRequestDispatcher("main.jsp").forward(req,resp);
                }
            }else {
                resp.sendRedirect("login.jsp");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

用户注册

可以使用ajax来处理用户名和密码
url后面拼接参数这样避免了使用多个controller来处理业务