public interface UserDao {
void insert(User user);
void update(User user);
void delete(int id);
User findById(int id);
List<User> findAll();
}
public class UserDaoImpl implements UserDao {
public UserDaoImpl(Connection connection) {
this.connection = connection;
}
public void insert(User user) {
}
public void update(User user) {
}
public void delete(int id) {
}
public User findById(int id) {
return null;
}
public List<User> findAll() {
return null;
}
}
public class UserService {
public UserService() {
}
public void createUser(User user) {
userDao.insert(user);
}
public void updateUser(User user) {
userDao.update(user);
}
public void deleteUser(int id) {
userDao.delete(id);
}
public User findUserById(int id) {
return userDao.findById(id);
}
public List<User> findAllUsers() {
return userDao.findAll();
}
}
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);