java application to read a text document

Posted on 2012-08-16
Last Modified: 2012-08-27

I am looking for a java application which reads a text document(later on I should be able to change to accept other input formats) say xyz.txt as in attachment.After reading the document with say 2 records java application should build a query againest oracle database and find out if those 2 records are already there or not in a table called 'names' under schema say 'HR'. Accordingly it should prepare a report of missing records document. Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
Question by:gudii9
    LVL 26

    Assisted Solution

    I'm not sure what advice you're looking for here - obviously there's a lot to writing a full application to do all this.

    Step 1 for reading a text document is explained here:

    LVL 24

    Assisted Solution

    by:Tomas Helgi Johannsson

    Look at this website here for sample code and to get ideas :)

    This chapter is on how to handle Files in various ways :)

        Tomas Helgi
    LVL 20

    Accepted Solution

    You can use apache commons io APIs "" class that will give you a List of string for each line in the file. Then use StringTokenizer and extract the field values to  be used in the query and form the query.

    Refer the API
    LVL 7

    Author Comment

    Can you please let me know how to form the query to after readog the string for each line in the file. Please advise

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    squareUp  challenge 22 81
    array6 challenfge 6 48
    nestparen challenge 4 37
    wordlen challenge 3 30
    By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
    I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    This video teaches viewers about errors in exception handling.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now