If you've written your own element, then you don't need to extend
Cisco's element. And you shouldn't need to catch AudiumException -
unless you write something incorrectly.
I wrote a simple DB element (as an Action, but you can easily change it
to a Decision element).
You should be able to do something like this:
public void doAction(String name, ActionElementData data) throws
ElementException
{
String user="user";
String password="pwd";
String driverClass="com.mysql.jdbc.Driver";
String jdbcString="jdbc:mysql://localhost:3306/rx";
Connection con = null;
Statement st = null;
ResultSet rs = null;
// get a connection here. this creates an empty jdbc object
try {
Class.forName(driverClass).newInstance();
con = DriverManager.getConnection(jdbcString,user,password);
// this reads and displays all the records in the rxtable
st = con.createStatement();
rs = st.executeQuery("SELECT * FROM RXTABLE");
while (rs.next()){
//get values by col index or by name
//do something here
}
} catch (Exception e) {
System.out.println("exception:"+e.getMessage());
} finally {
try {
if(rs != null) rs.close();
if(st != null) st.close();
if(con != null) con.close();
} catch (SQLException e) { }
}
}
