public interface ISql
| Modifier and Type | Method and Description |
|---|---|
void |
close()
Close Connection to Database
|
void |
connect()
Connect to Database
|
java.sql.ResultSet |
get(java.lang.String sql)
Return Data from Database
|
boolean |
isConnected()
Check if a Database Connection Exists
|
int |
update(java.lang.String sql)
Execute SQL on Database
|
long |
updateId(java.lang.String sql)
Execute SQL on Database and Return Id of new Row
|
void connect()
throws java.sql.SQLException
java.sql.SQLException - in Case of Errorvoid close()
throws java.sql.SQLException
java.sql.SQLException - in Case of Errorboolean isConnected()
throws java.sql.SQLException
java.sql.SQLException - in Case of Errorint update(java.lang.String sql)
throws java.sql.SQLException
sql - SQL to Executejava.sql.SQLException - in Case of Errorlong updateId(java.lang.String sql)
throws java.sql.SQLException
sql - SQL to Executejava.sql.SQLException - in Case of Errorjava.sql.ResultSet get(java.lang.String sql)
throws java.sql.SQLException
sql - SQL to Executejava.sql.SQLException - in Case of Error