com.fgm.formbuilder.database

Class MySQLIf

java.lang.Object

javax.servlet.GenericServlet

javax.servlet.http.HttpServlet

com.fgm.formbuilder.database.MySQLIf

All Implemented Interfaces:

java.io.Serializable, javax.servlet.Servlet, javax.servlet.ServletConfig

public class MySQLIf
extends javax.servlet.http.HttpServlet

Servlet for SQL Interface requires the following setup in web.xml MySQLIf com.fgm.formbuilder.database.MySQLIf

Author:

Dong Shin

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private DBUserInfo	_user The _user.
private java.sql.Connection	dbConnection The db connection.
protected org.apache.log4j.Logger	logger The logger.
private static java.lang.String	PROP_FILE The Constant PROP_FILE.
private java.lang.String	queryHistoryTbl The query history tbl.
private java.sql.ResultSet	resultSet The result set.
private java.lang.String	sqlStr The sql str.
private java.sql.Statement	statement The statement.

Constructor Summary

Constructors

Constructor and Description
MySQLIf() Instantiates a new blank MySQLIf
MySQLIf(DBUserInfo user) Instantiates a new populated MySQLIf

Method Summary

Methods

Modifier and Type	Method and Description
private void	closeConnection(java.sql.Connection conn) Close connection.
private void	connect(DBUserInfo user) Connect.
SQLResult	copyProject(DBUserInfo user, int projectId) Copy project.
static java.lang.String	executeScript(java.lang.String dbname, java.lang.String dbuser, java.lang.String dbpassword, java.lang.String scriptpath, boolean verbose) execute SQL script - not tested.
void	init() initialize database user configuration using properties file.
static void	main(java.lang.String[] args) The main method.
private java.lang.String	parseQueryType(java.lang.String query) parse query type from query string - INSERT, UPDATE, DELETE.
java.util.ArrayList	parseResultSet(java.sql.ResultSet rs) Parse a result set into a list of lists, where the first list is the column headings and the subsequent lists contain the data.
private java.lang.String	parseTableName(java.lang.String query) parse table name from query string.
private boolean	recordQuery(java.lang.String user, java.lang.String query) record SQL by inserting query data to a table database connection must exist prior!!!!.
SQLResult	runSQL(DBUserInfo user, java.lang.String stmt, boolean recordFlag) run SQL on MySQL database, return results accordingly.
SQLResult	runSQLArr(DBUserInfo user, java.util.List<java.lang.String> sqlList, java.lang.Boolean recordFlag) run list of SQLs on MySQL database, return results accordingly.
SQLResult	runSQLArr(DBUserInfo user, java.util.List<java.lang.String> sqlList, java.lang.Boolean commit, java.lang.Boolean recordFlag) run list of SQLs on MySQL database, return results accordingly.
private SQLResult	SQLError(java.sql.SQLException e, java.lang.String msg, java.lang.String sqlStr) process and construct SQL Error and return.

Methods inherited from class javax.servlet.http.HttpServlet

doDelete, doGet, doHead, doOptions, doPost, doPut, doTrace, getLastModified, service, service

Methods inherited from class javax.servlet.GenericServlet

destroy, getInitParameter, getInitParameterNames, getServletConfig, getServletContext, getServletInfo, getServletName, init, log, log

Methods inherited from class java.lang.Object

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

Field Detail

dbConnection

private java.sql.Connection dbConnection

The db connection.

statement

private java.sql.Statement statement

The statement.

resultSet

private java.sql.ResultSet resultSet

The result set.

sqlStr

private java.lang.String sqlStr

The sql str.

PROP_FILE

private static final java.lang.String PROP_FILE

The Constant PROP_FILE.

See Also:

Constant Field Values

_user

private DBUserInfo _user

The _user.

queryHistoryTbl

private java.lang.String queryHistoryTbl

The query history tbl.

logger

protected org.apache.log4j.Logger logger

The logger.

Constructor Detail

MySQLIf

public MySQLIf()

Instantiates a new blank MySQLIf

MySQLIf

public MySQLIf(DBUserInfo user)

Instantiates a new populated MySQLIf

Parameters:

user - the user

Method Detail

init

public void init()

initialize database user configuration using properties file.

Overrides:

init in class javax.servlet.GenericServlet

connect

private void connect(DBUserInfo user)
              throws java.sql.SQLException

Connect.

Parameters:

user - the user

Throws:

java.sql.SQLException - the SQL exception

runSQL

public SQLResult runSQL(DBUserInfo user,
               java.lang.String stmt,
               boolean recordFlag)

run SQL on MySQL database, return results accordingly.

Parameters:

user - the user

stmt - the stmt

recordFlag - the record flag

Returns:

the SQL result

runSQLArr

public SQLResult runSQLArr(DBUserInfo user,
                  java.util.List<java.lang.String> sqlList,
                  java.lang.Boolean commit,
                  java.lang.Boolean recordFlag)

run list of SQLs on MySQL database, return results accordingly.

Parameters:

user - the user

sqlList - the sql list

commit - the commit

recordFlag - the record flag

Returns:

the SQL result

runSQLArr

public SQLResult runSQLArr(DBUserInfo user,
                  java.util.List<java.lang.String> sqlList,
                  java.lang.Boolean recordFlag)

run list of SQLs on MySQL database, return results accordingly.

Parameters:

user - the user

sqlList - the sql list

recordFlag - the record flag

Returns:

the SQL result

SQLError

private SQLResult SQLError(java.sql.SQLException e,
                 java.lang.String msg,
                 java.lang.String sqlStr)

process and construct SQL Error and return.

Parameters:

e - the e

msg - the msg

sqlStr - the sql str

Returns:

the SQL result

parseResultSet

public java.util.ArrayList parseResultSet(java.sql.ResultSet rs)
                                   throws java.sql.SQLException

Parse a result set into a list of lists, where the first list is the column headings and the subsequent lists contain the data.

Parameters:

rs - the rs

Returns:

the array list

Throws:

java.sql.SQLException - the SQL exception

recordQuery

private boolean recordQuery(java.lang.String user,
                  java.lang.String query)

record SQL by inserting query data to a table database connection must exist prior!!!!.

Parameters:

user - the user

query - the query

Returns:

true, if successful

parseTableName

private java.lang.String parseTableName(java.lang.String query)

parse table name from query string.

Parameters:

query - the query

Returns:

the string

parseQueryType

private java.lang.String parseQueryType(java.lang.String query)

parse query type from query string - INSERT, UPDATE, DELETE.

Parameters:

query - the query

Returns:

the string

executeScript

public static java.lang.String executeScript(java.lang.String dbname,
                             java.lang.String dbuser,
                             java.lang.String dbpassword,
                             java.lang.String scriptpath,
                             boolean verbose)

execute SQL script - not tested.

Parameters:

dbname - the dbname

dbuser - the dbuser

dbpassword - the dbpassword

scriptpath - the scriptpath

verbose - the verbose

Returns:

the string

copyProject

public SQLResult copyProject(DBUserInfo user,
                    int projectId)

Copy project.

Parameters:

user - the user

projectId - the project id

Returns:

the SQL result

closeConnection

private void closeConnection(java.sql.Connection conn)

Close connection.

Parameters:

conn - the conn

main

public static void main(java.lang.String[] args)

The main method. For debugging only

Parameters:

args - the arguments