public class PgRDB extends SharableResource
| Modifier and Type | Class and Description |
|---|---|
static class |
PgRDB.Cluster<R extends PgRDB> |
static class |
PgRDB.Column |
static class |
PgRDB.Condition |
static class |
PgRDB.DeleteInsert |
static class |
PgRDB.Exists |
static class |
PgRDB.Fields |
static class |
PgRDB.From |
static class |
PgRDB.GroupBy |
static class |
PgRDB.Limit |
static class |
PgRDB.Logic |
static class |
PgRDB.NotExists |
static class |
PgRDB.OrderBy |
protected static class |
PgRDB.Phrase |
static interface |
PgRDB.RDBCreator<R> |
static class |
PgRDB.Select |
static interface |
PgRDB.SQLPhrase |
static interface |
PgRDB.SQLText |
static class |
PgRDB.Table |
static class |
PgRDB.Value |
static class |
PgRDB.Where |
static class |
PgRDB.Word |
| Modifier and Type | Field and Description |
|---|---|
protected Connection |
connection |
static String |
CT_Boolean |
static String |
CT_Double |
static String |
CT_Integer |
static String |
CT_Long |
static String |
CT_Real |
static String |
CT_String |
(package private) String |
database_url |
protected static String |
PG_TABLES |
protected static String |
PG_TABLES_tablename |
protected static PgRDB.Table |
PgTables |
protected static PgRDB.Column |
PgTables_tablename |
renewRequestedidlingTime, isReserved, isReservedByMe, release, renew, reserve, tryReserveprotected static final String PG_TABLES
protected static final PgRDB.Table PgTables
protected static final String PG_TABLES_tablename
protected static final PgRDB.Column PgTables_tablename
String database_url
protected Connection connection
public static final String CT_Integer
public static final String CT_Long
public static final String CT_Real
public static final String CT_Double
public static final String CT_String
public static final String CT_Boolean
public PgRDB(String url)
protected PgRDB getRDB()
public Connection getConnection()
public boolean open()
open in class SharableResourcepublic void close()
close in class SharableResourcepublic boolean isAvailable()
isAvailable in class SharableResourceboolean executeCommand(CharSequence cmd) throws SQLException
SQLExceptionpublic boolean executeCommandOutsideOfTransaction(CharSequence cmd) throws SQLException
SQLExceptionpublic boolean executeBatch(CharSequence... cmds) throws SQLException
SQLExceptionpublic boolean executeBatch(List<CharSequence> cmds) throws SQLException
SQLExceptionpublic boolean vacuum()
throws SQLException
SQLExceptionpublic boolean vacuum(PgRDB.Table table) throws SQLException
SQLExceptionpublic boolean exists(PgRDB.Table table) throws SQLException
SQLExceptionpublic void createTable(PgRDB.Table table, Collection<PgRDB.Column> columns) throws SQLException
SQLExceptionpublic void createTable(PgRDB.Table table, PgRDB.Column... columns) throws SQLException
SQLExceptionpublic void dropTable(PgRDB.Table table) throws SQLException
SQLExceptionpublic void grantTableTo(PgRDB.Table table, String privilege, String to) throws SQLException
SQLExceptionpublic String createIndex(PgRDB.Table table, PgRDB.Column ct, boolean unique) throws SQLException
SQLExceptionpublic String createIndex(PgRDB.Table table, boolean unique, PgRDB.Column... columns) throws SQLException
SQLExceptionpublic List<List<String>> select(CharSequence query) throws SQLException
SQLExceptionpublic List<List<String>> select(PgRDB.SQLPhrase... phrases) throws SQLException
SQLExceptionpublic List<String> select1row(CharSequence query) throws SQLException
query - querySQLException - Errorpublic List<String> select1row(PgRDB.SQLPhrase... phrases) throws SQLException
phrases - query phrasesSQLException - Errorpublic List<String> select1(CharSequence query) throws SQLException
SQLExceptionpublic List<String> select1(PgRDB.SQLPhrase... phrases) throws SQLException
SQLExceptionpublic int count(PgRDB.From table, PgRDB.Where where) throws SQLException
SQLExceptionpublic int count(PgRDB.Table table) throws SQLException
SQLExceptionpublic String max(PgRDB.Column c, PgRDB.Table table) throws SQLException
SQLExceptionpublic String min(PgRDB.Column c, PgRDB.Table table) throws SQLException
SQLExceptionpublic void insertInto(PgRDB.Table table, Collection<PgRDB.Value> cvs) throws SQLException
SQLExceptionpublic void insertInto(PgRDB.Table table, PgRDB.Value... cvs) throws SQLException
SQLExceptionpublic void multipleInsertInto(PgRDB.Table table, Collection<Collection<PgRDB.Value>> cvss) throws SQLException
SQLExceptionpublic void deleteFrom(PgRDB.Table table, PgRDB.Where where) throws SQLException
SQLExceptionpublic void deleteFrom(PgRDB.Table table) throws SQLException
SQLExceptionpublic void deleteAndInsert(PgRDB.Table table, PgRDB.Where where, Collection<PgRDB.Value> cvs) throws SQLException
SQLExceptionpublic void deleteAndInsert(PgRDB.Table table, PgRDB.Where where, PgRDB.Value... cvs) throws SQLException
SQLExceptionpublic void deleteAndMultipleInsert(PgRDB.Table table, PgRDB.Where where, Collection<? extends Collection<PgRDB.Value>> cvss) throws SQLException
SQLExceptionpublic void multipleDeleteAndInsert(PgRDB.Table table, Collection<PgRDB.DeleteInsert> delins) throws SQLException
SQLExceptionpublic static void printSQLError(PrintStream err, String n, SQLException ex)
public static void printSQLError(PrintWriter err, String n, SQLException ex)
public static <R extends PgRDB> PgRDB.Cluster<R> createCluster(PgRDB.RDBCreator<R> creator, String url, int num, long ttp)
EDB Working Group at Mon Dec 15 16:45:05 JST 2025