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

NetBeansÁ¬½ÓSqlserverÎÊÌâ

ÓÃNetBeans×Ô¶¯´´½¨ÁËÒ»¸öÊý¾Ý¿âÓ¦ÓóÌÐò£¨Ò»¸ö×ÀÃæÓ¦ÓóÌÐò£©£¬ÊµÏÖ»ù±¾µÄ¶Ô±íµÄÌí¼Ó¡¢É¾³ý¡¢Ð޸ġ¢Ë¢Ð£¬ÀïÃæÉú³ÉÁËÈý¸öÎļþ£¬Ò»¸öÊÇGUIÏÔʾ£¬Ò»¸öÊÇÈë¿ÚÎļþ£¨ launch(CarsApp3App.class, args)£©»¹ÓÐÒ»¸öÎļþ£¬ÎÒÍÆ²âÊÇÓйØÊý¾Ý¿âµÄ£¬µ«ÊÇ¿´²»Ì«Ã÷°×¡£

¸÷λÄÜ·ñ°ïæ¿´¿´£¬´óÖ½âÊÍһϣ¿
------------------------------------------
ÎÒ²»Ã÷°×µÄÓÐÈçϼ¸µã£º
1¡¢@Entity£¬@TableÖ®ÀàÓï¾äµÄÇ°ÃæµÄ@ÊÇʲôÒâ˼£¿

2¡¢´ÓNetBeansÀïÃæµÄ ·þÎñ->Êý¾Ý¿â->н¨Á¬½Ó ¿ÉÒÔÖ±½Ó´´½¨Óësql server2000µÄÁ¬½Ó£¬µ«ÎÒÔÚ×Ô¶¯Éú³ÉµÄ3¸öÎļþÖУ¬²¢Ã»ÓÐÕÒµ½ÖîÈçÒÔÏ»ù±¾²½Öè¡£¡£¡£

ÇëÎʸ÷λ¸ßÈË£¬´´½¨Ò»¸öÕâÑùµÄÓ¦ÓóÌÐò£¬´ó¸ÅµÄ½á¹¹ÊÇʲô£¿
------------------------------------------

»ù±¾²½Ö裺
//1¡¢¼ÓÔØjdbcÊý¾Ý¿âÇý¶¯
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Êý¾Ý¿âÇý¶¯³ÌÐò×¢²á³É¹¦£¡");

//jdbcÁ¬½ÓURL
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "sa";//Óû§Ãû
String password = "sa";//ÃÜÂë

//2¡¢È¡µÃÁ¬½Ó
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("Êý¾Ý¿âÁ¬½Ó³É¹¦");


//3¡¢±íʾԤ±àÒëµÄ SQL Óï¾äµÄ¶ÔÏó
PreparedStatement ps = conn.prepareStatement("select * from test_tab");


//»òÕßÓÃÓÚÖ´Ðо²Ì¬ SQL Óï¾ä²¢·µ»ØËüËùÉú³É½á¹ûµÄ¶ÔÏó
//Statement s = conn


Ïà¹ØÎÊ´ð£º

sqlserverÈ«ÎÄË÷ÒýµÄÔ­Àí

ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......

³õѧÕß¡£Sqlserver nullµÄÎÊÌâ

´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......

sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå

sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É

identity?ɶÒâ˼£¿

IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

windows server 2003Íü¼ÇÃÜÂ룬¿ÉÒÔSqlServer¿ÉÒÔÁ¬ÉÏ

ÎҼǵÃsqlserverÖÐÓдúÂë¿ÉÒÔÖ±½Ó´´½¨Ò»¸öÓû§µÄ£¬ÇëÄÄλָµãÏ£¡
ºÃÏñÒªÓõ½xp_cmdshellÀ´´´½¨windowsÓû§£¬¾ßÌåµÄÄã¿ÉÒÔgoogleÒ»ÏÂ

ÄãÁ¬ÉϵÄÓû§Èç¹ûÄÜÓÃxp_cmdshellµÄ»°£¬¾ÍÓðɡ£

xp_cmdshell 'n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ