Apache Commons DBUtils Tutorial
Selected Reading
- DBUtils - Discussion
- DBUtils - Useful Resources
- DBUtils - Quick Guide
- DBUtils - Using DataSource
- DBUtils - Custom Row Processor
- DBUtils - Custom Handler
- DBUtils - MapListHandler Class
- DBUtils - ArrayListHandler Class
- DBUtils - BeanListHandler Class
- DBUtils - BeanHandler Class
- DBUtils - ResultSetHandler interface
- DBUtils - AsyncQueryRunner interface
- DBUtils - QueryRunner interface
- DBUtils - Delete Query
- DBUtils - Update Query
- DBUtils - Read Query
- DBUtils - Create Query
- DBUtils - First Application
- DBUtils - Environment Setup
- DBUtils - Overview
- DBUtils - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
DBUtils - Update Query
Apache Commons DBUtils - Update Query
The following example will demonstrate how to update a record using Update query with the help of DBUtils. We ll update a record in Employees Table.
Syntax
The syntax for update query is as follows −
String updateQuery = "UPDATE employees SET age=? WHERE id=?"; int updatedRecords = queryRunner.update(conn, updateQuery, 33,104);
Where,
updateQuery − Update query having placeholders.
queryRunner − QueryRunner object to update employee object in database.
To understand the above mentioned concepts related to DBUtils, let us write an example which will run an update query. To write our example, let us create a sample apppcation.
Step | Description |
---|---|
1 | Update the file MainApp.java created under chapter | .
2 | Compile and run the apppcation as explained below. |
Following is the content of the Employee.java.
pubpc class Employee { private int id; private int age; private String first; private String last; pubpc int getId() { return id; } pubpc void setId(int id) { this.id = id; } pubpc int getAge() { return age; } pubpc void setAge(int age) { this.age = age; } pubpc String getFirst() { return first; } pubpc void setFirst(String first) { this.first = first; } pubpc String getLast() { return last; } pubpc void setLast(String last) { this.last = last; } }
Following is the content of the MainApp.java file.
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; pubpc class MainApp { // JDBC driver name and database URL static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost:3306/emp"; // Database credentials static final String USER = "root"; static final String PASS = "admin"; pubpc static void main(String[] args) throws SQLException { Connection conn = null; QueryRunner queryRunner = new QueryRunner(); DbUtils.loadDriver(JDBC_DRIVER); conn = DriverManager.getConnection(DB_URL, USER, PASS); try { int updatedRecords = queryRunner.update(conn, "UPDATE employees SET age=? WHERE id=?", 33,104); System.out.println(updatedRecords + " record(s) updated."); } finally { DbUtils.close(conn); } } }
Once you are done creating the source files, let us run the apppcation. If everything is fine with your apppcation, it will print the following message −
1 record(s) updated.Advertisements