Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ±¸·ÝÓÐÊ²Ã´Çø±ð

sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã

²»Ã÷°×~~~

Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹Ô­Êý¾Ý¿â

Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

sqlServerÓû§saµÇ¼²»ÉÏÁË

±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, ......

SQLServer IP¿â ²éѯIP²»Í¬ ËÙ¶ÈÏà²î¾Þ´ó ÇóÓÅ»¯Òâ¼û

ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â
°´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal
±ÈÈç
IP±í

IPStart      IPEnd      Address
-------------------------------------
994304000  ......

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖÐ

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß

ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷

DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß

ËùÓÐÈÎÎñ£­µ¼³öÊý¾Ý¡£

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