Java Reference
In-Depth Information
110
results.add(
new
Person(resultSet.getInt(
"addressID"
),
111
resultSet.getString(
"FirstName"
),
112
resultSet.getString(
"LastName"
),
113
resultSet.getString(
"Email")
,
114
resultSet.getString(
"PhoneNumber"
)));
115
}
116
}
117
catch
(SQLException sqlException)
118
{
119
sqlException.printStackTrace();
120
}
121
finally
122
{
123
try
124
{
125
resultSet.close();
126
}
127
catch
(SQLException sqlException)
128
{
129
sqlException.printStackTrace();
130
close();
131
}
132
}
133
134
return
results;
135
}
136
137
// add an entry
138
public int
addPerson(
139
String fname, String lname, String email, String num)
140
{
141
int
result =
0
;
142
143
// set parameters, then execute insertNewPerson
144
try
145
{
146
147
148
149
150
151
152
153
}
154
catch
(SQLException sqlException)
155
{
156
sqlException.printStackTrace();
157
close();
158
}
159
160
return
result;
161
}
162
insertNewPerson.setString(
1
, fname);
insertNewPerson.setString(
2
, lname);
insertNewPerson.setString(
3
, email);
insertNewPerson.setString(
4
, num);
// insert the new entry; returns # of rows updated
result = insertNewPerson.executeUpdate();
Fig. 24.31
|
PreparedStatements
used by the Address Book application. (Part 4 of 5.)