<%@page import="java.sql.*,java.sql.DriverManager,java.sql.SQLException,java.net.*,java.sql.Connection,java.sql.ResultSet"%>
<%
String grtitle=request.getParameter("grtitle");
String grname=request.getParameter("grname");
//String grdate=request.getParameter("grdate");
String grdate=request.getParameter("grdate");
String graddr=request.getParameter("graddr");
String grphone=request.getParameter("grphone");
String gremail=request.getParameter("gremail");
String grmodelno=request.getParameter("grmodelno");
String grserialno=request.getParameter("grserialno");
String grdealer=request.getParameter("grdealer");
String grinvoice=request.getParameter("grinvoice");
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", "trends");
Statement st = con.createStatement();
System.out.println("testtesttest=====");
Statement stmt=con.createStatement();
rs=stmt.executeQuery("select max(GRRFNBR) + 1 as nRFNBR from guarantee");
if(rs.next())
nReference=rs.getInt("nRFNBR");
else
System.out.println("where is it ???!?!");
PreparedStatement ps=null;
String sql = "insert into guarantee (grrfnbr, grtitle, grname, graddr, grphone, gremail, grmodelno, grserialno, grdealer, grinvoice, grstmp, grvalid) values (?,?,?,?,?,?,?,?,?,?,?,?)";
System.out.println(sql);
ps=con.prepareStatement(sql);
System.out.println("NNNNNNNNNNNNNNNNN = " + nReference);
ps.setInt(1,nReference); //Forum reference
ps.setString(2,grtitle); //member reference
ps.setString(3,grname); //forum Name
ps.setString(4,graddr);
ps.setString(5,grphone);
ps.setString(6,gremail);
ps.setString(7,grmodelno);
ps.setString(8,grserialno);
ps.setString(9,grdealer);
ps.setString(10,grinvoice);
ps.setString(11,grdate);
ps.setInt(12,1); //Is it public,1=yes,0=no
//ps.setTimestamp(5,SystemTimestamp); //create date & time
//ps.setTimestamp(6,SystemTimestamp); //Time of lastest response
//Update the data to Forum
ps.executeUpdate();
//*************************
//con.commit();
//con.setAutoCommit(true);
%>
Your record is recorded.
Click here to return www.trendsaudio.com
<%
} catch(Exception e) {
%>
Please try again !
<%
e.printStackTrace();
System.out.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
%>