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ÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......