Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"));
- Statement checkTicketExistID = connectMySQL.createStatement();
- ResultSet MySQL_checkTicketExistID = checkTicketExistID.executeQuery("SELECT COUNT(*) AS pocet FROM "+ getConfig().getString("MySQL.tabulka") +" WHERE ticketid = '"+ args[2] +"'");
- MySQL_checkTicketExistID.next();
- int MySQL_MySQL_checkTicketExistID_out = MySQL_checkTicketExistID.getInt("pocet");
- MySQL_checkTicketExistID.close();
- if(MySQL_MySQL_checkTicketExistID_out != 0)
- {
- PreparedStatement MySQL_setTicketLabel = connectMySQL.prepareStatement("UPDATE "+ getConfig().getString("MySQL.tabulka") +" SET status = ? WHERE ticketid = ?");
- MySQL_setTicketLabel.setInt(1, ticketLabelValue);
- MySQL_setTicketLabel.setString(2, args[2]);
- MySQL_setTicketLabel.executeUpdate();
- sender.sendMessage(ChatMessage_prefix +" Ticket #"+ args[2] +" byl uspesne ocejchovan!");
- }
- else
- {
- sender.sendMessage(ChatMessage_prefix +" Ticket #"+ args[2] +" neexistuje!");
- }
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- return true;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement