PreparedStatement using batch update

PreparedStatement using batch update

View Answers

June 2, 2009 at 11:21 AM

Hi Friend,

Try the following code:

import java.sql.*;

public class JdbcPreparedstatementAddbatch {

public static void main(String args[]) {

Connection con = null;
PreparedStatement pst = null;

String url = "jdbc:mysql://localhost:3306/";;
String db = "mysql";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";

try {

Class.forName(driver);
con = DriverManager.getConnection(url + db, user, pass);
pst = con.prepareStatement("update data set address=? where name =?");


pst.setString(1, "Delhi");
pst.setString(2, "angelina1");
pst.addBatch();

pst.setString(1, "Mumbai");
pst.setString(2, "angelina2");
pst.addBatch();

pst.executeBatch();
pst.close();

con.close();

} catch (Exception e) {
e.printStackTrace();
}
}
}
To insert using addBatch(),please visit the following code:

http://www.roseindia.net/jdbc/prepared-statement-add-batch.shtml

Thanks

June 2, 2009 at 11:24 AM

Hey but u have used only one preparedStatement object.i want to use more than one..can i do that??









Related Tutorials/Questions & Answers:
PreparedStatement using batch update - Java Beginners
PreparedStatement using batch update  How to execute different preparedStatement object using batch update(Java) Pls explain with the code... args[]) { Connection con = null; PreparedStatement pst
Prepared Statement With Batch Update
Prepared Statement With Batch Update   ... with BatchUpdate and we are going to provide an example that performs batch update facility. In batch update more than one records can be added in the database
Advertisements
JDBC: Batch Update Example
update of records using JDBC API. Batch Update : When you want to update... concept. We can update multiple rows using single connection in batch update... to write batch update process - Create object of Statement using
Inserting a row using PreparedStatement
INSERING A ROW USING PREPAREDSTATEMENT If you want to execute a statement many time , "PreparedStatement " reduces execution time. Unlike a ".... The advantage of using "PreparedStatement " is that you can use the same
PreparedStatement
PreparedStatement  What is PreparedStatement? Give me example
using case in update statement
using case in update statement  i want to use case in update clause... syntax is not working for update stmt.my problem is update emp set case deptno... working but for first condition only update emp set deptno=(case when 10 then 20
Retrieving Data from the table using PreparedStatement
Retrieving Data from the table using PreparedStatement... by using the executeQuery() method of the PreparedStatement object. Now the data... to fetch the data from the database in the table from our java program using
Update Record using Prepared Statement
) { System.out.println("Update Record using PreparedStatement..."); Connection... JDBC: Update Record using Prepared Statement In this section, you will learn how to update row using Prepared Statements. Update Record  
JDBC Batch Update Example
; } Batch Update Example You can update data in a table batch. To update in batch at first you need set connection autoCommit fale mode then add the query...(updateQuery1); and finally commit the connection. An example of batch update
Statement Batch Update
Statement Batch Update       In this section we are going to learn about the batch update...;Successfully!" and if any problem arises in the batch update
Update value of database using hibernate.
Update value of database using hibernate.  How to update value of database using hibernate?   Hibernate provides facility to update... this by setting the value and calling the update method. session.update(employee
update excel sheet using jsp::
update excel sheet using jsp::   Hi Sir,... I have a excel... given excel sheet and display it into another excel sheet using jsp" i am using 'session' to get the empid from one page to another jsp
Update Records using Prepared Statement
Update Records using Prepared Statement   ... the process of updating the records by using the PreparedStatement.  Here arise... the connection with MySQL database by using the JDBC driver. When the connection has
how to update table using inner joins
how to update table using inner joins  how to update table using inner joins
Using insert update and delete in the same servlet
Using insert update and delete in the same servlet  How to write insert, update and delete coding in the same servlet
update a particular of mysql table using servlet
update a particular of mysql table using servlet  how to update a particular column for the entire table by taking requests from html form and update the particular column with out affecting other attribute values in the tuple
JDBC Batch Example With SQL Update Statement
JDBC Batch Example With SQL Update Statement: In this tutorial, we are discuss about update SQL statement with the jdbc batch. Now we will create a java... of the batch processing with update statement. The code of the BatchUpdate.java
Using the escape percent in the batch file
Using the escape percent in the batch file   If you use the one % in the batch file it will consider it as the parameter input and will try to find the variable and replace it. But how to use the percentage in batch file
update database using two queries at a time
update database using two queries at a time  String sql="insert into employee values(emp_seq.nextval,\'"+ename+"\',\'"+eadd+"\',\'"+ephone+"\',\'"+email+"\',\'"+department+"\',"+Integer.parseInt(ebpay)+",20,0
More than 1 preparedStatement object - Java Beginners
More than 1 preparedStatement object  Hey but I want to use more than one prepared Statement object using batch update.. Explain with a code using...(String args[]) { Connection con = null; PreparedStatement
JDBC batch update
JDBC batch update       JDBC batch update is a collectively called when a group of SQL statements... update. For this we have a class JDBC Batch Update. Inside the main method we have
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
update
written by the developer to update the Status table: String str = "UPDATE m_id SET m_id= ? WHERE bk_id= ? "; PreparedStatement ps = con.prepareStatement...://localhost:3306/roseindia", "root", "root"); String str = "UPDATE Status SET
Read data from excel file and update database using jsp
Read data from excel file and update database using jsp  read data from excel file and update database using jsp Hi, I am using a MySQL database... upload excel file and update database using JSP ? Thanks in Advance
update
update  how can i update multiple records in database using jsp ,servlet and jdbc based on selection of checkbox in jsp
how to update values of a html form into an excel table using java servlets?
how to update values of a html form into an excel table using java servlets?  i have written a java servlet program, which has a html form to be filled. after filling the form the servlet generates a receipt and the values should
select with preparedstatement in java
select with preparedstatement in java  How to write code example for select with preparedstatement in java? Thanks   Hi, Following code examples can be used: PreparedStatement pstmt = conn.prepareStatement
jdbctemplate batchUpdate example
if the same prepared statement is used for the multiple calls' batch. This Section contains the example of batch update using 'jdbcTemplate'. Two...; method is used to find the size of the batch. This method is necessary because
How to make a CRUD without using SQL Server? by just using your GUI? (CRUD = Creating, Register, Update, Delete)
How to make a CRUD without using SQL Server? by just using your GUI? (CRUD = Creating, Register, Update, Delete)  well I got a Program that can Register Update and delete a account to SQL Server. from now on we have to make
JDBC batch insert using Java bean class
In this tutorial, you will learn about JDBC batch insert using java bean / model class
Spring SimpleJdbcTemplate update
Spring SimpleJdbcTemplate update This section is about update method using SimpleJdbcTemplate  to update records . The update method is beneficial... are going to update the database table row using update method . We are using
how to fetch data fron facebbok using spring batch and hibernate ?
how to fetch data fron facebbok using spring batch and hibernate ?  how to fetch data from facebbok using spring batch and hibernate ? Means i have to get all details of data from one source like facebook using id ans save all
Update Database Table using JDBC in JSP
Update Database Table using JDBC in JSP       This example shows how to update the existing  record of mysql table using jdbc connectivity in the jsp page
Select Records Using Prepared Statement
to select some specific records by using the PreparedStatement. We know that the PreparedStatement object  represents a precompiled SQL statement. See brief... Select Records Using Prepared Statement   
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp  iam a fresher newbie to softparsing i... for update also thank you
Running a stand alone application using batch file in windows
Running a stand alone application using batch file in windows  I have created a stand alone application and i have generated jar file for my application. All the .class files are available inside a package called as com.tbss. I
Alter Database Table Using JDBC Batch Process
Alter Database Table Using JDBC Batch Process: In this example, we are discuss about alter database table using JDBC Batch process. First of all, we... for modify the database user table  and add these statement in batch using
Deleting Records using the Prepared Statement
the records from the database table by using the PreparedStatement interface... of movies in the setInt method by using the PreparedStatement object. If it records... Deleting Records using the Prepared Statement  
Inserting Records using the Prepared Statement
Inserting Records using the Prepared Statement  ... to learn how we will insert the records in the database table by using the PreparedStatement interface of java.sql package.  As we all know that in database
update query
update query  using oops concept in php.. How to update the data from databse ? with program example
JDBC: Update Records Example
JDBC: Update Records Example In this section, you will learn how to update records of the table using JDBC API. Update Records : Update record is most... for such situation you can use update statement to update particular value of record
JDBC Update Statement Example
.style1 { text-align: center; } JDBC Update Statement Example JDBC update statement is used to update the records of a table using java application... query = "UPDATE student SET Name='John', Address='New York', Course='M.Tech' WHERE
JDBC: Batch Insert Example
insertion of records using JDBC API. Batch Insert : When you want to insert... are the steps to write batch insertion process - Create object of Statement using... setAutoCommit(false). Add sql insert statements into your batch by using
JDBC Batch SQL Update Statement Example With Return Number of Effected Rows
JDBC Batch SQL Update Statement Example With Return Number of Effected Rows: In this example, we are discuss about update statement with return number of effected rows. The executebatch() method are use to execute the batch
JDBC add batch, JDBC add batch Example, JDBC add batch example code
JDBC add batch Making JDBC batch update example In this section we will learn how use JDBC add batch to make JDBC batch update. The JDBC batch update is used to execute a group of updates at one go. The JDBC batch update is different
Set Timestamp by using the Prepared Statement
Set Timestamp by using the Prepared Statement... will teach how to set the Timestamp in database table by using the PreparedStatement interface of java.sql package. If you want to insert the Timestamp
update profile
update profile  coding for update profile
how to update
how to update   conditional update
Update - JDBC
is what I used to update normally. It works. Please assist me. Thanks Connection con, cc; PreparedStatement stat, ss...("jdbc:odbc:Biu"); stat = con.prepareStatement("Update Biu SET itemcode
Set Time by using the Prepared Statement
the time in database table by using the PreparedStatement interface of java.sql... Set Time by using the Prepared Statement   ... This example helps us for setting the time in database table (child) by using

Ads