Advertisement
Guest User

Untitled

a guest
Oct 18th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. public boolean createElection(Election e) throws RemoteException {
  2.  
  3. try {
  4.  
  5.  
  6. Statement statement = connect.createStatement();
  7. ResultSet rs = statement.executeQuery("SELECT title FROM elections WHERE title= '"+ e.getTitle()+"'");
  8.  
  9.  
  10. if(!rs.next()) {
  11.  
  12.  
  13.  
  14. Date start_election = e.getBegin();
  15. Date current_date = new Date();
  16.  
  17.  
  18. if (start_election.after(current_date) || start_election.equals(current_date)) {
  19.  
  20. PreparedStatement preparedStatement = connect.prepareStatement("INSERT INTO elections " +
  21. " (title, description, date_begin, date_end, election_status) VALUES" +
  22. " (?,?,?,?,?)");
  23. System.out.println("title"+ e.getTitle());
  24. System.out.println("des"+ e.getDescription());
  25.  
  26. preparedStatement.setString(1, e.getTitle());
  27. preparedStatement.setString(2, e.getDescription());
  28. preparedStatement.setDate(3, new java.sql.Date(e.getBegin().getTime()));
  29. preparedStatement.setDate(4, new java.sql.Date(e.getEnd().getTime()));
  30.  
  31. preparedStatement.setInt(5,1);
  32. preparedStatement.executeUpdate();
  33.  
  34. System.out.println("Election successfully created");
  35. return true;
  36.  
  37. }else{
  38.  
  39. PreparedStatement preparedStatement = connect.prepareStatement("INSERT INTO elections "+
  40. " (title, description, date_begin, date_end, election_status) VALUES" +
  41. " (?,?,?,?,?)");
  42.  
  43. System.out.println("title"+ e.getTitle());
  44. System.out.println("des"+ e.getDescription());
  45.  
  46. preparedStatement.setString(1, e.getTitle());
  47. preparedStatement.setString(2, e.getDescription());
  48. preparedStatement.setDate(3, new java.sql.Date(e.getBegin().getTime()));
  49. preparedStatement.setDate(4, new java.sql.Date(e.getEnd().getTime()));
  50.  
  51. preparedStatement.setInt(5,0);
  52. preparedStatement.executeUpdate();
  53. System.out.println("The begin of the election is earlier than the current date");
  54.  
  55.  
  56. return false;
  57.  
  58. }
  59.  
  60. }
  61.  
  62. } catch (SQLException e1) {
  63. // TODO Auto-generated catch block
  64. e1.printStackTrace();
  65. }
  66. return false;
  67. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement