Java MapResultAsBean类代码示例

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();
 

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);
 

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();
 

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();
 

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();
 

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();
 

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);
 

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);
 

import org.skife.jdbi.v2.sqlobject.helpers.MapResultAsBean; //导入依赖的package包/类
@SqlQuery(SELECT_SUBJECT + "order by subject_parent_id asc")
@MapResultAsBean
List<PandasSubject> listSubjects();
 

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();
 

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();
 

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);
 

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);
 

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);
 

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);