[UnSolved] MySQL Problem

As you can see im running in some trouble because i dont know how to do this. Lets say i want to return all rows ''location'' where the ''worldname'' is equal to ''world''. But i dont know how to do this, If you know how please help me out.

 

Check out how to integrate MySQL in Java and use this query:

Code:

SELECT location FROM <table> WHERE worldname = 'world'

 

I need to return XLoc, YLoc and ZLoc, Or i can put them together and return the location. And i dont know how to return this:

Code:java

ResultSet res = statement.executeQuery("SELECT " + select + " FROM " + table + " WHERE " + where  +" = '" + value + "';");
            res.next();

 

@CursedCode

Take a look at the methods ResultSet provides you: http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html
You can specify in your select sql query which coulms you want to have included in this ResultSet and then use thoe methods of ResultSet to get the x,y,z values from it to create your Location from.

 

I got it working though, But i cant get it to work with Multiple rows that has WorldName to world

 

CursedCoder

Code:

//SQL Command
SELECT * FROM `your_table_name` WHERE *your var*=?
//Java
yourPreparedStatement.setString(1, *whatever you want*);

Probably this?

 

FabeGabeMC Actually what im trying to do is, /robbery create <storename>. This creates a stone plate under the player and store's everything in a object PLUS MySQL. Object's reset every time the server gets reloaded, restarted, stopped etc. So i have to get that information from the MySQL and store it again in the Object. But i have to get all the information with the ''WorldName'' = world. So i need to put every row where worldname is equal to world in the object again.

Bump

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

 

You said you got it to work to get a some data, can you show us the code you're using to get/parse the data? As well as the query you're running.

 

getLocation(); :

Code:java

private Location getLocation() {
int XLoc = Integer.parseInt(MySQLUtil.getSQL("XLoc", "stores", "WorldName", "world", ""));
int YLoc = Integer.parseInt(MySQLUtil.getSQL("YLoc", "stores", "WorldName", "world", ""));
int ZLoc = Integer.parseInt(MySQLUtil.getSQL("ZLoc", "stores", "WorldName", "world", ""));
Location location = new Location(Bukkit.getWorld("world"), XLoc, YLoc, ZLoc);
return location;
}

getSQL:

Code:java

public static String getSQL(String select, String table, String where, String value, String returns) {
try {
openConnection();
Statement statement;
statement = Main.getConnection().createStatement();
ResultSet res = statement.executeQuery("SELECT " + select + " FROM " + table + " WHERE " + where +" = '" + value + "';");
res.next();
String returned = res.getString(returns);
return returned;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

I want it to get all the locations where WorldName is equal to World

 

CursedCoder

Perhaps you should reconsider your storage solution. Does this really need to be SQL? Why can't this be done just as well with YAML? It would likely be easier to implement, and with the way you've poorly handled SQL, likely much faster as well.

 

I cant because im gonna use more server than 1.

 

CursedCoder

Each server is going to have a different world, and therefore, different locations. They don't need to share this data.

 

Not each server is going to have a diffrent one, Some will have the same and im too lazy to copy paste the right one on the right place.

 

CursedCoder

It's literally one file that you would copy, and it's a whole lot easier than writing a proper SQL implementation.

 

Its something that im willing to learn, Because what if i need to do it with PlayerData im sure not gonna copy paste that every time somethings update. Like what if i need to return all playername's where donator = 'true' or something.

 

CursedCoder

Well, fair enough. Learning experiences are good. I would start by understanding that you need to perform SQL queries on a separate thread, and go from there.

 

mythbusterma

Im sorry i dont know what you mean, Bad english sorry x].

 

Use this to translate