Package com.almworks.sqlite4java

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

280
281
282
283
284
285
286
287
288
289
290
    st.bind(2, this.getLeftPath());
    st.bind(3, this.getLeftResourceId());
    st.bind(4, this.getRightPath());
    st.bind(5, this.getRightResourceId());

    st.step();
  }

  public void update() throws Exception
  {
    String sql = "UPDATE " +
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
    st.bind(2, this.getLeftPath());
    st.bind(3, this.getLeftResourceId());
    st.bind(4, this.getRightPath());
    st.bind(5, this.getRightResourceId());

    st.step();
  }

  public void delete() throws Exception
  {
    String sql = "DELETE FROM " +
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
    "WHERE " +
      "id = " + id;

    SQLiteStatement st = Db.getInstance().query(sql);

    st.step();

    if(st.hasRow())
    {
      Project project = new Project();
     
View Full Code Here
388
389
390
391
392
393
394
395
396
397
398
    "FROM " +
      "projects";

    SQLiteStatement st = Db.getInstance().query(sql);

    while(st.step())
    {
      projects.add(Project.getProjectById(st.columnInt(0)));
    }

    return projects;
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getProjectId());

    st.step();
  }

  public void update() throws Exception
  {
    String sql = "UPDATE " +
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getProjectId());

    st.step();
  }

  public void delete() throws Exception
  {
    String sql = "DELETE FROM " +
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
    "WHERE " +
      "id = " + id;

    SQLiteStatement st = Db.getInstance().query(sql);

    st.step();

    if(st.hasRow())
    {
      Release release = new Release();
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
      champions = new LinkedList<Champion>();
      queue.execute(new SQLiteJob<Object>() {
        protected Object job(SQLiteConnection connection) throws Throwable {
          SQLiteStatement st = connection
              .prepare("SELECT * FROM champions");
          while (st.step()) {
            Champion newChamp = new Champion();
            int i = 0; // first column is id
            newChamp.ID = st.columnInt(i); i++;
            newChamp.name = st.columnString(i); i++;
            newChamp.displayName = st.columnString(i); i++;
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
            newChamp.selectSoundPath = st.columnString(i); i++;
 
            SQLiteStatement skinsDB = connection
                .prepare("SELECT * FROM championskins WHERE championId = ?");
            skinsDB.bind(1, newChamp.ID);
            while (skinsDB.step()) {
              ChampionSkin theSkin = new ChampionSkin();
              i = 0;
              theSkin.ID = skinsDB.columnInt(i); i++;
              theSkin.isDefault = skinsDB.columnInt(i) == 1; i++;
              theSkin.order = skinsDB.columnInt(i); i++;
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    SQLiteQueue queue = GameStatsDBWrapper.getQueue();
    items = new LinkedList<Item>();
    queue.execute(new SQLiteJob<Object>() {
      protected Object job(SQLiteConnection connection) throws Throwable {
        SQLiteStatement st = connection.prepare("SELECT * FROM items");
        while (st.step()) {
          Item newItem = new Item();
          int i = 0;
          newItem.ID = st.columnInt(i);
          i++;
          newItem.name = st.columnString(i);
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.