Advertisement
Guest User

Untitled

a guest
Apr 18th, 2015
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION net_train(terms text[], perceptron_id integer)
  2. RETURNS void AS
  3. $BODY$begin
  4. -- stub
  5. end;$BODY$
  6. LANGUAGE plpgsql VOLATILE
  7. COST 100;
  8. ALTER FUNCTION net_train(text[], integer)
  9. OWNER TO postgres;
  10.  
  11. ArrayList<String> ProcessedTherms = new ArrayList<String>();
  12.  
  13. CallableStatement cstmt = con.prepareCall(
  14. "{call net_train(?, ?)}");
  15. ArrayList<String> myTerms;
  16. //Преобразуем термы в строковое представление массива
  17. StringBuilder sb=new StringBuilder("'{"); //'{
  18. for(String s:myTerms) {
  19. sb.append(""").append(s).append(""").append(','); //пишем нечто вроде "термN",
  20. }
  21. sb.deleteCharAt(sb.length()-1); //убираем последнюю запятую
  22. sb.append("}'"); // }'
  23. cstmt.setString(1, sb.toString());
  24. cstmt.setInt(2, perceptron_id);
  25. cstmt.executeQuery();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement