{"id":80,"date":"2013-01-23T06:12:23","date_gmt":"2013-01-23T06:12:23","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=80"},"modified":"2022-02-03T11:25:06","modified_gmt":"2022-02-03T17:25:06","slug":"really-common-groovy-and-java-code-for-bonita","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/really-common-groovy-and-java-code-for-bonita\/","title":{"rendered":"Really common groovy and Java code for Bonita"},"content":{"rendered":"
I seem to use this code all the time so I published it for others to use.<\/p>\n
Java Date to MySQL<\/h2>\n[cc lang=”groovy”]\njava.util.Date dt = new java.util.Date(); \njava.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”); \nString currentTime = sdf.format(dt); \n[\/cc]\n
date MySQL string to Java:<\/h2>\n[cc lang=”groovy”]\nimport java.text.SimpleDateFormat; \nimport java.text.DateFormat; \nString target = “2012-02-01 20:29:30”; \nDateFormat df = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”, Locale.ENGLISH); \nDate result = df.parse(target); \nprintln result; \n[\/cc]\n
Debugging to the Bonita Log<\/h2>\n[cc lang=”groovy”]\nimport org.slf4j.Logger; \nimport org.slf4j.LoggerFactory; \nLogger LOGGER = LoggerFactory.getLogger(this.getClass()); \nLOGGER.error(“Your String Here”); \n[\/cc]\n
Groovy SQL in place of MySQL connector which is more of a hassle than a help<\/h2>\n[cc lang=”groovy”]\nimport groovy.sql.Sql import java.sql.Connection; \nimport java.sql.DriverManager; \nimport org.slf4j.Logger; \nimport org.slf4j.LoggerFactory; \nLogger LOGGER = LoggerFactory.getLogger(this.getClass()); \nsql = providedscripts.BonitaSql.newInstance(“jdbc:mysql:\/\/10.11.12.13:3306\/grails”,”user”, “password”, new com.mysql.jdbc.Driver()) \nsql.eachRow(“select * from person”) { LOGGER.error(“Person = ” \u00a0+ it.first_name + ” ” + it.last_name); } \n[\/cc]\n
Groovy web link encoding that works<\/h2>\n[cc lang=”groovy”]\n