Advertisement
Guest User

Untitled

a guest
Jan 30th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. Connection connectMySQL = DriverManager.getConnection("jdbc:mysql://"+ getConfig().getString("MySQL.hostitel") +":"+ getConfig().getString("MySQL.port") +"/"+ getConfig().getString("MySQL.databaze"), getConfig().getString("MySQL.uzivatel"), getConfig().getString("MySQL.heslo"));
  2. Statement checkTicketExistID = connectMySQL.createStatement();
  3. ResultSet MySQL_checkTicketExistID = checkTicketExistID.executeQuery("SELECT COUNT(*) AS pocet FROM "+ getConfig().getString("MySQL.tabulka") +" WHERE ticketid = '"+ args[2] +"'");
  4. MySQL_checkTicketExistID.next();
  5. int MySQL_MySQL_checkTicketExistID_out = MySQL_checkTicketExistID.getInt("pocet");
  6. MySQL_checkTicketExistID.close();
  7. if(MySQL_MySQL_checkTicketExistID_out != 0)
  8. {
  9. PreparedStatement MySQL_setTicketLabel = connectMySQL.prepareStatement("UPDATE "+ getConfig().getString("MySQL.tabulka") +" SET status = ? WHERE ticketid = ?");
  10. MySQL_setTicketLabel.setInt(1, ticketLabelValue);
  11. MySQL_setTicketLabel.setString(2, args[2]);
  12. MySQL_setTicketLabel.executeUpdate();
  13. sender.sendMessage(ChatMessage_prefix +" Ticket #"+ args[2] +" byl uspesne ocejchovan!");
  14. }
  15. else
  16. {
  17. sender.sendMessage(ChatMessage_prefix +" Ticket #"+ args[2] +" neexistuje!");
  18. }
  19. }
  20. catch (Exception e)
  21. {
  22. e.printStackTrace();
  23. }
  24. return true;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement