package com.qiku.app;
import com.qiku.dao.UserDao;
import com.qiku.entity.User;
import org.junit.Test;
import java.sql.SQLException;
public class Test1 {
private UserDao dao = new UserDao();
@Test
public void Testre() throws SQLException {
User user =
new User("006","夜刀十神香","234","12345678911","2022-5-6","女");
int re = dao.Register(user);
if (re > 0){
System.out.println("注册成功,"+user.getUsername());
}else {
System.out.println("注册失败!");
}
}
}
package com.qiku.dao;
import com.qiku.Utils.DruidUtils;
import com.qiku.entity.User;
import org.apache.commons.dbutils.QueryRunner;
import java.sql.SQLException;
public class UserDao {
public int Register(User user) throws SQLException {
QueryRunner runner = new QueryRunner(DruidUtils.dataSource);
String sql = "insert into user values(?,?,?,?,?,?)";
int update = runner.update(sql,
user.getUid(), user.getUsername(),
user.getPassword(),user.getTelephone(),
user.getBirthday(), user.getSex());
return update;
}
}