Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public boolean createElection(Election e) throws RemoteException {
- try {
- Statement statement = connect.createStatement();
- ResultSet rs = statement.executeQuery("SELECT title FROM elections WHERE title= '"+ e.getTitle()+"'");
- if(!rs.next()) {
- Date start_election = e.getBegin();
- Date current_date = new Date();
- if (start_election.after(current_date) || start_election.equals(current_date)) {
- PreparedStatement preparedStatement = connect.prepareStatement("INSERT INTO elections " +
- " (title, description, date_begin, date_end, election_status) VALUES" +
- " (?,?,?,?,?)");
- System.out.println("title"+ e.getTitle());
- System.out.println("des"+ e.getDescription());
- preparedStatement.setString(1, e.getTitle());
- preparedStatement.setString(2, e.getDescription());
- preparedStatement.setDate(3, new java.sql.Date(e.getBegin().getTime()));
- preparedStatement.setDate(4, new java.sql.Date(e.getEnd().getTime()));
- preparedStatement.setInt(5,1);
- preparedStatement.executeUpdate();
- System.out.println("Election successfully created");
- return true;
- }else{
- PreparedStatement preparedStatement = connect.prepareStatement("INSERT INTO elections "+
- " (title, description, date_begin, date_end, election_status) VALUES" +
- " (?,?,?,?,?)");
- System.out.println("title"+ e.getTitle());
- System.out.println("des"+ e.getDescription());
- preparedStatement.setString(1, e.getTitle());
- preparedStatement.setString(2, e.getDescription());
- preparedStatement.setDate(3, new java.sql.Date(e.getBegin().getTime()));
- preparedStatement.setDate(4, new java.sql.Date(e.getEnd().getTime()));
- preparedStatement.setInt(5,0);
- preparedStatement.executeUpdate();
- System.out.println("The begin of the election is earlier than the current date");
- return false;
- }
- }
- } catch (SQLException e1) {
- // TODO Auto-generated catch block
- e1.printStackTrace();
- }
- return false;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement