當前位置: 首頁>>代碼示例>>Java>>正文

Java MapResultAsBean類代碼示例

本文整理匯總了Java中org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean類的典型用法代碼示例。如果您正苦於以下問題：Java MapResultAsBean類的具體用法？Java MapResultAsBean怎麽用？Java MapResultAsBean使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。


MapResultAsBean類屬於org.skife.jdbi.v2.sqlobject.helpers包，在下文中一共展示了MapResultAsBean類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: findAllWithAccesses

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.contentid AS contentid, c.size AS size, " +
        "c.url AS url, c.path AS path, c.cachedate AS cachedate, " +
        "c.downloaded AS downloaded, c.prefetched AS prefetched, " +
        "c.vimeoprefetched AS prefetchedvimeo, co.timestamp AS timestamp " +
        "FROM content c " +
        "LEFT JOIN contentaccess co " +
        "ON co.contentid = c.contentid")
@MapResultAsBean
public abstract List<ContentDAO.ContentAccessJoinRow> findAllWithAccesses();
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:10，代碼來源:AbstractContentDAO.java

示例2: findAllCostSegmentsByLinkD

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.TYPE as type, c.SUBTYPE as subtype, c.INPUTUNIT as inputUnit, "
		+ "c.OUTPUTUNIT as outputUnit, LEFTBORDER as leftBorder, seg.RIGHTBORDER as rightBorder, "
		+ "seg.A as a, seg.B as b, c.LOCALLINKID as linkID, c.LOCALISPNAME as ispName "
		+ "FROM COSTFUNCTION c "
		+ "LEFT JOIN SEGMENT seg "
		+ "ON (c.LOCALLINKID = seg.LOCALLINKID AND c.LOCALISPNAME = seg.LOCALISPNAME) "
		+ "WHERE c.LOCALLINKID = :localLinkID AND c.LOCALISPNAME = :localIspName")
@MapResultAsBean
public abstract List<CostFunctionSegmentJoinRow> findAllCostSegmentsByLinkD(@BindBean SimpleLinkID linkID);
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:10，代碼來源:AbstractCostFunctionDAO.java

示例3: findAll

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.TYPE as type, c.SUBTYPE as subtype, c.INPUTUNIT as inputUnit, "
		+ "c.OUTPUTUNIT as outputUnit, LEFTBORDER as leftBorder, seg.RIGHTBORDER as rightBorder, "
		+ "seg.A as a, seg.B as b, c.LOCALLINKID as linkID, c.LOCALISPNAME as ispName "
		+ "FROM COSTFUNCTION c "
		+ "LEFT JOIN SEGMENT seg "
		+ "ON (c.LOCALLINKID = seg.LOCALLINKID AND c.LOCALISPNAME = seg.LOCALISPNAME) ")
@MapResultAsBean
public abstract List<CostFunctionSegmentJoinRow> findAll();
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:9，代碼來源:AbstractCostFunctionDAO.java

示例4: findAll

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.CLOUDDCNAME AS cloudName, c.ASNUMBER AS asNumber, "
		+ "c.DAROUTERADDRESS AS daRouterAddress, c.SDNADDRESS AS sdnAddress, "
		+ "p.PREFIX AS prefix, p.PREFIXLENGTH AS prefixLength, a.SBOXADDRPREFIX AS sboxAddress "
		+ "FROM CLOUDDC c "
		+ "LEFT JOIN SDNCONTROLLER s ON c.SDNADDRESS = s.ADDRESS "
		+ "LEFT JOIN DAROUTER d ON c.DAROUTERADDRESS = d.ADDRESS "
		+ "LEFT JOIN PREFIXES p ON c.CLOUDDCNAME = p.CLOUDDCNAME "
		+ "JOIN ASYSTEM a ON a.ASNUMBER=c.ASNUMBER")
@MapResultAsBean
public abstract List<CloudPrefixJoinRow> findAll();
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:11，代碼來源:AbstractCloudDCDAO.java

示例5: findLocalClouds

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.CLOUDDCNAME AS cloudName, c.ASNUMBER AS asNumber, "
		+ "c.DAROUTERADDRESS AS daRouterAddress, c.SDNADDRESS AS sdnAddress, "
		+ "p.PREFIX AS prefix, p.PREFIXLENGTH AS prefixLength, a.SBOXADDRPREFIX AS sboxAddress "
		+ "FROM CLOUDDC c "
		+ "LEFT JOIN SDNCONTROLLER s ON c.SDNADDRESS = s.ADDRESS "
		+ "LEFT JOIN DAROUTER d ON c.DAROUTERADDRESS = d.ADDRESS "
		+ "LEFT JOIN PREFIXES p ON c.CLOUDDCNAME = p.CLOUDDCNAME "
		+ "JOIN ASYSTEM a ON a.ASNUMBER=c.ASNUMBER "
		+ "WHERE a.LOCAL = 1")
@MapResultAsBean
public abstract List<CloudPrefixJoinRow> findLocalClouds();
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:12，代碼來源:AbstractCloudDCDAO.java

示例6: findRemoteClouds

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.CLOUDDCNAME AS cloudName, c.ASNUMBER AS asNumber, "
		+ "c.DAROUTERADDRESS AS daRouterAddress, c.SDNADDRESS AS sdnAddress, "
		+ "p.PREFIX AS prefix, p.PREFIXLENGTH AS prefixLength, a.SBOXADDRPREFIX AS sboxAddress "
		+ "FROM CLOUDDC c "
		+ "LEFT JOIN SDNCONTROLLER s ON c.SDNADDRESS = s.ADDRESS "
		+ "LEFT JOIN DAROUTER d ON c.DAROUTERADDRESS = d.ADDRESS "
		+ "LEFT JOIN PREFIXES p ON c.CLOUDDCNAME = p.CLOUDDCNAME "
		+ "JOIN ASYSTEM a ON a.ASNUMBER=c.ASNUMBER "
		+ "WHERE a.LOCAL = 0")
@MapResultAsBean
public abstract List<CloudPrefixJoinRow> findRemoteClouds();
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:12，代碼來源:AbstractCloudDCDAO.java

示例7: findById

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.CLOUDDCNAME AS cloudName, c.ASNUMBER AS asNumber, "
		+ "c.DAROUTERADDRESS AS daRouterAddress, c.SDNADDRESS AS sdnAddress, "
		+ "p.PREFIX AS prefix, p.PREFIXLENGTH as prefixLength, a.SBOXADDRPREFIX AS sboxAddress "
		+ "FROM CLOUDDC c "
		+ "LEFT JOIN SDNCONTROLLER s ON c.SDNADDRESS = s.ADDRESS "
		+ "LEFT JOIN DAROUTER d ON c.DAROUTERADDRESS = d.ADDRESS "
		+ "LEFT JOIN PREFIXES p ON c.CLOUDDCNAME = p.CLOUDDCNAME "
		+ "JOIN ASYSTEM a ON a.ASNUMBER=c.ASNUMBER "
		+ "WHERE c.CLOUDDCNAME = :name ")
@MapResultAsBean
public abstract List<CloudPrefixJoinRow> findById(@Bind("name") String name);
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:12，代碼來源:AbstractCloudDCDAO.java

示例8: findByASNumber

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT c.CLOUDDCNAME AS cloudName, c.ASNUMBER AS asNumber, "
		+ "c.DAROUTERADDRESS AS daRouterAddress, c.SDNADDRESS AS sdnAddress, "
		+ "p.PREFIX AS prefix, p.PREFIXLENGTH as prefixLength, a.SBOXADDRPREFIX AS sboxAddress "
		+ "FROM CLOUDDC c "
		+ "LEFT JOIN SDNCONTROLLER s ON c.SDNADDRESS = s.ADDRESS "
		+ "LEFT JOIN DAROUTER d ON c.DAROUTERADDRESS = d.ADDRESS "
		+ "LEFT JOIN PREFIXES p ON c.CLOUDDCNAME = p.CLOUDDCNAME "
		+ "JOIN ASYSTEM a ON a.ASNUMBER=c.ASNUMBER "
		+ "WHERE c.ASNUMBER=:asNumber")
@MapResultAsBean
public abstract List<CloudPrefixJoinRow> findByASNumber(@Bind("asNumber") int asNumber);
開發者ID:smartenit-eu，項目名稱:smartenit，代碼行數:12，代碼來源:AbstractCloudDCDAO.java

示例9: listSubjects

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery(SELECT_SUBJECT + "order by subject_parent_id asc")
@MapResultAsBean
List<PandasSubject> listSubjects();
開發者ID:nla，項目名稱:bamboo，代碼行數:4，代碼來源:PandasDAO.java

示例10: listCollections

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("select COL_ID id, DISPLAY_COMMENT displayComment, DISPLAY_ORDER displayOrder, IS_DISPLAYED displayed, NAME name, COL_PARENT_ID parentId from COL")
@MapResultAsBean
List<PandasCollection> listCollections();
開發者ID:nla，項目名稱:bamboo，代碼行數:4，代碼來源:PandasDAO.java

示例11: listAgencies

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("select AGENCY_ID id, NAME name, LOGO logo, ORGANISATION.NAME name, ORGANISATION.URL url from agency left join organisation on ORGANISATION.ORGANISATION_ID = AGENCY.ORGANISATION_ID")
@MapResultAsBean
List<PandasAgency> listAgencies();
開發者ID:nla，項目名稱:bamboo，代碼行數:4，代碼來源:PandasDAO.java

示例12: findEnabledUsersWithRolesAndPermissions

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery(EnabledUserRolesPermissionsBaseSelectPrefix + "users.username = :username")
@MapResultAsBean
@Transaction(value = TransactionIsolationLevel.READ_COMMITTED)
protected abstract Iterator<UserRolePermissionJoinRow> findEnabledUsersWithRolesAndPermissions(@Bind("username") String username);
開發者ID:Multifarious，項目名稱:shiro-jdbi-realm，代碼行數:5，代碼來源:DefaultJdbiUserSecurityDAO.java

示例13: findUsersWithRolesAndPermissions

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery(UserRolesPermissionsBaseSelectPrefix + "users.username = :username")
@MapResultAsBean
@Transaction(value = TransactionIsolationLevel.READ_COMMITTED)
protected abstract Iterator<UserRolePermissionJoinRow> findUsersWithRolesAndPermissions(@Bind("username") String username);
開發者ID:Multifarious，項目名稱:shiro-jdbi-realm，代碼行數:5，代碼來源:DefaultJdbiUserSecurityDAO.java

示例14: findEnabledUsersWithoutRoles

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT user_Id AS id, username, password FROM users WHERE enabled AND username = :username")
@MapResultAsBean
@Transaction(value = TransactionIsolationLevel.READ_COMMITTED)
protected abstract Iterator<DefaultUserImpl> findEnabledUsersWithoutRoles(@Bind("username") String username);
開發者ID:Multifarious，項目名稱:shiro-jdbi-realm，代碼行數:5，代碼來源:DefaultJdbiUserSecurityDAO.java

示例15: findUsersWithoutRoles

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //導入依賴的package包/類
@SqlQuery("SELECT user_Id AS id, username, password FROM users WHERE username = :username")
@MapResultAsBean
@Transaction(value = TransactionIsolationLevel.READ_COMMITTED)
protected abstract Iterator<DefaultUserImpl> findUsersWithoutRoles(@Bind("username") String username);
開發者ID:Multifarious，項目名稱:shiro-jdbi-realm，代碼行數:5，代碼來源:DefaultJdbiUserSecurityDAO.java


注：本文中的org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。