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 that many times fields regenerates........

help me out in forming loops to insert into db

View Answers

May 9, 2012 at 4:19 PM

JSP insert form data into database

The given code allow the user to enter the details in the form. When the user click the button,after entering the fields, the action page is called and save the form data into the database.

1)form.html:

<html>
<form method="post" action="insert.jsp">
<table>
<tr><td>First Name:</td><td><input type="text" name="fname"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lname"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td>Confirm Password:</td><td><input type="password" name="cpass"></td></tr>
<tr><td>Date Of Birth</td><td><input type="text" name="dob"></td></tr>
<tr><td>Age:</td><td><input type="text" name="age"></td></tr>
<tr><td>Gender</td><td><input type="text" name="gender"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td>Country</td><td><input type="text" name="country"></td></tr>
<tr><td>State:</td><td><input type="text" name="state"></td></tr>
<tr><td>City</td><td><input type="text" name="city"></td></tr>
<tr><td>Telephone No:</td><td><input type="text" name="tno"></td></tr>
<tr><td>Mobile:</td><td><input type="text" name="mobile"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insert.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String pass=request.getParameter("pass");
String cpass=request.getParameter("cpass");
String dob=request.getParameter("dob");
int age=Integer.parseInt(request.getParameter("age"));
String gender=request.getParameter("gender");
String address=request.getParameter("address");
String country=request.getParameter("country");
String state=request.getParameter("state");
String city=request.getParameter("city");
int telephone=Integer.parseInt(request.getParameter("tno"));
int mobile=Integer.parseInt(request.getParameter("mobile"));
        try{
         Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into student(firstname,lastname,email,pass,confirm_pass,dob,age,gender,address,country,state,city,telephone,mobile) values('"+fname+"','"+lname+"','"+email+"','"+pass+"','"+cpass+"','"+dob+"',"+age+",'"+gender+"','"+address+"','"+country+"','"+state+"','"+city+"',"+telephone+","+mobile+")");
        out.println("Data is successfully inserted!");
        }
        catch(Exception e){
        System.out.print(e);
        e.printStackTrace();
        }
        %>

For more example, visit the following link:

http://www.roseindia.net/jsp/prepared-statement-query.shtml

May 9, 2012 at 4:26 PM

thanks a lot but question was not that.... there are few text fields and 2 buttons 1 button is to "add another text boxes" the other button is to submit the form

am comfortable in updating db with the existing text fields but after clicking on "add another text boxes" button i could not form a loop to read values from that text fields....

the concept is how many times i click on that button that many times new text fields generates so can you help me out to conclude..

Advertisements

Problem in inserting clob data in jsp
Problem in inserting clob data in jsp how to insert any rich text editor data (which have more than 32766 characters) in a clob type column of oracle database with jsp

hibernate firstExample not inserting data - Hibernate
problem is data is not inserting into DB even though the program is executed... DEFAULT CHARSET=latin1 data is not inserting...hibernate firstExample not inserting data hello all , i followed

Data is not inserting correctly in mysql database.
Data is not inserting correctly in mysql database. Hello Sir, below is my code to insert data into database by list iteration... for each data cloumn ..at the time of end of the query... PLz see my code and point my

Inserting data in Excel File - Java Beginners
Inserting data in Excel File Dear Sir, How can we fill the excel with fetched data from the database like Oracle, DB2? Is it possible to create an excel with filled data? Kindly give me the solutions to questions

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

inserting same data to different tables in oracle
inserting same data to different tables in oracle Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can

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

Inserting data on a database in servlet - JSP-Servlet
Inserting data on a database in servlet Hi I am following... to a databse by a servlet.I used the example in "Inserting Data In Database table... of a table,that is none of the data which i tried to enter into database by using

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

inserting data from radio buttons to database-ERROR - JSP-Servlet
inserting data from radio buttons to database-ERROR hi, i have already changed the option field of table question. the code which you give me has the option field as options. but it is option in the table,so i changed

inserting data from radio buttons to database - JSP-Servlet
inserting data from radio buttons to database hi, i am getting error in my code of feedback form. once i finished selecting all the radio buttons and when i click on delete button. it points to the answer.jsp. answer.jsp

inserting data from radio buttons to database - JSP-Servlet
inserting data from radio buttons to database hi, my problem is as follows: i am creating a feedback form of a college. this feedback form will ask some question and students have to answer those question with the help

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...+")"); out.println("Data is successfully inserted!"); } catch(Exception e

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

How to Make a Pdf and inserting data
How to Make a Pdf and inserting data �... make a pdf file and how we can insert a data into the pdf file. This all...;FORM ENCTYPE="multipart/form-data" ACTION="UploadPDF.jsp"

php inserting date into mysql
php inserting date into mysql php inserting date into mysql �..., data is a database table. <?php table $query_manual = "INSERT INTO data... = "INSERT INTO data(dp_name, dp_date) VALUE ('DATE: Auto CURDATE()', CURDATE

Inserting Mysql CLOB data using Servlet
Inserting Mysql CLOB data using Servlet In this Section, we will insert "clob" data using "servlet". A CLOB is a Character Large Object in a Database table. CLOB data is used to store a block of text. It is designed

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

inserting value - JSP-Servlet
the database mySQl with the help of servlet. Inserting form data Inserting form data into database using JSP and ServletGiven code will illustrate you...inserting value sir i want to create a web application when we use

inserting image into database
inserting image into database how to insert image into database using struts frame work and spring JDBC

Inserting id in place of name to database
Inserting id in place of name to database Hello, I have a database department where I have "id" and "name". I am fetching this data to a jsp form in dropdown list displaying "name" there and Now I wanted to insert data from

inserting picture in ms access
inserting picture in ms access hi i am sanatan, how to insert picture in ms access by jsp. <%@page import="java.sql.*,java.io.*"%>...()); pre.executeUpdate(); out.println("Inserting Successfully

duplicate records inserting
duplicate records inserting in the application i have provided the text filed on entering and submit the record is getting inserted. my question is i want to avoid duplicate values getting inserted. ex. i am inserting name

Insert Data in Table Using Stored Procedure
Insert Data in Table Using Stored Procedure In this example we are inserting data into a table using stored procedure. Steps: 1.Create database

inserting multiple file formats into database
inserting multiple file formats into database hi i want to insert multiple file format like .pdf.doc.zip into mysql database using jsp

inserting dropdown values into database table
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp

Inserting a value to an Enum field in Table
Inserting a value to an Enum field in Table I'm writing a code that creates a user account and sends the result to the user table in a mysql... as a 'N' but I get some database error that says data truncated. How do I set

to fetch data from ms word and storing into database
to fetch data from ms word and storing into database i want to know how to fetch datafields from ms word and storing into database??? please answer soon .its urgent

Inserting values into a database table of selected DropDown in jsp.
Inserting values into a database table of selected DropDown in jsp. http://www.roseindia.net/answers/viewqa/Ajax/15250-DropDown-in-ajax+jsp.html... to insert all selected values in data base correspondent to each like if user

iBatis-Inserting data into database
iBatis-Inserting data into database �...;  <insert id="insert... is inserting a row into database. And for this we are using MySQL as a database

Inserting Image into table
Inserting Image into table In this section , we will insert a image into a table. For inserting image, table's field (in which image...)) For inserting whole image, we have to create an 'InputStream'

Inserting Image(s) - JSP-Servlet
Inserting Image(s) Hello Guys, Thank you so much for your support so far. I appreciate everything you guys have done for me. Please what I wanted was java servlet or jsp codes that I can use to insert and retrieve image from MS

Inserting content(DOM Insertion)
Inserting content(DOM Insertion) Inserting content(DOM Insertion) Inserting Dom contents to html ,can be categories in the following 4 categories

inserting an path of an image in database - JDBC
inserting an path of an image in database hello kindly help related to the following issue... I m working in a project where we have to capture an image using web cam.... and when the image is saved in a project at the same

Inserting Image(s) - JSP-Servlet
Inserting Image(s) Hello, I need sample code using java servlet and html form and explanation on how to insert and retrieve image from mysql. Hi friend,This is insert image code.import java.sql.*;import java.io.

Lock while inserting/updating database in multithreaded.
Lock while inserting/updating database in multithreaded. Hi, I am having a multithreaded process which replicates the data from many table to one... inserting/updating to database. I dont know what is the issue but it was never

inserting text into text file using java application
inserting text into text file using java application Hi, I want to insert a text or string into a text file using java application

Insert data in database by using sql tag of JSTL SQL library
are going to create application that update database by inserting data given by user. To update database first create a data source and then execute insert sql... Insert data in database by using sql tag of JSTL SQL library

urgent help for inserting database in a project
urgent help for inserting database in a project I need some urgent help i have made java application for conducting a quiz which displays 25 mcq's and then the result at the end.I need to add simple database connectivity

inserting multiple file formats into database using html
inserting multiple file formats into database using html hi the code was working fine,i want to choose the file and then upload to database,by using html.whether it is possible to upload larger file size,please explain

inserting all the values in a html table column
inserting all the values in a html table column strong text hai everyone, i'm a fresher to servlet i need to know that, how can i insert all the values in a html table column into a database. Thanks in advance

Ads