New Address Creation using executeUpdate : Database « JSP « Java
New Address Creation using executeUpdate
//File: newAddress.html
<html>
<head>
<title>Add a new entry</title>
</head>
<body>
<h1>Please enter the new address information</h1>
<form method="POST" action="addNewAddress.jsp">
Name: <input type="text" name="name" size="20"><br>
Street: <input type="text" name="street" size="20"><br>
City: <input type="text" name="city" size="20"><br>
Zip Code: <input type="text" name="zip" size="20"><br>
Country: <input type="text" name="country" size="20"><br>
Telephone: <input type="text" name="tel" size="20">
<p><input type="submit" value="Submit"></p>
</form>
</body>
</html>
//File: addNewAddress.jsp
<%@page import="java.sql.*"%>
<html>
<head>
<title>Add a new Address</title>
</head>
<body>
<h1>New Address Creation using executeUpdate()</h1>
<%
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.
</body>
</html>
