How to read from text file and insert into database using java

[ryanalhakim]

Hi all,

Please somebody help me, i am newbie in Java. i have questions about java programing, how to read from text file and insert into database.

I have text file let's say like
Header
A123445
U156664
A734355
U835353
A535355
Footer

I wanna be able to read the text file and skip the header and footer, String A means i have to insert the data and String U means i have to update the previous record in database. And i have to parse every string after string A or U. There are 6 strings after A or U. so i want to put into 6 fields in database.

Please somebody help me. Can we do those things in Java?

Thanks

Warmly regards,

Ryan

[Tolls]

while read a line from file
    if line isn't header or footer
        if first letter is A then process Add
        else process Update

[ryanalhakim]

while read a line from file
    if line isn't header or footer
        if first letter is A then process Add
        else process Update

hi sir. thanks so sir. i know the algorithm but i cannot translate that into java code or class.


ryan

[quad64bit]

hi sir. thanks so sir. i know the algorithm but i cannot translate that into java code or class.

So what have you done so far? We don't know where to begin to help you, since you have not provided us with any code. Can we assume you know how to make a java class, main method, regular class & instance methods, understand return types, etc etc?

If so, then the first thing you will need is a database connector. The one for MySQL is MySQL :: Download Connector/J
and the one for oracle is JDBC/UCP Download Page

Once you have a JDBC driver, add it to your project, and then you can establish connections using methods described in this tutorial:Establishing a Connection (The Java™ Tutorials > JDBC(TM) Database Access > JDBC Basics)

[quad64bit]

PS. For file reading, look into the BufferedReader class or the Scanner class. I prefer BufferedReader myself, you would use it like so:

BufferedReader in = new BufferedReader(new FileReader(new File("someFile.txt")));
String line = in.readLine();