public void bind(VariableTable vt) throws java.sql.SQLException {
int rows;
Object val;
try {
stmt.clearParameters();
} catch (java.sql.SQLException sqle) {
}
if (paramNames.length > 0) {
for (rows = 0; rows < paramNames.length; rows++) {
val = vt.getValue(paramNames[rows]);
if (paramTypes[rows].equals("IN")) {
if (val == null) stmt.setNull(rows + 1, 1);
else {
if (vt.getType(paramNames[rows]) != java.sql.Types.LONGVARCHAR
&& vt.getType(paramNames[rows]) != java.sql.Types.LONGVARBINARY)
stmt.setObject(rows + 1, val);
else if (vt.getType(paramNames[rows]) == java.sql.Types.LONGVARCHAR) {
java.io.StringReader long_var = new java.io.StringReader(val.toString());
stmt.setCharacterStream(rows + 1, long_var, 16384);
// long_var.close();
} else if (vt.getType(paramNames[rows]) == java.sql.Types.LONGVARBINARY) {
java.io.File os_file = new java.io.File(val.toString());
if (os_file.exists() && os_file.isFile() && os_file.canRead()) {
try {
java.io.FileInputStream long_var = new java.io.FileInputStream(os_file);
stmt.setBinaryStream(rows + 1, long_var, 16384);
// long_var.close();
} catch (java.io.IOException ioe) {
}
} else stmt.setNull(rows + 1, 1);
}
}
} else if (paramTypes[rows].equals("OUT")) {
stmt.registerOutParameter(rows + 1, vt.getType(paramNames[rows]));
} else if (paramTypes[rows].equals("INOUT")) {
if (val == null) stmt.setNull(rows + 1, 1);
else {
if (vt.getType(paramNames[rows]) != java.sql.Types.LONGVARCHAR
&& vt.getType(paramNames[rows]) != java.sql.Types.LONGVARBINARY)
stmt.setObject(rows + 1, val);
else if (vt.getType(paramNames[rows]) != java.sql.Types.LONGVARCHAR) {
java.io.StringReader long_var = new java.io.StringReader(val.toString());
stmt.setCharacterStream(rows + 1, long_var, 16384);
// long_var.close();
} else if (vt.getType(paramNames[rows]) != java.sql.Types.LONGVARBINARY) {
java.io.File os_file = new java.io.File(val.toString());
if (os_file.exists() && os_file.isFile() && os_file.canRead()) {
try {
java.io.FileInputStream long_var = new java.io.FileInputStream(os_file);
stmt.setBinaryStream(rows + 1, long_var, 16384);
// long_var.close();
} catch (java.io.IOException ioe) {
}
} else stmt.setNull(rows + 1, 1);
}
}
stmt.registerOutParameter(rows + 1, vt.getType(paramNames[rows]));
}
}
}
}
