Page History

import java.sql.*Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.sql.DataSource;

import org.joget.apps.app.service.AppUtil;

Connection con = null;
try {
    // retrieve connection from the default datasource
    DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
    con = ds.getConnection();

    // execute SQL query
    if(!con.isClosed()) {
        PreparedStatement stmt = con.createStatement(prepareStatement("UPDATE table1 SET column1='value1'"); 
        stmt.executeUpdate("UPDATE formdata_simpleflow set c_status='#assignment.activityId#' WHERE processId='#assignment.processId#'"); 
    }
} catch(Exception e) { 
    System.err.println("Exception: " + e.getMessage()); 
} finally {
    try { 
        if(con != null) {
            con.close(); 
        }
    } catch(SQLException e) {
    }
}