UNIX for Advanced & Expert Users

public class scriptBuilder {
    private static final Logger logger = LoggerFactory.getLogger(scriptBuilder.class);

    public scriptBuilder() {
    }

    public void writeScript(String scriptFileName) throws java.io.IOException {
        Runtime rt = Runtime.getRuntime();
        String script = scriptFileName;
        rt.exec("chmod 777 " + script);
        Process p = null;
        try {
            String shellCmd = "./" + script;
            p = rt.exec(shellCmd);
            int exitVal = p.waitFor();
            logger.info("rt.exec exit value = " + exitVal);
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        String shellfilename = "testing.txt";
        if (new File(shellfilename).exists()) {
            logger.info(shellfilename+" File exists");
        }
    }

}

    public static void main(String []args)    { 
            try {
                sb.writeScript("testingScriptBuilder.sh");
            } catch (IOException e) {
                e.printStackTrace();
            }
}

#!/bin/bash


DBCON="mysql -usmartie -phal77berd"
DPS_DB="dps4"

function d {
$DBCON << EOF1

ALTER TABLE ${DPS_DB}.sz_avm_g1 ADD COLUMN test_col INT(1);
DROP TABLE IF EXISTS ${DPS_DB}.test_script;
CREATE TABLE ${DPS_DB}.test_script (property_id int(12));

EOF1
    
}
d

ALTER TABLE ${DPS_DB}.sz_avm_g1 ADD COLUMN test_col INT(1);