Java Define类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Java›Java编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Java中org.skife.jdbi.v2.sqlobject.customizers.Define类的典型用法代码示例。如果您正苦于以下问题：Java Define类的具体用法？Java Define怎么用？Java Define使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

Define类属于org.skife.jdbi.v2.sqlobject.customizers包，在下文中一共展示了Define类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: FROM

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
@SqlQuery("SELECT *, RESULT.ID AS RESULT_ID, RESULT.ERRNO FROM (SELECT T.TASK_ID, MT.MONITOR_ID, M.NAME AS MONITOR_NAME, T.ACCOUNT_ID, T.NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, T.STATUS, T.CREATION_TIME, T.MODIFIED_TIME FROM SNM_TASK T " +
"LEFT JOIN SNM_MONITOR_TASK MT ON MT.TASK_ID = T.TASK_ID " +
"LEFT JOIN SNM_MONITOR M ON M.MONITOR_ID = MT.MONITOR_ID " +
"WHERE T.ACCOUNT_ID = :accountId AND T.STATUS <ne> :taskDeleteStatus GROUP BY T.TASK_ID, MONITOR_ID) AS TMP " +
"LEFT JOIN ( " +
        "SELECT R.ID, R.COLLECTED_TIME, R.MONITOR_ID, R.TASK_ID, R.ERRNO " +
        "FROM SNM_NIPING_RESULT AS R " +
        "INNER JOIN  " +
        "( " +
        "SELECT MAX(RES2.ID) AS ID " +
        "FROM SNM_NIPING_RESULT RES2 " +
        "INNER JOIN ( " +
        "SELECT MAX(COLLECTED_TIME) AS T1, MONITOR_ID, TASK_ID FROM SNM_NIPING_RESULT WHERE COLLECTED_TIME <ge> :lasthour AND TYPE = :type GROUP BY TASK_ID, MONITOR_ID " +
        ") AS RES1 " +
        "ON RES2.COLLECTED_TIME = RES1.T1 AND RES1.MONITOR_ID = RES2.MONITOR_ID AND RES1.TASK_ID = RES2.TASK_ID " +
        "GROUP BY RES2.COLLECTED_TIME, RES2.TASK_ID, RES2.MONITOR_ID\n" +
        ") AS RES3 " +
        "ON R.ID = RES3.ID "+
") AS RESULT ON TMP.MONITOR_ID = RESULT.MONITOR_ID AND TMP.TASK_ID = RESULT.TASK_ID " +
" ORDER BY TMP.CREATION_TIME DESC")
@RegisterMapper(TaskMapper.class)
List<Task> selectByAccountId(@Bind("accountId") String accountId, @Bind("taskDeleteStatus") int taskDeleteStatus, @Bind("lasthour") Date lasthour, @Bind("type") int type, @Define("ne") String notEqual, @Define("ge") String greaterThan);

开发者ID:CloudWise-OpenSource，项目名称:SAPNetworkMonitor，代码行数:23，代码来源:TaskDao.java

示例2: values

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
@SqlUpdate("delete from \"<schema>\".entry;" +
        "delete from \"<schema>\".entry_item;" +
        "delete from \"<schema>\".entry_system;" +
        "delete from \"<schema>\".entry_item_system;" +
        "delete from \"<schema>\".current_entry_number;" +
        "insert into \"<schema>\".current_entry_number values(0);")
void wipeData(@Define("schema") String schema);

开发者ID:openregister，项目名称:openregister-java，代码行数:8，代码来源:TestEntryDAO.java

示例3: T

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
/**
 * @param testcaseId
 * @return folder path of the testcase
 */
@SqlQuery("WITH RECURSIVE T(parent_folder_id, path) AS (" +
              "SELECT parent_folder_id, name AS path " +
              "FROM folder WHERE id = (SELECT parent_folder_id FROM testcase WHERE id = <testcaseId>) " +
              "UNION ALL " +
              "SELECT T2.parent_folder_id, (T2.name || '/' || T.path) AS path " +
              "FROM T INNER JOIN folder AS T2 ON T.parent_folder_id = T2.id " +
          ") SELECT path FROM T WHERE parent_folder_id IS NULL")
protected abstract String getFolderPath(@Define("testcaseId") long testcaseId);

开发者ID:zheng-wang，项目名称:irontest，代码行数:13，代码来源:TestcaseDAO.java

示例4: selectMonitors

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
@SqlQuery("SELECT SNM_MONITOR.MONITOR_ID, VERSION, ACCOUNT_ID, NAME, COUNTRY, PROVINCE, CITY, ISP, AREA, IP, NIPING_T, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_MONITOR INNER JOIN SNM_MONITOR_TASK " +
        " ON SNM_MONITOR.MONITOR_ID = SNM_MONITOR_TASK.MONITOR_ID" +
        " WHERE ACCOUNT_ID = :accountId AND TASK_ID = :taskId <condition>")
@RegisterMapper(MonitorMapper.class)
List<Monitor> selectMonitors(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Define("condition") String condition);

开发者ID:CloudWise-OpenSource，项目名称:SAPNetworkMonitor，代码行数:6，代码来源:MonitorDao.java

示例5: updateTaskStatus

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
@SqlUpdate("UPDATE SNM_TASK SET STATUS = :status, MODIFIED_TIME = :modifiedTime WHERE TASK_ID = :taskId AND ACCOUNT_ID = :accountId AND STATUS <ne> :deleteStatus")
void updateTaskStatus(@Bind("accountId") String accountId, @Bind("taskId") String taskId, @Bind("status") int status,  @Bind("deleteStatus") int deleteStatus, @Bind("modifiedTime") Date modifiedTime, @Define("ne") String notEqual) ;

开发者ID:CloudWise-OpenSource，项目名称:SAPNetworkMonitor，代码行数:3，代码来源:TaskDao.java

示例6: IN

import org.skife.jdbi.v2.sqlobject.customizers.Define; //导入依赖的package包/类
@SqlQuery("SELECT SNM_TASK.TASK_ID, MONITOR_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK INNER JOIN SNM_MONITOR_TASK ON SNM_MONITOR_TASK.TASK_ID = SNM_TASK.TASK_ID " +
        " WHERE SNM_MONITOR_TASK.MONITOR_ID = :monitorId AND SNM_MONITOR_TASK.TASK_ID NOT IN (<runningTaskIds>) AND STATUS = :taskEnableStatus AND REDISPATCHER <ne> :redispatcher")
@MaxRows(1)
@RegisterMapper(TaskMapper.class)
Task getNextStartTask(@Bind("monitorId") String monitorId, @BindIn("runningTaskIds") List<String> runningTaskIds, @Bind("taskEnableStatus") int taskEnableStatus, @Define("ne") String notEqual, @Bind("redispatcher") int redispatcher) ;

开发者ID:CloudWise-OpenSource，项目名称:SAPNetworkMonitor，代码行数:6，代码来源:TaskDao.java