Thread: 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