They are different structures which I think is determined by the 'Kind' (transaction type) value.
For example:
'Opening Account' kind:
insert into Transactions (YY_MM_DD, HH_MM_SS, Kind, Account, Name, Street, Suburb, Postcode)
values ('07/02/20', '16:42:46', '(', 'S017', 'Strathfield Car Radios ', '689 South Road ', 'Black Forest SA ', 5035);
'Closing Account' kind:
insert...
Muffcake29
Last Activity: May 20 '07, 04:22 AM
Joined: May 11 '07
Location:
-
Oh ok I've read those but I can't seem to apply them to the file I'm reading. I'm trying to use a FileReader and Tokenizer to read the strings but I'm not sure on how to ignore the things I don't need.
For example I want to save the values of the attributes into strings so I can use them in a subsequent query. But one of the attributes, Kind, can have the value '(' but I'm not sure how to make the tokenizer ignore opening brackets...Leave a comment:
-
Reading a SQL file in Java
Hello everyone,
Just wondering if someone could help me with this. I'm working on a JDBC assignment but cannot quite figure out how to read in the required file.
Some example lines are:
insert into Transactions (YY_MM_DD, HH_MM_SS, Kind, Account, Name, Street, Suburb, Postcode)
values ('07/02/20', '16:42:46', '(', 'S017', 'Strathfield Car Radios ', '689 South Road ', 'Black Forest SA ', 5035);...
No activity results to display
Leave a comment: