Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Sireesha
sqlserver2008
0 Answer(s)      3 years and 7 months ago
Posted in : Development process


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>

Advertisement
View Answers

Related Tutorials/Questions & Answers:
sqlserver2008
sqlserver2008  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
Database Connectivity
Database Connectivity  I tried to establish database connection with sqlserver2008 through GlassFish server. When I set the path of sqljdbc.jar(E:\Glass Fish\glassfish-v2ur1\javadb\lib\sqljdbc.jar) it shows me error
Advertisements
 

 

 

DMCA.com