Solved SQLite with SQLibrary problem

Hello, I'm trying to implement SQLite and I'm using the SQLibrary. However I am trying to write the contstructor, but it returns an error. With all lines off code as seen below, it says the semicolan on line 2 should be a comma. Without line three, everything is fine. What am I doing wrong?

Code:java

//Variables
    Server server;
    Database sql;
    sql = new SQLite(Logger.getLogger("Minecraft"), "[HDSkinner] ", this.getDataFolder().getAbsolutePath(), "HDSkinner", ".sqlite");

 

Wee need the entire code. It's probably your IDE that's glitching up because something above that line is not as it should.

 

No problem. Here is the full code:

Code:java

package com.kmccmk9.HDSkinner;
 
import lib.PatPeter.SQLibrary.Database;
 
import org.bukkit.ChatColor;
import org.bukkit.Server;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.plugin.java.JavaPlugin;
import org.getspout.spoutapi.SpoutManager;
import org.getspout.spoutapi.player.SpoutPlayer;
 
public class HDSkinner extends JavaPlugin {
    //Variables
    Server server;
    Database sql;
    sql = new SQLite(Logger.getLogger("Minecraft"), "[HDSkinner] ", this.getDataFolder().getAbsolutePath(), "HDSkinner", ".sqlite");
 
    public void onDisable()
    {
        System.out.print("HDSkinner is disabled");
    }
 
    public void onEnable()
    {
        System.out.print("HDSkinner is enabled");
        server = this.getServer();
    }
 
    public boolean onCommand(CommandSender sender,Command command, String commandLabel,String args[])
    {
        if (sender instanceof Player)
        {
            Player player = (Player) sender;
            SpoutPlayer splayer = SpoutManager.getPlayer(player);
            if(commandLabel.equalsIgnoreCase("skin"))
            {
                if (args.length == 1)
                {
                    if (args[0].equalsIgnoreCase("help"))
                    {
                        player.sendMessage(ChatColor.BLUE + "Type the command skin followed by the url to change your skin to that url.");
                    }
                    else
                    {
                        splayer.setSkin(args[0]);
                    }
                }
                else
                {
                    player.sendMessage(ChatColor.DARK_RED + "Arguments mismatch. Type the skin command followed by help.");
                }
            }
            if(commandLabel.equalsIgnoreCase("cape"))
            {
                if (args.length == 1)
                {
                    if (args[0].equalsIgnoreCase("help"))
                    {
                        player.sendMessage(ChatColor.BLUE + "Type the command cape followed by the url to change your cape to that url.");
                    }
                    else
                    {
                        splayer.setCape(args[0]);
                    }
                }
                else
                {
                    player.sendMessage(ChatColor.DARK_RED + "Arguments mismatch. Type the cape command followed by help.");
                }
            }
        }
        return true;   
    }
 
}
 

 

Why save Server you can access it anywhere in you main method with getServer(). No need to save it as a variable.
Do you mean your plugin??

Code:java

 Server server;
//To
HDSkinner plugin;

 

ProtoTempus
Okay I will remove that. What is your question about? Also removing that line of code did not fix the syntax error.

 

Anyone have any ideas? I still can't seem to fix this error.

Have you been able to figure anything out?

 

kmccmk9
You can't initialize it outside of a declaration, a method, an instance block, or a static block.

Move it into one of those and you'll be golden.

 

Okay I tried moving it into the onCommand but it still can't be resolved.

 

Just put it in your onEnable().. Also, paste error or screenshot please?

 

I tried that as well. The error in Eclipse is; SQLite can not be resolved to a type.

 

You need to import SQLite

 

Ah thank you. I had an import but not the right one. This was the correct code:

Code:

import lib.PatPeter.SQLibrary.*;

Does anyone know how to use this library that could lend a hand?

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Ah well I had no idea you were using PatPeter's library xD

 

First of all, you cannot do this outside of a method:

Code:

sql = new ...

It has to be inside your onEnable().

 

A few posts up... Also this is marked as solved.

 

Sorry, seems like I've overlooked that. My apologies.

 

Would you recommend using something else?

 

PatPeter's SQLibrary is fine. Using it by myself. I created a helper class which dynamically switches between MySQL and SQLite depending on config.

http://pastebin.com/wQ3Ju81r

 

If I private message you could you help me?

 

Why? Just ask here and maybe me or anyone else will help you.

 

Okay I couldn't find too much documentation. I created the database but how do I set the name of the table and create it

 

There is lots of information out in the web. I have to google it as well. Why don't you do it?

https://www.google.de/search?q=sql+create+table

 

Ya its not the SQL as much as working with the plugin and such. Like making the table with variables and stuff.

 

Well, your description sounds like: "I have problems with grammar and such. Could you help me?" This is far too common. Everything you need to know can be found in tutorials. SQL and SQLibrary. And you need some basic Java skills as well.

If you have a specific question, ask.

 

I don't need help with java. Also there are no tutorials I could find for using his library specifically. That's where my problems are. But I think I figured out how to set and create a table in the database with variables instead of a query.