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

sql ²ËÄñÎÊÌ⣨ÔÚÏߵȣ©

ÈçºÎÓÃsqlÓï¾ä²éѯ id=xx µÄÉÏÒ»Ìõ¼Ç¼ºÍÏÂÒ»Ìõ¼Ç¼
ÔÚÏßµÈ ±È½Ï׿±

id authorid
1  1111
2  2222
3  1111
4  3333
5  4444
6  1111
7  5555
ÎÒÄÜ»ñµÃµÄÌõ¼þÊÇid=3 authorid=1111 ÈçºÎ²éѯid=6ÕâÌõÊý¾Ý Ò²¾ÍÊÇid=3 authorid=1111µÄÏÂÒ»ÌõÊý¾Ý

µ¥´¿µÄsqlµÄ»°£¬¾ÍÓÃÓαꣻÓÃjdbcµÄ»° £¬¾Íµ÷ÓÃjava.sql.resultsetµÄnext()ºÍprevious()·½·¨

ÉÏÒ»Ìõ
select top 1 id,authorid from table where id <7 order by id desc 
ÏÂÒ»Ìõ
select top 1 id,authorid from table where id>6 order by id asc 

ÒýÓÃ
µ¥´¿µÄsqlµÄ»°£¬¾ÍÓÃÓαꣻÓÃjdbcµÄ»° £¬¾Íµ÷ÓÃjava.sql.resultsetµÄnext()ºÍprevious()·½·¨

Ê×ÏÈллÄú£¬²»¹ýÄÜдµÄÏêϸһµãô jdbc·½Ê½µÄ

ÒýÓÃ
ÉÏÒ»Ìõ
select top 1 id,authorid from table where id <7 order by id desc 
ÏÂÒ»Ìõ
select top 1 id,authorid from table where id>6 order by id asc 

authoridÊÇÎÒÖªµÀµÄ²éѯÌõ¼þ£¬id=3Ò²ÊÇÎÒÖªµÀµÄ²éѯÌõ¼þ

ÒýÓÃ
ÈçºÎÓÃsqlÓï¾ä²éѯ id=xx µÄÉÏÒ»Ìõ¼Ç¼ºÍÏÂÒ»Ìõ¼Ç¼


Äã說µÄÊÇÄÄ種數據庫,ÿ種µÄ寫·¨¶¼²»Ò»樣.

ÒýÓÃ
ÒýÓÃÂ¥Ö÷ pangpanglovezz µÄ»Ø¸´:
ÈçºÎÓÃsqlÓï¾ä²éѯ id=xx µÄÉÏÒ»Ìõ¼Ç¼ºÍÏÂÒ»Ìõ¼Ç¼


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sql¸üÐÂ×ֶη¾¶

Èç¹ûÓÃsqlÓï¾ä¸ü¸Älj×ֶεÄ·¾¶£¬ÈçÏ£º
lj
7/200781616183095962.jar
8/f_200812111413292.jar
8/f_200812111413291.jar

µÃµ½µÄ½á¹ûÈçÏ£º
lj
1/7/200781616183095962.jar
1/8/f_20081 ......

OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ