17 | October | 2014

/* ***************************************************************************** */
/* This is a short example of implementing a MySQL DB connection via ooRexx      */ 
/* by using BSF4ooRexx. Using the Java - mysql connector via bean scripting      */
/* in ooRexx                                                                     */
/* created by Martin Stoppacher - 26.12.2009                                     */
/* ***************************************************************************** */

say hello access to a my sql database via java using bsf4rexx
uid = "root";
url = "jdbc:mysql://localhost/test";
pw = "password";

mydrive=.bsf~new('com.mysql.jdbc.Driver')        /* establishe the db connection */
man=bsf.loadClass("java.sql.DriverManager")
man~registerDriver(mydrive)

conn=man~getConnection(url, uid, pw)                  /* connecting the database */

stmt=conn~createStatement                                       /* fetching data */
rset=stmt~executeQuery("select max(Nr)+1 as maximum from mytest")

rset~next; i = rset~getString("maximum"); say i;
stmt~executeUpdate("insert into mytest values(" || i ||",'BSF4ooRexx')") 

rset=stmt~executeQuery("select NR, NAME from mytest")           /* fetching data */

say "NR______NAME"                                                 /* print data */
do while rset~next
say rset~getString("nr")  || ______ || rset~getString("NAME")
end

say end

::requires BSF.CLS                                       /* get the Java support */

/* ***************************************************************************** */

/* This is a short example of implementing a MySQL DB connection via ooRexx */

/* by using BSF4ooRexx. Using the Java - mysql connector via bean scripting */

/* in ooRexx */

/* created by Martin Stoppacher - 26.12.2009 */

/* ***************************************************************************** */

say hello access to a my sql database via java using bsf4rexx

uid = "root";

url = "jdbc:mysql://localhost/test";

pw = "password";

mydrive=.bsf~new('com.mysql.jdbc.Driver') /* establishe the db connection */

man=bsf.loadClass("java.sql.DriverManager")

man~registerDriver(mydrive)

conn=man~getConnection(url, uid, pw) /* connecting the database */

stmt=conn~createStatement /* fetching data */

rset=stmt~executeQuery("select max(Nr)+1 as maximum from mytest")

rset~next; i = rset~getString("maximum"); say i;

stmt~executeUpdate("insert into mytest values(" || i ||",'BSF4ooRexx')")

rset=stmt~executeQuery("select NR, NAME from mytest") /* fetching data */

say "NR______NAME" /* print data */

do while rset~next

say rset~getString("nr") || ______ || rset~getString("NAME")

end

say end

::requires BSF.CLS /* get the Java support */

MST

Daily Archives: 10/17/2014

Implementing a MySQL DB connection via ooRexx by using BSF4ooRexx – (3_MySql_connector.rxj)