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±íʾ½µÐòÅÅÁÐ
......
Òý×Ôhttp://www.05112.com/Article/200908/26674.html
ÍøÕ¾SQL×¢È멶´È«½Ó´¥£¨¸ß¼¶Æª£©
ÎÄÕÂÕûÀí·¢²¼£ººÚ¿Í·çÔÆ ÄÚÈݹØ×¢¶È£º
291 ¸üÐÂʱ¼ä£º2009-8-15 6:36:47
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿Ôõ ......
/*ͳ¼ÆÿÌìÊý¾Ý×ÜÁ¿ÈýÖÖ·½·¨£º
select convert(char(10),happentime ,120) as date ,count(1) from table1
group by convert(char(10),happentime ,120) order by date desc
s ......
ÔÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“° ......