new file mode 100644
--- /dev/null
+++ b/javadb/org/homelinux/largo/sql/client/DBClient.java
@@ -0,0 +1,120 @@
+package org.homelinux.largo.sql.client;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.Statement;
+
+import javax.naming.Context;
+import javax.naming.InitialContext;
+import javax.sql.DataSource;
+
+public class DBClient {
+ private Connection connection;
+ private Statement statement;
+ private ResultSet resultset;
+
+ private String driver, username, password;
+ private String dbURL;
+
+ /**
+ * Default Konstruktor to connect to my database
+ */
+ public DBClient () throws Exception {
+ this.driver = "org.apache.derby.jdbc.EmbeddedDriver";
+ this.dbURL = "jdbc:derby://localhost/clubstatistik";
+
+ this.username = null;
+ this.password = null;
+
+ Class.forName (driver);
+ connection = DriverManager.getConnection (dbURL, username, password);
+ statement = connection.createStatement ();
+ }
+
+ /**
+ * Default Konstruktor to connect to my DataPool
+ */
+ public DBClient (String jndiResource) throws Exception {
+ Context ctx = new InitialContext ();
+ DataSource ds = (DataSource) ctx.lookup (jndiResource);
+
+ connection = ds.getConnection ();
+ statement = connection.createStatement ();
+ }
+
+ /**
+ * Default Konstruktor to connect to my database with auth-data
+ */
+ public DBClient (String driver, String dbURL, String username, String password) throws Exception {
+ this.driver = driver;
+ this.dbURL = dbURL;
+
+ this.username = username;
+ this.password = password;
+
+ Class.forName (driver);
+ connection = DriverManager.getConnection (dbURL, username, password);
+ statement = connection.createStatement ();
+ }
+
+ public void close () throws Exception {
+ connection.close ();
+ }
+
+ public String getColumn (int pos) throws Exception {
+ return resultset.getString (pos);
+ }
+
+ public String getColumn (String name) throws Exception {
+ return resultset.getString (name);
+ }
+
+ public Connection getConnection () {
+ return connection;
+ }
+
+ public String getDbURL () {
+ return dbURL;
+ }
+
+ public String getDriver () {
+ return driver;
+ }
+
+ public String getPassword () {
+ return password;
+ }
+
+ public String getUsername () {
+ return username;
+ }
+
+ public boolean hasNext () throws Exception {
+ return resultset.next ();
+ }
+
+ public void query (String query) throws Exception {
+ resultset = statement.executeQuery (query);
+ }
+
+ public void setConnection (Connection connection) {
+ this.connection = connection;
+ }
+
+ public void setDbURL (String dbURL) {
+ this.dbURL = dbURL;
+ }
+
+ public void setDriver (String driver) {
+ this.driver = driver;
+ }
+
+ public void setPassword (String password) {
+ this.password = password;
+ }
+
+ public void setUsername (String username) {
+ this.username = username;
+ }
+}