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
Ïà¹ØÎĵµ£º
Eclipse Java×¢ÊÍÄ£°åÉèÖÃÏê½â ===²Î¿¼
http://blog.csdn.net/ahhsxy/archive/2009/09/11/4542682.aspx
¼òµ¥Ä£°åÀý×Ó£º
view
plain
copy
to clipboard
print
?
<?xml version=
"1.0"
encoding=
"UTF-8"
?><templates><template&nb ......
×òÌìÉÏÍøÓöµ½ÒÔǰµÄͬѧ£¬ÔÚÒøÐÐÉϰ࣬¸øÎÒÀ´Á˾䣺javaÊÇ´ÏÃ÷ÈËѧµÄ¶«Î÷£¡
˵µÃÎҺܺ¹ÑÕ£¬ÒòΪ¾õµÃ×Ô¼ºÒ»Ö±ºÜ±¿µÄ£¬Ò²Ã»ÓоõµÃѧϰjavaÓë´ÏÃ÷£¬±¿µ°
Ö®¼äµÄ¹ØÏµ£¡
¼ÇµÃÀϱÏÿ´Î½²¿Î£¬×îºó×ÜÒªÎÊ£ºÌý¶®Ã»Óа¡£¿ È»ºóÆä×Ô¼º»Ø´ð×Ô¼º£º¿Ï¶¨Ìý¶®ÁË¡£
ÎÒ˵µÄÊÇÖйú»°£¬´ó°×»°£¬Ôõô»áÌý²»¶®£¿ ͬÑùµÄµÀÀí£¬Ö»ÒªÊÇÒ»¸öÕ ......
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......