org.buglet.db
Class SQLTable

java.lang.Object
  |
  +--org.buglet.db.SQLTable

Direct Known Subclasses:

SQLSelect

public class SQLTable

extends java.lang.Object

This class designed to allow the user to easily insert a row into a table in mysql. The example is something like: SQLTable mtable = new SQLTable("tablename"); mtable.add("col1", 12); mtable.add("col2", "234"); mtable.send(); Insert is the default mode of the classe However, you can also do an update // example: update tablename // set col1=value1, col2=value2 // where col3=value3 SQLTable m = new SQLTable("tablename"); m.setOpUpdate(); m.add("col1", value1); m.add("col2", value2); // add a where clause to the sql m.addWhere(col3, value3); m.send();

Inner Class Summary

class

SQLTable.whereParam

Field Summary

static BugPool	bugPool
static int	DB_CONTACT
static int	DB_JOB
(package private) java.lang.String	dbname
boolean	isBug
boolean	isContact
(package private) static org.apache.log4j.Category	log
static int	OP_DELETE
static int	OP_INSERT
static int	OP_STRAIGHT
static int	OP_UPDATE
int	operation
static java.lang.String[]	operationNames
(package private) java.lang.String	overridesql
(package private) java.util.Hashtable	parameters parameters for insert, update, e.g.
(package private) int	success
(package private) java.lang.String	tablename
static int	WHEREOP_DATEEND
static int	WHEREOP_DATESTART
static int	WHEREOP_EMPTYORNULL
static int	WHEREOP_EQUALORNULL
static int	WHEREOP_EQUALS Various where clause operations that can be performed
static int	WHEREOP_GREATERTHAN
static int	WHEREOP_GREATERTHANORNULL
static int	WHEREOP_GREATERTHANZEROORNULL
static int	WHEREOP_ISIN
static int	WHEREOP_ISNOTNULL
static int	WHEREOP_ISNULL
static int	WHEREOP_LESSTHAN
static int	WHEREOP_LESSTHANORNULL
static int	WHEREOP_LESSTHANZEROORNULL
static int	WHEREOP_LIKE
static int	WHEREOP_NOTEQUALS
static int	WHEREOP_VALUE
(package private) java.util.Vector	whereParams

Constructor Summary

SQLTable(java.lang.String tablename)

SQLTable(java.lang.String dbname, java.lang.String tablename)
sole constructor

Method Summary

void	add(java.lang.String name, double value) adds an item to the parameters prepped to send to the db
void	add(java.lang.String name, FancyDateCore theDate)
void	add(java.lang.String name, int value)
void	add(java.lang.String name, long value)
void	add(java.lang.String name, java.lang.String value) adds an item to the parameters prepped to send to the db
void	addDateEnd(java.lang.String name, FancyDateCore theDate)
void	addDateOnlyEnd(java.lang.String name, FancyDateCore theDate)
void	addDateOnlyStart(java.lang.String name, FancyDateCore theDate)
void	addDateStart(java.lang.String name, FancyDateCore theDate)
void	addEmptyOrIsNull(java.lang.String name)
void	addEqualOrNull(java.lang.String name, java.lang.String value)
void	addGreaterThan(java.lang.String name, long value)
void	addGreaterThan(java.lang.String name, java.lang.String value)
void	addGreaterThanOrNull(java.lang.String name, double value)
void	addGreaterThanOrNull(java.lang.String name, long value)
void	addGreaterThanZeroOrNull(java.lang.String name, double value)
void	addGreaterThanZeroOrNull(java.lang.String name, long value)
void	addIgnoreParam(java.lang.String name, long value)
void	addIgnoreParam(java.lang.String name, java.lang.String value)
void	addIsIn(java.lang.String name, java.lang.String isinclause)
void	addIsIn(java.lang.String name, java.lang.String[] inVals)
void	addIsNotNull(java.lang.String name)
void	addIsNull(java.lang.String name)
void	addLessThan(java.lang.String name, double value)
void	addLessThan(java.lang.String name, FancyDateCore theDate)
void	addLessThan(java.lang.String name, long value)
void	addLessThan(java.lang.String name, java.lang.String value)
void	addLessThanOrNull(java.lang.String name, double value)
void	addLessThanOrNull(java.lang.String name, long value)
void	addLessThanZeroOrNull(java.lang.String name, double value)
void	addLessThanZeroOrNull(java.lang.String name, long value)
void	addLike(java.lang.String name, java.lang.String value)
void	addLikeParam(java.lang.String name, java.lang.String value)
void	addWhere(java.lang.String name, FancyDateCore theDate)
void	addWhere(java.lang.String name, int value)
void	addWhere(java.lang.String name, long value)
void	addWhere(java.lang.String name, java.lang.String value) add to the where clause
void	freeHandle(java.sql.Connection con)
java.sql.Connection	getHandle()
long	getInsertID() returns the InsertID of the last insert
boolean	isSuccess() return the result of the last send - if there was no error then return true.
java.lang.String	prepSql() internal function to create the appropriate "insert statement it processes the Hashtable "row"
void	send() sends the current "row" Hashtable to the database clears the list otherwise.
void	setFetchID() set the flag to indicate that this insert will generate an auto_increment LAST_INSERT key.
void	setIsBug(boolean isBug)
void	setIsContact(boolean isContact)
void	setOpDelete()
void	setOpStraight()
void	setOpUpdate()
void	setOverRideSql(java.lang.String theSql)
(package private) java.lang.String	sqlEscape(java.lang.String sql) private escape codes to protect sql.
java.lang.String	toString()
(package private) java.lang.String	wherePartClause(SQLTable.whereParam w, java.lang.String name, java.lang.String alias)

Methods inherited from class java.lang.Object

, clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

log

static org.apache.log4j.Category log

DB_JOB

public static final int DB_JOB

DB_CONTACT

public static final int DB_CONTACT

dbname

java.lang.String dbname

tablename

java.lang.String tablename

overridesql

java.lang.String overridesql

success

int success

parameters

java.util.Hashtable parameters

parameters for insert, update, e.g. insert tablename (value1, value2) values("foo", "junk"); there would be listed value1 and value2 in parameters e.g. update tablename value1=foo, value2 =2 where value3 = foo3; parameters in this case would have value1, value2 whereParams would have value3.

whereParams

java.util.Vector whereParams

bugPool

public static BugPool bugPool

isContact

public boolean isContact

isBug

public boolean isBug

operation

public int operation

OP_INSERT

public static final int OP_INSERT

OP_UPDATE

public static final int OP_UPDATE

OP_DELETE

public static final int OP_DELETE

OP_STRAIGHT

public static final int OP_STRAIGHT

WHEREOP_EQUALS

public static final int WHEREOP_EQUALS

Various where clause operations that can be performed

WHEREOP_LESSTHAN

public static final int WHEREOP_LESSTHAN

WHEREOP_GREATERTHAN

public static final int WHEREOP_GREATERTHAN

WHEREOP_NOTEQUALS

public static final int WHEREOP_NOTEQUALS

WHEREOP_LIKE

public static final int WHEREOP_LIKE

WHEREOP_DATEEND

public static final int WHEREOP_DATEEND

WHEREOP_DATESTART

public static final int WHEREOP_DATESTART

WHEREOP_ISIN

public static final int WHEREOP_ISIN

WHEREOP_ISNULL

public static final int WHEREOP_ISNULL

WHEREOP_ISNOTNULL

public static final int WHEREOP_ISNOTNULL

WHEREOP_VALUE

public static final int WHEREOP_VALUE

WHEREOP_LESSTHANORNULL

public static final int WHEREOP_LESSTHANORNULL

WHEREOP_GREATERTHANORNULL

public static final int WHEREOP_GREATERTHANORNULL

WHEREOP_GREATERTHANZEROORNULL

public static final int WHEREOP_GREATERTHANZEROORNULL

WHEREOP_LESSTHANZEROORNULL

public static final int WHEREOP_LESSTHANZEROORNULL

WHEREOP_EMPTYORNULL

public static final int WHEREOP_EMPTYORNULL

WHEREOP_EQUALORNULL

public static final int WHEREOP_EQUALORNULL

operationNames

public static java.lang.String[] operationNames

Constructor Detail

SQLTable

public SQLTable(java.lang.String dbname,
                java.lang.String tablename)

sole constructor

SQLTable

public SQLTable(java.lang.String tablename)

Method Detail

setIsContact

public void setIsContact(boolean isContact)

setIsBug

public void setIsBug(boolean isBug)

setOpDelete

public void setOpDelete()

setOpUpdate

public void setOpUpdate()

setOpStraight

public void setOpStraight()

add

public void add(java.lang.String name,
                double value)

adds an item to the parameters prepped to send to the db

add

public void add(java.lang.String name,
                FancyDateCore theDate)

add

public void add(java.lang.String name,
                java.lang.String value)

adds an item to the parameters prepped to send to the db

addWhere

public void addWhere(java.lang.String name,
                     java.lang.String value)

add to the where clause

addWhere

public void addWhere(java.lang.String name,
                     long value)

addWhere

public void addWhere(java.lang.String name,
                     FancyDateCore theDate)

addWhere

public void addWhere(java.lang.String name,
                     int value)

addLike

public void addLike(java.lang.String name,
                    java.lang.String value)

addGreaterThan

public void addGreaterThan(java.lang.String name,
                           long value)

addGreaterThan

public void addGreaterThan(java.lang.String name,
                           java.lang.String value)

addLessThan

public void addLessThan(java.lang.String name,
                        long value)

addLessThan

public void addLessThan(java.lang.String name,
                        double value)

addLessThan

public void addLessThan(java.lang.String name,
                        java.lang.String value)

addLessThanOrNull

public void addLessThanOrNull(java.lang.String name,
                              long value)

addLessThanOrNull

public void addLessThanOrNull(java.lang.String name,
                              double value)

addLessThanZeroOrNull

public void addLessThanZeroOrNull(java.lang.String name,
                                  long value)

addLessThanZeroOrNull

public void addLessThanZeroOrNull(java.lang.String name,
                                  double value)

addGreaterThanOrNull

public void addGreaterThanOrNull(java.lang.String name,
                                 long value)

addGreaterThanOrNull

public void addGreaterThanOrNull(java.lang.String name,
                                 double value)

addGreaterThanZeroOrNull

public void addGreaterThanZeroOrNull(java.lang.String name,
                                     long value)

addGreaterThanZeroOrNull

public void addGreaterThanZeroOrNull(java.lang.String name,
                                     double value)

addLessThan

public void addLessThan(java.lang.String name,
                        FancyDateCore theDate)

addDateOnlyEnd

public void addDateOnlyEnd(java.lang.String name,
                           FancyDateCore theDate)

addDateOnlyStart

public void addDateOnlyStart(java.lang.String name,
                             FancyDateCore theDate)

addDateEnd

public void addDateEnd(java.lang.String name,
                       FancyDateCore theDate)

addDateStart

public void addDateStart(java.lang.String name,
                         FancyDateCore theDate)

addLikeParam

public void addLikeParam(java.lang.String name,
                         java.lang.String value)

addIsIn

public void addIsIn(java.lang.String name,
                    java.lang.String[] inVals)

addIsIn

public void addIsIn(java.lang.String name,
                    java.lang.String isinclause)

addIsNull

public void addIsNull(java.lang.String name)

addEmptyOrIsNull

public void addEmptyOrIsNull(java.lang.String name)

addEqualOrNull

public void addEqualOrNull(java.lang.String name,
                           java.lang.String value)

addIsNotNull

public void addIsNotNull(java.lang.String name)

add

public void add(java.lang.String name,
                long value)

add

public void add(java.lang.String name,
                int value)

addIgnoreParam

public void addIgnoreParam(java.lang.String name,
                           long value)

addIgnoreParam

public void addIgnoreParam(java.lang.String name,
                           java.lang.String value)

send

public void send()

sends the current "row" Hashtable to the database clears the list otherwise.

isSuccess

public boolean isSuccess()

return the result of the last send - if there was no error then return true.

setFetchID

public void setFetchID()

set the flag to indicate that this insert will generate an auto_increment LAST_INSERT key. this is used in case where we want our db to give us a magic number.

getInsertID

public long getInsertID()

returns the InsertID of the last insert

setOverRideSql

public void setOverRideSql(java.lang.String theSql)

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

prepSql

public java.lang.String prepSql()

internal function to create the appropriate "insert statement it processes the Hashtable "row"

wherePartClause

java.lang.String wherePartClause(SQLTable.whereParam w,
                                 java.lang.String name,
                                 java.lang.String alias)

sqlEscape

java.lang.String sqlEscape(java.lang.String sql)

private escape codes to protect sql. fixme - what needs to be escaped for mysql???

getHandle

public java.sql.Connection getHandle()

freeHandle

public void freeHandle(java.sql.Connection con)