ibatisÖÐÖ±Ö´ÐÐsql£¬·µ»Ø´æ´¢MapµÄListÀàÐÍ
ibatis×÷Ϊһ¸öÇáÁ¿¼¶µÄorm¹¤¾ßÏÖÔڷdz£Á÷ÐУ¬ÎÒÔÚʹÓÃÖз¢ÏÖ£¬ÓÐʱ½ö½öÏ£Íû·µ»ØÒ»¸öÀàÐÍΪmapµÄlist¾Í¿ÉÒÔÁË£¬
±ÈÈç¼òµ¥µÄ²éѯͳ¼ÆÖ®ÀàµÄ£¬Ã»ÓбØÒª¶¨ÒåÌ«¶àµÄpojo£¬Òò´ËÏëÄܲ»ÄÜÔÚibatisÖÐÖ±½Ó´«ÈësqlÓï¾äÀ´Ö´ÐУ¬È»ºó·µ»ØmapÄØ£¿
´ÓÍøÉÏËÑÁËһϣ¬»¹ÕæÓУ¬ÊµÑé³É¹¦ºó×ܽáһϣ¬´ó¼Ò¹²Í¬½ø²½¡£ ÆäʵºÜ¼òµ¥£¬¾ÍÊÇÔÚÅäÖÃÎļþÖÐÌí¼ÓÒÔϵÄÅäÖã¬
<!-- ²âÊÔSql -->
<select id="sqlQuery" parameterClass="java.lang.String" resultClass="java.util.HashMap">
<![CDATA[
$sql$
]]>
</select>
ʹÓ÷½·¨¾Í¸ü¼òµ¥ÁË£¬Æ´ºÃsqlÓï¾äºó£¬µ÷ÓÃ
sqlMapper.queryForList("sqlQuery", sql)¾ÍµÃµ½Á˲éѯ½á¹û£¬
µ±È»Õâ¸ö½á¹ûΪList£¬²¢ÇÒlistÖеÄÔªËØΪMapÀàÐÍ£¬Ñ»·List£¬¾ÍµÃµ½²éѯÃ÷ϸ¡£
ÒÔÉÏ·½·¨¶ÔÓÚ·ÖÀà»ã×ÜÀàµÄ²éѯͳ¼Æ¹¦ÄÜÓÈÆäʵÓá£Èç¹ûÖ»ÊÇcount()µÄ»°£¬¾ÍÈ¡ListµÄµÚÒ»¸öÔªËؾÍÐÐÁË¡£ ÎÒÃÇ¿ÉÒÔ°ÑÕâ¸ö·½·¨³é³öÀ´Ð´µ½Ò»¸öutilÀàÖУ¬·½·¨ÈçÏÂ
/**
* ²éѯ²¢·µ»ØList
*/
public static List queryForList(String sql){
List rtn = null;
try{
rtn = sqlMapper.queryForList("sqlQuery", sql);
}catch(SQLException sqle){
sqle.printStackTrace();
}
return rtn;
}
ÕâÑùÓÃÆðÀ´¾Í·½±ã¶àÁË¡£Èç¹û´ó¼Ò»¹ÓÐÆäËüµÄºÃ·½·¨£¬Ò»ÆðÌÖÂÛһϡ£ ÎÒµÄÍƹ㣺ÀÏÀÖÍø
Ïà¹ØÎĵµ£º
et ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[Get_StrArrayLength]
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûºÅ
)
returns int
as
begin
declare @location int
declare @start int
declare @length int
&nbs ......
sql²éѯÖÐÏÔʾÐòºÅ
2009-06-04 09:27
/* ·½·¨Ò»*/
SELECTÐòºÅ= (SELECT COUNT(¿Í»§±àºÅ) from ¿Í»§ AS LiMing
WHERE LiMing.¿Í»§±àºÅ<= Chang.¿Í»§±àºÅ),
¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§ AS Chang ORDER BY 1;
G ......
Ò»¡¢ADO¼ò½é
¡¡¡¡ADO(ActiveX Data Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢µÄнӿڣ¬Êǽ¨Á¢ÔÚOLE DBÖ®Éϵĸ߲ãÊý¾Ý¿â·ÃÎʼ¼Êõ,²»½ö¼òµ¥Ò×Ó㬲¢ÇÒ²»Ê§Áé»îÐÔ.²»Ê§ÎªC++ÀûÓÃÊý¾Ý¿â¿ìËÙ¿ª·¢µÄ²»´íÑ¡Ôñ¡£
¡¡¡¡ÀíÂ۾Ͳ»ÓÃÎÒÔÚÕâ¶ù·Ñ»°ÁË,ÍøÉÏÓкܶà,µ«¹âÊÇÀíÂÛ,Ò²²»ÊDz»¹»µÄ,ADO·ÃÎÊÊý¾ÝµÄ·½·¨ºÜÁé»î,ÈÝÒ×ÈÃÈË»ìÏý.ÍøÉÏ´ó²¿·Ö ......
¸üÐÂÏÂÎÊÌ⣺
񡜧TBL_Info
×ֶΣº
infoId int
title varchar(20)
Content text
byUser varchar(20)
createTime datetime
1¡¢ÈçºÎɾ³ý±íÖÐÊý¾ÝÏàͬµÄÊý¾ÝÄØ£¿£¨Ö÷¼ü³ýÍ⣩
2¡¢ÈçºÎɾ³ýÊý¾Ý±íÖÐij¸ö×Ö¶ÎÊý¾ÝÏàÍ ......
ʹÓÃSQL ServerÉí·ÝÑéÖ¤µÇ¼ʱ±¨´í£º
ÎÞ·¨Á¬½Óµ½.\SQLEXPRESS.
Additional information:
Óû§'sa'µÇ¼ʧ°Ü¡£¸ÃÓû§Óë¿ÉÐÅSQL Server Á¬½ÓÎÞ¹ØÁª¡£(microsoft SQL Server,Error:18452£©)
------------------
ÏÂÃæÊÇÓ³Éäʱ±¨µÄ´í£º
´´½¨¶ÔÓÚÓû§“sa”ʧ°Ü¡££¨microsoft.sqlServer.express.smo£©
Additional ......