Advertisement
Guest User

Untitled

a guest
Mar 16th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. SET SQL_SAFE_UPDATES = 0;
  2.  
  3. public class DatabaseWork {
  4. // подключение к бд
  5. private static final String url = "jdbc:mysql://localhost:3306/players?autoReconnect=true&useSSL=false";
  6. private static final String user = "user";
  7. private static final String password = "password";
  8.  
  9. // переменные подключения
  10. private static Connection con = null;
  11. private static Statement stmt = null;
  12. private static ResultSet rs = null;
  13.  
  14. // строка запроса
  15. private String query;
  16.  
  17. public void banIp(String ipaddress, String reason) {
  18. query = "INSERT INTO `bannedip` (`ip`, `reason`) VALUES ('" + ipaddress + "', '" + reason + "');";
  19.  
  20. try {
  21. con = DriverManager.getConnection(url, user, password);
  22.  
  23. // getting Statement object to execute query
  24. stmt = con.createStatement();
  25.  
  26. stmt.executeUpdate(query);
  27. } catch (SQLException e) {
  28. e.printStackTrace();
  29. }
  30. finally {
  31. try {
  32. con.close();
  33. } catch (SQLException se) {
  34. se.printStackTrace(); }
  35. try {
  36. stmt.close();
  37. } catch (SQLException se) {
  38. se.printStackTrace(); }
  39. }
  40. }
  41.  
  42. DatabaseWork db = new DatabaseWork();
  43. db.banIp("hjg996k", "reason");
  44.  
  45. com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'hjg996k' for key 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement