QuestionAsk Questions?
Sireesha
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>
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
