Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: An absolute newbie looking for Java JDBC code/query help ?

  1. #1
    Junior Member
    Join Date
    Oct 2018
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default An absolute newbie looking for Java JDBC code/query help ?

    I have an oracle table that has columns with values that look like the below. I am in need of a code/query to connect to oracle through JDBC and get a list report to display , display the average number of days that each part(Pno) spent in transit. With a query, for each projec(projno), display the number of parts delivered in 2017. Can anybody help

    Oracle table:

    SNo PNo ProjNo ShipDate ArriveDate
    S1 P1 J1 1/5/18 1/25/19
    S1 P1 J4 2/1/18 2/4/18
    S1 P3 J1 12/15/17 1/8/18
    S1 P3 J2 11/2/17 11/18/17
    S1 P3 J3 8/5/17 9/1/17
    S2 P3 J4 8/5/17 8/9/17
    S2 P3 J5 7/3/17 7/29/17
    S2 P3 J6 9/3/17 9/10/17
    S2 P3 J7 2/5/18 2/15/18
    S3 P5 J6 1/6/18 1/14/18
    S3 P3 J2 3/5/18 3/15/18
    S3 P4 J1 2/27/18 3/6/18
    S3 P6 J2 6/15/17 6/27/17
    S4 P6 J3 6/17/17 6/30/17
    S4 P2 J6 5/2/17 6/2/17
    S4 P5 J5 5/5/17 5/10/17
    S4 P5 J2 9/15/17 10/1/17
    S5 P7 J4 10/2/17 10/23/17
    S5 P1 J5 11/5/17 11/17/17
    S5 P3 J7 12/12/17 1/4/18
    S5 P4 J4 12/22/17 1/16/18
    S5 P5 J4 5/7/18 6/1/18
    S5 P6 J4 4/23/18 5/2/18
    S5 P2 J4 4/20/18 5/2/18

  2. #2
    Member John Joe's Avatar
    Join Date
    Jun 2017
    Posts
    258
    My Mood
    Amused
    Thanks
    8
    Thanked 18 Times in 18 Posts

    Default Re: An absolute newbie looking for Java JDBC code/query help ?

    This article might help
    JDBC - How to connect Eclipse to Oracle Database - Step by Step Guide | Java67
    Whatever you are, be a good one

Similar Threads

  1. Need help with my code! Absolute coordinates
    By MrLemons in forum Java Theory & Questions
    Replies: 10
    Last Post: September 16th, 2013, 04:17 PM
  2. Absolute beginner with errors in code
    By Robl in forum What's Wrong With My Code?
    Replies: 9
    Last Post: February 13th, 2013, 07:13 PM
  3. JDBC - any query and the corresponding result set
    By moekler in forum What's Wrong With My Code?
    Replies: 3
    Last Post: November 19th, 2012, 04:15 PM
  4. Replies: 1
    Last Post: April 25th, 2011, 04:06 PM
  5. Re: Java Newbie Code Problem
    By erinbasim in forum What's Wrong With My Code?
    Replies: 1
    Last Post: January 17th, 2010, 01:05 AM