在课堂中实现的登录功能项目的基础上,完成注册与登出功能
package com.qiku.dao;
import com.qiku.entity.User;
import com.qiku.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import java.sql.SQLException;
public class UserDao {
QueryRunner qr = new QueryRunner(DruidUtils.dataSource);
/**
* 登录功能
* @param user
* @return
*/
public User login(User user) {
try {
String sql = "select * from user where username = ? and password = ?";
User sqlUser = qr.query(sql, new BeanHandler<>(User.class), user.getUsername(), user.getPassword());
System.out.println("dao。。。。。" + user.getUsername() + ",,," + user.getPassword());
return sqlUser;
} catch (SQLException e) {
e.printStackTrace();
}
//表示查找失败
retur