@Test
public void testNewOrMappingsQuery() throws Exception {
// SQLParams params = new SQLParams();
// params.addSQLParam("id", "1", SQLParams.STRING);
// //
// ID,HOST_ID,PLUGIN_ID,CATEGORY_ID,NAME,DESCRIPTION,DATASOURCE_NAME,DRIVER,JDBC_URL,USERNAME,PASSWORD,VALIDATION_QUERY
// params.addSQLParam("blobname", "abcdblob",
// SQLParams.BLOB);
// params.addSQLParam("clobname", "abcdclob",
// SQLParams.CLOB);
List<LobBean> bean = SQLExecutor.queryList(LobBean.class, "select * from test");
System.out.println();
}
public List<HashMap> queryclobfiles() throws Exception {
return SQLExecutor.queryList(HashMap.class, "select FILENAME,fileid,FILESIZE from CLOBFILE");
}