#application.properties
spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
public class User {
private int id;
private String name;
// Getter and setter methods
}
public interface UserDAO {
void insert(User user);
void update(User user);
void delete(int id);
User getById(int id);
List<User> getAll();
}
public class UserDAOImpl implements UserDAO {
private Connection connection;
// Constructor and methods
}
public void insert(User user) {
try {
PreparedStatement statement = connection.prepareStatement("INSERT INTO User (id, name) VALUES (?, ?)");
statement.setInt(1, user.getId());
statement.setString(2, user.getName());
statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public class UserService {
private UserDAO userDAO;
public void addUser(User user) {
userDAO.insert(user);
}
// Other methods
}
