Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- package wgsqltoyaml;
- import java.io.File;
- import java.io.FileNotFoundException;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.ArrayList;
- import java.util.List;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import org.ho.yaml.Yaml;
- import pyaml.Pyaml;
- import pyaml.UsePyaml;
- /**
- *
- * @author Punga
- */
- public class WGSQLtoYAML {
- static List yaml = new ArrayList(1);
- static int temp = 0;
- public static void main(String[] args) throws FileNotFoundException, IOException {
- List regions=new ArrayList(20);
- regions.add(new Region());
- yaml.add(regions);
- Pyaml p = new Pyaml();
- p.addWordDoubleDot("regions");
- p.levelUp();
- String dbtime;
- String dbUrl = "jdbc:mysql://maturin.clanwars.cz/mc41";
- String dbClass = "com.mysql.jdbc.Driver";
- String regionQuery = "Select * FROM region ORDER BY id ASC";
- String regionCuboidQuery = "Select * FROM region_cuboid ORDER BY region_id ASC";
- String regionFlagQuery = "Select * FROM region_flag ORDER BY region_id ASC";
- //String regionQuery = "Select * FROM region ORDER BY id ASC";
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection (dbUrl,"mc41","Asn301mxS");
- Statement stmt = con.createStatement();
- Statement stmt2 = con.createStatement();
- Statement stmt3 = con.createStatement();
- Statement stmt4 = con.createStatement();
- ResultSet rs = stmt.executeQuery(regionQuery);
- System.out.println("rs htv");
- ResultSet rs2 = stmt2.executeQuery(regionCuboidQuery);
- System.out.println("rs2 htv");
- ResultSet rs3 = stmt3.executeQuery(regionFlagQuery);
- System.out.println("rs3 htv");
- rs3.next();
- int i=0;
- while (rs.next()&&rs2.next()) {
- System.out.println("rs.");
- p.addWordDoubleDot(rs.getString(1));
- p.levelUp();
- p.addWordDoubleDot("type");
- p.addValue(rs.getString(3));
- p.addWordDoubleDot("min");
- p.addValue("{x:"+rs2.getString(3)+".0, y:"+rs2.getString(4)+".0, z:"+rs2.getString(5)+".0}");
- p.addWordDoubleDot("max");
- p.addValue("{x:"+rs2.getString(6)+".0, y:"+rs2.getString(7)+".0, z:"+rs2.getString(8)+".0}");
- p.addWordDoubleDot("priority");
- p.addValue(rs.getString(2));
- p.addWordDoubleDot("flags");
- System.out.println(rs.getString(1)+":");
- Statement stmttemp = con.createStatement();
- ResultSet rstemp = stmttemp.executeQuery("Select * FROM region_flag WHERE region_id LIKE '"+rs.getString(1) +"' ORDER BY region_id ASC");
- p.levelUp();
- while(rstemp.next()){
- System.out.println(p.tab+"+flag");
- p.addWordDoubleDot(rstemp.getString(4));
- p.addValue(rstemp.getString(5));
- i++;
- }
- if(i==0){
- p.addValue("{}");
- }else{
- i=0;
- }
- p.levelDown();
- p.addWordDoubleDot("owners");
- ResultSet rstemp2 = stmttemp.executeQuery("Select * FROM region_players WHERE region_id LIKE '"+rs.getString(1) +"' AND owner = 1 ORDER BY region_id ASC");
- if(rstemp2.next()){
- String strii="[";
- Boolean s=true;
- strii=owner(strii,con,rstemp,rstemp2,s);
- while(rstemp2.next()){
- strii=owner(strii,con,rstemp,rstemp2,false);
- s=false;
- }
- strii=strii+"]";
- if(temp!=0){
- p.levelUp();
- p.addWordDoubleDot("players");
- p.addValue(strii);
- p.levelDown();
- temp=0;
- }else{
- p.addValue("{}");
- }
- }
- p.addWordDoubleDot("members");
- Statement stmttemp2 = con.createStatement();
- ResultSet rstemp4 = stmttemp2.executeQuery("Select * FROM region_players WHERE region_id LIKE '"+rs.getString(1) +"' AND owner = 0 ORDER BY region_id ASC");
- if(rstemp4.next()){
- String striii="[";
- striii=member(striii,con,rstemp,rstemp4,true);
- while(rstemp4.next()){
- striii=member(striii,con,rstemp,rstemp4,false);
- }
- striii=striii+"]";
- if(temp!=0){
- p.levelUp();
- p.addWordDoubleDot("players");
- p.addValue(striii);
- p.levelDown();
- temp=0;
- }else{
- p.addValue('{'+'}'+"");
- }
- }
- p.levelDown();
- } //end while
- con.close();
- } //end try
- catch(ClassNotFoundException e) {
- e.printStackTrace();
- }
- catch(SQLException e) {
- e.printStackTrace();
- }
- UsePyaml.save(p,new File("regions.yml"));
- }
- private static String owner(String strii, Connection con, ResultSet rstemp, ResultSet rstemp2,boolean first) throws SQLException {
- System.out.println(new Pyaml().tab+"+owner");
- Statement stmttemp2 = con.createStatement();
- ResultSet rstemp3 = stmttemp2.executeQuery("Select * FROM user WHERE id = "+rstemp2.getString(3) +" ORDER BY id ASC");
- rstemp3.next();
- if(!first){
- strii=strii+", "+rstemp3.getString(2);
- temp++;
- }else{
- strii=strii+rstemp3.getString(2);
- temp++;
- }
- return strii;
- }
- private static String member(String striii, Connection con, ResultSet rstemp, ResultSet rstemp2, boolean b) throws SQLException {
- System.out.println(new Pyaml().tab+"+member");
- Statement stmttemp2 = con.createStatement();
- ResultSet rstemp3 = stmttemp2.executeQuery("Select * FROM user WHERE id = "+rstemp2.getString(3) +" ORDER BY id ASC");
- rstemp3.next();
- if(!b){
- striii=striii+", "+rstemp3.getString(2);
- temp++;
- }else{
- striii=striii+rstemp3.getString(2);
- temp++;
- }
- return striii;
- }
- }
Add Comment
Please, Sign In to add comment