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
Ïà¹ØÎĵµ£º
native2ascii
ÔÚWINDOWSƽ̨ϱàдµÄ×ÊÔ´Îļþ,ÒÔGB2312·½Ê½±àÂë,ÔÚ±àÒëʱÐèҪתÂë,ÒÔÈ·±£ÔÚ¸÷¸öƽ̨ÉϵÄÕýÈ·ÐÔ
±àÂë:
native2ascii -encoding utf8 temp.properties ApplicationResources_zh_CN.properties
&n ......
½ñÌìÍí·¹³Ô¶àÁË£¬¶Ç×ÓÄÑÊÜ£¬¾ÍÈ¥±±´óÀïÃæ¹äÁ˹䣬²»Öª²»¾õÀ´µ½ÁËδÃûºþ±ß£¬ÓеãÀÛÁË£¬ÔÚºþ±ßÕÒÁ˸ö³¤ÒÎÌÉÁËһϣ¬·¿´ÊÖ»úµÄµç»°²¾£¬·¢ÏֺöàÅóÓѺþÃûÓÐÁªÏµÁË£¬ÉõÖÁÓÐЩ¶¼ÒѾÍü¼ÇÁËËûÃǵÄÑù×Ó£¬ÓÐЩÃû×Ö¶¼ÈÃÎҸе½ÓеãİÉúÁË£¬²»ÖªµÀËûÃÇ»¹ÊÇ·ñ¼ÇµÃÎÒ£¡
&nbs ......
С²ËÄñÎÒ×î½ü¿ªÊ¼¾ö¶¨ÈÏÕæÑ§Ò»Ñ§Java»ù´¡ÖªÊ¶¡£
´óѧµÄʱºò¿ªÁËÕâÃſγ̣¬²»¹ýÊÇÑ¡Ð޿Ρ£¶øÇÒµ±Ê±¶ÔC/C++µÄÖ´×ŵ¼ÖÂÎÒÌìÕæµÄÍêÈ«¶ÔJava“±ÉÊÓ”ÓëºöÂÔ¡£ÏÖÔÚ¿´ÆðÀ´ÊǶàôÌìÕæ£¬Ôø¾ºÍºÜ¶à¸¡Ôê¡¢ÎÞÖªµÄÈËÒ»Æð±ÉÊÓÓÃJavaµÄ³ÌÐòÔ±£¬È»ºó²ÅÖªµÀ×Ô¼ºÊǶàôÎÞÖª£¬ÒÔÖÁÓÚºöÂÔÁ˽ü´ú¼¸ºõ×îΰ´ó×îÓÐÕùÒéµÄ¡¢È´¼¯ÖÐÁËÈËÀàÔ ......
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......