java code for New Address Creation using executeUpdate

//File: newAddress.html

Please enter the new address information

Name:

Street:

City:

Zip Code:

Country:

Telephone:

//File: addNewAddress.jsp


<%@page import="java.sql.*"%>

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.