Package com.almworks.sqlite4java

Examples of com.almworks.sqlite4java.SQLiteStatement.columnString()

127
128
129
130
131
132
133
134
135
136
137
            newChamp.ratingAttack = st.columnInt(i); i++;
            newChamp.ratingDefense = st.columnInt(i); i++;
            newChamp.ratingDifficulty = st.columnInt(i); i++;
            newChamp.ratingMagic = st.columnInt(i); i++;
            newChamp.tips = st.columnString(i); i++;
            newChamp.opponentTips = st.columnString(i); i++;
            newChamp.selectSoundPath = st.columnString(i); i++;
 
            SQLiteStatement skinsDB = connection
                .prepare("SELECT * FROM championskins WHERE championId = ?");
            skinsDB.bind(1, newChamp.ID);
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
            newChamp.ratingDefense = st.columnInt(i); i++;
            newChamp.ratingDifficulty = st.columnInt(i); i++;
            newChamp.ratingMagic = st.columnInt(i); i++;
            newChamp.tips = st.columnString(i); i++;
            newChamp.opponentTips = st.columnString(i); i++;
            newChamp.selectSoundPath = st.columnString(i); i++;
 
            SQLiteStatement skinsDB = connection
                .prepare("SELECT * FROM championskins WHERE championId = ?");
            skinsDB.bind(1, newChamp.ID);
            while (skinsDB.step()) {
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
              i = 0;
              theSkin.ID = skinsDB.columnInt(i); i++;
              theSkin.isDefault = skinsDB.columnInt(i) == 1; i++;
              theSkin.order = skinsDB.columnInt(i); i++;
              theSkin.championID = skinsDB.columnInt(i); i++;
              theSkin.name = skinsDB.columnString(i); i++;
              theSkin.displayName = skinsDB.columnString(i); i++;
              theSkin.portraitPath = skinsDB.columnString(i); i++;
              theSkin.splashPath = skinsDB.columnString(i); i++;
              newChamp.skins.add(theSkin);
            }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
              theSkin.ID = skinsDB.columnInt(i); i++;
              theSkin.isDefault = skinsDB.columnInt(i) == 1; i++;
              theSkin.order = skinsDB.columnInt(i); i++;
              theSkin.championID = skinsDB.columnInt(i); i++;
              theSkin.name = skinsDB.columnString(i); i++;
              theSkin.displayName = skinsDB.columnString(i); i++;
              theSkin.portraitPath = skinsDB.columnString(i); i++;
              theSkin.splashPath = skinsDB.columnString(i); i++;
              newChamp.skins.add(theSkin);
            }
            skinsDB.dispose();
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
              theSkin.isDefault = skinsDB.columnInt(i) == 1; i++;
              theSkin.order = skinsDB.columnInt(i); i++;
              theSkin.championID = skinsDB.columnInt(i); i++;
              theSkin.name = skinsDB.columnString(i); i++;
              theSkin.displayName = skinsDB.columnString(i); i++;
              theSkin.portraitPath = skinsDB.columnString(i); i++;
              theSkin.splashPath = skinsDB.columnString(i); i++;
              newChamp.skins.add(theSkin);
            }
            skinsDB.dispose();
 
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
              theSkin.order = skinsDB.columnInt(i); i++;
              theSkin.championID = skinsDB.columnInt(i); i++;
              theSkin.name = skinsDB.columnString(i); i++;
              theSkin.displayName = skinsDB.columnString(i); i++;
              theSkin.portraitPath = skinsDB.columnString(i); i++;
              theSkin.splashPath = skinsDB.columnString(i); i++;
              newChamp.skins.add(theSkin);
            }
            skinsDB.dispose();
 
            /*
 
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
        while (st.step()) {
          Item newItem = new Item();
          int i = 0;
          newItem.ID = st.columnInt(i);
          i++;
          newItem.name = st.columnString(i);
          i++;
          newItem.description = st.columnString(i);
          i++;
          newItem.iconPath = st.columnString(i);
          i++;
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
          int i = 0;
          newItem.ID = st.columnInt(i);
          i++;
          newItem.name = st.columnString(i);
          i++;
          newItem.description = st.columnString(i);
          i++;
          newItem.iconPath = st.columnString(i);
          i++;
          newItem.price = st.columnInt(i);
          i++;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
          i++;
          newItem.name = st.columnString(i);
          i++;
          newItem.description = st.columnString(i);
          i++;
          newItem.iconPath = st.columnString(i);
          i++;
          newItem.price = st.columnInt(i);
          i++;
          newItem.flatHPPoolMod = st.columnInt(i);
          i++;
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
        protected String job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT hiveTableName FROM HiveTables WHERE fpath = ?");
          try {
            stmt.bind(1, fpath.toString());
            while (stmt.step()) {
              return stmt.columnString(0);
            }
            return null;
          } finally {
            stmt.dispose();
          }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.