public void guardarSQLite(){
        Connection con = null;
        PreparedStatement state = null;
        try{
            Class.forName("org.sqlite.JDBC");
            String dir = System.getProperty("user.dir");
            System.out.println(dir);
            con = DriverManager.getConnection("jdbc:sqlite:"+dir+"/pokedex.db");
            con.setAutoCommit(false);
            try{
                String sql = "CREATE TABLE IF NOT EXISTS POKEMON" +
                        "(ID    INT     PRIMARY KEY     NOT NULL," +
                        "NAME TEXT    NOT NULL," +
                        "TYPE1  TEXT    NOT NULL," +
                        "TYPE2  TEXT," +
                        "HP     INT     NOT NULL," +
                        "ATK    INT     NOT NULL," +
                        "DEF    INT     NOT NULL," +
                        "SPATK  INT     NOT NULL," +
                        "SPDEF  INT     NOT NULL," +
                        "SPEED  INT     NOT NULL," +
                        "AVG    REAL    NOT NULL," +
                        "DESCR  TEXT);"; 
                state = con.prepareStatement(sql);
                state.executeUpdate();
            }catch(Exception e){
                System.out.println(e+" Debug 1");
            }
            try{
                for(int i = 0; i<pokeId.length; i++){
                    String sql1 = "INSERT INTO POKEMON (ID, NAME, TYPE1, TYPE2, HP, ATK, DEF, SPATK, SPDEF, SPEED, AVG, DESCR) " +
                             "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);";
                    state = con.prepareStatement(sql1);
                    state.setInt(1, pokeId[i].numero);
                    state.setString(2, pokeId[i].nombre);
                    state.setString(3, pokeId[i].type1);
                    state.setString(4, pokeId[i].type2);
                    state.setInt(5, pokeId[i].stats[0]);
                    state.setInt(6, pokeId[i].stats[1]);
                    state.setInt(7, pokeId[i].stats[2]);
                    state.setInt(8, pokeId[i].stats[3]);
                    state.setInt(9, pokeId[i].stats[4]);
                    state.setInt(10, pokeId[i].stats[5]);
                    state.setDouble(11, pokeId[i].avg);
                    state.setString(12, pokeId[i].descripcion);
                    state.executeUpdate();
                }
            }catch(Exception e){
                System.out.println(e+" Debug 2");
            }
            con.commit();
        }catch(Exception e){
            System.out.println(e);
        }
    }