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/?, ?ΪÏîÄ¿Ãû³Æ¡£
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊ ......
Òý×Ôhttp://www.05112.com/Article/200908/26674.html
ÍøÕ¾SQL×¢È멶´È«½Ó´¥£¨¸ß¼¶Æª£©
ÎÄÕÂÕûÀí·¢²¼£ººÚ¿Í·çÔÆ ÄÚÈݹØ×¢¶È£º
291 ¸üÐÂʱ¼ä£º2009-8-15 6:36:47
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿Ôõ ......
SQL ÊÇÒ»ÃÅ ANSI µÄ±ê×¼¼ÆËã»úÓïÑÔ£¬ÓÃÀ´·ÃÎʺͲÙ×÷Êý¾Ý¿âϵͳ¡£SQL Óï¾äÓÃÓÚÈ¡»ØºÍ¸üÐÂÊý¾Ý¿âÖеÄÊý¾Ý¡£SQL ¿ÉÓëÊý¾Ý¿â³ÌÐòÐͬ¹¤×÷£¬±ÈÈç MS Access¡¢DB2¡¢Informix¡¢MS SQL Server¡¢Oracle¡¢Sybase ÒÔ¼°ÆäËûÊý¾Ý¿âϵͳ¡£
²»ÐÒµØÊÇ£¬´æÔÚןܶ಻ͬ°æ±¾µÄ SQL ÓïÑÔ£¬µ«ÊÇΪÁËÓë ANSI ±ê×¼Ïà¼æÈÝ£¬ËüÃDZØÐëÒÔÏàËÆµÄ ......
參¿¼: http://brightsky006.blog.163.com/blog/static/22583668200962195059485/
°ÑSQL 2005µÄ±¸·ÝÎļþµ¼Èëµ½SQL 2000
ѧϰÕä²Ø 2009-07-21 09:50 ÔĶÁ616 ÆÀÂÛ0
×ֺţº ´ó´ó ÖÐÖРСС
µçÄÔÉÏ°²×°ÁËSQL Server 2005£¬ÏÖÔÚÏë»»»ØSQL2000À´£¬ ......