Guest User

Untitled

a guest
Apr 22nd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. public int executePreparedUpdate(String query, ArrayList<String> parameters) throws SQLException{
  2. PreparedStatement stmt = null;
  3. int result = -1;
  4. connectToServer();
  5.  
  6. try{
  7. stmt = con.prepareStatement(query);
  8. System.out.println("1");
  9. if (parameters != null){
  10. for(int i = 0; i < parameters.size(); i++){
  11. if (parameters.get(i) == null)
  12. stmt.setString(i+1,"null");
  13. else
  14. stmt.setString(i+1, parameters.get(i));
  15. System.out.println(parameters.get(i));
  16. }
  17. }
  18. System.out.println("2");
  19. result = stmt.executeUpdate();
  20. System.out.println("3");
  21. return result;
  22. }catch(SQLException e){
  23. System.out.println("executePreparedQuery crashade!");
  24. }
  25. finally{
  26. closeConnection();
  27. try{
  28. if (stmt != null)
  29. stmt.close();
  30. }catch(SQLException e){}
  31. }
  32. return -1;
  33. }
  34. String query;
  35. ArrayList<String> parameters = new ArrayList<String>();
  36. if(name.getText().length() != 0 && race.getText().length() != 0 && sex.getText().length() != 0)
  37. try{
  38. query = "INSERT INTO T_ANIMAL (owner,species_name,name,race,sex) VALUES (?,?,?,?,?)";
  39. parameters.add(this.c.getEmail());
  40. parameters.add(this.animalRaces.getSelectedItem().toString());
  41. parameters.add(this.nameText.getText());
  42. parameters.add(this.raceText.getText());
  43. parameters.add(this.animalSexCombo.getSelectedItem().toString());
  44. DatabaseUtility.getInstance().executePreparedUpdate(query, parameters);
  45. if(journalText.getText().length() != 0){
  46. try{
  47. DatabaseUtility.getInstance().executeUpdate("INSERT INTO T_JOURNAL VALUES ('" + journalText.getText() + "')");
  48. }catch(SQLException sqle2){
  49. System.out.println("Error saving animal journal to database!");
  50. }
  51. }
  52. }catch(SQLException sqle){
  53. System.out.println("Error saving animal to database!");
  54. }
Add Comment
Please, Sign In to add comment