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

JavaÁ¬½ÓSQL Server 2000

Êý¾Ý¿â²Ù×÷ÏÖÔÚÊÇÏîÄ¿¿ª·¢µÄ¸ù±¾£¬Ñ§Ï°JavaÊ×ÏÈÓ¦¸Ãѧ»áÔõôÑùÁ¬½ÓÊý¾Ý¿â£¬ÓÃJavaÁ¬½ÓÊý¾Ý¿â¿É²»ÏñÓÃDelphiÕâÀ๤¾ßÄÇÑùÉ輸¸öÊôÐÔ¾ÍOK£¬Ëµ¼òµ¥Ò²¼òµ¥£¬Ëµ¸´ÔÓ£¬ÆäʵҲͦ¸´Ôӵ쬶øÇÒºÜÂé·³£¬Èç¹ûÊdzõѧ£¬¸ù±¾²»Äܱ£Ö¤µÚÒ»´Î¾ÍÁ¬½Ó³É¹¦£¬ÏÂÃæÒÔSQL Server 2000ΪÀý£¬ËµËµJavaÁ¬½ÓÊý¾Ý¿âµÄ»ù±¾·½·¨£¬Ò²¼Ç¼һÏÂÐĵá£
1¡¢ÏÂÔØSQL Server 2000 driver for JDBC
SQL Server 2000 Driver For JDBC Downloads
¸ÃÇý¶¯½ØÖ¹Ä¿Ç°ÓÐËĸö°æ±¾£¬½¨ÒéÏÂÔØ×îеÄSP3°æ¡£
¸ÃÇý¶¯°²×°³É¹¦ºó£¬Ç뽫°²×°Ä¿Â¼ÏµÄlibĿ¼ÏµÄÈý¸ö.jarÎļþ¼Óµ½CLASSPATHÖУ»Èç¹ûÄãʹÓõÄÊÇJBuilder»òEclipse£¬½«ÕâÈý¸öÎļþ¸ù¾ÝIDEµÄÌáʾ¼Óµ½¹¤³ÌÖÐÒ²¿É¡£
2¡¢Éý¼¶ÄãµÄSQL Server 2000£¬ÎªÆä´òÉÏ×îеIJ¹¶¡¡£
ÕâÒ»²½¿ÉÄܲ»ÊDZØÐèµÄ£¬Òò²Ù×÷ϵͳ»·¾³¶ø¶¨£¬ÔÚ²»´ò²¹¶¡µÄÇé¿ö£¬ÓÐʱ¿ÉÒÔÕý³£Á¬½Ó£¬ÓÐʱȴ²»ÄÜ£¬ËùÒÔ½¨Ò黹Êǰ²×°×îеÄSQL Server 2000²¹¶¡£¨SP4£©ºÍJDBCÇý¶¯£¨SP3£©¡£
Èç¹ûÄãµÄ³ÌÐòÔÚÔËÐÐʱÌáʾ£ºError establishing socket£¬Ò»°ãÇé¿öÏ£¬´òÉÏSQL Server 2000µÄ²¹¶¡¾Í¿É½â¾ö¡£
3¡¢Çý¶¯µÄ¼ÓÔØ·½·¨
ÔÚ½¨Á¢Á¬½Ó֮ǰ£¬ÒªÏȼÓÔØSQL Server 2000 JDBCµÄÇý¶¯£¬´úÂëÐÎʽÈçÏ£º
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ÔÚ´Ë×¢Ò⣬forName·½·¨µÄ²ÎÊý×Ö·û´®±ØÐëÍêÈ«ÏàͬÓÚÒÔÉÏÄÚÈÝ£¬´óСдÊÇÇø·ÖµÄ£¬ÆäʵÕâ¸ö´®¾ÍÊÇÇý¶¯ÀàµÄÍêÕûÃû³Æ£º°üÃû+ÀàÃû¡£
4¡¢»ñµÃÒ»¸öÁ¬½Ó
ÔÚ²Ù×÷Êý¾Ý¿â֮ǰ£¬ÒªÏÈ»ñµÃÓëÊý¾Ý¿âµÄÒ»¸öÁ¬½Ó£¬Ê¹ÓÃÈçÏ´úÂë¸ñʽ£º
DriverManager.getConnection(Á¬½Ó×Ö·û´®, µÇ¼Óû§Ãû, µÇ¼ÃÜÂë);
Àý£º
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs", "sa", "");
ÔÚ´Ë´¦¹Ø¼üµÄÊÇÁ¬½Ó×Ö·û´®µÄÄÚÈÝ£¬localhost²¿·Ö¼´·þÎñÆ÷µÄÃû×Ö£¬¿ÉÒÔ¸ü¸Ä£»1433²¿·ÖΪSQL ServerʹÓõĶ˿ںţ¬¸ù¾Ýʵ¼ÊÇé¿öÐ޸ļ´¿É£»DatabaseName¼´ÎªÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÃû×Ö£¬ÔÚ´Ë×¢ÒâDatabaseName֮ǰµÄÊǷֺţ¬¶ø²»ÊÇðºÅ¡£
5¡¢´úÂëʵÀý
// µ¼ÈëJava SQL°ü£¬Á¬½ÓÊý¾Ý¿â±ØÐ裻
import java.sql.*;
public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
String userName = "sa";
String userPwd = "";
Connection dbCo


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

Java NIO APIÏê½â

 
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔǰ£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......

½âÎöJavaÀàºÍ¶ÔÏóµÄ³õʼ»¯¹ý³Ì

ÀàµÄ³õʼ»¯ºÍ¶ÔÏó³õʼ»¯ÊÇ JVM ¹ÜÀíµÄÀàÐÍÉúÃüÖÜÆÚÖзdz£ÖØÒªµÄÁ½¸ö»·½Ú£¬Google ÁËÒ»±éÍøÂ磬ÓйØÀà×°ÔØ»úÖÆµÄÎÄÕµ¹ÊDz»ÉÙ£¬È»¶øÀà³õʼ»¯ºÍ¶ÔÏó³õʼ»¯µÄÎÄÕ²¢²»¶à£¬ÌرðÊÇ´Ó×Ö½ÚÂëºÍ JVM ²ã´ÎÀ´·ÖÎöµÄÎÄÕ¸üÊÇÏÊÓÐËù¼û¡£
±¾ÎÄÖ÷Òª¶ÔÀàºÍ¶ÔÏó³õʼ»¯È«¹ý³Ì½øÐзÖÎö£¬Í¨¹ýÒ»¸öʵ¼ÊÎÊÌâÒýÈ룬½«Ô´´úÂëת»»³É JVM ×Ö½ÚÂëºó£¬ ......

JAVA±Ê¼Ç£¨Î壩

javaÖеÄÐÞÊηû
static ±íʾ¾²Ì¬£¬Ëü¿ÉÒÔÐÞÊÎÊôÐÔ£¬·½·¨ºÍ´úÂë¿é¡£
1£¬staticÐÞÊÎÊôÐÔ£¨Àà±äÁ¿£©£¬ÄÇôÕâ¸öÊôÐԾͿÉÒÔÓà ÀàÃû.ÊôÐÔÃû À´·ÃÎÊ£¬Ò²¾ÍÊÇʹÕâ¸öÊôÐÔ³ÉΪ±¾ÀàµÄÀà±äÁ¿£¬Îª±¾Àà¶ÔÏóËù¹²ÓС£Õâ¸öÊôÐÔ¾ÍÊÇÈ«À๫ÓС££¨¹²ÓеÄÀà±äÁ¿Óë¶ÔÏóÎ޹أ¬Ö»ºÍÀàÓйأ©¡£
Àà¼ÓÔØµÄ¹ý³Ì£¬Àà±¾ÉíÒ²ÊDZ£´æÔÚÎļþÖУ¨×Ö½ÚÂëÎļþ± ......

JAVA·´ÉäС½á

1  JAVAµÄ·´Éä,Æäʵ¾ÍÊÇͨ¹ýÒ»¸öʵÀý»¯µÄ¶ÔÏó·´¹ýÀ´È¥ÕÒµ½Ò»¸öÀàµÄÍêÕûÐÅÏ¢,±ÈÈç¶ÔÓÚÈçϵÄÐÎʽ:
X x=new X();
   x.getClass().getName();
ÕâÀï¾Í»áÊä³öÕâ¸öÀàËùÔÚµÄÍêÕûÐÅÏ¢,¼´"°üÃû.ÀàÃû";
  ×î³£ÓõÄÈýÖÖʵÀý»¯CLASSÀà¶ÔÏó
Class<?> c1 = null ;  // Ö¸¶¨·ºÐÍ
  C ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ