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

¿ìËٸ㶨ÔÚEclipseÖÐÓÃJDBCÁ¬½ÓSQL Server 2005

1¡¢ÏÂÔØ±Ø±¸Èí¼þ
(1) JDK (Java Development Kit)
SUN¹Ù·½µÄÏÂÔØµØÖ·ÊÇhttp://java.sun.com/javase/downloads/index.jsp
(2) JDBC
(3) Eclipse
(4) Microsoft SQL Server 2005 Express£¨µ±È»£¬ÓзÇExpressÒ²OK°¡£©
(5) SQL Server Management Studio
2¡¢°²×°Óë»·¾³ÅäÖÃ
(1) JDK
Ê×ÏÈÔÚWindows»·¾³Ï£¬ÏÂÔØºó°²×°¼´¿É¡£
È»ºóÔÚÎҵĵçÄÔ-ÊôÐÔ-¸ß¼¶ÏµÍ³ÉèÖÃ-¸ß¼¶-»·¾³±äÁ¿-ϵͳ±äÁ¿£º
1¡¢“н¨”£º±äÁ¿ÃûΪJAVA_HOME£¬±äÁ¿ÖµÎªJDKµÄ¸ùĿ¼¡£
2¡¢“н¨”£º±äÁ¿ÃûΪCLASSPATH£¬±äÁ¿ÖµÎª%JAVA_HOME%\lib
3¡¢“н¨”£º±äÁ¿ÃûΪPATH£¬±äÁ¿ÖµÎª%JAVA_HOME%\bin
×¢Ò⣺Èç¹û±äÁ¿ÃûÒѾ­´æÔÚ£¬ÔòÑ¡Ôñ“±à¼­”£¬ÔÚ±äÁ¿ÖµµÄ×îºó¼ÓÉÏ“;”£¨·ÖºÅ£©£¬²¢ÔڷֺźóÃæÊäÈëÉÏÃæËùÊöµÄ±äÁ¿Öµ¡£
×îºó±ðÍüÁ˵ã“È·¶¨”¡£ÏÖÔھͿÉÒÔÔÚÃüÁîÐÐÖÐʹÓÓjavac”ÁË¡£
(2) JDBC
ÏÂÔØºó½âѹ£¬ÔÚ°²×°Ä¿Â¼ÕÒµ½sqljdbc.jar£¨×¢Ò⣬Ä㻹»áÕÒµ½Ò»¸ösqljdbc4.jar£¬¿¼Âǵ½ÓеÄjre°æ±¾µÍµÄÇé¿ö£¬Ö»ÓÃsqljdbc.jar£¬²»ÓÃsqljdbc4.jar£©¡£
¼ÆËã»ú->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿->ϵͳ±äÁ¿->classpath×îºó×·¼ÓÕâ¸ösqljdbc.jar£¬Ò»¶¨ÒªÐ´ÍêÕûµÄ·¾¶£¬´ÓÅÌ·û¿ªÊ¼¡£
Ñ¡ÔñÈ·¶¨¡£
(3) SQL Server Configuration Management
¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->SQL Server Configuration Management
->SQLEXPRESSµÄЭÒé->ÓÒ¼üTCP/IP£¬Ñ¡ÔñÆô¶¯£»
->SQLEXPRESSµÄЭÒé->Ë«»÷TCP/IP£¬°ÑIPµØÖ·Ñ¡ÏÖеÄIPALLÖеÄTCP¶Ë¿ÚÉèÖÃΪÄãËùÏëÒªÉèÖõĶ˿ڣ¬Èç1433£»
ÖØÐÂÆô¶¯SQL Server·þÎñ
¹Ø±ÕSQL Server Configuration Management
(4) SQL Server Management Studio
н¨Êý¾Ý¿â£¬Ãû³Æ¿É¶¨Îªsample
(5) Eclipse
File->New->java project£¬Ãû³Æ×Ô¶¨£»
Window->Preferences->Java->Installed JREs->Ñ¡Ôñjre6->Edit->Add Extenal JARs->Ñ¡Ôñsqljdbc.jarµÄλÖá£
3¡¢²Î¿¼×ÊÁÏ£º
¡¾1¡¿http://wenku.baidu.com/view/19967d1b6bd97f192279e9a5.html
¡¾2¡¿http://blog.csdn.net/Poechant/archive/2010/05/31/5635542.aspx
¡¾3¡¿http://blog.sina.com.cn/s/blog_5ccc0a650100he46.html
¡¾4¡¿http://blog.csdn.net/downmoon/archive/2009/07/16/4352914.aspx


Ïà¹ØÎĵµ£º

SQLÖÐobject_idº¯ÊýµÄÓ÷¨

 ¾­³£»á¿´¼ûÔÚSQL³ÌÐòµÄ¿ªÍ·ÓÐÕâÑùÒ»¾ä»°
if OBJECT_ID('tb') is not null
drop table tb  
º¯ÊýÓï·¨ÊÇÕâÑù£º
int OBJECT_ID('objectname');
×÷ÓÃÊÇ¿´¶ÔÏóobjectnameÊÇ·ñ´æÔÚ¡£
ÆäÖвÎÊýobjectname±íʾҪʹÓõĶÔÏó£¬ÊÇchar»òÕßncharÀàÐÍ¡£
·µ»ØÖµÀàÐÍΪint£¬Èç¹û¶ÔÏó´æÔÚ£¬Ôò·µ»Ø´Ë¶ÔÏóÔÚϵͳÖеı ......

SQL*PLUSÖк¯Êý

´´½¨º¯Êý
CREATE OR REPLACE FUNCTION ntfuc(inp IN NUMBER)
RETURN NUMBER
IS
ntmp NUMBER;
BEGIN
ntmp := inp;
RETURN ntmp;
END ntfuc;
/
Ö´Ðиú¯Êýʱ
DECLARE
rcn NUMBER;
BEGIN
rcn := ntfunc(1);
END;
/ ......

SQL Server²éѯÓÅ»¯

MS SQL Server²éѯÓÅ»¯·½·¨
×÷Õߣºxmllover 2007-11-29 
²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ 
  1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ) 
  2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£ 
  3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£ 
  4¡¢ÄÚ´æ ......

sql¸½¼ÓÊý¾Ý¿âÖ»¶ÁÎÊÌâ

ÔÚSQL Server 2005 Express Éϸ½¼Ó´ÓÁíÍâһ̨µçÄÔCopy¹ýÀ´µÄÊý¾Ý¿âºó£¬Êý¾Ý¿âΪ“Ö»¶Á”¡£ 
½â¾ö°ì·¨£º
´ò¿ª SQL Server Configuration Manager, ´ò¿ªSQL Server SQLEXPRESS µÄÊôÐÔ
ÔÚÄÚÖÃÕʺŴ¦£¬°Ñ“ÍøÂç·þÎñ”¸Ä³É“±¾µØÏµÍ³”£¬ÖØÐÂÆô¶¯SQL Server 2005 Express ºó£¬ÔÙ¸½¼ÓÊý¾Ý ......

textareaÖеÄÄÚÈÝͨ¹ýÌí¼Ó°´Å¥Ìí¼Óµ½SQLÊý¾Ý¿âÖÐ

ÎÒ¶¨ÒåÁËÒ»¸ö textarea:
  <tr bgcolor="#CCCCCC" align="center" valign="bottom">
            <td align="right" valign="top" class="style1"  >ÎÄÕÂÄÚÈÝ£º</td>
         &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ