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/?, ?ΪÏîÄ¿Ãû³Æ¡£
Ïà¹ØÎĵµ£º
JSPÓï·¨Ïê½â[תÌû]
HTML×¢ÊÍ:
1) ¿ÉÒÔÓÃ×¢ÊÍÄÚÈÝ,Ò²¿ÉÒÔÓñí´ïʽ.
2)Òþ²Ø×¢ÊÍ:
×¢Êͻᱠ......
DECLARE @dt datetime
SET @dt=GETDATE()
DECLARE @number int
SET @number=3
--1£®Ö¸¶¨ÈÕÆÚ¸ÃÄêµÄµÚÒ»Ìì»ò×îºóÒ»Ìì
--A. ÄêµÄµÚÒ»Ìì
SELECT CONVERT(char(5),@dt,120)+'1-1'
--B. ÄêµÄ×îºóÒ»Ìì
SELECT CONVERT(char(5),@dt,120)+'12-31'
--2£®Ö¸¶¨ÈÕÆÚËùÔÚ¼¾¶ÈµÄµÚÒ»Ìì»ò×îºóÒ»Ìì
--A. ¼¾¶ÈµÄµÚÒ»Ìì
SELECT CON ......
Òý×Ôhttp://www.05112.com/Article/200908/26674.html
ÍøÕ¾SQL×¢È멶´È«½Ó´¥£¨¸ß¼¶Æª£©
ÎÄÕÂÕûÀí·¢²¼£ººÚ¿Í·çÔÆ ÄÚÈݹØ×¢¶È£º
291 ¸üÐÂʱ¼ä£º2009-8-15 6:36:47
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿Ôõ ......
[C#]
public void RunSqlTransaction(string myConnString)
{
SqlConnection myConnection = new SqlConnection(myConnString);
myConnection.Open();
SqlCommand myCommand = myConnection.CreateCommand();
SqlTransaction m ......
/*ͳ¼ÆÿÌìÊý¾Ý×ÜÁ¿ÈýÖÖ·½·¨£º
select convert(char(10),happentime ,120) as date ,count(1) from table1
group by convert(char(10),happentime ,120) order by date desc
s ......