rohitsingh
May 11, 2010 at 11:45 AM
Please post your code.
Thanks
March 24, 2011 at 3:26 PM
<%@ page import="java.util.*" %> <%@ page import="javax.mail.*" %> <%@ page import="javax.mail.internet.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="java.lang.String" %> <%@ page import="javax.activation.*" %>
<HTML> <HEAD> <TITLE>insert data using prepared statement <BODY bgcolor="#ffffcc">
<FORM method="get">
<% String firstname=request.getParameter("txtFirstName"); String lastname=request.getParameter("txtLastName"); String Designation=request.getParameter("txtDesignation"); String CompanyName=request.getParameter("txtCompanyName"); String City=request.getParameter("drpCity"); String ContactNo=request.getParameter("txtContactNo"); String Email=request.getParameter("txtEmail"); String PassportNo=request.getParameter("txtPassportNo"); String gender=request.getParameter("gender"); String meal=request.getParameter("meal"); String room=request.getParameter("room"); String tshirt=request.getParameter("tshirt"); String shirt=request.getParameter("shirt");
//To be solved
String connectionURL = "jdbc:mysql://localhost:3306/trend";
// declare a connection by using Connection interface
Connection connection = null;
// declare object of Statement interface that uses for executing sql statements.
PreparedStatement pstatement = null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
int updateQuery = 0;
//To be solved
connection = DriverManager.getConnection(connectionURL, "root", "pace");
String queryString = "INSERT INTO tblTrend(firstname,lastname,Designation,CompanyName,City,ContactNo,Email,PassportNo,gender,meal,room,tshirt,shirt) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
//String queryString = "INSERT INTO test(name) values(?)";
pstatement = connection.prepareStatement(queryString);
pstatement.setString(1, firstname);
pstatement.setString(2, lastname);
pstatement.setString(3, Designation);
pstatement.setString(4, CompanyName);
pstatement.setString(5, City);
pstatement.setString(6, ContactNo);
pstatement.setString(7, Email);
pstatement.setString(8, PassportNo);
pstatement.setString(9, gender);
pstatement.setString(10, meal);
pstatement.setString(11, room);
pstatement.setString(12, tshirt);
pstatement.setString(13, shirt);
updateQuery = pstatement.executeUpdate();
// String query = "Select * from tblTrend(firstname,lastname,Designation,CompanyName,City,ContactNo,Email,PassportNo,gender,meal,room,tshirt,shirt) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
String x="<html><tr><td>firstname</td></tr>"
+ "<tr><td>lastname</td></tr>"
+ "<tr><td>Designation</td></tr>"
+ "<tr><td>CompanyName</td></tr>"
+ "<tr><td>City</td></tr>"
+ "<tr><td>ContactNo</td></tr>"
+ "<tr><td>Email</td></tr>"
+ "<tr><td>PassportNo</td></tr>"
+ "<tr><td>gender</td></tr>"
+ "<tr><td>meal</td></tr>"
+ "<tr><td>room</td></tr>"
+ "<tr><td>tshirt</td></tr>"
+ "<tr><td>shirt</td></tr></html>";
// close all the connections.
pstatement.close();
connection.close();
response.sendRedirect("thank.jsp");
%>