mvc实现登录退出登录 注册功能

UserDao

package com.qiku.yrc.Dao;

import com.qiku.yrc.entity.User;
import com.qiku.yrc.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.junit.Test;

import java.sql.SQLException;

public class UserDao {
    QueryRunner queryRunner = new QueryRunner(DruidUtils.dataSource);
    //登陆功能
    public User login(User user) {
        String sql= "select * from user where username=? and password=?";
        try {
            User sqlUser = queryRunner.query(sql, new BeanHandler<>(User.class), user.getUsername()
                    , user.getPassword());
            return sqlUser;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //表示失败
        return null;
    }


    public void register(User user) {
        String sql="insert into user values(?,?,?,?,?,?)";
        try {
            int update = queryRunner.update(sql,user.getUid(), user.getUsername(), user.getPassword(),
                    user.getTelephone(), user.getBirthday(), user.getSex());


        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
    public User findUserByName(String userName){
        try {
            String sql = "select * from user where username = ?";
            User user = queryRunner.query(sql, new BeanHandler<>(User.class), userName);
            return user;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }


}

UserService

package com.qiku.yrc.service;

import com.qiku.yrc.Dao.UserDao;
import com.qiku.yrc.entity.User;
import com.qiku.yrc.utils.UUIDUtils;

public class UserService {
    private UserDao userDao = new UserDao();
    // 自定义方法   根据参数 对象的User对象 调用 UserDao 实现登录

    public User login(User user) {
        if (user.getUsername()!=null&& user.getPassword()!=null){
            return userDao.login(user);
        }else{
            return  null;
        }

    }
    public String register(User user){
        if (user!=null && user.getUsername() != null){
            User userByName = userDao.findUserByName(user.getUsername());
            if (userByName == null){// 说明用户名不存在  可以注册
                //完善用户信息
                user.setUid(UUIDUtils.getUUID());
                // 调用Dao 插入数据
                userDao.register(user);
                return "success";
            }else{
                return "用户名已存在";