Example #1
0
 @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();
 }
Example #2
0
  public List<HashMap> queryclobfiles() throws Exception {

    return SQLExecutor.queryList(HashMap.class, "select FILENAME,fileid,FILESIZE from CLOBFILE");
  }