JAVASERVER FACES - Introduction to Java Programming: Comprehensive Version - page 1251

115 return "" ;

116 else

117 return "Last Name and First Name are required" ;

118 }
119
120 public String getInput() {
121 return "<p style=\"color:red\">You entered <br />"
122 + "Last Name: " + lastName + "<br />"
123 + "First Name: " + firstName + "<br />"
124 + "MI: " + mi + "<br />"
125 + "Telephone: " + telephone + "<br />"
126 + "Email: " + email + "<br />"
127 + "Street: " + street + "<br />"
128 + "City: " + city + "<br />"
129 + "Street: " + street + "<br />"
130 + "City: " + city + "<br />"
131 + "State: " + state + "<br />"
132 + "Zip: " + zip + "</p>" ;
133 }
134
135 /** Initialize database connection */
136 private void initializeJdbc() {
137 try {
138 // Explicitly load a MySQL driver
139 Class.forName( "com.mysql.jdbc.Driver" );
140 System.out.println( "Driver loaded" );
141
142 // Establish a connection
143 Connection conn = DriverManager.getConnection(
144

get input

"jdbc:mysql://localhost/javabook" , "scott" , "tiger" );

145
146 // Create a Statement
147 pstmt = conn.prepareStatement( "insert into Address (lastName,"
148 + " firstName, mi, telephone, email, street, city, "
149 + "state, zip) values (?, ?, ?, ?, ?, ?, ?, ?, ?)" );
150 }
151 catch (Exception ex) {
152 System.out.println(ex);
153 }
154 }
155
156 /** Store an address to the database */
157 public String storeStudent() {
158 try {
159 pstmt.setString( 1 , lastName);
160 pstmt.setString( 2 , firstName);
161 pstmt.setString( 3 , mi);
162 pstmt.setString( 4 , telephone);
163 pstmt.setString( 5 , email);
164 pstmt.setString( 6 , street);
165 pstmt.setString( 7 , city);
166 pstmt.setString( 8 , state);
167 pstmt.setString( 9 , zip);
168 pstmt.executeUpdate();
169 status = firstName + " " + lastName
170 + " is now registered in the database." ;
171 }
172 catch (Exception ex) {
173 status = ex.getMessage();
174 }

store address

update status