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 ......
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (תÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (תÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......
ÓÐÈËÊÔ¹ýÔÚwin7ÉÏ°²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËƵÄÖµ£¬ÎÒÐèÒª½«Æä ......