Java Reference
In-Depth Information
57
try
58
{
59
// executeQuery returns ResultSet containing matching entries
resultSet = selectAllPeople.executeQuery();
60
61
results =
new
ArrayList< Person >();
62
63
while
(resultSet.next())
64
{
65
results.add(
new
Person(
66
resultSet.getInt(
"addressID"
),
67
resultSet.getString(
"FirstName"
),
68
resultSet.getString(
"LastName"
),
69
resultSet.getString(
"Email"
),
70
resultSet.getString(
"PhoneNumber")
));
71
}
72
}
73
catch
(SQLException sqlException)
74
{
75
sqlException.printStackTrace();
76
}
77
finally
78
{
79
try
80
{
81
resultSet.close();
82
}
83
catch
(SQLException sqlException)
84
{
85
sqlException.printStackTrace();
86
close();
87
}
88
}
89
90
return
results;
91
}
92
93
// select person by last name
94
public
List< Person > getPeopleByLastName(String name)
95
{
96
List< Person > results =
null
;
97
ResultSet resultSet =
null
;
98
99
try
100
{
101
102
103
104
105
106
results =
new
ArrayList< Person >();
107
108
while
(resultSet.next())
109
{
selectPeopleByLastName.setString(
1
, name);
// specify last name
// executeQuery returns ResultSet containing matching entries
resultSet = selectPeopleByLastName.executeQuery();
Fig. 24.31
|
PreparedStatements
used by the Address Book application. (Part 3 of 5.)