JDBC Statement – Update a record

package net.dharmaraj;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCStatementUpdateExample {

private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
private static final String DB_CONNECTION = "jdbc:mysql://localhost/pkm";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "";
//==================================================================
public static void main(String[] args) {
try {
updateRecordIntoDbUserTable();
} catch (SQLException e) {
System.out.println(e.getMessage());
}//end of try catch block
}//end of main method
//==================================================================
private static void updateRecordIntoDbUserTable() throws SQLException {
Connection dbConnection = null;
Statement statement = null;
String updateTableSQL = "UPDATE DBUSER"
+ " SET USERNAME = 'mkyong_new' "
+ " WHERE USER_ID = 1";
try {
dbConnection = getDBConnection();
statement = dbConnection.createStatement();
System.out.println(updateTableSQL);
statement.execute(updateTableSQL);
System.out.println("Record is updated to DBUSER table!");
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
if (statement != null) {
statement.close();
}
if (dbConnection != null) {
dbConnection.close();
}
}//end of try catch finally block
}//end of method
//==================================================================
private static Connection getDBConnection() {
Connection dbConnection = null;
try {
Class.forName(DB_DRIVER);
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
}//end of try catch block

try {
dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER,DB_PASSWORD);
return dbConnection;
} catch (SQLException e) {
System.out.println(e.getMessage());
}//end of try catch block
return dbConnection;
}//end of method
//==================================================================
}//end of Class