<%@page import="java.sql.*,java.sql.DriverManager,java.sql.SQLException,java.net.*,java.sql.Connection,java.sql.ResultSet"%>
<%
String btref=request.getParameter("btref");
String btname=request.getParameter("btname");
//String btstmp=request.getParameter("btstmp");
Connection con = null;
ResultSet rs=null;
int nReference=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://localhost/trends","root", "");
Statement st = con.createStatement();
System.out.println("testtesttest=====");
Statement stmt=con.createStatement();
rs=stmt.executeQuery("select max(btrfnbr) + 1 as nRFNBR from bannerstat");
if(rs.next())
nReference=rs.getInt("nRFNBR");
else
System.out.println("where is it ???!?!");
PreparedStatement ps=null;
String sql = "insert into bannerstat (btrfnbr, btref, btname) values (?,?,?)";
System.out.println(sql);
ps=con.prepareStatement(sql);
System.out.println("NNNNNNNNNNNNNNNNN = " + nReference);
ps.setInt(1,nReference);
ps.setString(2,btref); //banner reference
ps.setString(3,btname);
//ps.setString(4,"current);
//Update the data to Forum
ps.executeUpdate();
//*************************
//con.commit();
//con.setAutoCommit(true);
%>
<%
} catch(Exception e) {
%>
<%
e.printStackTrace();
System.out.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
%>