@Select("SELECT m.id, m.name, m.series_id, " + "s.id series_id, s.name series_name, s.brand_id series_brand_id, " + "b.id brand_id, b.name brand_name " + "FROM models m " + "INNER JOIN series s ON s.id = m.series_id " + "INNER JOIN brands b ON b.id = s.brand_id " + "WHERE m.id = #{id}") @ResultMap("modelObj") public Model getObj(long id);
@Select({ "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName", "FROM Person", "WHERE id = #{id,jdbcType=INTEGER}" }) @ResultMap("personMapComplex") public Person getWithComplex2(Long id);
@Select({ "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName", "FROM Person", "WHERE id = #{id,jdbcType=INTEGER}" }) @ResultMap("org.apache.ibatis.submitted.complex_column.PersonMapper.personMapComplex") public Person getWithComplex3(Long id);
@Select({ "select id, animal_name, brain_weight, body_weight", "from AnimalData", "${whereClause}" }) @ResultMap("AnimalDataResult") List<AnimalData> selectByExample(WhereClauseProvider whereClause);
@Select({ "select a.id, a.animal_name, a.brain_weight, a.body_weight", "from AnimalData a", "${whereClause}" }) @ResultMap("AnimalDataResult") List<AnimalData> selectByExampleWithAlias(WhereClauseProvider whereClause);
@Select({ "select id, animal_name, brain_weight, body_weight", "from AnimalData", "${whereClauseProvider.whereClause}", "order by id", "OFFSET #{offset,jdbcType=INTEGER} LIMIT #{limit,jdbcType=INTEGER}" }) @ResultMap("AnimalDataResult") List<AnimalData> selectByExampleWithLimitAndOffset(@Param("whereClauseProvider") WhereClauseProvider whereClause, @Param("limit") int limit, @Param("offset") int offset);
@Select({ "select b.id, b.animal_name, b.brain_weight, b.body_weight", "from AnimalData b", "${whereClauseProvider.whereClause}", "order by id", "OFFSET #{offset,jdbcType=INTEGER} LIMIT #{limit,jdbcType=INTEGER}" }) @ResultMap("AnimalDataResult") List<AnimalData> selectByExampleWithAliasLimitAndOffset(@Param("whereClauseProvider") WhereClauseProvider whereClause, @Param("limit") int limit, @Param("offset") int offset);
@Select({ "select", "id, openid", "from t_b_account", "where id = #{id,jdbcType=CHAR}" }) @ResultMap("ResultMapWithBLOBs") User selectByPrimaryKey(String id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_campaigns_leads * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, campaignId, leadId, createdTime", "from m_crm_campaigns_leads", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CampaignLeadMapper.BaseResultMap") CampaignLead selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_campaigns_accounts * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, campaignId, accountId, createdTime", "from m_crm_campaigns_accounts", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CampaignAccountMapper.BaseResultMap") CampaignAccount selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_campaigns_contacts * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, campaignId, contactId, createdTime", "from m_crm_campaigns_contacts", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CampaignContactMapper.BaseResultMap") CampaignContact selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_opportunity * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, opportunityName, currencyid, accountid, amount, type, source, expectedClosedDate, ", "campaignid, nextStep, probability, createdTime, createdUser, sAccountId, assignUser, ", "opportunityType, salesStage, lastUpdatedTime, avatarId, description", "from m_crm_opportunity", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.OpportunityMapper.ResultMapWithBLOBs") Opportunity selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_account * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, accountName, website, phoneOffice, fax, alternatePhone, annualRevenue, billingAddress, ", "city, postalCode, state, email, ownership, shippingAddress, shippingCity, shippingPostalCode, ", "shippingState, numemployees, createdTime, createdUser, sAccountId, assignUser, ", "type, industry, lastUpdatedTime, billingCountry, shippingCountry, avatarId, ", "description", "from m_crm_account", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.AccountMapper.ResultMapWithBLOBs") Account selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_campaign * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, campaignName, startDate, endDate, currencyId, budget, actualCost, expectedRevenue, ", "expectedCost, impression, createdTime, createdUser, sAccountId, status, type, ", "assignUser, lastUpdatedTime, avatarId, impressionnote, objective, description", "from m_crm_campaign", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CampaignMapper.ResultMapWithBLOBs") CampaignWithBLOBs selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_contacts_leads * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, contactId, leadId, isConvertRel", "from m_crm_contacts_leads", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ContactLeadMapper.BaseResultMap") ContactLead selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_meeting_invitees * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, meetingId, username, isModerator, status, source", "from m_crm_meeting_invitees", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.MeetingInviteeMapper.BaseResultMap") MeetingInvitee selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_customer * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, firstname, lastname, leadsource, assignUser, department, officePhone, mobile, ", "homePhone, assisstant, assisstantPhone, birthday, createdTime, createdUser, ", "sAccountId, lastUpdatedTime, title", "from m_crm_customer", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CustomerMapper.BaseResultMap") Customer selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_target * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, prefixname, firstname, lastname, title, department, birthday, accountname, ", "isCallable, officePhone, mobile, homePhone, otherPhone, fax, assistant, assistantPhone, ", "primaryAddress, primaryCity, primaryState, primaryPostal, primaryCountryId, ", "description, email, createdTime, createdUser, sAccountId, assignUser, lastUpdatedTime", "from m_crm_target", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.TargetMapper.BaseResultMap") Target selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_quote * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, subject, quotestage, opportunityid, validuntil, shipping, billaccount, billcontact, ", "shipaccount, shipcontact, billingaddress, billingcity, billingstate, billingpostalcode, ", "billingcountry, shippingaddress, shippingcity, shippingstate, shippingpostalcode, ", "shippingcountry, description, paymentterm, originalpodate, purchaseordernum, ", "createdTime, createdUser, sAccountId, assignUser, lastUpdatedTime", "from m_crm_quote", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.QuoteMapper.BaseResultMap") Quote selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_notifications * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, username, sAccountId, level", "from m_crm_notifications", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CrmNotificationSettingMapper.BaseResultMap") CrmNotificationSetting selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_call * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, subject, startDate, durationInSeconds, calltype, type, typeid, lastUpdatedTime, ", "createdTime, createdUser, assignUser, contactId, sAccountId, status, purpose, ", "isClosed, description, result", "from m_crm_call", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CallMapper.ResultMapWithBLOBs") CallWithBLOBs selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_contacts_opportunities * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, contactId, opportunityId, createdTime, decisionRole", "from m_crm_contacts_opportunities", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ContactOpportunityMapper.BaseResultMap") ContactOpportunity selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_contract * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, contractname, status, code, accountid, opportunityid, currencyid, customersigneddate, ", "companysigneddate, type, description, startdate, enddate, contractvalue, createdTime, ", "createdUser, sAccountId, assignUser, lastUpdatedTime", "from m_crm_contract", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ContractMapper.BaseResultMap") Contract selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_meeting * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, subject, status, type, typeid, startDate, endDate, lastUpdatedTime, createdTime, ", "createdUser, sAccountId, location, isRecurrence, recurrenceType, recurrenceStartDate, ", "recurrenceEndDate, contactType, contactTypeId, isClosed, isNotified, isNotifiedPrior, ", "description, recurrenceInfo", "from m_crm_meeting", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.MeetingMapper.ResultMapWithBLOBs") MeetingWithBLOBs selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_target_list * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, name, type, description, createdTime, createdUser, sAccountId, assignUser, ", "lastUpdatedTime", "from m_crm_target_list", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.TargetGroupMapper.BaseResultMap") TargetGroup selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_product_catalog * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, url, taxclass, mft_partnumber, vendor_partnumber, currencyid, cost, listprice, ", "discountprice, pricing_formula, description, date_available, availability, quantity_in_stock, ", "support_name, support_contact, support_desc, support_term, productname, sAccountId, ", "createdTime, lastUpdatedTime", "from m_crm_product_catalog", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ProductCatalogMapper.BaseResultMap") ProductCatalog selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_contacts_cases * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, contactId, caseId, createdTime", "from m_crm_contacts_cases", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ContactCaseMapper.BaseResultMap") ContactCase selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_opportunities_leads * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, opportunityId, leadId, createdTime, isConvertRel", "from m_crm_opportunities_leads", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.OpportunityLeadMapper.BaseResultMap") OpportunityLead selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_accounts_leads * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, accountId, leadId, createTime, isConvertRel", "from m_crm_accounts_leads", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.AccountLeadMapper.BaseResultMap") AccountLead selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_case * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, priority, status, type, subject, accountId, createdTime, createdUser, sAccountId, ", "assignUser, lastUpdatedTime, reason, origin, email, phonenumber, description, ", "resolution", "from m_crm_case", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CaseMapper.ResultMapWithBLOBs") CaseWithBLOBs selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_contact * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, prefix, firstname, lastname, leadSource, campaignId, isCallable, officePhone, ", "mobile, homePhone, otherPhone, fax, birthday, assistant, primAddress, primCity, ", "primState, primPostalCode, primCountry, title, assistantPhone, email, department, ", "createdTime, createdUser, sAccountId, assignUser, otherAddress, otherCity, otherState, ", "otherPostalCode, otherCountry, lastUpdatedTime, accountId, avatarId, description", "from m_crm_contact", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ContactMapper.ResultMapWithBLOBs") Contact selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_lead * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, campaignId, leadSourceDesc, statusDesc, referredBy, prefixName, firstname, ", "lastname, accountName, title, department, isCallable, officePhone, homePhone, ", "mobile, otherPhone, fax, primAddress, primState, primCity, primPostalCode, primCountry, ", "email, createdTime, createdUser, sAccountId, assignUser, status, source, website, ", "otherAddress, otherState, otherCity, otherPostalCode, otherCountry, industry, ", "lastUpdatedTime, noEmployees, avatarId, description", "from m_crm_lead", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.LeadMapper.ResultMapWithBLOBs") Lead selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_task * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, subject, startdate, duedate, contactId, typeid, createdTime, createdUser, ", "sAccountId, status, assignUser, priority, type, lastUpdatedTime, isClosed, description", "from m_crm_task", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.CrmTaskMapper.ResultMapWithBLOBs") CrmTask selectByPrimaryKey(Integer id);
/** * This method was generated by MyBatis Generator. * This method corresponds to the database table m_crm_product * * @mbg.generated Sat Oct 21 18:03:12 ICT 2017 */ @Select({ "select", "id, productname, status, accountid, website, quantity, serialnumber, assessnumber, ", "contactid, supportstartdate, supportenddate, salesdate, unitprice, description, ", "producturl, supportcontact, supportterm, supportdesc, cost, listprice, groupid, ", "tax, taxClass, mftNumber, vendorPartNumber, createdTime, createdUser, sAccountId, ", "lastUpdatedTime", "from m_crm_product", "where id = #{id,jdbcType=INTEGER}" }) @ResultMap("com.mycollab.module.crm.dao.ProductMapper.BaseResultMap") Product selectByPrimaryKey(Integer id);
@Select("select id, job_name, job_path, job_doc, job_table, job_type, renewable from bi_execute_job where id=#{id}") @ResultMap("biJobDto") public BiJob selectJobInfoById(String jobId);
@Select("SELECT * FROM `draw_word`\n" + "WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `draw_word`))) \n" + "LIMIT 1;") @ResultMap("telemarketer.skittlealley.persist.mybatis.dao.DrawWordMapper.BaseResultMap") DrawWord randomWord();
