public String connectToDB(String systemName,String userid,String password)
{
 try {
	setCursor(java.awt.Cursor.getPredefinedCursor(java.awt.Cursor.WAIT_CURSOR));
	AS400JDBCConnectionPoolDataSource dataSource =new
		AS400JDBCConnectionPoolDataSource(systemName,userid,password);
	AS400JDBCConnectionPool pool =new AS400JDBCConnectionPool(dataSource);
	pool.setMaxConnections(1);
	pool.fill(1);
	dbConnect =pool.getConnection();

	psSingleRecord =dbConnect.prepareStatement("SELECT *FROM PARTS WHERE PARTNO =?");
	psAllRecord =dbConnect.prepareStatement("SELECT *FROM PARTS ORDER BY PARTNO",
	java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,
	java.sql.ResultSet.CONCUR_READ_ONLY);
	psAllRecord.setFetchSize(10);
	psUpdateRecord =dbConnect.prepareStatement("UPDATE PARTS SET PARTDS =?,"+"
		PARTQY =?,PARTPR =?,PARTDT =?WHERE PARTNO =?");
	psAddRecord =dbConnect.prepareStatement("INSERT INTO PARTS (PARTDS,PARTQY,"+"
		PARTPR,PARTDT,PARTNO)VALUES(?,?,?,?,?)");
	psDeleteRecord =dbConnect.prepareStatement("DELETE FROM PARTS WHERE PARTNO =?");
 }catch (Exception e){
	e.printStackTrace();
	showException(e);
	setCursor(java.awt.Cursor.getPredefinedCursor(java.awt.Cursor.DEFAULT_CURSOR));
	return "Connect Failed.";
 }
	setCursor(java.awt.Cursor.getPredefinedCursor(java.awt.Cursor.DEFAULT_CURSOR));
	return "Connected to AS/400.";
}