Advertisement
Guest User

Untitled

a guest
Oct 19th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. //stations AS
  2. sql_query = "from IMSStation " +
  3. "where sta_id = ? and technology_type = 'AS'" +
  4. " order by treaty_number";
  5. ServletActionContext.getRequest().setAttribute("stations_as_list", dbManager.excecuteQueryWithParams(sql_query, values, types));
  6.  
  7. //stations HA
  8. sql_query = "from IMSStation " +
  9. "where sta_id = ? and technology_type = 'HA'" +
  10. " order by treaty_number";
  11. ServletActionContext.getRequest().setAttribute("stations_ha_list", dbManager.excecuteQueryWithParams(sql_query, values, types));
  12.  
  13. //stations IS
  14. sql_query = "from IMSStation " +
  15. "where sta_id = ? and technology_type = 'IS'" +
  16. " order by treaty_number";
  17. ServletActionContext.getRequest().setAttribute("stations_is_list", dbManager.excecuteQueryWithParams(sql_query, values, types));
  18.  
  19. //stations PS
  20. sql_query = "from IMSStation " +
  21. "where sta_id = ? and technology_type = 'PS'" +
  22. " order by treaty_number";
  23. ServletActionContext.getRequest().setAttribute("stations_ps_list", dbManager.excecuteQueryWithParams(sql_query, values, types));
  24.  
  25. //stations RN
  26. sql_query = "from IMSStation " +
  27. "where sta_id = ? and technology_type = 'RN'" +
  28. " order by treaty_number";
  29. ServletActionContext.getRequest().setAttribute("stations_rn_list", dbManager.excecuteQueryWithParams(sql_query, values, types));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement