Java Reference
In-Depth Information
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
Search WWH ::
Custom Search