package
cobolprogramclasses.dao;
/************************************************************************
**This file automatically generated from a
part of Cobol program in source file BGE018Q.CBL
**Generated at time 20:42:01.10 on Saturday,
01/23/10
************************************************************************/
import
com.res.java.lib.*;
import
java.math.BigDecimal;
import
java.sql.*;
public class
Bge018qDao extends AbstractDao {
//SELECT TABLENAME
//,IDCOLNAME
//,FKCOLNAME
//,OBJECTTABLENAME
//INTO
:SV-PF-TABLENAME:SV-PF-IND-TABLENAME
//,:SV-PF-IDCOLNAME:SV-PF-IND-IDCOLNAME
//,:SV-PF-FKCOLNAME:SV-PF-IND-FKCOLNAME
//,:SV-PF-OBJECTTABLENAME:SV-PF-IND-OBJECTTABLENAME
//FROM PROPERTYFUNCTION
//WHERE PFCODE = :SV-WK-PFCODE
public boolean execSqlStatement1(String
val1) {
try {
if(openConnection()) {
if(prepareStatement("SELECT
TABLENAME"+
",IDCOLNAME"+
",FKCOLNAME"+
",OBJECTTABLENAME
"+
"FROM"+
"PROPERTYFUNCTION
"+
"WHERE"+
"PFCODE"+
"="+
"?")) {
getStatement().setString(1,val1);
return true;
}
}
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//DECLARE SQL1 CURSOR FOR
//SELECT DFLTVALUE
//FROM PROPERTYSETMBR PSM
//WHERE PSM.PSID = -( :SV-KEYVALUE )
//AND PSM.PROPERTYKEY = :SV-WK-PROPERTYKEY
//AND USERREADFLG = 'Y'
public boolean execSqlStatement2(int
val1,String val2) {
try {
if(openConnection()) {
if(prepareStatement("SELECT
DFLTVALUE "+
"FROM
PROPERTYSETMBR PSM "+
"WHERE PSM.PSID =
-( ? )"+
"AND
PSM.PROPERTYKEY = ?"+
"AND USERREADFLG =
'Y'")) {
getStatement().setInt(1,val1);
getStatement().setString(2,val2);
getStatement().executeQuery();
saveStatement("SQL1",getStatement());
return true;
}
}
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//OPEN SQL1
public boolean execSqlStatement3() {
try {
loadStatement("SQL1");
saveResult("SQL1",getStatement().executeQuery());
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH SQL1
//INTO:SV-DFLTVALUE
public boolean execSqlStatement4() {
try {
loadResult("SQL1");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//SELECT :SV-DFLTVALUE
//INTO :SV-PROPVALDATE
//FROM DUAL
public boolean execSqlStatement5(String
val1) {
try {
if(openConnection()) {
if(prepareStatement("SELECT
? "+
"FROM"+
"DUAL")) {
getStatement().setString(1,val1);
return true;
}
}
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//SELECT :SV-DFLTVALUE
//INTO :SV-PROPVALDATE
//FROM DUAL
public boolean execSqlStatement6(String
val1) {
try {
if(openConnection()) {
if(prepareStatement("SELECT
? "+
"FROM"+
"DUAL")) {
getStatement().setString(1,val1);
return true;
}
}
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//OPEN DFT3
public boolean execSqlStatement7() {
try {
loadStatement("DFT3");
saveResult("DFT3",getStatement().executeQuery());
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH DFT3 INTO:SV-PROPVALNUMBER
public boolean execSqlStatement8() {
try {
loadResult("DFT3");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//SELECT TO_NUMBER(:SV-DFLTVALUE)
//INTO :SV-PROPVALNUMBER
//FROM DUAL
public boolean execSqlStatement9(String
val1) {
try {
if(openConnection()) {
if(prepareStatement("SELECT
TO_NUMBER(?) "+
"FROM"+
"DUAL")) {
getStatement().setString(1,val1);
return true;
}
}
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//OPEN SQL6000
public boolean execSqlStatement10() {
try {
loadStatement("SQL6000");
saveResult("SQL6000",getStatement().executeQuery());
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH SQL6000
//INTO:SV-TN-PROPVALCHAR
//,:SV-TN-ROWID
//,:SV-TN-ROWVERSION
public boolean execSqlStatement11() {
try {
loadResult("SQL6000");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH SQL6000
//INTO:SV-TN-PROPVALDATE
//,:SV-TN-ROWID
//,:SV-TN-ROWVERSION
public boolean execSqlStatement12() {
try {
loadResult("SQL6000");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH SQL6000
//INTO:SV-TN-PROPVALNUMBER
//,:SV-TN-ROWID
//,:SV-TN-ROWVERSION
public boolean execSqlStatement13() {
try {
loadResult("SQL6000");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//OPEN SQL7000 USING :SV-WK-PROPERTYKEY
//,:SV-WK-KEYVALUE
public boolean execSqlStatement14() {
try {
loadStatement("SQL7000");
saveResult("SQL7000",getStatement().executeQuery());
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//OPEN SQL7000 USING :SV-WK-PROPERTYKEY
public boolean execSqlStatement15() {
try {
loadStatement("SQL7000");
saveResult("SQL7000",getStatement().executeQuery());
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
//FETCH SQL7000
//INTO:SV-TN-IDCOLVALUE
//,:SV-TN-PROPVALCHAR
//,:SV-TN-PROPVALDATE
//,:SV-TN-PROPVALNUMBER
//,:SV-TN-DATESTART
//,:SV-TN-DATEEND
//,:SV-TN-ROWID
//,:SV-TN-ROWVERSION
public boolean execSqlStatement16() {
try {
loadResult("SQL7000");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return
false;
}
//FETCH SQL7000
//INTO:SV-TN-IDCOLVALUE
//,:SV-TN-PROPVALCHAR
//,:SV-TN-PROPVALDATE
//,:SV-TN-PROPVALNUMBER
//,:SV-TN-DATESTART
//,:SV-TN-DATEEND
//,:SV-TN-ROWID
//,:SV-TN-ROWVERSION
public boolean execSqlStatement17() {
try {
loadResult("SQL7000");
return true;
} catch(Exception e) {
e.printStackTrace();
}
return false;
}
}