JavaÃüÁîÐÐÖ´ÐдÓSQL 2000Êý¾Ý¿â×ªÒÆµ½2005Êý¾Ý¿â
1.ÏÂÔØ2005Êý¾Ý¿âÇý¶¯£¨sqljdbc.jar£©
2.ÕâʱҪÓÃEclipseµÈ¼¯³É¿ª·¢»·¾³£¬ÔÚbuild pathÀïÃæ°Ñ2000Êý¾Ý¿âÇý¶¯°üɾ³ýÁË£¬È»ºóµ¼½ø2005Êý¾Ý°ü¡£
3.°Ñ´úÂëÖÐ×¢²áÊý¾Ý¿âÇý¶¯µÄ´úÂë»»³É2005µÄ´úÂë¡£
È磺
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 2000 version
Connection con = DriverManager.getConnection("jdbc:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2005 version
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2000 version
4.ÐÞ¸Äsqljdbc.jar°ü£¬°Ñ¸Ã°üÖеÄmanifest.mfÖгýÁ˵ÚÒ»ÐÐÒÔÍ⣬ÆäËûµÄ¶¼É¾³ýÁË£»ÁíÍâͬʱ°Ñzigbert.rsaºÍzigber.sfÕâÁ½¸öÎļþɾ³ýÁË£»£¨Õâʱ×îÖØÒªµÄÒ»²½£¬²»È»»á³öÏÖÒÔÏ´íÎó£¬È簲ȫ´íÎóµÈ£©
Exception in thread "main" java.lang.SecurityException: no manifiest section for
signature file entry com/microsoft/sqlserver/jdbc/SQLServerException.class
at sun.security.util.SignatureFileVerifier.verifySection(Unknown Source)
at sun.security.util.SignatureFileVerifier.processImpl(Unknown Source)
at sun.security.util.SignatureFileVerifier.process(Unknown Source)
at java.util.jar.JarVerifier.processEntry(Unknown Source)
at java.util.jar.JarVerifier.update(Unknown Source)
at java.util.jar.JarFile.initializeVerifier(Unknown Source)
at java.util.jar.JarFile.getInputStream(Unknown Source)
at sun.misc.URLClassPath$JarLoader$2.getInputStream(Unknown Source)
at sun.misc.Resource.cachedInputStream(Unknown Source)
a
Ïà¹ØÎĵµ£º
×î½ü¹«Ë¾Åöµ½ÐèÒªÓÃͼ±íµÄÐÎʽÏÔʾһЩÊý¾Ý£¬ÎҾͿªÊ¼µ½ÍøÉϲéѯ£¬²éµ½ÁËjfreechartºÍamcharts,ÕâÁ½ÕßÎÒ¶¼ÊµÏÖ¹ýÁË£¬jfreechart×îºóÉú³ÉͼƬ£¬µ«ÊÇͼƬЧ¹û²»ÊÇÎÒÏëÒªµÄ£¬È»ºóÓÖÑо¿amcharts ËüµÄЧ¹ûȷʵºÜºÃ£¬¶øÇÒ¹Ù·½ÍøÕ¾ÉÏ»¹ÓкÃЩÀý×ӿɹ©ÏÂÔØ£¬ÍøÖ·ÊÇ:www.amcharts.com
£¨ÏëÒªÍê³ÉÒ»¸öamchartsͼÐÎÐèÒªswfobjects. ......
û¿´Í꣬ת¹ýÀ´ÊÕ²Ø
¿ÎǰË÷Òý
¿Îǰ˼¿¼
¡¡¡¡1. ʲôÊÇTCP/ IPÐÒ飿
¡¡¡¡2. TCP/IPÓÐÄÄÁ½ÖÖ´«ÊäÐÒé,¸÷ÓÐÊ²Ã´ÌØµã£¿
¡¡¡¡3. ʲôÊÇURL£¿
¡¡¡¡4. URLºÍIPµØÖ·ÓÐʲôÑùµÄ¹ØÏµ£¿
¡¡¡¡5. ʲô½ÐÌ×½Ó×Ö£¨Socket£©£¿
¡¡¡¡6. Ì×½Ó×Ö£¨Socket£©ºÍTCP/IPÐÒéµÄ¹ØÏµ£¿
¡¡¡¡7. URLºÍÌ×½Ó×Ö£¨Socket£©µÄ¹ØÏµ£¿
8£®1 ÍøÂç±à³Ì» ......
ÀëÆßÔµÄÌì¿ÕÔ½À´Ô½½üÁË£¬ÎÒËÆºõÄܹ»¸ÐÊܵõ½ÎÒµÄÀíÏëÔÚÂýÂýµÄ¿¿½üÎÒ£¬´ËʱÎÒÒѾÓÐЩÐË·ÜÁË¡£
´ÓÅàѵJavaÈí¼þ¹¤³Ìʦµ½ÏÖÔÚÒѾÓÐ5¸ö¶àÔÂÁË£¬¿´×ÅÉí±ßµÄʦÐÖÃǸ÷¸ö¶¼ÄÃ×Å×Ô¼º¾«ÐÄÖÆ×÷µÄ¼òÀúÈ¥ÃæÊÔµÄʱºò£¬ÎÒÒ²¿ªÊ¼¾²¾²µÄ¹æ»®ÆðÁËÎÒµÄÈËÉú·¡£Ï£Íûͨ¹ýÕâ¸öÄܹ»Ö¸ÒýÎÒ×ߵĸüºÃ£¬Ò²Ï£Íû×Ô¼ºÄܹ»ÔçÈÕʵÏÖ×Ô¼ºµÄÃÎÏë--½«À´ÓÐÒ»¼ ......
ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ - Êý¾Ý¿â - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£ ......
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......