Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

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

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

identity?ɶÒâ˼£¿

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

¹ØÓÚSQLserverÁ¬½ÓµÄÎÊÌâ

  ÎÒ×°ÁËSQLserver2000¡¢SQLserver2005ÕâÁ½¸öÊý¾Ý¿â£¬ÔõôÁ¬½ÓÕâÁ½¸öÊý¾ÝÄØ£¿£¨¿ª·¢¹¤¾ßΪmyEclipse£©

  ÎÒÓÃJDBCÁ¬½ÓÉÏÁËSQLserver2005,¼ÓÈëÁËÈý¸öÇý¶¯°ü(Ìý˵ÕâÈý¸öÇý¶¯ÊÇÓÃÓÚÁ¬½ÓSQLserver200 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ