How To Read In File And Insert Into Database

I need to read in a file then create the tables and load in the data from the files to the database. I cant seem to figure out how to load the provided text file into the database.it contains lines like this

Boston Americans,AL,Pittsburgh Pirates
New York Giants,NL,Philadelphia Athletics
etc..

The first line in the field is the name of the team that won in 1903, and the last line is the name of the team that won in 2013. Note that the World Series was not played in 1904 or 1994, so those years are skipped in the file

The program should have a menu that has the following options.

NOTE: the data for choices to e) needs to come from running sql statements on the database tables created in choice a). Not from an ArrayList in memory.

a) Convert the baseball text file to a database table. Ask the user from a dialog box, for the location of the text file. This menu item should create the tables and load up the data.

b)Let the user input a team name, and list all of the years that they won the World Series

c)Let the user input a team name, and list the number of times they won the World Series

d)Let the user input a year, and you list the winner and loser for that year.

e)Add a new winner. The user should supply the winning team name, losing team name and year. Make certain that the year does not yet exist in the table and do not duplicate the team name(s) if they are already in the database tables.

f)Exit

I have two tables teams and games:

Drop table if exists game;
Drop table if exists team;
CREATE TABLE IF NOT EXISTS game (
yearGame int(11) NOT NULL,
winTeam int(11) NOT NULL,
lossTeam int(11) NOT NULL,

[Code] ....

I cant figure out how to load the values into the tables as only some of the fields are in the text and and the league field is in a seperate table. Here is my script so far

do {
JFileChooser chooser = new JFileChooser();
FileNameExtensionFilter filter = new FileNameExtensionFilter("Text/Java files", "txt", "java");
chooser.setFileFilter(filter);
int returnVal = chooser.showOpenDialog(null);

[Code] .....