Package com.almworks.sqlite4java

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

409
410
411
412
413
414
415
416
417
418
419
    "WHERE " +
      "projectId = " + projectId;

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

    while(st.step())
    {
      exclude.add(st.columnString(0));
    }

    return exclude;
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
    st.bind(1, this.getType());
    st.bind(2, this.getName());
    st.bind(3, serialize(this.getConfig()));

    st.step();
  }

  public void update() throws Exception
  {
    String sql = "UPDATE " +
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    st.bind(1, this.getType());
    st.bind(2, this.getName());
    st.bind(3, serialize(this.getConfig()));

    st.step();
  }

  public void delete() throws Exception
  {
    String sql = "DELETE FROM " +
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
    "WHERE " +
      "id = " + id;

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

    st.step();

    if(st.hasRow())
    {
      Resource resource = new Resource();
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
    "FROM " +
      "resources";

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

    while(st.step())
    {
      resources.add(Resource.getResourceById(st.columnInt(0)));
    }

    return resources;
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
    SQLiteStatement st = Db.getInstance().query(sql);

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

    st.step();
  }

  public void update() throws Exception
  {
    String sql = "UPDATE " +
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
    SQLiteStatement st = Db.getInstance().query(sql);

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

    st.step();
  }

  public void delete() throws Exception
  {
    String sql = "DELETE FROM " +
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
    "WHERE " +
      "id = " + id;

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

    st.step();

    if(st.hasRow())
    {
      Exclude exclude = new Exclude();
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
      sql+= " LIMIT " + limit;
    }

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

    while(st.step())
    {
      releases.add(Release.getReleaseById(st.columnInt(0)));
    }

    return releases;
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
    "ORDER BY " +
      "id DESC";

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

    while(st.step())
    {
      excludes.add(Exclude.getExcludeById(st.columnInt(0)));
    }

    return excludes;
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.