2022-5-6

---

TestUserDao

---

package com.qiku.app;

import com.qiku.dao.UserDao;
import com.qiku.entity.User;
import org.junit.Test;

import java.sql.SQLException;

public class TestUserDao {
    //创建UserDao对象
    private UserDao userDao = new UserDao();

    //测试 注册功能
    @Test
    public void testRegister() throws SQLException {
        //1 准备 User对象
        User user = new User();
        //2 对user属性进行赋值
        user.setUid("006");
        user.setUsername("鸡你太美");
        user.setPassword("123456");
        user.setTelephone("1234567899");
        user.setBirthday("2000-12-21");
        user.setSex("男");
        //3 进行注册
        int register = userDao.register(user);
        //4 判断结果
        if (register > 0) {
            System.out.println("注册成功,欢迎您："+user.getUsername());
        } else {
            System.out.println("注册失败");
        }
    }
}

---

UserDao

---

package com.qiku.dao;

import com.qiku.entity.User;
import com.qiku.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;

import java.sql.SQLException;

//注册登录
public class UserDao {
    public int register(User user) throws SQLException {
        //1 创建 QueryRunner
        QueryRunner qr = new QueryRunner(DruidUtils.dataSource);
        //2 编写SQL
        String sql = "insert into user values (?,?,?,?,?,?)";
        //3 补全占位符 并执行SQL
        int i = qr.update(sql,
                user.getUid(), user.getUsername(),
                user.getPassword(), user.getTelephone(),
                user.getBirthday(), user.getSex());
        return i;
    }
}