Advertisement
Guest User

java player listener

a guest
Jan 9th, 2012
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.07 KB | None | 0 0
  1. package me.blackjack.improvedchatlogger;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.SQLException;
  7.  
  8. import org.bukkit.event.player.PlayerChatEvent;
  9. import org.bukkit.event.player.PlayerListener;
  10.  
  11.  
  12. public class ImprovedChatLoggerPlayerListener extends PlayerListener
  13. {
  14.     String login = "database";
  15.     String pass = "password";
  16.     String url = "jdbc://server:3306/database";
  17.    
  18.     public ImprovedChatLogger plugin;
  19.    
  20.    
  21.     public ImprovedChatLoggerPlayerListener(ImprovedChatLogger instance)
  22.     {
  23.         plugin = instance;
  24.     }
  25.    
  26.     public void onPlayerChat(PlayerChatEvent event)
  27.     {
  28.         try
  29.         {
  30.             addMessagetoDB(event.getMessage());
  31.         }
  32.         catch (SQLException e)
  33.         {
  34.             e.printStackTrace();
  35.         }
  36.     }
  37.    
  38.     public void addMessagetoDB(String msg) throws SQLException
  39.     {
  40.         Connection conn = DriverManager.getConnection(url, login, pass);
  41.         PreparedStatement SQLSample = conn.prepareStatement("INSERT INTO `chat` VALUES `" + msg + "`");
  42.         SQLSample.executeUpdate();
  43.         SQLSample.close();
  44.         conn.close();
  45.        
  46.     }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement