%@ page language="java" import="java.sql.*"%>
ASSET Newsletter issue 6 for partners
<%
int flag=0;
String s=request.getParameter("C1");
String email=request.getParameter("T1");
Connection con =null;
try {
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
con =DriverManager.getConnection("jdbc:odbc:NewsLetterSummerDB", "", "");
if(s.equals("subscribe") )
{
PreparedStatement statement1 =
con.prepareStatement("insert into subscribtion values ('"+email +"','' ) ");
statement1.executeUpdate();
}
else
{
PreparedStatement statement1 =
con.prepareStatement("insert into subscribtion values ('', '"+email +"') ");
statement1.executeUpdate();
}
con.close();
}
catch (Exception e) {
out.println(e.getMessage());
}
%>