value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.

Home Answers Viewqa JSP-Servlet value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.

QuestionAsk Questions?

nayna kumari

value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
0 Answer(s) 10 months ago
Posted in : JSP-Servlet

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>

        <style type="text/css">
<!--
.style1 {
    font-family: Arial, Helvetica, sans-serif;
    font-weight: bold;
    font-size: 18px;
}
-->
        </style>
</head>
    <body>
        <p>Â </p>
        <p>Â </p>
        <p>Â </p>
        <p>Â </p>
        <table width="498" height="177" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666">
          <tr>
            <td width="184" height="51"> <div align="center" class="style1">
              <div align="justify">NAME </div>
            </div></td>
            <td width="187"><label>
              <input  type="text" name="textfield" size="30">
            </label></td>
          </tr>
          <tr>
            <td height="48" class="style1"> <div align="justify">EMAIL</div></td>
            <td><input name="textfield2" type="text" size="30"></td>
          </tr>
          <tr>
            <td height="39"><div align="justify" class="style1">PASSWORD</div></td>
            <td><input name="textfield3" type="text" size="30"></td>
          </tr>
          <tr>
            <td height="39">Â </td>
            <td><input type="submit" name="Submit" value="Submit"></td>
          </tr>
    </table>
           <h1>Â </h1>


           <form action="http://localhost:8080/WebApplication1/faces/jsp1.jsp">
               <%@page language="java" %>
               <%@ page import ="java.sql.*"  %>

      <%     String  name=request.getParameter("textfield");
              String email=request.getParameter("textfield2");
              String password=request.getParameter("textfield3");  


          try{     

    //String query ="INSERT INTO demodb VALUES('"+name+"','"+email+"','"+password+"')";
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Nayna-PC:1521:orcl","scott","tiger");
      //Statement stmt=conn.createStatement();
    PreparedStatement ps=conn.prepareStatement("insert into demodb(name,email,password) values(?,?,?)");
     ps.setString(1,name);
    ps.setString(2,email);
    ps.setString(3,password);
    int rs=ps.executeUpdate();
   //conn.close();
    if(rs!=0){
    System.out.println("successful");
    }
    else{
    System.out.println("unsuccessful");
    }
    }
          catch(Exception e){
              System.out.println("error in connection"+e);
          }

        %>

    </form>
</body>
</html>

View Answers

value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <..."> <title>JSP Page</title> <style type

Insert Data in Table Using Stored Procedure
Insert Data in Table Using Stored Procedure ... Your data has been inserted into table. Download this example.(Java... into a table using stored procedure. Steps: 1.Create database: To create

Deleting a Row from SQL Table Using EJB
Deleting a Row from SQL Table Using EJB ... to delete a row from the SQL Table. Find out the steps given below that describes how to delete a particular row from the database table using EJB. The steps

mysql table construction - SQL
mysql table construction In MySql there is no pivot function. using a function or Stored Procedure, I want to loop through a column of data and create a another table that uses the row value as Column labels from the row

jsp - JDBC
JSP Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL <html><head>..., will help you in storing date in sql database.See how to insert data from html

JSP - JDBC
JSP Store Results in Integer Format JSP Example Code that stores the result in integer format in JSP Hi! Just run the given JSP Example...*,java.text.*" %><html><head><title>Retrive value from

Help on JSP and JDBC - JDBC
Help on JSP and JDBC Retrieve data from Database in JSP and JDBC...;hi friend, jsp only for view , we should use for presentation don t... for connection from that class get values. jsp only for view , even html designers can

Stored Procedures and Functions
reissuing the number of individual SQL statements. Stored procedure can call another... ?defined variable because then the procedure returns the value then only you can... of rows affected that a client program can obtain at the SQL level by calling the ROW

same data inserted 2 times in database
same data inserted 2 times in database pls help me, i have table studentmaster(firstname,lastname,fathername,phone,address). i am inserting data into database 2 times the data will be inserted. forexample: firstname

Delete row and column from table through java code
Delete row and column from table through java code... will see how to delete row and column from given table through java code. Java code... will delete the row having minimum value of ID then delete the column named

Inserting Data In Database table using Statement
to insert the data in the database from our java program in the table stored... Inserting Data In Database table using Statement... of the PrintWriter class. We can insert the data in the database only and only

Deleting a Row from SQL Table Using EJB
Deleting a Row from SQL Table Using EJB... are going to delete a row from the SQL Table. Find out the steps given below... ===================================== Data updated successfully : See sql table to verify

Database books Page1
in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be extracted, sorted, updated, deleted and inserted. SQL has the full support of ANSI (American National Standards Institute

SQL add column default value
into the table. The Stu_Class takes the default value of 10,when no value is inserted... SQL add column default value Add a Column default value is used in SQL, When create

Hoe to refresh a table row dynamically
Hoe to refresh a table row dynamically Want to refresh a table data... Friend, Is there a link attribute with every row of a table through which we will able to refresh a particular table row? Please clarify this. Thanks

jsp-jdbc - JDBC
jsp-jdbc Hi! html- jsp-jdbc program from the html form where username, password and other fields to be stored in the oracle database using jsp frequently. I am getting error through request.getParameter(). can you please

Query regarding JSP, JDBC
Query regarding JSP, JDBC I have a table in SQL Server database storing some ids and names. In my jsp code a while loop is displaying the list... by running a query through the id corresponding the name using arraylist

servlets and jsp - JDBC
using JSP and servlets (javascript for validation). For eg, consider... dropdown list box, it has to display 2 text boxes for getting input for +2 and UG... text boxes for getting input for +2, UG marks and UG marks For all the above

how to insert value in dynamic table
student table. and company and year value i'm getting through company table.but apache...how to insert value in dynamic table i am creating a project... a dynamic table for every company.but whenever i'm inserting values to the company

Table maximum Row count - JDBC
Table maximum Row count Dear friends I want to select maximum... maximum time entry value? Thanks in advance Rajkumar Hi friend, Sql Query for select maximum value max() function use. "select max

Sql row retrieve - SQL
Sql row retrieve Sir What are the sql statements so that I can retrieve rows from a table by specifying the row numbers such as row no.5 to 10...; Sir What are the sql statements so that I can retrieve rows from a table

jsp - JDBC
jsp LOAD DATA INFILE 'tempc.txt' INTO TABLE main FIELDS TERMINATED BY '|' LINES TERMINATED BY '#'(A200,A060,A620,A300,A201,A490,A400,A101,A630,A040,A600,A440,A100,A610,A320,A310,A002,A020,A022

What?s the maximum size of a row in SQL table?
What?s the maximum size of a row in SQL table? What?s the maximum size of a row in SQL table? Hi, The maximum Row Size is 8060 Bytes in a sql table. Thanks

Deleting row and column from a table
Deleting row and column from a table In this program ,we delete row and column of a table. First we create connection to a database using connection interface and java driver. After it we can delete row using "delete

JDBC: Last Inserted Id Example
JDBC: Last Inserted Id Example In this tutorial, you will learn how to find last inserted record ID using JDBC API. Getting Last Inserted ID : Last...;In this example we are finding the roll_no of last inserted record of student table

Delete a Specific Row from a Database Table
Delete a Specific Row from a Database Table ... in a row, now we need to delete that wrong data. This can be done very easily... the facility for deleting specific row in a database table. Sometimes, you want

jsp - JDBC
data from database in a string variable.Data cannot be stored into a String variable. JSP Page... Login Successful <%-- <jsp:forward page="studenthome.jsp"/>

JavaScript add row to table
JavaScript add row to table ...' and 'td'. As you already know that 'td' contains the table data and 'tr 'defines...(document.createTextNode()) adds the text node to the 'td' element as the table data. Then we

SQL Example, Codes and Tutorials
tables and data stored in the table. SQL provides everything to help... of column in a table. SQL Alter Column Default Value Alter Column Default Value in SQL Server is used with Create Table

Retriving data stored in database
Retriving data stored in database Hi, How to retrive data from my sql database using Hibernate,Spring and tapestry please give me an example.I am new to this Hibernate and Spring

What is Stored Procedure?
, Here is the answer, A stored procedure is a named group of SQL statements.... Syntax is- CREATE PROCEDURE procedure_name @param data_type = default_value, @param data_type = default_value, @param data_type = default_value AS BEGIN

how to display the selected row from the data table in model panel ??
how to display the selected row from the data table in model panel ?? ...:dataTable value="#{tableRecordBean.dataList}" var="dataItems" onRowClick="#{rich...="350"> <f:facet name="caption"> <h:outputText value

delete row
; We are providing you the jsp code that displays the database table data into the html table. Along each table row there is a checkbox consists of id...[]" value="<?php echo $row['id'];?>"></td> <td><?php echo

Using while loop to loop through a cursor
of data rows and perform complex logic on each row by row basis... while loop to loop through a cursor'. The Example create a table Stu_Table... like field name,data type etc. Create Table Stu_Table create

Create After Insert Trigger in SQL
statement. The insert into add the records or rows value to the table stu... insert ON stu_table FOR EACH ROW BEGIN INSERT into stu_log(user_id, description... Create After Insert Trigger in SQL

SQL Auto increment Primary Key
number to be generated when a new record is inserted into a table... and data type. The following SQL statement is used to define the "Emp... SQL Auto increment Primary Key

add image in a row of table
add image in a row of table i have a table in which i have to add... a label in which instead of passing text i have inserted image using jLabel.setIcon(new ImageIcon("E:/2.jpg"));.But when i pass this jlabel in the row it shows

SQL Alter Table Name
SQL Alter Table Name SQL Alter Table Name is used to change or modify name of the existing table. To understand how to change the name of created table in SQL

the last data entered into database is getting stored again after refreshing
the last data entered into database is getting stored again after refreshing hey all i made a shout box using php and mysql but the last data... if the data is deleted from the database the last data entered is getting posted plz help

Insert a row in 'Mysql' table using JSP Code
Insert a row in 'Mysql' table using JSP Code In this section, we will discuss about how to insert data in Mysql database using JSP code. Query...; Mysql database Table. Code to insert row in Mysql table : databaseinsertion.jsp

insert data 50 row *column into 300 row *column by using xls sheet data (50 row *column) are given in xls sheet
insert data 50 row *column into 300 row *column by using xls sheet data (50 row *column) are given in xls sheet 1- there are matrix of data with 300 row and 300 column,this is master table we have input data 50 row and 50

Insert text into database table using JSP & jQuery
Insert text into database table using JSP & jQuery In this tutorial , the text is inserted into database table using JSP & jQuery. In the below example, the first JSP page is use to display text box in which we type data

SQL fetch value
SQL fetch value how to get ( 15 march 2011) and (15/03/2011) output using SQL Use the following queries to get the data from database.../%Y') FROM patient; where patient is our table name and dob is a field of date

Insertion of multiple row data for billing purpose.
the input field data of all row through JSP. any good suggestion please help...Insertion of multiple row data for billing purpose. Hi , I have...)========(inutfield2) I want to insert all these row value .problem

Setting and Getting Data in jsp through the Session
Setting and Getting Data in jsp through the Session... can retrieve data from one page to another page only when the session is true... value is false, no one can retrieve data from any Form. Please remember

Records are not inserting in to main table while running the mysql stored procedure.
that procedure records are not inserted into main table from temp table.But im getting msg as "inserted successfully".What could be the reason for that.Can you plz help...Records are not inserting in to main table while running the mysql stored

Getting Textbox data from database
Getting Textbox data from database When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown...("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle

updating a table in a database - SQL
updating a table in a database give me complete source code in java to execute the sqlquery such that (update table_name set phone no=? where cous_id=?). or in simple way give me source code to update my table in MsAccess

Ask Questions?

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