<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
Contact - Freedom Appraise
<%
try{
// Process form submission
if (request.getMethod().equalsIgnoreCase("post")) {
// Database connection variables
String url = ""jdbc:postgresql://ovh2.appraisergenie.com:5432/genie",
"landis", "pcnf1999"";
// Get form data
String fname = request.getParameter("fname");
String lname = request.getParameter("lname");
String company_name = request.getParameter("company_name");
String phone_number = request.getParameter("phone_number");
String email = request.getParameter("email");
String mailing_address = request.getParameter("mailing_address");
String zip = request.getParameter("zip");
String city = request.getParameter("city");
String state = request.getParameter("state");
String current_software = request.getParameter("current_software");
String message = request.getParameter("message");
Connection conn = null;
PreparedStatement pstmt = null;
try {
// Load PostgreSQL JDBC driver
Class.forName("org.postgresql.Driver");
// Establish connection
conn = DriverManager.getConnection(url);
// Create SQL statement
String sql = "INSERT INTO form_submissions (
fname, lname, company_name, phone_number, email,
mailing_address, zip, city, state, current_software,
message, submission_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, date)";
pstmt = conn.prepareStatement(sql);
// Set parameters
pstmt.setString(1, fname);
pstmt.setString(2, lname);
pstmt.setString(3, company_name);
pstmt.setString(4, phone_number);
pstmt.setString(5, email);
pstmt.setString(6, mailing_address);
pstmt.setString(7, zip);
pstmt.setString(8, city);
pstmt.setString(9, state);
pstmt.setString(10, current_software);
pstmt.setString(11, message);
// Execute SQL query
int rowsAffected = pstmt.executeUpdate();
// Check if the insertion was successful
if (rowsAffected > 0) {
%>
Form submitted successfully! Data has been saved to the database.
<%
} else {
%>
Error: Failed to submit form data.
<%
}
} catch (Exception e) {
%>
Error: <%= e.getMessage() %>
<%
e.printStackTrace();
} finally {
// Close resources
try {
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
%>
Form submitted successfully! Data has been saved to the database.
<%
} else {
%>
Error: Failed to submit form data.
<%
}
} catch (Exception e) {
%>
Error: <%= e.getMessage() %>
<%
e.printStackTrace();
} finally {
// Close resources
try {
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>