Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hello Jogetor guys,
I wrote beanshell script in beanshell tool plug-in. my question is how can call it in my form.
import java.util.*; import java.sql.*; import javax.sql.DataSource; import java.io.*; Connection conn = null; PreparedStatement stmt = null; try { String userName = "root"; String password = ""; String url = "jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); if(!conn.isClosed()) { String sql = "SELECT Count(*) FROM app_fd_application WHERE app_fd_application.c_companyName = '#form.application.companyName#'"; stmt = conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery(sql); rs.next(); boolean exists; if( exists = rs.getInt("COUNT(*)") > 0) { System.out.println("exists"); } else { System.out.println("not exists"); } } } catch (Exception e) { System.err.println("Exception: " + e.getMessage()); } finally { try { if(conn != null) { conn.close(); } } catch(SQLException e) { } }
BR