//File: newAddress.html
Add a new entry
Please enter the new address information
Name:
Street:
City:
Zip Code:
Country:
Telephone:
//File: addNewAddress.jsp
<%@page import="java.sql.*"%>
Add a new Address
New Address Creation using executeUpdate()
<%
Connection conn = null;
PreparedStatement stmt = null;
try {
Class c = Class.forName("com.mysql.jdbc.Driver");
}
catch (Exception e) {
System.out.println("Error occurred " + e);
}
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ADDRESS");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
try {
stmt = conn.prepareStatement("INSERT INTO AddressList (name, street, city, zip, country, telephone) VALUES (?, ?, ?,?, ?, ?)");
stmt.setString(1, request.getParameter("name"));
stmt.setString(2, request.getParameter("street"));
stmt.setString(3, request.getParameter("city"));
stmt.setString(4, request.getParameter("zip"));
stmt.setString(5, request.getParameter("country"));
stmt.setString(6, request.getParameter("tel"));
stmt.executeUpdate();
stmt.close();
conn.close();
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
finally {
try {
if (stmt != null)
stmt.close();
} catch (SQLException e) {}
try {
if (conn != null)
conn.close();
} catch (SQLException e) {}
}
%>
The new address has been created.