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 "用户名已存在";