Tutorial Using MySQL In your Plugins!

Discussion in 'Resources' started by -_Husky_-, Mar 1, 2013.

Thread Status:
Not open for further replies.
  1. Guys, I have a little issue with this...
    Whenever I try to retrieve values from the database a get the "ResultSet closed" exception. Here's the part of my code that produces it:
            ResultSet set = l.statement.executeQuery("SELECT Location FROM LaunchPlate WHERE Location = '"+ serializeLoc(loc.getBlock().getLocation()) +"';");
            if(player.hasPermission(l.p) && set.getString("Location").equals(serializeLoc(loc.getBlock().getLocation()))){
    //do stuff
    This code is part of a class for event handling, so 'l' represents the instance of the main class, where I created the connection and the statement.
    Can you help me?
  2. Offline


    Your query doesn't really make sense. Why would you be retrieving your Location column when you already know what it is? Your query doesn't actually DO anything does it?
  3. Not at all. My query's only purpose is that of checking if the Location entry is the same as the location of the player. It's an if inside an event handler.
  4. Offline


    @dadus33 RingOfStorms is correct. You already know that the location is correct, because that is part of the query. If the result set is closed, then it is empty, so the location is not correct.
  5. I can see that, but how can I check if the location of the player is that found inside the database? I mean, without the exception.
  6. Offline


    ResultSet set = l.statement.executeQuery("SELECT Location FROM LaunchPlate WHERE Location = '"+ serializeLoc(loc.getBlock().getLocation())+"';");
    if (!set.next()) {
    //code here
  7. Offline


    I still don't get your query. You are selecting the Location column where the Location column is equal to something you already know. Maybe you should just COUNT rather than select the same exact column that you already know.

    SELECT COUNT(*) FROM LaunchPlate WHERE Location = ....

    This way you just get the number matching, and are also not having the SQL server send a bunch of useless data.

    And another thing, your second line with the IF statement doesn't make a whole lot of sense.
    if(player.hasPermission(l.p)&& set.getString("Location").equals(serializeLoc(loc.getBlock().getLocation()))){

    You should probably check the permissions FIRST before you start using sql as you are just wasting bandwidth if you do absolutely nothing with the result due to no permission. And then the second part of your if statement will never be false because you've already had SQL return you a location that does equal the one you just asked for. What you wrote there was basically
    if(player has permission && true == true)

    So use count instead and format it more like

    Pseudo code:
    if(player has permission) {
       Result ... "SELECT COUNT(*)..."
       if(result > 0) {
  8. Look, I'm not an SQL expert, actualy, I'm more of a begginer, so I don't kinda understand what you mean. I want to check if a player's location exists inside the database. As far as I know, the COUNT(*) function will return the number of entries in a table, and I really don't know how that would be useful to me. I don't want to get the location from the table, because, as you said, I already know it. However, I want to CHECK if it exists. But thank you for the idea of putting the permission thingy first.

    Eh, I think I got it now. Using the COUNT function I can check wheter the location is present in the db or not. If it is, it will return 1, else, 0. Thank you so much!

    Hmm, guys, how can I get the value of a result set? I mean, I can't just do 'if (res>0)'. And getInt doesn't work...

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: Dec 20, 2015
    RingOfStorms likes this.
  9. Offline


    if (result.next() && result.getInt("value") > 0) {
    A ResultSet has a pointer. The value you pass, in this case "value", is the column label; the pointer designates the row number. It starts before the first one. The boolean function next() moves it one farther, and returns false if it is now past the entire set.
  10. Offline


    if (getResultSet().first() && getResultSet().getInt(1) > 0)
    Same as above but doesn't require you to know column 1's name which makes it a little easier to remember and use elsewhere
  11. Offline


    @RingOfStorms Except the correct column isn't necessarily the first one.
    However, he does know the name.
  12. Thanks guys, solved it. Just used res.getInt(1) and it worked.
  13. Offline


    @dadus33 I would also hope you are not doing IO on the database on the main thread, and instead use some sort of hashmap to store the data
  14. Offline


    Hey guys, Just started using this lib and it is great :) I am having a problem with my code. I followed A YouTube video but I am getting some errors. Bellow is my code and the errors. I hope you can help me.

    package me.flamboo.WebbedMCAuth;
    import java.sql.Connection;
    import java.sql.SQLException;
    import java.sql.Statement;
    import org.bukkit.ChatColor;
    import org.bukkit.Server;
    import org.bukkit.command.Command;
    import org.bukkit.command.CommandSender;
    import org.bukkit.command.ConsoleCommandSender;
    import org.bukkit.configuration.file.FileConfiguration;
    import org.bukkit.entity.Player;
    import org.bukkit.event.Listener;
    import org.bukkit.plugin.PluginManager;
    import org.bukkit.plugin.java.JavaPlugin;
    import code.husky.mysql.MySQL;
    public class Main extends JavaPlugin implements Listener{
        public String sqhost = getConfig().getString("Database.Host");
        public String sqport = getConfig().getString("Database.port");
        public String sqdb = getConfig().getString("Database.Database");
        public String squser = getConfig().getString("Database.User");
        public String sqpass = getConfig().getString("Database.Password");
        public String sqtable = getConfig().getString("Database.Table");
           public MySQL db;
           public boolean logDB = true ;
              public void onEnable(){
                   Server server = getServer();
            ConsoleCommandSender console = server.getConsoleSender();
                   console.sendMessage(ChatColor.RED + getDescription().getName());
            console.sendMessage(ChatColor.RED + "Version " + getDescription().getVersion());
                 PluginManager pm = getServer().getPluginManager();
          pm.registerEvents(this, this);
               FileConfiguration config = getConfig();
               config.addDefault("Database.Host", "localhost");
          config.addDefault("Database.Port", 3306);
          config.addDefault("Database.Database", "test");
          config.addDefault("Database.User", "root");
          config.addDefault("Database.Password", "fliplip1");
          config.addDefault("Database.Table", "test");
               try {
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            this.logDB = false;
            console.sendMessage("Error (1) :" + e);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            this.logDB = false;
            console.sendMessage("Error (2) :" + e);
              public void onEnalbe(){
        public boolean onCommand(CommandSender sender, Command cmd, String commandLabel, String[] arg)
            Player player = (Player)sender;
            Server server = getServer();
            ConsoleCommandSender console = server.getConsoleSender();
            if (commandLabel.equalsIgnoreCase("auth")) {
                if (player.hasPermission("auth.can")) {
                    if(arg.length == 0){
                        player.sendMessage(ChatColor.GRAY + "You need to enter your site ID");
                    else if(arg.length == 1){
                        Player ap = player.getServer().getPlayer(arg[0]);
                        String pname = player.getDisplayName().toLowerCase();
                        Statement statement = this.db.getConnection().createStatement();
                        statement.executeUpdate("UPDATE '"+sqtable+" SET 'Auth'='1' WHERE 'Site'="+ap+"';");
                        statement.executeUpdate("UPDATE '"+sqtable+" SET 'Name'='"+pname+"' WHERE 'Site'="+ap+"';");
                        } catch (ClassNotFoundException e) {
                            // TODO Auto-generated catch block
                            this.logDB = false;
                            console.sendMessage("Error: (3) " + e);
                        } catch (SQLException e) {
                            // TODO Auto-generated catch block
                            this.logDB = false;
                            console.sendMessage("Error: (4) " + e);
            return true;
            public void setupDB() throws SQLException, ClassNotFoundException{
            this.db = new MySQL(this, sqhost, sqport, sqdb, squser, sqpass);
            Statement statement = this.db.getConnection().createStatement();
            statement.executeUpdate("CREATE TABLE IF NOT EXISTS '"+sqtable+"' ('Site' int,'name' varchar(32),'Auth' int)");
    [18:54:55 INFO]: [WebbedMC_Auth] Enabling WebbedMC_Auth v1.0
    [18:54:55 INFO]: WebbedMC_Auth
    [18:54:55 INFO]: Version 1.0
    [18:54:55 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'.
    [18:54:55 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [18:54:55 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    [18:54:55 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    [18:54:55 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    [18:54:55 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [18:54:55 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
    [18:54:55 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    [18:54:55 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    [18:54:55 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    [18:54:55 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    [18:54:55 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:314)
    [18:54:55 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:571)
    [18:54:55 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:215)
    [18:54:55 WARN]: at code.husky.mysql.MySQL.openConnection(MySQL.java:58)
    [18:54:55 WARN]: at me.flamboo.WebbedMCAuth.Main.setupDB(Main.java:123)
    [18:54:55 WARN]: at me.flamboo.WebbedMCAuth.Main.onEnable(Main.java:60)
    [18:54:55 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
    [18:54:55 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
    [18:54:55 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
    [18:54:55 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:356)
    [18:54:55 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:316)
    [18:54:55 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:418)
    [18:54:55 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:382)
    [18:54:55 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:337)
    [18:54:55 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:256)
    [18:54:55 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:528)
    [18:54:55 WARN]: at java.lang.Thread.run(Thread.java:745)
    [18:54:55 WARN]: Caused by: java.lang.NumberFormatException: For input string: "null"
    [18:54:55 WARN]: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    [18:54:55 WARN]: at java.lang.Integer.parseInt(Integer.java:492)
    [18:54:55 WARN]: at java.lang.Integer.parseInt(Integer.java:527)
    [18:54:55 WARN]: at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:831)
    [18:54:55 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    [18:54:55 WARN]: ... 16 more
    the errors
  15. Offline


    MySQL MySQL = new MySQL(this, ip, port, name, user, pass);
            try {
                c = MySQL.openConnection();
            } catch (ClassNotFoundException e) {
            } catch (SQLException e) {
    When running this code the last log message is shown. I have checked so many times and I am using the same connection values loaded from a config as another mysql plugin that works fine on the same test server and test database.
  16. Offline


    Helloo There Bukkit Community, I was wondering how would i make it so it will add a player to the table on my mysql database but if the player is already on there do nothing?
    Last edited: Jul 24, 2015
  17. Offline


    When the player first joins the server check if they exist in the table with SELECT * and if it they don't exist create a new table for them.
  18. Offline


    @Eos Why would you select "*"?
  19. Offline


    Are you still active on the forums? I need help
  20. Offline


  21. Offline


    @MCMatters Because it's slower, more overload to the database and unnecessary data sent?
  22. Offline


    Nice tutorial, worked. I only bumped into this small problem:

     MySQL MySQL = new MySQL("host.name", "port", "database", "user", "pass");
        Connection c = null;
        public void onEnable() {
            c = MySQL.openConnection();
    //Unhandled exception type ClassNotFoundException
    And btw, how do you close the connection? I assume it isnt as simple as c = MySQL.closeConnection(); (In onDisable())?
  23. Offline


    If there is a "CNF" error, that means you imported the wrong thing. Can we see your imports?

    Also, to close a port I believe is "c.close()" or "c.closeConnection();".
  24. Offline


    Last edited: Dec 28, 2015
  25. Offline


    I'm getting the "no database selected" error
    [21:35:59 WARN]: java.sql.SQLException: No database selected
    [21:35:59 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    [21:35:59 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    [21:35:59 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    [21:35:59 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    [21:35:59 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    [21:35:59 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    [21:35:59 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    [21:35:59 WARN]:        at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    [21:35:59 WARN]:        at me.pvpdog.sqlproject.commands.AddCommand.onCommand(Ad
    [21:35:59 WARN]:        at org.bukkit.command.PluginCommand.execute(PluginComman
    [21:35:59 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
    [21:35:59 WARN]:        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCo
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.PlayerConnection.handleC
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.PlayerConnection.a(Playe
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(Packe
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(Packe
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.
    [21:35:59 WARN]:        at java.util.concurrent.Executors$RunnableAdapter.call(U
    nknown Source)
    [21:35:59 WARN]:        at java.util.concurrent.FutureTask.run(Unknown Source)
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.SystemUtils.a(SystemUtil
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.B(Minecr
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.DedicatedServer.B(Dedica
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.A(Minecr
    [21:35:59 WARN]:        at net.minecraft.server.v1_8_R3.MinecraftServer.run(Mine
    [21:35:59 WARN]:        at java.lang.Thread.run(Unknown Source)
    try {
                        ResultSet res = statement.executeQuery("SELECT * FROM players WHERE email = "+args[1].toLowerCase());
                            p.sendMessage(ChatColor.GREEN+"You have not registered!");
                            return true;
                            p.sendMessage(ChatColor.RED+"You have already registered your email!");
                            return false;
                    } catch (SQLException e) {
                        return false;
    Plz help.
  26. Offline


    You have to actually connect to the database first.
  27. Offline


    I do have a connection.
  28. Offline


    In c = MySQL.openConnection(); i have to add that in my onEnable() with try/catch ?
  29. Offline


    Probably, your IDE will tell you
  30. Offline


    Could anyone help me please? Im getting this error:

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    [13:06:42 WARN]:        at sun.reflect.GeneratedConstructorAccessor226.newInstance(Unknown Source)
    [13:06:42 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [13:06:42 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [13:06:42 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    [13:06:42 WARN]:        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)
    [13:06:42 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    [13:06:42 WARN]:        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
    [13:06:42 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
    [13:06:42 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
    [13:06:42 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
    [13:06:42 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    [13:06:42 WARN]:        at sun.reflect.GeneratedConstructorAccessor223.newInstance(Unknown Source)
    [13:06:42 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [13:06:42 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [13:06:42 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    [13:06:42 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
    [13:06:42 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
    [13:06:42 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
    [13:06:42 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
    [13:06:42 WARN]:        at me.zachbears27.MySQL.openConnection(MySQL.java:77)
    [13:06:42 WARN]:        at me.zachbears27.DeathLocation.onEnable(DeathLocation.java:32)
    [13:06:42 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:271)
    [13:06:42 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
    [13:06:42 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
    [13:06:42 WARN]:        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugin(CraftServer.java:375)
    [13:06:42 WARN]:        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugins(CraftServer.java:325)
    [13:06:42 WARN]:        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.reload(CraftServer.java:749)
    [13:06:42 WARN]:        at org.bukkit.Bukkit.reload(Bukkit.java:540)
    [13:06:42 WARN]:        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
    [13:06:42 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    [13:06:42 WARN]:        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.dispatchCommand(CraftServer.java:649)
    [13:06:42 WARN]:        at org.bukkit.craftbukkit.v1_11_R1.CraftServer.dispatchServerCommand(CraftServer.java:635)
    [13:06:42 WARN]:        at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:437)
    [13:06:42 WARN]:        at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:400)
    [13:06:42 WARN]:        at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:675)
    [13:06:42 WARN]:        at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:574)
    [13:06:42 WARN]:        at java.lang.Thread.run(Unknown Source)
    [13:06:42 WARN]: Caused by: java.net.ConnectException: Connection refused: connect
    [13:06:42 WARN]:        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    [13:06:42 WARN]:        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    [13:06:42 WARN]:        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    [13:06:42 WARN]:        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    [13:06:42 WARN]:        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    [13:06:42 WARN]:        at java.net.PlainSocketImpl.connect(Unknown Source)
    [13:06:42 WARN]:        at java.net.SocksSocketImpl.connect(Unknown Source)
    [13:06:42 WARN]:        at java.net.Socket.connect(Unknown Source)
    [13:06:42 WARN]:        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
    [13:06:42 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
    [13:06:42 WARN]:        ... 31 more

    package me.zachbears27;
    import java.sql.Connection;
    import java.sql.SQLException;
    import java.sql.Statement;
    import org.bukkit.Bukkit;
    import org.bukkit.Location;
    import org.bukkit.entity.Player;
    import org.bukkit.event.EventHandler;
    import org.bukkit.event.Listener;
    import org.bukkit.event.entity.PlayerDeathEvent;
    import org.bukkit.plugin.java.JavaPlugin;
    import me.zachbears27.MySQL;
    public class DeathLocation extends JavaPlugin implements Listener {
        DeathLocation plugin;
        MySQL MySQL = new MySQL("localhost", "3306", "id115504_mumbo", "STUFF", "STUFF");
           Connection connection = null;
    public void onDisable() {
    public void onEnable() {
      getServer().getPluginManager().registerEvents(this, this);
      try {
        connection = MySQL.openConnection();
    } catch (ClassNotFoundException e) {
    } catch (SQLException e) {
    public void onPlayerDeath(PlayerDeathEvent e) {
      if (e.getEntity() instanceof Player) {
       Player p = e.getEntity();
       Location loc = e.getEntity().getLocation();
       int x = loc.getBlockX();
       int y = loc.getBlockY();
       int z = loc.getBlockZ();
       String time = "its time";
       Bukkit.broadcastMessage(x + " " + y + " " + z );
       String statementstring = "INSERT INTO `" + "id115504_mumbo" + "`DeathLocations` (`PlayerName`, `X`, `Y`, `Z`, `Time`) VALUES (" + p.getName() + ", '" + x + "', '" + y + "', '" + z + "', '" + time + "');";
       try {
        Statement statement = this.connection.createStatement();
    } catch (SQLException e1) {
        // TODO Auto-generated catch block
Thread Status:
Not open for further replies.

Share This Page