Java BindBean类代码示例

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

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

示例1: update

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("update into image set"
		+ "imageId=:imageId, "
		+ "name=:name, "
		+ "location=:location, "
		+ "enumCountryId=:enumCountryId, "
		+ "enumRatingId=:enumRatingId, "
		+ "exposure=:exposure, "
		+ "settings=:settings, "
		+ "tools=:tools, "
		+ "metaDate=:metaDate, "
		+ "description=:description, "
		+ "enumStatusId=:enumStatusId, "
		+ "cUser=:cUser, "
		+ "cDate=:cDate, "
		+ "URI=:URI "
		+ " where imageId = :imageId")
void update(@BindBean ImageBean bean);

开发者ID:yoonghan，项目名称:selfservicedb，代码行数:18，代码来源:ImageJDBI.java

示例2: update

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("update tool set "
        + "url = :url, "
        + "verified = :verified, "
        + "verifiedSource = :verifiedSource, "
        + "metaVersion = :metaVersion, "
        + "where tool_id = :id and version = :version")
int update(@BindBean ToolVersion t);

开发者ID:dockstore，项目名称:write_api_service，代码行数:8，代码来源:ToolVersionDAO.java

示例3: update

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("update tool set url = :url,"
        + "organization = :organization,"
        + "toolname = :toolname,"
        + "description = :description,"
        + "author = :author,"
        + "verified = :verified,"
        + "verifiedSource = :verifiedSource,"
        + "metaVersion = :metaVersion,"
        + "signed = :signed"
        + " where tool_id = :id")
int update(@BindBean Tool t);

开发者ID:dockstore，项目名称:write_api_service，代码行数:12，代码来源:ToolDAO.java

示例4: current_timestamp

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlBatch("insert into repositories " +
        "(id, owner_id, name, full_name, description, fork, homepage, stargazers_count, language, created_at, updated_at, fetched_at) " +
        "values (:id, :ownerId, :name, :fullName, :description, :fork, :homepage, :stargazersCount, :language, current_timestamp(), current_timestamp(), current_timestamp()) " +
        "on duplicate key update " +
        "owner_id=values(owner_id), name=values(name), full_name=values(full_name), description=values(description), homepage=values(homepage), stargazers_count=values(stargazers_count), language=values(language), updated_at=values(updated_at), fetched_at=values(fetched_at)")
@BatchChunkSize(100)
void bulkInsert(@BindBean List<Repository> repos);

开发者ID:k0kubun，项目名称:gitstar-ranking，代码行数:8，代码来源:RepositoryDao.java

示例5: FLOOR

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlQuery("SELECT "
        + "  FLOOR(SUM(numberpoints * (ST_Area(ST_Intersection(geom, qgeom)) /ST_Area(geom)))) AS numpoints "
        + "FROM "
        + "  extent_raw, "
        + "  (SELECT ST_SetSRID(ST_MakeBox2D(ST_Point(:b.left, :b.bottom),ST_Point(:b.right, :b.top)), :srid) AS qgeom) AS B "
        + "WHERE geom && qgeom "
        + "AND ST_Area(geom) != 0")
long getNumberOfPoints(@BindBean("b") Selection bbox,
                       @Bind("srid") int srid);

开发者ID:NLeSC，项目名称:ahn-pointcloud-viewer-ws，代码行数:10，代码来源:RawExtentsDOA.java

示例6: FLOOR

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlQuery("SELECT "
        + "  FLOOR(SUM(numberpoints * (ST_Area(ST_Intersection(geom, qgeom)) /ST_Area(geom)))) AS numpoints "
        + "FROM "
        + "  extent_potree, "
        + "  (SELECT ST_SetSRID(ST_MakeBox2D(ST_Point(:b.left, :b.bottom),ST_Point(:b.right, :b.top)), :srid) AS qgeom) AS B "
        + "WHERE level = :level "
        + "AND geom && qgeom "
        + "AND ST_Area(geom) != 0")
long getNumberOfPoints(@Bind("level") int level,
                       @BindBean("b") Selection bbox,
                       @Bind("srid") int srid);

开发者ID:NLeSC，项目名称:ahn-pointcloud-viewer-ws，代码行数:12，代码来源:PotreeExtentsDOA.java

示例7: findById

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlQuery("SELECT COMMUNICATIONNUMBER, COMMUNICATIONSYMBOL, "
		+ "TRAFFICDIRECTION, REMOTECLOUDNAME, REMOTEASNUMBER, " 
		+ "LOCALCLOUDNAME, LOCALASNUMBER "
		+ "FROM DC2DCCOMMUNICATION "
		+ "WHERE COMMUNICATIONNUMBER = :d.communicationNumber AND "
		+ "COMMUNICATIONSYMBOL = :d.communicationSymbol AND "
		+ "LOCALCLOUDNAME = :d.localCloudDCName AND "
		+ "LOCALASNUMBER = :d.localAsNumber AND "
		+ "REMOTECLOUDNAME = :d.remoteCloudDCName AND "
		+ "REMOTEASNUMBER = :d.remoteAsNumber")
@Mapper(DC2DCCommunicationMapper.class)
public abstract DC2DCCommunication findById(@BindBean("d") DC2DCCommunicationID dcID);

开发者ID:smartenit-eu，项目名称:smartenit，代码行数:13，代码来源:AbstractDC2DCCommunicationDAO.java

示例8: deleteById

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("DELETE FROM DC2DCCOMMUNICATION "
		+ "WHERE COMMUNICATIONNUMBER = :d.communicationNumber AND "
		+ "COMMUNICATIONSYMBOL = :d.communicationSymbol AND "
		+ "LOCALCLOUDNAME = :d.localCloudDCName AND "
		+ "LOCALASNUMBER = :d.localAsNumber AND "
		+ "REMOTECLOUDNAME = :d.remoteCloudDCName AND "
		+ "REMOTEASNUMBER = :d.remoteAsNumber")
public abstract void deleteById(@BindBean("d") DC2DCCommunicationID dcID);

开发者ID:smartenit-eu，项目名称:smartenit，代码行数:9，代码来源:AbstractDC2DCCommunicationDAO.java

示例9: findAllByLinkID

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlQuery("SELECT TUNNELNAME, LOCALTUNNELENDADDRESS, REMOTETUNNELENDADDRESS, "
           + "PHYSICALLOCALINTERFACENAME, INBOUNDINTERFACECOUNTEROID, "
           + "OUTBOUNDINTERFACECOUNTEROID, LOCALLINKID, LOCALISPNAME, OFSWITCHPORTNUMBER, "
           + "LOCALROUTERADDRESS "
           + "FROM TUNNEL WHERE LOCALLINKID = :localLinkID AND LOCALISPNAME = :localIspName")
@Mapper(TunnelMapper.class)
public abstract List<Tunnel> findAllByLinkID(@BindBean SimpleLinkID linkID);

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

示例10: findAllByDC2DCCommunicationID

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlQuery("SELECT TUNNELNAME, LOCALTUNNELENDADDRESS, REMOTETUNNELENDADDRESS, "
           + "PHYSICALLOCALINTERFACENAME, INBOUNDINTERFACECOUNTEROID, "
           + "OUTBOUNDINTERFACECOUNTEROID, LOCALLINKID, LOCALISPNAME, OFSWITCHPORTNUMBER, LOCALROUTERADDRESS "
		+ "FROM TUNNEL WHERE COMMUNICATIONNUMBER = :d.communicationNumber AND "
		+ "COMMUNICATIONSYMBOL = :d.communicationSymbol AND "
		+ "LOCALCLOUDNAME = :d.localCloudDCName AND "
		+ "LOCALASNUMBER = :d.localAsNumber AND "
		+ "REMOTECLOUDNAME = :d.remoteCloudDCName AND "
		+ "REMOTEASNUMBER = :d.remoteAsNumber")
@Mapper(TunnelMapper.class)
public abstract List<Tunnel> findAllByDC2DCCommunicationID(@BindBean("d") DC2DCCommunicationID dcID);

开发者ID:smartenit-eu，项目名称:smartenit，代码行数:12，代码来源:AbstractTunnelDAO.java

示例11: deleteByDC2DCCommunicationID

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("DELETE FROM TUNNEL WHERE COMMUNICATIONNUMBER = :d.communicationNumber AND "
		+ "COMMUNICATIONSYMBOL = :d.communicationSymbol AND "
		+ "LOCALCLOUDNAME = :d.localCloudDCName AND "
		+ "LOCALASNUMBER = :d.localAsNumber AND "
		+ "REMOTECLOUDNAME = :d.remoteCloudDCName AND "
		+ "REMOTEASNUMBER = :d.remoteAsNumber")
public abstract void deleteByDC2DCCommunicationID(@BindBean("d") DC2DCCommunicationID dcID);

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

示例12: updateByDC2DCCommunicationID

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("UPDATE TUNNEL SET COMMUNICATIONNUMBER = :d.communicationNumber, "
		+ "COMMUNICATIONSYMBOL = :d.communicationSymbol, "
		+ "LOCALCLOUDNAME = :d.localCloudDCName, "
		+ "LOCALASNUMBER = :d.localAsNumber, "
		+ "REMOTECLOUDNAME = :d.remoteCloudDCName, "
		+ "REMOTEASNUMBER = :d.remoteAsNumber "
           + "WHERE TUNNELNAME = :t.tunnelName AND LOCALTUNNELENDADDRESS = :t.localTunnelEndAddress "
           + "AND REMOTETUNNELENDADDRESS = :t.remoteTunnelEndAddress")
public abstract void updateByDC2DCCommunicationID(@BindEndAddressPairTunnelID("t") EndAddressPairTunnelID tunnelID,
		@BindBean("d") DC2DCCommunicationID dcID);

开发者ID:smartenit-eu，项目名称:smartenit，代码行数:11，代码来源:AbstractTunnelDAO.java

示例13: findAllCostSegmentsByLinkD

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的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

示例14: insertBatchByLinkId

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlBatch("INSERT INTO SEGMENT "
		+ "(LOCALLINKID, LOCALISPNAME, LEFTBORDER, RIGHTBORDER, A, B) "
		+ "VALUES (:l.localLinkID, :l.localIspName, "
		+ ":costFunctionID , :s.leftBorder, :s.rightBorder, :s.a, :s.b)")
@BatchChunkSize(1000)
public abstract void insertBatchByLinkId(@BindBean("s") List<Segment> slist, 
		@BindBean("l") SimpleLinkID linkID);

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

示例15: insert

import org.skife.jdbi.v2.sqlobject.BindBean; //导入依赖的package包/类
@SqlUpdate("INSERT INTO TimeScheduleParameters "
		+ "(startDate, accountingPeriod , reportingPeriod, tol1, tol2, "
		+ "samplingPeriod, reportPeriodEA, reportPeriodDTM, compensationPeriod) "
		+ "VALUES (:startDate, :accountingPeriod, :reportingPeriod, :tol1, :tol2, "
		+ ":samplingPeriod, :reportPeriodEA, :reportPeriodDTM, :compensationPeriod)")
@GetGeneratedKeys
public abstract long insert(@BindBean TimeScheduleParameters tsp);

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

注：本文中的org.skife.jdbi.v2.sqlobject.BindBean类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。