when i enter the form details only mobile number and telephone was inserted succesfully.when i enter the SELECT * FROM registertable show the all fields all null excepi mobile and telephone tell me the solution for this here is the code
abc.java
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class abc extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String connectionURL = "jdbc:sqlserver://localhost:1433;databaseName=sree;integratedSecurity=true;";
Connection connection=null;
ResultSet rs;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String fname = req.getParameter("firstname");
String lname = req.getParameter("lastname");
String email = req.getParameter("email");
String password= req.getParameter("password");
String confirmpassword = req.getParameter("confirmpassword");
String dateofbirth = req.getParameter("dateofbirth");
String age = req.getParameter("age");
String gender = req.getParameter("gender");
String address= req.getParameter("address");
String country = req.getParameter("country");
String state= req.getParameter("state");
String city = req.getParameter("city");
String telephone = req.getParameter("telephone");
String mobile = req.getParameter("mobile");
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection(connectionURL, " ", " ");
String sql = "insert into registertable(firstname,lastname,email,password,confirmpassword,dateofbirth,age,gender,address,country,state,city,telephone,mobile) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement pst = connection.prepareStatement(sql);
pst.setString(1,fname);
pst.setString(2, lname);
pst.setString(3, email);
pst.setString(4,password );
pst.setString(5,confirmpassword );
pst.setString(6,dateofbirth);
pst.setString(7,age );
pst.setString(8,gender);
pst.setString(9,address);
pst.setString(10, country);
pst.setString(11,state );
pst.setString(12,city );
pst.setString(13,telephone );
pst.setString(14, mobile );
int numRowsChanged = pst.executeUpdate();
out.println("Hello:");
out.println("'"+fname+"'");
pst.close();
}
catch(Exception e){
out.println(e);
}
}
}
xml
<web-app>
<servlet>
<servlet-name>abc</servlet-name>
<servlet-class>abc</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>abc</servlet-name>
<url-pattern>/abc</url-pattern>
</servlet-mapping>
</web-app>
Html code
<html>
<head>
<title>Registration Document</title>
</head>
<body>
<form method="post" action="http://localhost:8080/project/Registration">
<table width="50%" border="0" align="center" cellpadding="0" cellspacing="8">
<tr>
<td width="26%">Â </td>
<td width="74%">Â </td>
</tr>
<tr>
<td height="25" colspan="5" align="center" valign="middle"> <h2><a style="color:Green">Individual Registration Form</a></h2>
</center></tr>
<tr>
<td><strong>FirstName:</strong>
<td><b>
<input type="text" name="FirstName"size="23" >
<strong>LastName :</strong>
<td><b>
<input type="text" name="last name"size="23" />
</b></td>
</tr>
</tr>
<tr>
<td><strong>Email:</strong></td>
<td><b>
<input type="text" name="Mail id" size="40" />
</b></td>
</tr>
<tr>
<td><strong>Password:</strong>
<td><b>
<input type="Password" name="pwd" size="23" />
<strong>ConfirmPassword:</strong>
<td>
<input type="Password" name="cpwd" size="23" />
</b></td>
</tr>
<tr>
<td><strong>Dateofbirth:</strong></td>
<td><b>
<select name="DateOfBirth_Day">
<option> - Day - </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
</b><b>
<select name="DateOfBirth_Month">
<option> - Month - </option>
<option value="January">January</option>
<option value="Febuary">Febuary</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
</b><b>
<select name="DateOfBirth_Year">
<option> - Year - </option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
<option value="1929">1929</option>
<option value="1928">1928</option>
<option value="1927">1927</option>
<option value="1926">1926</option>
<option value="1925">1925</option>
<option value="1924">1924</option>
<option value="1923">1923</option>
<option value="1922">1922</option>
<option value="1921">1921</option>
<option value="1920">1920</option>
<option value="1919">1919</option>
<option value="1918">1918</option>
<option value="1917">1917</option>
<option value="1916">1916</option>
<option value="1915">1915</option>
<option value="1914">1914</option>
<option value="1913">1913</option>
<option value="1912">1912</option>
<option value="1911">1911</option>
<option value="1910">1910</option>
<option value="1909">1909</option>
<option value="1908">1908</option>
<option value="1907">1907</option>
<option value="1906">1906</option>
<option value="1905">1905</option>
<option value="1904">1904</option>
<option value="1903">1903</option>
<option value="1902">1902</option>
<option value="1901">1901</option>
<option value="1900">1900</option>
</select>
</b></td>
</tr>
<tr>
<td><strong>Age:</strong></td>
<td><b>
<input type="text" name="Age" size="6" />
</b></td>
</tr>
<tr>
<td><strong>Gender:</strong></td>
<td><input type="radio" name="Gender">Male
<input type="radio" name="Gender">Female</td>
</tr>
<tr>
<td valign="top"><strong>Address: </strong></td>
<td><textarea name="Address" rows="8" cols="30"> </textarea></td>
</tr>
</table>
</form>
</html>