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

jbossƽ̨ÏÂjspÁ¬½Ósql2005ºÍsql2000

1¡¢ÅäÖÃjava»·¾³£¬MyEclipse7.0¡£ÅäÖÃjboss5.0£¬Õ¹¿ªÑ¡ÔñjdkΪÒÑ°²×°µÄjdk·¾¶¡£
2¡¢°²×°2005ºÍsql2000£¬×°2000ʱҪװsp4.Çý¶¯Ñ¡Ôñjdbc2.0¡£ÔÙ×°2000ʱʵÀýÃû×Ô¼ºÊäÈëÒ»¸ö¡£ÕâÀïµÄÎÊÌâ¾ÍÊǵǼÃûºÍÃÜÂëµÄÉèÖã¬ÓÒ»÷“SQL   Server×é”ϵÄʵÀýÃû£¨Windows   NT)"µÄ“ÊôÐÔ”£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ“°²È«ÐԔѡÏ£¬°ÑÉí·ÝÑéÖ¤µÄÑ¡ÏîÉèΪÉÏÒ»ÏSQl   ServerºÍWindows£¬µã»÷È·¶¨¼´¿É£¡ÔÚ°²È«ÐÔÀïÃæн¨Ò»¸öÓû§£¬·þÎñÆ÷½ÇÉ«Ñ¡Ôñpublic£¬Êý¾Ý¿â½ÇÉ«Ñ¡Ôñower¡£¶Ï¿ªÒ»¿ªÊ¼ÒÔwindowsÉí·ÝµÄÊý¾Ý¿âµÇ¼£¬2000ÀïÃæ±à¼­×¢²áÊôÐÔ£¬Ñ¡ÔñÓû§ÃûºÍÃÜÂë¡£ÔÙ´ÎÁ¬½ÓÊý¾Ý¿â£¬²âÊÔһϣ¬¿´Äܲ»Äܳɹ¦¶Á³öÊý¾Ý¡£»¹ÓÐÒ»µã¶ù£ºÔÚ·þÎñÆ÷sql2000·þÎñÆ÷ÍøÂçʵÓù¤¾ßµÄtcp¶Ë¿Ú¸ÄΪ1433.È»ºóÖØÆôÉúЧ¡£
3¡¢Ð½¨Ò»¸öweb Project£¬Á¬½ÓÓï¾äΪ
 public static final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 public static final String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=Knowledge_Base";
 public static final String userName = "yue";
 public static final String password = "123456";
4¡¢MyEclipse7.0---windows---ÊôÐÔ£¬java---ÒÑ°²×°jar£¬Ñ¡Ôñsqljdbc4.jar¡£
5¡¢²¿ÊðÏîÄ¿£¬ÔÚä¯ÀÀÆ÷ÊäÈ룺http://localhost:8080/?,  ?ΪÏîÄ¿Ãû³Æ¡£


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL×¢È멶´½Ó´¥

 Òý×Ôhttp://www.05112.com/Article/200908/26674.html
ÍøÕ¾SQL×¢È멶´È«½Ó´¥£¨¸ß¼¶Æª£©
ÎÄÕÂÕûÀí·¢²¼£ººÚ¿Í·çÔÆ ÄÚÈݹØ×¢¶È£º
291 ¸üÐÂʱ¼ä£º2009-8-15 6:36:47
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿Ôõ ......

SQLÖÐÒÔÈÕÆÚΪÌõ¼þͳ¼Æ·½·¨

 /*ͳ¼ÆÿÌìÊý¾Ý×ÜÁ¿ÈýÖÖ·½·¨£º
        select convert(char(10),happentime ,120) as date ,count(1) from table1
        group by convert(char(10),happentime ,120) order by date desc
       s ......

´´½¨SQL SERVER 2005ÐÂÕË»§

 Ô­ÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ