java Simple Java JDBC Program To Execute SQL Update Statement

Below is a sample Java JDBC program which takes database connection string as command line arguments and executes the SQL update statement.

 
 
 

Value to be updated in the table is passed as a command line argument.

 
 
 

Replace the SQL update statement in the below code with the desired update statement.

 
 
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class Run_SQL_Update {
 
    static Connection sqlConn = null;
    static Statement sqlStmt = null;
    static ResultSet sqlResultset = null;
 
    public static void main(String[] args) throws SQLException {
 
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException exception) {
            System.out.println("Oracle Driver Class Not found Exception: " + exception.toString());
            return;
        }
 
        DriverManager.setLoginTimeout(5);
 
        try {

	    String db_host=args[0];
            String db_serviceName=args[1];
            String db_username=args[2];
            String db_password=args[3];
            String jdbc_conn_string="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="+db_host+")(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME="+db_serviceName+")))";
	    sqlConn = DriverManager.getConnection(jdbc_conn_string, db_username, db_password);
        } 
        catch (SQLException e) {
            System.out.println("Connection Failed! Check output console");
            e.printStackTrace();
            System.exit(1);
            return;
        }
        
        sqlStmt = sqlConn.createStatement();
        String var1 = args[4];
	String var2 = args[5];
	sqlResultset = sqlStmt.executeQuery("update SAMPLE_TABLE SET SAMPLE_COLUMN1='"+var1+"' where SAMPLE_COLUMN2=='"+var2+"'");
        sqlResultset.close(); 
        
    }
 
}
 
 
 

Copy paste the above code in a file having same name as the class name.

 
 
 

Replace the SQL update statement as per your requirement.

 
 
 

Compile the code:

 
javac Run_SQL_Update.java
 
 
 

Execute the code with the class name:

 
java Run_SQL_Update ${DB_HOST} ${DB_SID} ${DB_USER} ${DB_PASSWORD} ${VALUE_TO_UPDATE} ${CONDITION_VALUE}
 
 
0 (0)
Article Rating (No Votes)
Rate this article
Attachments
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Full Name
Email Address
Security Code Security Code
Related Articles RSS Feed
Unix - Find command examples
Viewed 3883 times since Fri, Jun 8, 2018
Display basic information about Physical Volumes
Viewed 2644 times since Sun, Jun 3, 2018
java Simple Java JDBC Program To Execute SQL Select Query
Viewed 948 times since Sun, Jan 9, 2022
Unix - eval command example
Viewed 1404 times since Fri, Jun 8, 2018
O’Reilly’s CD bookshelf
Viewed 10087 times since Wed, Jun 27, 2018
To do a quick check on the number of path present (does not mean all are Enabled] using for loop
Viewed 3053 times since Fri, Jun 8, 2018
bash for do done AIX
Viewed 1260 times since Mon, Jun 4, 2018
Convert JSON to CSV with bash script
Viewed 9879 times since Mon, Jan 20, 2020
Convert CSV to JSON with bash script
Viewed 4132 times since Mon, Jan 20, 2020
Epoch & Unix Timestamp Conversion Tools
Viewed 38560 times since Fri, Jun 22, 2018