public class User {
private String username;
private String password;
@Override
public String toString() {
return "User{" +
"username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
public String getUsername() {
return username;
}
public String getPassword() {
return password;
}
}
dao:
UserDao
import domain.User;
import java.sql.SQLException;
import java.util.List;
public interface UserDao {
// 根据账号密码查找用户
public User selectUser(String username, String password) throws SQLException;
//查找全部
public List selectAll();
}
UserDaoImpl
import JDBCUtils.JDBCUtils;
import dao.UserDao;
import domain.User;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.jupiter.api.Test;
import java.sql.SQLException;
import java.util.List;
public class UserDaoImpl implements UserDao {
QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
@Override
public User selectUser(String username, String password) throws SQLException {
String sql = "select * from user where username=? and password=?";
User query = queryRunner.query(sql, new BeanHandler<User>(User.class),username,password);
return query;
}
@Override
public List selectAll() {
String sql = "select * from user";
List<User> query = null;
try {
query = queryRunner.query(sql, new BeanListHandler<User>(User.class));
} catch (SQLException e) {
e.printStackTrace();
}
// System.out.println(query);
return query;
}
}
service:
AjaxVideoService
import domain.User;
import java.util.List;
public interface AjaxVideoService {
public List selectAll();
}
AjaxVideoServiceImpl
import dao.UserDao;
import dao.impl.UserDaoImpl;
import service.AjaxVideoService;
import java.util.List;
public class AjaxVideoServiceImpl implements AjaxVideoService {
@Override
public List selectAll() {
UserDao userDao = new UserDaoImpl();
return userDao.selectAll();
}
}