private void frame1 ( ) { // SELECT acct_name = ca_name, broker_id = ca_b_id, // cust_id = ca_c_id, tax_status = ca_tax_st FROM // customer_account WHERE ca_id = acct_id String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account" + " WHERE ca_id = " + paramHelper . getAcctId ( ) ; Scan s = executeQuery ( sql ) ; acctName = ( String ) s . getVal ( "ca_name" ) . asJavaVal ( ) ; brokerId = ( Long ) s . getVal ( "ca_b_id" ) . asJavaVal ( ) ; custId = ( Long ) s . getVal ( "ca_c_id" ) . asJavaVal ( ) ; taxStatus = ( Integer ) s . getVal ( "ca_tax_st" ) . asJavaVal ( ) ; // TODO: Add this // num_found = row_count // SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, // cust_tier = c_tier, tax_id = c_tax_id FROM // customer WHERE c_id = cust_id sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer" + " WHERE c_id = " + custId ; s = executeQuery ( sql ) ; custFName = ( String ) s . getVal ( "c_f_name" ) . asJavaVal ( ) ; custLName = ( String ) s . getVal ( "c_l_name" ) . asJavaVal ( ) ; custTier = ( Integer ) s . getVal ( "c_tier" ) . asJavaVal ( ) ; taxId = ( String ) s . getVal ( "c_tax_id" ) . asJavaVal ( ) ; // SELECT broker_name = b_name FROM broker WHERE b_id = broker_id sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId ; s = executeQuery ( sql ) ; brokerName = ( String ) s . getVal ( "b_name" ) . asJavaVal ( ) ; }
Get customer customer account and broker information