Kriti
PreparedStatement using batch update
2 Answer(s)      6 years ago
Posted in : Java Beginners
Advertisement
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...). Add sql update statements into your batch by using method addBatch
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...!" and if any problem arises in the batch update then the exception
PreparedStatement
PreparedStatement  What is PreparedStatement? Give me example
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
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
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
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
Retrieving Data from the table using PreparedStatement
Retrieving Data from the table using PreparedStatement... to fetch the data from the database in the table from our java program using PreparedStatement.  To accomplish our goal we first have to make a class named
JDBC batch insert using Java bean class
In this tutorial, you will learn about JDBC batch insert using java bean / model class
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
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
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
Update Records using Prepared Statement
Update Records using Prepared Statement   ... the process of updating the records by using the PreparedStatement.  Here arise... with MySQL database by using the JDBC driver. When the connection has been established
Update Record using Prepared Statement
) { System.out.println("Update Record using PreparedStatement..."); Connection con = null...) { e.printStackTrace(); } } } Output : Update Record using PreparedStatement... JDBC: Update Record using Prepared Statement In this section, you
JDBC: Batch Insert Example
insertion of records using JDBC API. Batch Insert : When you want to insert... batch insertion process - Create object of Statement using createStatement...(false). Add sql insert statements into your batch by using method addBatch
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
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
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
how to update table using inner joins
how to update table using inner joins  how to update table using inner joins
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
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
Spring Batch Example
Spring Batch Example       JDBC Template Batch update example, In the tutorial we have discussed.... The Batch update methods are used to executes multiple SQL updates query
Spring Batch Example
Spring Batch Example       JDBC Template Batch update example, In the tutorial we have discussed.... The Batch update methods are used to executes multiple SQL updates query
Batch file for java application
Batch file for java application  please tell me how to create the batch file for java application(using swings).the application is created with netbeans
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