Version Differences for Workflow Properties

(→AHPSCRIPTS-112)
Line 35:
  }     }  
  return values;</pre>    return values;</pre> 
       
    + = Get Value From Database =  
       
    + ==== AHPSCRIPTS-113 ====  
    + <pre> import java.sql.*;  
    + import java.util.*;  
    +  
    + String url = "jdbc:sqlserver://SomeDatabaseServer:1433;DatabaseName=SomeDatabase";  
    +  
    + List valueList = new ArrayList();  
    +  
    + try {  
    + Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");  
    + }  
    + catch (Exception e) {  
    + throw new Exception("Failed to load SQL Server driver.");  
    + }  
    + try {  
    + Connection conn = DriverManager.getConnection(url, "username", "password");  
    + Statement statement = conn.createStatement();  
    + ResultSet rs = select.executeQuery("SELECT value FROM my_table");  
    +  
    + while (rs.next()) {  
    + String value = rs.getString("value");  
    + valueList.add(value);  
    + }  
    +  
    + rs.close();  
    + statement.close();  
    + con.close();  
    + }  
    + catch (Exception e) {  
    + throw new Exception("Error querying database for values", e);  
    + }  
    +  
    + return valueList.toArray(new String[valueList.size()]);</pre>