single query to insert the data

Home Answers Viewqa SQL single query to insert the data

QuestionAsk Questions?

Java Coder

single query to insert the data
1 Answer(s) a year and 3 months ago
Posted in : SQL

How to insert data for all HTML fields in single MYSQL query?

View Answers

February 15, 2012 at 12:04 PM

1)form.html:

<html>
<form method="post" action="http://localhost:8080/examples/jsp/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();
        }
        %>

single query to insert the data
single query to insert the data How to insert data for all HTML fields in single MYSQL query

problem in insert query - JSP-Servlet
problem in insert query Hi! I am using this statement for data insertion into table but data is not moving only null passed and stored:- String insertQuery= "insert into volunteer_profiles ( name, gender ) values ( 'name

How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

Hibernate insert Query
Hibernate insert Query In this tutorial you will learn about how to use HQL insert query. INSERT query in HQL is used to insert the records into the database table. INSERT query of HQL is just like the INSERT query used in SQL

FAILED TO INSERT DATA FROM FUNCTION();
FAILED TO INSERT DATA FROM FUNCTION(); HELLO, I HAVE A PROBLEM TO INSERT DATA FROM OUTPUT FROM FUNCTION()... I WANT TO STORE THE OUTPUT IN DATABASE, BUT FAILED TO INSERT... before this.... ......................... function

insert
insert insert data in database from servlet through JDBC Ho Friend, Please visit the following: Insert data into database Thanks

How can i search and insert within a query
then insert these data (batch, semester, degree, seat numbers and marks of mid, lab...How can i search and insert within a query if it is possible... that when seat numbers more then one problem generates how insert multiple values

Insert file data into database
. Now to insert this data into the database, we have established a database connection. Then using the insert query, we have inserted whole file data...Insert file data into database In this section, you will learn how to insert

insert query in jsp
insert query in jsp give me insert code in jsp at run time

insert query in mysql
insert query in mysql insert query in mysql not working [INSERT INTO Birthdays(firstname, lastname, birthday, group) VALUES('Sam','Smith','June','Junior

Java Multiple Insert Query
Java Multiple Insert Query In this example we will discuss about how to execute multiple insert query in Java. This example explains you about how... the multiple insert query. In this example we will use the Eclipse IDE

Create table and insert data by sql query
Create table and insert data by sql query... to connect java application and execute sql query like create table in mysql database, insert some values and retrieve values from the table. Before running

The INSERT INTO Statement
of data into the table. To insert records into a table, just write the key word... amar@roseindia.com Insert Data in Specified Columns Let us consider... Let us consider we want to insert data in field name 'emp_name', 'Position

insert data
insert data i've got a problem to insert my data to database.i can...("insert into images values(?,?,?,?,?)"); st.setString(2... and as well as the passed data from mulitpart/form-data is greater than or equal to 0

Write a query to insert a record into a table
Write a query to insert a record into a table Write a query to insert a record into a table Hi, The query string is as follows- Insert into employee values ('35','gyan','singh'); Thanks

Mysql Multiple Date Insert
(0.01 sec) Query for Multiple insertion of data in table: The Query insert into is used for Multiple insertion of data in table 'Employee'. The Query is used mysql>INSERT INTO Employee (Empid

Mysql Multiple Date Insert
sec) Query for Multiple insertion of data in table: The Query insert into is used for Multiple insertion of data in table 'Employee'. The Query... Warnings: 0 Query to view data inserted in table: To view the records from table

how to insert multiple columns of a single row into my sql database using jsp
how to insert multiple columns of a single row into my sql database using jsp hi sir, how to insert multiple columns of a single row into my... the data in the row must be added into database. the following code

The INSERT INTO Statement, SQL Tutorial
of data into the table. To insert records into a table, just write the key word... Insert Data in Specified Columns Let us consider we have a table named employee... 10000 amar@roseindia.com Let us consider we want to insert data

how to insert data in database using html+jsp
how to insert data in database using html+jsp anyone know what... = null; // declare a resultset that uses as a table for output data from... = 0; // sql query to retrieve values from the specified

using insert and delete in a single page in jsp
using insert and delete in a single page in jsp I am using the following code in jsp to declare two javascript functions to insert and delete in a single jsp page but insert function doesn't works only delete function works even

Uploading a single file by using JSp
Uploading a single file by using JSp u have said about submit button...;%@ page language="java" %> <HTML> <FORM ENCTYPE="multipart/form-data...;(contentType.indexOf("multipart/form-data") >= 0)){ DataInputStream in = new DataInputStream

query
query Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) Find the name of all

query
query if i want to insert 1labelbox,1textbox,1button in 1st row and in second row 1label box and a text box ly how can i align it? Hi Friend, Try the following code: import java.awt.*; import javax.swing.*; import

executing multiple sql statements on the single button click...
executing multiple sql statements on the single button click... how can i frame a code on the click of a button to insert data into a table as well as to retrieve records from the same table in another form

mysql query
mysql query how do transfer into the excel data to my sql ...; data sources. 2)Click Add button and select the Drive do Microsoft Excel(*.xls). 3)After selecting the driver, click finish button. 4)Then give Data Source

insert and delete data in database
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links: Insert Data Delete Data Thanks

Introduction To Hibernate Query Language (HQL)
Introduction To Hibernate Query Language (HQL) In this tutorial you will learn about Hibernate Query Language. HQL is an abbreviation of Hibernate Query Language. It is a powerful query language, inspired by SQL that the Hibernate uses

Difference between Normal Insert and BLOB insert
=con.prepareStatement("insert into data(name,city,image)"+"values(?,?,?)"); psmt.setString(1...Difference between Normal Insert and BLOB insert I have sql database...), DisplayImage (image). Table has 2 rows for first row i have written insert into Image

insert data into database
insert data into database hi,thanks for reply just i am doing student information project,frontend is jsp-servlet and backend is msaccess2007. i... the data into the jsp page that data stored into the database.Here the error

Ant Script to Insert Data in Mysql Table
Ant Script to Insert Data in Mysql Table This example illustrates how to insert data...;target name="createTables"> is used to execute the query which

Insert Data From File
Insert Data From File Insert Data From File is used to insert data from file... to insert data from file. To understand this example, we create a table 'Stu_Table

displaying data for a single column from Mysql database in the list box in php form
displaying data for a single column from Mysql database in the list box in php form I have a form in php.want to display data from a single column in an listbox in php.thanks.. <?php $data = @mysql_query("select

How to insert clob data??
How to insert clob data?? Can any one tell me in details how... to insert more than 4000 characters.I have heard that clob fields can hold 4 gb of data and need pl/sql to avail that feature.Can any one tell me how to create

Merge two list into a single list
and insert data into it, printlist function prints all the data and the mergelist funtion merge the two lists into a single list. Code: # include...Description: This example demonstrate how to merge two lists into a single

database is connected but not insert the data
database is connected but not insert the data hi, i am getting connected to database.Retrive the data also but cannot insert the data into database...=con.prepareStatement("insert into studentmaster(slno) values('"+batch+"')"); i

unable to insert data into database
unable to insert data into database hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based

PHP SQL Query Insert
PHP SQL Query Insert This example illustrates how to execute insert query in php...). Now, queries can be executed using mysql_query() method to insert values

insert data into database
insert data into database type Exception report message...)Go to the start->Control Panel->Administrative Tools-> data sources. 2... selecting the driver, click finish button. 4)Then give Data Source Name

EJB Insert data
.style1 { color: #FFFFFF; } EJB Insert data... describes you the way to insert data into the database using EJB. The steps involved in inserting data are as :- 1)Create an interface named

Php Sql Query Insert
Php Sql Query Insert This example illustrates how to execute insert query with values in php application. In this example we create two mysql query for insert statement with separate values in the database table. The table before

upload file and insert other details to database using a single form
upload file and insert other details to database using a single form hi.. I have problem with uploading a file and insert other user datas together which I retrieved from another jsp/html page. Here i was able to upload file

PDO Insert
PDO-Insert-Code To get data from the database, we need to put some data into it. In PDO we use same conventional coding of inserting data, but to execute the query we use PDO::exec method. PDO::exec method returns the number

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