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.)
Search WWH ::




Custom Search