PRG 421 Week 5 Individual Week Five Coding Assignment//tutorfortune.com

1. PRG 421 Week 5 Individual Week Five Coding Assignment//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-week-five-coding- assignment P R G 4 2 1 We e k 5 I n d i v i d u a l We e k F i v e C o d i n g A s s i g n me n t R e s o u r c e :   “ S t a r t e r C o d e t o A c c e s s T a b l e s v i a J D B C ” t e x t fi l e F o r t h i s a s s i g n me n t , y o u w i l l c r e a t e J a v a ™ c o d e t h a t a c c e s s e s a r e l a t i o n a l d a t a b a s e , r e q u e s t s d a t a , a n d t h e n a n a l y z e s a n d d i s p l a y s a p o r t i o n o f t h a t d a t a .   I ma g i n e a My S Q L r e l a t i o n a l d a t a b a s e s c h e ma n a me d C O MP A N Y _ D B c o n t a i n i n g t w o t a b l e s , e mp l o y e e _ t a b l e a n d p a y r o l l _ t a b l e , s u c h t h a t t h e r e c o r d s i n e a c h o f t h e t a b l e s i s a s f o l l o w s : E mp i d F N a me L N n a me A d d r C i t y S t a t e Z i p 1 0 0 J a c k S mi t h 1 2 3 N o r t h T o p e k a   K S 6 6 6 0 3 1 0 1 J o e A p p l e 4 S t r e e t D e n v e r C O 8 0 2 0 2 1 1 1 N a n c y G o o d 4 5 S W H a r t f o r d C T

2. 0 6 1 0 3 1 2 1 T o m Wh a t e v e r 8 9 N E D o v e r D E 1 9 9 0 1 1 2 2 J i m T h o mp s o n 7 8 9 W 9 5 A l b a n y N Y 1 2 2 0 7 1 2 3 T o mmy B o y s o n 1 5 4 B o l t B o s t o n MA 0 2 2 0 1 1 2 5 J o h n J o n e s 4 7 We s t L i n c o l n N E 6 8 5 0 2   E mp i d P a y s c h 4 0 1 k S p o u s e 1 0 0 B i Wk y e s y e s 1 0 1 B i Wk y e s y e s 1 1 1 Mo n t h l y n o n o 1 2 1 Wk l y p e n d i n g y e s

3. 1 2 2 Wk l y y e s n o 1 2 3 Mo n t h l y p e n d i n g n o 1 2 5 Mo n t h l y n o y e s   T h e c r e d e n t i a l s y o u w i l l n e e d t o a c c e s s t h e d a t a b a s e w h i c h h o l d s b o t h o f t h e t a b l e s a r e a s f o l l o w s :   H o s t s t r i n g = l o c a l h o s t : 3 3 0 6 U s e r n a me = s t u d e n t P a s s w o r d = p r g 4 2 1 C o p y a n d p a s t e t h e l i n k e d J a v a ™ “ s t a r t e r ” c o d e i n t o t h e N e t B e a n s e d i t o r a n d s a v e a s a J A V A fi l e .   A d d J a v a ™ s t a t e me n t s t o t h e fi l e t o a c c o mp l i s h t h e f o l l o w i n g :   E s t a b l i s h a c o n n e c t i o n t o t h e d a t a b a s e Q u e r y t h e d a t a b a s e , j o i n i n g t h e t w o t a b l e s o n t h e E mp _ i d fi e l d D i s p l a y y o u r n a me a n d t o d a y ’ s d a t e o n t h e c o n s o l e a l o n g w i t h t h e f o l l o w i n g r e t u r n e d d a t a b a s e r e s u l t s : e mp l o y e e i d e n t i fi c a t i o n n u mb e r fi r s t a n d l a s t n a me s t a t e p a y r o l l s c h e d u l e 4 0 1 k p l a n C l o s e t h e d a t a b a s e c o n n e c t i o n

4. I d e n t i f y a n d c o r r e c t a n y c o mp i l e - t i me e r r o r s t h a t e x i s t i n t h e s t a r t e r c o d e .   N o t e : B e c a u s e y o u w i l l n o t b e c o n n e c t i n g t o a n a c t u a l d a t a b a s e , s o me c o mp i l e r e r r o r s w i l l r e ma i n .   A f t e r y o u fi n i s h , r e n a me y o u r J A V A fi l e w i t h a . t x t e x t e n s i o n u s i n g t h e f o l l o w i n g n a mi n g c o n v e n t i o n :   P R G 4 2 1 _ We e k 5 C o d i n g A s s i g n me n t _ L a s t n a me F i r s t n a me . t x t . S u b mi t y o u r T X T fi l e t o t h e A s s i g n me n t F i l e s t a b .   P R G 4 2 1 We e k 5 I n d i v i d u a l We e k F i v e C o d i n g A s s i g n me n t Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-week-five-coding- assignment