Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package destinymod.MySQL;
- import org.bukkit.entity.Player;
- import java.sql.*;
- public class MySql {
- private String urlbase,host,database,username,password;
- public MySql(String s) {
- this.urlbase = urlbase;
- this.host = host;
- this.database = database;
- this.username = username;
- this.password = password;
- }
- public Connection con;
- //connection
- public void connect(){
- if(!isConnected()){
- try{
- con = DriverManager.getConnection(urlbase + host + "/" + database, username, password);
- System.out.println("Connection etablie !");
- }catch (SQLException e) {
- e.printStackTrace();
- System.out.println("Accès Refusé");
- }
- }
- }
- //public void disconnect(){
- //if(isConnected()){
- //try{
- //con.close();
- //System.out.print("Connection Fermée !");
- //}catch (SQLException e){
- // e.printStackTrace();
- // }
- // }
- //}
- private boolean isConnected() {
- return (con != null);
- }
- public Connection getConnection(){
- return con;
- }
- public boolean getReport(Player player){
- try{
- PreparedStatement q = (PreparedStatement) con.prepareStatement("SELECT * FROM report WHERE uuid = ?");
- q.setString(1, player.getUniqueId().toString());
- ResultSet resultat = q.executeQuery();
- boolean getReport = resultat.next();
- q.close();
- return getReport;
- }catch (SQLException e){
- e.printStackTrace();
- }
- return false;
- }
- public void postReport(Player player, String arg){
- try{
- PreparedStatement q = (PreparedStatement) con.prepareStatement("INSERT INTO report (uuid, reason) VALUES (?,?)");
- q.setString(1, player.getUniqueId().toString());
- q.setString(2, arg);
- q.execute();
- }catch (SQLException e){
- e.printStackTrace();
- }
- }
- public int getHowManyReport(Player player){
- return 0;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement