Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÔ¤´¦ÀíÓï¾ä

ÓбíÈçÏ£º
id  name  sex  brithday
1    ÕÅÈý  ÄР 1983-12
2    ÀîËÄ  ÄР 1984-11
3    ÍõÎå  Å®  1985-07
4    ÕÔ¶þ  ÄР 1986-08
Java code:

PrepareStatement sql;
sql=con.prepareStatement("select * from ta_name where id=?");
//ÏÂÃæÕâ¾ä²»¶®£¬Ö÷ÒªÊÇÊä³öÔ­Àí²»¶®
sql.setInt(1,2)


Èç¹ûÕâÀï²ÎÊý¸ÄΪsql.setInt(2,4) »òÕßʲô£¬½«»áÊä³öÊ²Ã´ÄØ£¿


Çë¸÷λ°ïæ¸ø¸ö½âÊ͹þ¡£
ллÀ²
SetInt·½·¨µÄ˵Ã÷£º
Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.

sql.setInt(1,2)µÄÒâ˼ÊÇÉèÖÃsqlµÄµÚÒ»¸ö²ÎÊý(µÚÒ»¸öÎʺÅÖµ)Ϊ2;

ÒýÓÃ
sql.setInt(1,2)µÄÒâ˼ÊÇÉèÖÃsqlµÄµÚÒ»¸ö²ÎÊý(µÚÒ»¸öÎʺÅÖµ)Ϊ2;

up
Èç¹ûÕâÀï²ÎÊý¸ÄΪsql.setInt(2,4) »òÕßʲô£¬½«»áÊä³öÊ²Ã´ÄØ£¿
´ð£º×Ô¼ºÊÔ£¬¹À¼ÆÊÇ»á³öÏÖË÷ÒýµÄÒì³£¡£

²»ÊÔ²»ÖªµÀ£¬Ò»ÊÔÒì³£×¼¿´µ½£¡


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ