<%@ page language="java" import="java.sql.*" %>
In-A-Box-Software
<% String pageAction = request.getParameter("action");
if (pageAction==null) { pageAction="showform"; }
String includePage = "iiab_trial_form.jsp";
if (pageAction.equals("downloadtrial"))
{ includePage = "iiab_trial_thankyou.jsp";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost/inaboxso_inaboxsoftware?user=inaboxso_dba&password=venus");
String querystr = "INSERT INTO `inaboxso_trialdownloads` ( `company_name` , `contact_email` , `source` , `download_date` ) "+
"VALUES ('"+request.getParameter("companyname")+"', '"+request.getParameter("contactemail")+"', '"+request.getParameter("hearby")+"', NOW( ) );";
PreparedStatement query = connection.prepareStatement(querystr);
query.execute();
}
%>