Package com.ibm.as400.access.jdbcClient

Class Main

java.lang.Object

com.ibm.as400.access.jdbcClient.Main

All Implemented Interfaces:

Runnable

public class Main
extends Object
implements Runnable

Main class for the jdbcClient program. This sample client uses JDBC to connect to the specified URL using the specified userid and password. This program is provided AS/IS and formal support will NOT be provided. This program should not be used in a production environment. Because this program is provided AS/IS, no consideration is made for NLS support.

Field Summary

Fields

Modifier and Type	Field	Description
static String[]	commandHelp
static String[]	knownDrivers
static String	usage

Constructor Summary

Constructors

Constructor	Description
Main(Main originalMain, String command, PrintStream out)
Main(String url, String userid, String password)

Method Summary

Modifier and Type	Method	Description
static void	appendMixedUXOutput(StringBuffer sb, char[] chars)
static void	dispResultSet(ResultSet rs)
void	executeCallCommand(String command, PrintStream out1)
void	executeCLCommand(String clCommand, PrintStream out1)
boolean	executeCommand(String command1, PrintStream printStreamForExecuteCommand)	Executes a command that is not an SQL query.
void	executeSqlCommand(String command, PrintStream out1)
boolean	executeTopLevelCommand(String command, PrintStream printStreamForTopLevelCommand)	Execute a top level command.
Object	getParameterObject(String thisParm, PrintStream printStreamForParameterObject)
Connection	getPooledConnection(String thisConnectUserId, String thisConnectPassword, String connectUrl, PrintStream out1)
int	go(InputStream in, PrintStream printStreamForGo)
static void	main(String[] args)
Array	makeArray(Object parameter, String arrayType)
static void	printStackTraceToStringBuffer(Throwable e, StringBuffer sb)
void	processException(SQLException ex, String command, PrintStream out1)
static String	readLine(BufferedReader input)
String	removeProperty(String url, String newProperties)
void	run()
void	setCommand(String command)
void	setManualResultSetColType(ResultSetMetaData rsmd)
void	setParameter(PreparedStatement cstmt, String thisParm, int parm, PrintStream printStreamForSetParameter)
void	setPassword(String newpassword)
void	setUrl(String newUrl)
void	setUserId(String newUserId)
void	showMixedUXOutput(PrintStream out1, char[] chars)
void	useConnectionPool(boolean value)

Methods inherited from class java.lang.Object

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

Field Detail

knownDrivers

public static String[] knownDrivers

usage

public static String usage

commandHelp

public static String[] commandHelp

Constructor Detail

Main

public Main(String url,
            String userid,
            String password)
     throws SQLException

Throws:

SQLException

Main

public Main(Main originalMain,
            String command,
            PrintStream out)

Method Detail

readLine

public static String readLine(BufferedReader input)
                       throws Exception

Throws:

Exception

go

public int go(InputStream in,
              PrintStream printStreamForGo)

run

public void run()

Specified by:

run in interface Runnable

setCommand

public void setCommand(String command)

useConnectionPool

public void useConnectionPool(boolean value)

setUrl

public void setUrl(String newUrl)

setUserId

public void setUserId(String newUserId)

setPassword

public void setPassword(String newpassword)

removeProperty

public String removeProperty(String url,
                             String newProperties)

setManualResultSetColType

public void setManualResultSetColType(ResultSetMetaData rsmd)
                               throws SQLException

Throws:

SQLException

getPooledConnection

public Connection getPooledConnection(String thisConnectUserId,
                                      String thisConnectPassword,
                                      String connectUrl,
                                      PrintStream out1)
                               throws SQLException

Throws:

SQLException

executeCLCommand

public void executeCLCommand(String clCommand,
                             PrintStream out1)
                      throws Exception

Throws:

Exception

executeCallCommand

public void executeCallCommand(String command,
                               PrintStream out1)
                        throws Exception

Throws:

Exception

executeSqlCommand

public void executeSqlCommand(String command,
                              PrintStream out1)
                       throws Exception

Throws:

Exception

processException

public void processException(SQLException ex,
                             String command,
                             PrintStream out1)

executeTopLevelCommand

public boolean executeTopLevelCommand(String command,
                                      PrintStream printStreamForTopLevelCommand)

Execute a top level command. This may be an SQL statement or a command !

Parameters:

command -

printStreamForTopLevelCommand -

Returns:

false if the top level command is exit or quit

executeCommand

public boolean executeCommand(String command1,
                              PrintStream printStreamForExecuteCommand)

Executes a command that is not an SQL query. The ! has already been stripped from the command.

Parameters:

command1 -

printStreamForExecuteCommand -

Returns:

false if the command is exit or quit

printStackTraceToStringBuffer

public static void printStackTraceToStringBuffer(Throwable e,
                                                 StringBuffer sb)

dispResultSet

public static void dispResultSet(ResultSet rs)
                          throws SQLException

Throws:

SQLException

showMixedUXOutput

public void showMixedUXOutput(PrintStream out1,
                              char[] chars)

appendMixedUXOutput

public static void appendMixedUXOutput(StringBuffer sb,
                                       char[] chars)

getParameterObject

public Object getParameterObject(String thisParm,
                                 PrintStream printStreamForParameterObject)

setParameter

public void setParameter(PreparedStatement cstmt,
                         String thisParm,
                         int parm,
                         PrintStream printStreamForSetParameter)
                  throws SQLException

Throws:

SQLException

makeArray

public Array makeArray(Object parameter,
                       String arrayType)
                throws Exception

Throws:

Exception

main

public static void main(String[] args)