97 lines
2.3 KiB
Java
97 lines
2.3 KiB
Java
package com.tarisan.chipcard.tpvvs.webservicetrayicon.accesodatos;
|
|
|
|
import java.util.Vector;
|
|
import es.chipcard.util.*;
|
|
|
|
public class TerminalSanitarioBean extends ClsDBBase{
|
|
public static String TABLENAME="TERMINALSANITARIO";
|
|
|
|
public TerminalSanitarioBean(){
|
|
if(!tableExistLocally()){
|
|
createLocalTable();
|
|
}
|
|
}
|
|
|
|
public String getTableName(){
|
|
return TABLENAME;
|
|
}
|
|
|
|
|
|
public java.util.Vector getTerminalesSanitarios(){
|
|
String sSQL="SELECT * FROM "+TABLENAME;
|
|
return getTerminalesSanitarios(sSQL);
|
|
}
|
|
|
|
|
|
public TerminalSanitario getTerminalesSanitarios(int nID){
|
|
String sSQL="SELECT * FROM "+TABLENAME+" WHERE ID_TER='"+nID+"'";
|
|
Vector vEL=getTerminalesSanitarios(sSQL);
|
|
if(vEL.size()==0)
|
|
return null;
|
|
else
|
|
return (TerminalSanitario)vEL.firstElement();
|
|
}
|
|
|
|
|
|
private java.util.Vector getTerminalesSanitarios(String sSQL){
|
|
java.util.Vector v=new java.util.Vector();
|
|
java.sql.ResultSet rs=null;
|
|
if(rs==null){
|
|
rs=LocalDatabaseControl.getInstance().getQuery(sSQL);
|
|
}
|
|
if(rs!=null){
|
|
try{
|
|
while(rs.next()){
|
|
v.addElement(getTerminalesSanitarios(rs));
|
|
}
|
|
}catch(Exception err){
|
|
SerClsDebug.aLog(err);
|
|
}
|
|
}
|
|
return v;
|
|
}
|
|
|
|
public static TerminalSanitario getTerminalesSanitarios(java.sql.ResultSet rs){
|
|
TerminalSanitario obj=new TerminalSanitario();
|
|
try{
|
|
obj.setNumeroTerminal(rs.getInt("ID_TER"));
|
|
obj.setTVA(rs.getInt("TIPO_TER")!=0);
|
|
}catch(Exception err){
|
|
SerClsDebug.aLog(err);
|
|
}
|
|
return obj;
|
|
}
|
|
|
|
|
|
|
|
|
|
public int insertInLocal(TerminalSanitario objTerminalSanitario){
|
|
int nRetorno=-1;
|
|
try{
|
|
if(objTerminalSanitario!=null){
|
|
String sSQL="INSERT INTO "+TABLENAME+"(" +
|
|
"ID_TER," +
|
|
"TIPO_TER" +
|
|
") "+
|
|
"VALUES (" +
|
|
DataBaseUtil.FormatSQLIntegerField(objTerminalSanitario.getNumeroTerminal())+","+
|
|
DataBaseUtil.FormatSQLIntegerField(((objTerminalSanitario.isTVA())?1:0)) +
|
|
")";
|
|
nRetorno=LocalDatabaseControl.getInstance().executeUpdate(sSQL);
|
|
}
|
|
}catch(Exception err){SerClsDebug.aLog(err);}
|
|
return nRetorno;
|
|
}
|
|
|
|
|
|
|
|
protected int createLocalTable(){
|
|
return LocalDatabaseControl.getInstance().executeUpdate(
|
|
"CREATE TABLE \""+TABLENAME+"\" (" +
|
|
"\"ID_TER\" int NOT NULL primary key ," +
|
|
"\"TIPO_TER\" int NOT NULL" +
|
|
")"
|
|
);
|
|
}
|
|
}
|