@Table(name = "users")
public class User {
@Column(name = "id")
private int id;
@Column(name = "name")
private String name;
}
public class Main {
public static void main(String[] args) {
ConnectionManager.initialize("jdbc:mysql://localhost:3306/test", "username", "password");
List<User> userList = SQLExecutor.query("SELECT * FROM users", User.class);
for (User user : userList) {
System.out.println(user.getName());
}
User newUser = new User();
newUser.setName("John Doe");
SQLExecutor.insert(newUser);
User updateUser = new User();
updateUser.setId(1);
updateUser.setName("Jane Smith");
SQLExecutor.update(updateUser);
User deleteUser = new User();
deleteUser.setId(2);
SQLExecutor.delete(deleteUser);
ConnectionManager.release();
}
}
properties
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=username
jdbc.password=password
scan.package=com.example.model
