Name $($print$)$:

ID:

$4.$ The following is the login table in the database. Only one tuple in login right now.

$\backslash$table$[[$ID$,$password$],[$User$3,123456]]$

If the following program is executed successfully, list all tuples in the login table, and give the output of the program.

import java.sql$.*$;

public class JDBCexample $\{$

public static void main$($String$[]$ args$)\{$

try

f

Class.forName$("$sun$.$jdbc$.$odbc.JdbcOdbcDriver"$)$;

Connection con$=$DriverManager.getConnection$("$jdbc:odbc:TESTJDBC"$)$;$/$TESTJDBC is the data

source name

Statement st $=$ con.createStatement ;

String str$=$"TESTJDBC";

st$.$executeUpdate$("$insert into login values$(\text{'}$userl$\text{'},$'abcdef'$)")$;

st$.$executeUpdate$("$insert into login values$(\text{'}$user$2\text{'},\text{'}123456\text{'})")$;

PreparedStatement stmt$=$con.prepareStatement$("$insert into login values$(?,\text{'}$a$123456\text{'})")$;

stmt$.$setString$(1,$ "Tom"$)$;

stmt$.$executeUpdate$()$;

stmt$.$setString$(1,$ "Jerry"$)$;

stmt$.$executeUpdate$()$;

st$.$executeUpdate$("$update login set password$=\text{'}"+$str$+"\text{'}$ where ID$=$'Jerry"$\text{'})$;

ResultSet rs$=$st$.$executeQuery$("$select $*$ from login where password LIKE $\text{'}$a$\%"\text{'})$;

String user;

String password;

while $($rs$.$next $0)$

$\{$

user$-$rs$.$getString$(1)$;

password$=$rs$.$getString$(2)$;

System.out.println$("$ID: $"+$ user $+"$ password: $"+$password$)$;

$\}$

rs$.$close $0$ ;

st$.$executeUpdate$("$delete from login where password LIKE $\text{'}\%6\%"\text{'})$;

st$.$close$()$;

stmt$.$close $()$;

con.close ;

$\}$

catch $($Exception e$)$

i

System.out.println$($e$)$;

$\}$

$\}$

a$)$ List tuples of login table in database after the above program is executed successfully. ID password