Printable View
Delighted to be on a forum where I can have my queries answered. I am an old Java programmer and the need to program in Java has arisen again. please I need guidance on how to carry out a task.
The task is to write a Java program that will populate an SQL database with the content of a text file. Help please!!!
Well, depending on where the text file is, you can use Scanner (Scanner (Java Platform SE 6)) or BufferedReader (BufferedReader (Java Platform SE 6)). Then use the Database classes to communicate and write to the database (Statement, Connection, ResultSet, ect.).
Welcome to the forums kahlit and welcome back to Java :)
Thank you for you response. would appreciate if you can give a step by step guide on what i need to do as this is completely new to me. still a beginner please. I am just going to create the text file and the database.
Firstly I suggest writing something that will allow you to connect to an SQL database. Then you can worry about populating it..
Is it a mySQL database?
MySQL and Java JDBC - Tutorial
When you move onto reading the file..
http://www.javaprogrammingforums.com...ner-class.html