import com.psp4jdbc.ConnectionPool;
import com.psp4jdbc.ConnectionWrapper;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Psp4jdbcExample {
public static void main(String[] args) {
ConnectionPool connectionPool = new ConnectionPool();
connectionPool.setUrl("jdbc:mysql://localhost:3306/mydb");
connectionPool.setUsername("root");
connectionPool.setPassword("password");
connectionPool.setMaxConnections(10);
try {
ConnectionWrapper connWrapper = connectionPool.getConnection();
Connection conn = connWrapper.getConnection();
String sql = "SELECT * FROM users";
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("ID: " + id + ", Name: " + name + ", Age: " + age);
}
rs.close();
stmt.close();
connWrapper.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
connectionPool.close();
}
}
}
