private void doKBErmitteln() {
Vector<Vector<String>> vec = SqlInfo.holeFelder("show tables");
datavec.clear();
for (int i = 0; i < vec.size(); i++) {
if (vec.get(i).get(0).startsWith("kb_")) {
datavec.add(vec.get(i).get(0));
}
}
kbvorhanden.setListData(datavec);
eltern.tabellenAktualisieren();
}
public String[] holeAbweichendeAdresse(String patid) {
// "anrede,titel,nachname,vorname,strasse,plz,ort"
String cmd =
"select abwanrede,abwtitel,abwn_name,abwv_name,abwstrasse,abwplz,abwort from pat5 where id='"
+ patid
+ "' LIMIT 1";
Vector<Vector<String>> abwvec = SqlInfo.holeFelder(cmd);
Object[] obj = {
(Object) abwvec.get(0).get(0),
(Object) abwvec.get(0).get(1),
(Object) abwvec.get(0).get(2),
(Object) abwvec.get(0).get(3),
(Object) abwvec.get(0).get(4),
(Object) abwvec.get(0).get(5),
(Object) abwvec.get(0).get(6)
};
return AdressTools.machePrivatAdresse(obj, true);
}
private void holeKalUser() {
vecKalUser = SqlInfo.holeFelder("select kalzeile,matchcode from kollegen2 order by kalzeile");
}