Here is 41.1 Listing

(Get a score from a database table) Suppose the scores are stored in the scores table. The table was created as follows: create table Scores (name varchar (20), score number, permission boolean); insert into Scores values 'John', 90.5, 1); insert into Scores values ('Michael', 100, 1); insert into Scores values ('Michelle', 100, 0) Revise the findscore method in Listing 41.1, ScoreServicejava, to obtain a score for the specified name. Note your program does not need thepermission column; ignore it. The next exercise will need the permission column