<%@ page import="java.sql.*" %> " name="description">

problem in inserting data in databases created in ecplise using jsp

Ads
 

problem in inserting data in databases created in ecplise using jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> JS Soft

      <meta name="description" content="free website template" />
      <meta name="keywords" content="enter your keywords here" />
      <meta http-equiv="content-type" content="text/html; charset=utf-8" />
      <meta http-equiv="X-UA-Compatible" content="IE=9" />

     <link rel="stylesheet" type="text/css" href="/js/css/style1.css" />
     <link rel="stylesheet" type="text/css" href="/js/css/menu.css" />
     <link rel="stylesheet" type="text/css" href="/js/css/style.css" />
     <link rel="stylesheet" type="text/css" href="/js/css/layout.css" />

<div id="about">
        <img src="/js/images/cont.png" alt="" />
</div>  
<div class="con">
    <h5>JS-Soft Technologies</h5>
    <div class="con1">
    <p>20-74 NGO Colony</p>
    <p>Main Road</p>
    <p>Nagercoil</p>
    <p>Kanyakumari-2<br><br>
    <p>+919629455197</p>
    <p>+919566262912</p>
</div><!--close con1-->

</div><!--close con-->

<div id="menubar">          
        <ul id="nav">
                   <li><a href="/js/index.jsp">Home</a></li>
                        <li><a href="/js/pages/about.jsp">About</a></li>
                        <li><a class="hsubs" href="#">Services</a>
                            <ul class="subs">
                                <li><a href="/js/pages/application.jsp">Application Services</a></li>
                                <li><a href="/js/pages/web.jsp">Web Services </a></li>
                                <li><a href="/js/pages/testing.jsp">Testin Services</a></li>
                                <li><a href="/js/pages/remote.jsp">Remote Tech Support </a></li>
                                <li><a href="#">SEO</a></li>
                            </ul>
                        </li>
                        <li><a href="/js/pages/career.jsp">Career</a></li>
                        <li><a href="/js/pages/conacts.jsp">Conact Us</a></li>

                  </ul>


        </div><!--close menubar-->  


<div id="cont">
        <h4>Conact Us</h4><br>
        <div>
            <form action="http://localhost:8080/js/pages/conacts.jsp" method="post">
                <table class="contact">
                        <tr><td align="right">*Select Inquiry Type:</td>
                        <td width="30%"><select name="selectinq" class="inputForm">
                                <option value="-1">Select Inquiry Type</option>
                                <option value="Career">Career Seekers</option>
                                <option value="investor">Investor Relations</option>
                                <option value="media">Media</option>
                                <option value="media">Request for Services</option>
                            </select>
                        </td></tr>
                          <TR>
                              <td align="right">First Name</td>
                              <TD width="30%"><INPUT TYPE="text" NAME="fname" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Last Name</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="lname" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Organization</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="organization" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                            <td align="right">Email</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="email" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Phone Number</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="phone" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Address</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="address" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">City</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="city" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Country</td>
                             <TD width="30%"><INPUT TYPE="text" NAME="country" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Zip</td>
                             <TD width="50%"><INPUT TYPE="text" NAME="zip" size="26%" class="inputForm"></TD>
                          </tr>
                          <TR>
                             <td align="right">Message</td>
                            <td><textarea rows="10" cols="30" name="message" class="inputForm"></textarea></TD>
                          </tr>
                          <TR>
                              <td></td>
                              <TD width="50%"><INPUT TYPE="submit" VALUE="submit" class="inputForm"></TD>
                          </tr>

                </table>

                <%
                       String selectinq = request.getParameter("selectinq");
                       String fname=request.getParameter("fname");
                       String lname=request.getParameter("lname");
                       String organization=request.getParameter("organization");
                       String email=request.getParameter("email");
                       String phone=request.getParameter("phone");
                       String address=request.getParameter("address");
                       String city = request.getParameter("city");
                       String country=request.getParameter("country");
                       String zip = request.getParameter("zip");
                       String message=request.getParameter("message");

/* Create string of connection url within specified format with machine name, port number and database name. Here machine name id localhost and database name is student. */ String connectionURL = "jdbc:mysql://localhost:3306/js";

// 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;

 // check if the text box is empty
 if(selectinq!=null && fname!=null && lname!=null && organization!=null && email!=null && phone!=null && address!=null && city!=null && country!=null && zip!=null && message!=null)
 {

     // check if the text box having only blank spaces
     if(selectinq!=" " && fname!=" " && lname!=" " && organization!=" " && email!=" " && phone!=" " && address!=" " && city!=" " && country!=" " && zip!=" " && message!=" ")
     {

        try {
          /* Create a connection by using getConnection() method that takes 
          parameters of string type connection url, user name and password to connect 
          to database. */
          connection = DriverManager.getConnection(connectionURL, "root", "root");

          // sql query to insert values in the secified table.
          String queryString = "INSERT INTO inquri(selectinq,,fname,lname,organization,email,phone,address,city,country,zip,message) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

         /* createStatement() is used for create statement object that is used for 
           sending sql statements to the specified database. */
          pstatement = connection.prepareStatement(queryString);
          pstatement.setString(1, selectinq);
          pstatement.setString(2, fname);
          pstatement.setString(3, lname);
          pstatement.setString(4, organization);
          pstatement.setString(5, email);
          pstatement.setString(6, phone);
          pstatement.setString(7, address);
          pstatement.setString(8, city);
          pstatement.setString(9, country);
          pstatement.setString(10, zip);
          pstatement.setString(11, message);
          updateQuery = pstatement.executeUpdate();

          if (updateQuery != 0) { %>
            <br>
            <TABLE style="background-color: #E3E4FA;" WIDTH="30%" border="1">
                <tr><th>Data is inserted successfully in database.</th></tr>
            </table>

<% } } catch (Exception ex) { out.println("Unable to connect to batabase.");

        }
        finally {
            // close all the connections.
            pstatement.close();
            connection.close();
        }
     }
   }

%>

            </form>
        </div>

</div>

Everything goes fine but the values are not updated in the table. what to do? plz help?

View Answers

Ads









Related Tutorials/Questions & Answers:
problem in inserting data in databases created in ecplise using jsp
problem in inserting data in databases created in ecplise using jsp  <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> JS Soft
problem in inserting data in databases created in ecplise using jsp
problem in inserting data in databases created in ecplise using jsp  <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> JS Soft
Advertisements
problem in inserting data in databases created in netbeans using jsp..
problem in inserting data in databases created in netbeans using jsp..  i am trying to make a virtual classroom website in jsp using netbeans.i created table inside netbeans through sql editor.and tried to make a login page whose
problem on jsp, inserting data into table(mysql).
problem on jsp, inserting data into table(mysql).  hello friends, I have a problem in jsp.I want to insert data, which is given by user through... is in mysql.I want to use placeholder("?") to insert data into table.Plsssss help
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql  i am working on a project... to know that how to query multiple databases(databases created in my mysql) so
problem in jsp using ms-access
problem in jsp using ms-access  after starting server(tomcat) wen v...)Your DSN will get created. 6) Restart your server and run your jsp code. Here... will get created. 6) Restart your server and run your jsp code. Here is your
help me in inserting data into db using hibernate
help me in inserting data into db using hibernate  How to insert data into dependent tables through hybernate   Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate/insert-data-database.shtml
Problem in enctype="multipart/form-data" in JSP
Problem in enctype="multipart/form-data" in JSP  im using a page which is in JSP. i have some text boxes and one upload button. i want to load the file itself when i click the submit button. im using enctype="multipart/form-data
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp   data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me
How to save run time created text-file on a disk using jsp/servlet?
How to save run time created text-file on a disk using jsp/servlet?  I have a JSP page with save button.In that I created the file(e.g a.txt) at run-time,when I click on the save button,it will ask where to save the file
Problem passing a value from one jsp to another using href
Problem passing a value from one jsp to another using href  first page.jsp <a href="common.jsp?param=<%l.get(k).parentname%>"> common.jsp <%String attr=request.getAttribute("param"); out.print(attr
Problem passing a value from one jsp to another using href
Problem passing a value from one jsp to another using href  first page.jsp <a href="common.jsp?param=<%l.get(k).parentname%>"> common.jsp <%String attr=request.getAttribute("param"); out.print(attr
how to insert data into database using jsp & retrive
how to insert data into database using jsp & retrive  Hello, I have created 1 html page which contain username, password & submit button. in my oracle10G database already contain table name admin which has name, password
jsp problem
jsp problem  Hi every one plz give me answer for below question ASAP I created one JSP(used pre defined javascript in jsp to get rtf format in browser) which creats RTF Format in browser to enter data. MY question is after i
How to get the data from the database using Servlet or JSP program
How to get the data from the database using Servlet or JSP program  .... Actual problem is that i have a simple program in jsp in the sense to get data... the problem   Get data from database using servlet Retrieve data from
get data between date using jsp with msaccess
get data between date using jsp with msaccess  hi, urgently i need program for get data between date using jsp with MsAccess database.plz any one can help me.thanks for anyone replay with regards c.b.chellappa
reading data using struts and jsp java
reading data using struts and jsp java  how can i read data entered by user into a textbox (jsp page) into struts action class ex emp id,so... employee related data
problem in creating web application using servelet, jsp, jdbc and xml - JSP-Servlet
problem in creating web application using servelet, jsp, jdbc and xml  Using Servlet, JSP, JDBC and XML create a web application for a courrier...; Hi friend, For solving the problem visit to : http://www.roseindia.net
jsp problem
jsp problem  problem:::::::: On JSP form ,when i insert data in text field........at that time action is perform and data is retriev from data base and get assign to other field on that form........ when data is assign to other
Accessing Jqxgrid data in Controller layer using JSP
Accessing Jqxgrid data in Controller layer using JSP  I am using Keyboard Navigation jqxgrid. I am able to bind the grid by passing data from controller layer using JAVA. What i actually require is to fetch the data which
Problem in jsp.
Problem in jsp.  hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <
Problem in jsp.
Problem in jsp.  hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <
Problem in jsp.
Problem in jsp.  hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <
inserting data into datafields
inserting data into datafields  I was raised with a query.... there is a button, on click on it....... few fields regenerates and the details entered there should be inserted into Database Number of times we click that button
Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp  Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my database.. Eg- text1,text2,text3,....,upto text30... i want to export this data
Fetch the data using jsp standard action
Fetch the data using jsp standard action  I want the code of fetch the data from the database & show in a jsp page using jsp:usebean in MVC model... that retrieves the data from the database through java bean and display it in jsp page
How to get data from Oracle database using JSP
problem in jsp in the sense to get data from the database like oracle . I have... data from the database like oracle), I have created one jsp program like... the answer to retrieve data from the database by using servlet or jsp program
How to export data from jsp to excel sheet by using java
How to export data from jsp to excel sheet by using java   How to export data from jsp to excel sheet by using java
Read Excel data using JSP and update MySQL databse
Read Excel data using JSP and update MySQL databse  HOw to read excel data using JSP and update MySQl database
Problem in populating tableview with database data using javafx MVC architecture.
Problem in populating tableview with database data using javafx MVC... architecture. Here i want to populate tableview as it is with database table data. Here the problem is i am getting all elelments of every row in each column
Problem in populating tableview with database data using javafx MVC architecture.
Problem in populating tableview with database data using javafx MVC... architecture. Here i want to populate tableview as it is with database table data. Here the problem is i am getting all elelments of every row in each column

Ads