swpatho.ap1.editor.statistik
Class SqlLib


java.lang.Object

  extended byswpatho.ap1.editor.statistik.SqlLib


public class SqlLib
extends java.lang.Object


Constructor Summary
SqlLib()
           
 
Method Summary
static boolean execute(java.lang.String q, java.sql.Connection conn)
          execute, performs a no-return-operation in mysql
static java.sql.Connection loadDriver()
          loadDriver, creates connection to mySQL database and returns it. --> Using connection parameters MYSQL_ADDRESS MYSQL_PASSWD, MYSQL_USERNAME
static java.sql.ResultSet query(java.lang.String q, java.sql.Connection conn)
          query, performs a query q on connection conn
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SqlLib


public SqlLib()
Method Detail

query


public static java.sql.ResultSet query(java.lang.String q,
                                       java.sql.Connection conn)
query, performs a query q on connection conn

Parameters:
q - String
conn - Connection
Returns:
ResultSet

loadDriver


public static java.sql.Connection loadDriver()
loadDriver, creates connection to mySQL database and returns it. --> Using connection parameters MYSQL_ADDRESS MYSQL_PASSWD, MYSQL_USERNAME

Returns:
Connection

execute


public static boolean execute(java.lang.String q,
                              java.sql.Connection conn)
execute, performs a no-return-operation in mysql

Parameters:
q - String
conn - Connection
Returns:
boolean