jdbc.url=jdbc:mysql://localhost:3306/mydb
jdbc.username=testuser
jdbc.password=testpass
mapping.table.user=tbl_user
mapping.column.user.id=user_id
mapping.column.user.name=user_name
public class User {
private int id;
private String name;
// getters and setters
}
import com.psp4jdbc.core.Psp4jdbc;
public class Main {
public static void main(String[] args) {
Psp4jdbc psp4jdbc = new Psp4jdbc("psp4jdbc.properties");
psp4jdbc.init();
}
}
List<User> users = psp4jdbc.select(User.class, "SELECT * FROM tbl_user WHERE user_id = ?", 1);
for (User user : users) {
System.out.println("ID: " + user.getId() + ", Name: " + user.getName());
}
User user = new User();
user.setId(1);
user.setName("John");
psp4jdbc.insert(user, "tbl_user");
