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" >
<typeAlias alias="test" type="com.sgcc.mdm.qualitymanage.test.model.Test" />
<resultMap id="testMap" class="test" >
<result column="ISBEGINDBORDER" property="isBegindBorder"/>
<select id="queryTest" resultMap="testMap" parameterClass="java.util.Map">
A.TESTB_ID = B.ID
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- Linux see redis process
command : ps ef|grep redis Return to upper level cd ..
- 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, ...
- 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 ...
- 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 ...
- 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 : ...
- 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 .
http://www.cnblogs.com/rubylouvre/archive/2009/07/24/1530074.html var name = "The Window"; ...
- 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 ...
- 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 ...
- 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 -> ...