Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
I want to use Beanshell plugins and SQL join queries to return the name of user(s) for mapping participants.
It doesn't seem to work. How do I go about doing this
SELECT username FROM dir_user WHERE criteria = 'something';
Connection con = null;
try { Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8", "root", "");
if(!con.isClosed()){
//manually handle insert and update by checking the data is exist or not
String selectQuery = "SELECT `id` FROM dir_user WHERE `id`=?";
PreparedStatement stmt = con.prepareStatement(selectQuery);
stmt.setString(1, id);
ResultSet rs = stmt.executeQuery();
Code Block |
---|
... Connection con = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8", "root", "London2012"); if(!con.isClosed()){ //manually handle insert and update by checking the data is exist or not String selectQuery = "SELECT `id` FROM dir_user WHERE `id`=?"; PreparedStatement stmt = con.prepareStatement(selectQuery); stmt.setString(1, id); ResultSet rs = stmt.executeQuery(); } catch (Exception ex) { System.err.println("#### Exception: " + ex.getMessage()); } finally { try { if(con != null) con.close(); } catch(SQLException e) {} } return rs; ... |