/*
|
* To change this license header, choose License Headers in Project Properties.
|
* To change this template file, choose Tools | Templates
|
* and open the template in the editor.
|
*/
|
package de.uhilger.radiozentrale.api;
|
|
import de.uhilger.baselink.GenericRecord;
|
import de.uhilger.baselink.PersistenceManager;
|
import java.util.List;
|
|
/**
|
*
|
*/
|
public abstract class DbApi extends Api {
|
|
public static final String SQL_GET_NEXT_KEY = "getNextKey";
|
public static final String SQL_INCREMENT_KEY = "incrementKey";
|
|
protected int getNextId(PersistenceManager db, String key) {
|
int nextKey = -1;
|
List<List<String>> list = db.select(getSql(SQL_GET_NEXT_KEY), GenericRecord.WITHOUT_BLOBS, key);
|
if(list != null && list.size() > 1) {
|
nextKey = Integer.parseInt(list.get(1).get(0)); // erster Datensatz ist Ueberschrift
|
if(nextKey > -1) {
|
db.execute(getSql(SQL_INCREMENT_KEY), nextKey+1, key, nextKey);
|
}
|
}
|
return nextKey;
|
}
|
}
|
