public abstract class KDataBase
extends java.lang.Object
Constructor and Description |
---|
KDataBase() |
KDataBase(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base) |
KDataBase(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base,
java.lang.String port) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
autoInc(java.lang.String tableName) |
void |
clear() |
void |
close() |
void |
connect() |
void |
connect(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base) |
void |
connect(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base,
java.lang.String port) |
void |
connect(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base,
java.lang.String port,
java.lang.String options) |
int |
execute(java.lang.String sql) |
void |
expireLease() |
java.util.HashMap<java.lang.String,java.lang.Object> |
fetchMap() |
java.lang.String |
getBase() |
java.lang.String |
getBaseName() |
java.sql.Connection |
getConnection() |
static java.sql.Connection |
getConnexion(java.lang.String host,
java.lang.String user,
java.lang.String pass,
java.lang.String base) |
java.util.ArrayList<java.lang.String> |
getDbNames() |
java.util.ArrayList<java.lang.String> |
getFieldNames(java.lang.String tableName) |
java.util.HashMap<java.lang.String,java.lang.Object> |
getFieldNamesAndTypes(java.lang.String tableName) |
java.util.ArrayList<KForeignKey> |
getForeignKeys(java.lang.String tableName) |
java.util.ArrayList<java.lang.String> |
getKeyFields(java.lang.String tableName) |
long |
getLastUse() |
java.lang.String |
getOptions() |
KDbParams |
getParams() |
java.util.ArrayList<java.lang.String> |
getTableNames(java.lang.String dbName) |
abstract java.lang.String |
getURL() |
java.lang.Object |
getValue(java.lang.String sql) |
java.util.ArrayList<java.lang.String> |
insert_id() |
boolean |
inUse() |
boolean |
isValid() |
static boolean |
isValid(java.sql.Connection connection) |
static boolean |
isValid(KDataBase db) |
boolean |
lease() |
int |
num_rows() |
int |
rowCount(java.lang.String sql) |
KDbResultSet |
sendQuery(java.lang.String sql) |
void |
setOptions(java.lang.String options) |
void |
setPool(KDbConnectionPool pool) |
boolean |
tableExist(java.lang.String tableName) |
public KDataBase()
public KDataBase(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base)
public KDataBase(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base, java.lang.String port)
public static boolean isValid(java.sql.Connection connection)
public java.sql.Connection getConnection()
public static boolean isValid(KDataBase db)
public boolean isValid()
public void connect(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public void connect(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base, java.lang.String port) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public void connect(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base, java.lang.String port, java.lang.String options) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public void connect() throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public java.util.ArrayList<java.lang.String> getDbNames() throws java.sql.SQLException
java.sql.SQLException
public java.util.ArrayList<java.lang.String> getTableNames(java.lang.String dbName) throws java.sql.SQLException
java.sql.SQLException
public java.util.ArrayList<java.lang.String> getFieldNames(java.lang.String tableName) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String autoInc(java.lang.String tableName) throws java.sql.SQLException
java.sql.SQLException
public java.util.HashMap<java.lang.String,java.lang.Object> getFieldNamesAndTypes(java.lang.String tableName) throws java.sql.SQLException
java.sql.SQLException
public java.util.ArrayList<java.lang.String> getKeyFields(java.lang.String tableName) throws java.sql.SQLException
java.sql.SQLException
public java.util.ArrayList<KForeignKey> getForeignKeys(java.lang.String tableName) throws java.sql.SQLException
java.sql.SQLException
public boolean tableExist(java.lang.String tableName)
public static java.sql.Connection getConnexion(java.lang.String host, java.lang.String user, java.lang.String pass, java.lang.String base)
public KDbResultSet sendQuery(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public java.lang.Object getValue(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public java.util.ArrayList<java.lang.String> insert_id() throws java.sql.SQLException
java.sql.SQLException
public int num_rows() throws java.sql.SQLException
java.sql.SQLException
public int rowCount(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public KDbParams getParams()
public java.lang.String getBase()
public void close() throws java.sql.SQLException
java.sql.SQLException
public int execute(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public java.util.HashMap<java.lang.String,java.lang.Object> fetchMap() throws java.sql.SQLException
java.sql.SQLException
public java.lang.String getOptions()
public void setOptions(java.lang.String options)
public java.lang.String getBaseName()
public boolean lease()
public boolean inUse()
public long getLastUse()
public void expireLease()
public void setPool(KDbConnectionPool pool)
public abstract java.lang.String getURL()
public void clear()