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
Ïà¹ØÎĵµ£º
û¿´Í꣬ת¹ýÀ´ÊÕ²Ø
¿ÎǰË÷Òý
¿Îǰ˼¿¼
¡¡¡¡1. ʲôÊÇTCP/ IPÐÒ飿
¡¡¡¡2. TCP/IPÓÐÄÄÁ½ÖÖ´«ÊäÐÒé,¸÷ÓÐÊ²Ã´ÌØµã£¿
¡¡¡¡3. ʲôÊÇURL£¿
¡¡¡¡4. URLºÍIPµØÖ·ÓÐʲôÑùµÄ¹ØÏµ£¿
¡¡¡¡5. ʲô½ÐÌ×½Ó×Ö£¨Socket£©£¿
¡¡¡¡6. Ì×½Ó×Ö£¨Socket£©ºÍTCP/IPÐÒéµÄ¹ØÏµ£¿
¡¡¡¡7. URLºÍÌ×½Ó×Ö£¨Socket£©µÄ¹ØÏµ£¿
8£®1 ÍøÂç±à³Ì» ......
java½øÖÆ×ª»»
javaÖнøÐжþ½øÖÆ£¬°Ë½øÖÆ£¬Ê®Áù½øÖÆ£¬Ê®½øÖÆ¼ä½øÐÐÏ໥ת»»
Ê®½øÖÆ×ª³ÉÊ®Áù½øÖÆ£º
Integer.toHexString(int i)
Ê®½øÖÆ×ª³É°Ë½øÖÆ
Integer.toOctalString(int i)
Ê®½øÖÆ×ª³É¶þ½øÖÆ
Integer.toBinaryString(int i)
Ê®Áù½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("FFFF",16 ......
½ñÌìÍí·¹³Ô¶àÁË£¬¶Ç×ÓÄÑÊÜ£¬¾ÍÈ¥±±´óÀïÃæ¹äÁ˹䣬²»Öª²»¾õÀ´µ½ÁËδÃûºþ±ß£¬ÓеãÀÛÁË£¬ÔÚºþ±ßÕÒÁ˸ö³¤ÒÎÌÉÁËһϣ¬·¿´ÊÖ»úµÄµç»°²¾£¬·¢ÏֺöàÅóÓѺþÃûÓÐÁªÏµÁË£¬ÉõÖÁÓÐЩ¶¼ÒѾÍü¼ÇÁËËûÃǵÄÑù×Ó£¬ÓÐЩÃû×Ö¶¼ÈÃÎҸе½ÓеãİÉúÁË£¬²»ÖªµÀËûÃÇ»¹ÊÇ·ñ¼ÇµÃÎÒ£¡
&nbs ......
¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......