<%@page	import="java.sql.*,java.sql.DriverManager,java.sql.SQLException,java.net.*"%>

<%  	
       	
	String	grtitle=request.getParameter("grtitle");
	String	grname=request.getParameter("grname");
	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;

try {
	
	
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://localhost/trends","root", "trends");
Statement st = con.createStatement();

PreparedStatement ps=null; 
String sql = "insert into guarantee (grrfnbr, grtitle, grname, graddr, grphone, gremail, grmodelno, grserialno, grdealer, grinvoice, grvalid) values (?,?,?,?,?,?,?,?,?,?,?)";

System.out.println(sql);

ps=con.prepareStatement(sql);

   	 ps.setInt(1,3);  //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.setInt(11,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);

} catch(Exception e) {
e.printStackTrace();
System.out.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
	
%>