Results 1 to 7 of 7
  1. #1
    akashvani is offline Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0

    Default How to read data from a file and search the results from database

    Hi All,

    I have a file which has to be uploaded from front end .
    Data has to be read from java code and get the corresponding values from the database and display on the screen.

    Please find the below sample data in a notepad.(Values can go upto 4000 records)
    215.0 215.0
    300.00 310.00
    194.10
    194.11
    300.8 300.8
    330.8 330.8
    330.80 330.8

    COuld you please help me in wiritng this functionality?

    Thanks,

  2. #2
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    25

    Default Re: How to read data from a file and search the results from database

    What problems are you having? Can you show us your current code and let us know how it isn't working?

  3. #3
    akashvani is offline Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0

    Default Re: How to read data from a file and search the results from database

    Iam wondering how to pass the values from java to database.
    Either call database procedure for each row or pass all the values as a array object to database.

    Iam a database guy need help in designing this fucntionality

  4. #4
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    25

    Default Re: How to read data from a file and search the results from database

    Have you gone through the Java database tutorials? If so, what part are you stuck on?

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    18

    Default Re: How to read data from a file and search the results from database

    This is a bit vague.
    Are those pairs of values?
    I see some of them have only a single value there.
    How do they tie up with the database structure?
    Please do not ask for code as refusal often offends.

  6. #6
    akashvani is offline Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0

    Default Re: How to read data from a file and search the results from database

    codes are ranges and single values
    select query will be based on input
    if it is range between and if it is single equalsto

  7. #7
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    18

    Default Re: How to read data from a file and search the results from database

    And when were you planning on informing this forum you had an answer?
    https://forums.oracle.com/forums/thr...72165&tstart=0
    Please do not ask for code as refusal often offends.

Similar Threads

  1. Replies: 3
    Last Post: 06-12-2012, 04:47 PM
  2. Replies: 2
    Last Post: 04-20-2011, 05:39 PM
  3. Replies: 2
    Last Post: 03-25-2011, 02:36 PM
  4. Design search results .jsp
    By maas in forum JavaServer Pages (JSP) and JSTL
    Replies: 3
    Last Post: 07-19-2010, 07:18 AM
  5. Read file from database
    By ipurdi in forum New To Java
    Replies: 1
    Last Post: 06-09-2010, 05:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •