If SQL Statement has two identical query column names , When mapping , Take the value of the first column name to map

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="com.sgcc.mdm.qualitymanage.test.model.Test">
    <typeAlias alias="test" type="com.sgcc.mdm.qualitymanage.test.model.Test" />
    
    <resultMap id="testMap" class="test" >
        <result column="ISBEGINDBORDER" property="isBegindBorder"/>
    </resultMap>

<select id="queryTest" resultMap="testMap"   parameterClass="java.util.Map">
        select
               C.ISBEGINDBORDER,
               B.ISBEGINDBORDER
          from
               TESTA          A,
               TESTB         B
         where
               A.TESTB_ID = B.ID
    </select>

</sqlMap>

1. ibatis Of the query sql Column has more related articles with the same column name

  1. ibatis middle voice SQL The use of query and dynamic tag nesting

    ibatis Dynamic query is very important for Java EE For developers ,iBatis It's a familiar persistence layer framework , stay Hibernate.JPA Such a one-stop object / Relation mapping (O/R Mapping) Explain ...

  2. SQL Server Take your own query result as the second sub column of the data to be queried

    Nested subqueries are SQL Statement is a common query method , In the process of development, we need to take one of our columns as the data to be queried , In reference to other people's SQL The writing of the sentence has finally realized the function you need . The query statement is as follows : SELECT DIS ...

  3. SQL Server Take your query result as one of the sub columns of the data to be queried

    Nested subqueries are SQL Statement is a common query method , In the process of development, we need to take one of our columns as the data to be queried , In reference to other people's SQL The writing of the sentence has finally realized the function you need . The query statement is as follows : SELECT DISTINC ...

  4. oracle Database query date sql sentence ( Example )、 Add a column of attributes to the already created table and add values to the column 、 Delete a column of data ( A whole column )

    First list my database tables : c_date(Date Format )     date_type(String Format ) 2011-01-01                   0 2012-03-07         ...

  5. iBatis The query result part is null Solutions for

    Today's first day of contact iBatis, No systematic learning , Encountered a simple but disturbing mistake : use iBatis When you query the multi column results of a table in the database as an object , Some of the properties of the object are null It's worth the mistake . for example , Query users in user table I ...

  6. MyBatis Of getMapper() Interface 、resultMap label 、Alias Alias 、 Try to extract sql Column 、 Dynamic operation

    One .getMapper() Interface analysis :getMapper() Interface IDept.class Define an interface , Mount a method that is not implemented , What's special , By any means , It has to be in a small configuration id Attributes are consistent Through agency : Generating connection ...

  7. Improve SQL The query efficiency (SQL Optimize )

    To improve SQL The query efficiency where How to write the order of sentence conditions http://blog.csdn.net/sforiz/article/details/5345359   We should not only be able to write SQL, And do it ...

  8. NHibernate Series 26 :NHibernate Inquiry SQL Query Inquire about ( Download with program )

    Abstract NHibernate It's available in very early versions SQL Query( Native SQL Inquire about ), For very complex queries , If it is difficult to use other query methods , In general use SQL Query. Use SQL Query Is based on ...

  9. Hibernate Inquiry SQL Inquire about

    from : Hibernate Also supports the use of SQL Inquire about , Use SQL Queries can take advantage of some database features , Or to use the original JDBC Application migration to Hibernate On the application . Use named SQL Query can also be SQL Statement in the configuration file ...

Random recommendation

  1. Linux see redis process

    command : ps ef|grep redis Return to upper level cd ..

  2. Match:Cyclic Nacklace(KMP Of next Advanced application of array )(HDU 3746)

    String beads The main idea of the topic : Given a string , I want you to find if you want to make it a loop string , The minimum number of words needed at the end ( Only characters can be added , You can't delete characters ) First of all, let's talk about the dynamic programming problem that we have done before POJ 3280, Yes, of course 3280 This question is used LD, ...

  3. Java Socket send and receive HTTP Message simple implementation

    Last time Java Socket The reality is simple HTTP Serve me We have achieved a simple HTTP service , It can be used to simulate HTTP service , It can intercept HTTP The original stream of the request , Let's have a clear understanding of what we send to the service HTTP The end of the message structure ...

  4. QQ Music Project (OC edition ) - Implementation details

    QQ Music seems simple , But it can be realized manually , It's not that simple , There are a lot of details , We need to pay attention to . github : https://github.com/keenleung/QQMusic-OC One . Business logic First ...

  5. Linux Synchronous time command ntpdate

    from :http://orgcent.com/linux-ntpdate/ Because of synchronization Linux Server time , In order to ensure the high accuracy of time , give up date And turn to ntpdate( Synchronous time command ). Scheme as follows : ...

  6. Oracle - Invalid character for reason not found

      When executed Oracle When the sentence is , Tips “ Invalid character ”, When there is no error in the sentence , Try to replace the space in the statement with the half width state .   In general, this problem occurs in directly copied statements .

  7. javascript Closure characteristics

    http://www.cnblogs.com/rubylouvre/archive/2009/07/24/1530074.html var name = "The Window"; ...

  8. TotoiseSVN Basic usage

    TotoiseSVN The basic usage of TotoiseSVN The basic usage of One . Check in the source code to SVNserver If we use Visual Studio In the catalog StartKit Created a project in . We need to sign the source code of this project ...

  9. JAVA Verification code generation ( turn )

    Recently, I have done the function of captcha , I found a good one on the Internet , Quote below :http://blog.csdn.net/ruixue0117/article/details/22829557 This article is very good , however web and js ...

  10. Openwrt Customize CGI Realization

    This article has been published by Netease cloud community authorized by author Wu Zhimeng . Welcome to Netease cloud community , Learn more about netease technology product operation experience . install uhttpd. Compiling openwrt front , Input make memuconfig, lookup Network -> ...