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. ......
java StringÓëunicode
java.nio.charset.Charset
public static Charset defaultCharset()
´Ë·½·¨µÄ×÷Ó㺷µ»ØjavaÐéÄâ»úµÄĬÈÏ×Ö·û¼¯£¬Ä¬ÈϵÄ×Ö·û¼¯È¡¾öÓÚ²Ù×÷ϵͳµÄ×Ö·û¼¯¡£
java.lang.String
public byte[] getBytes()
´Ë·½·¨µÄ×÷Ó㺱àÂë×Ö·û´®µ½Ò»¸ö×Ö½ÚÁ÷ÐòÁУ¬´Ëʱ²ÉÓõıàÂëÊÇÆ½Ì¨Ä¬ÈϵıàÂ룬Èç¹ûÏë»ñµÃÖ¸¶ ......
java½øÖÆ×ª»»
javaÖнøÐжþ½øÖÆ£¬°Ë½øÖÆ£¬Ê®Áù½øÖÆ£¬Ê®½øÖÆ¼ä½øÐÐÏ໥ת»»
Ê®½øÖÆ×ª³ÉÊ®Áù½øÖÆ£º
Integer.toHexString(int i)
Ê®½øÖÆ×ª³É°Ë½øÖÆ
Integer.toOctalString(int i)
Ê®½øÖÆ×ª³É¶þ½øÖÆ
Integer.toBinaryString(int i)
Ê®Áù½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("FFFF",16 ......
¶ÔÓÚJAVA±à³ÌºÍºÜ¶àÀàËÆC¡¢C++ÓïÑÔÓÐÒ»¸ö¾Þ´óÇø±ð¾ÍÊÇÄÚ´æ²»ÐèÒª×Ô¼ºÈ¥free»òÕßdelete£¬¶øÊÇÓÉJVMÀ¬»ø»ØÊÕ»úÖÆÈ¥Íê³ÉµÄ¡£¶ÔÓÚÕâ¸ö¹ý³ÌºÜ¶àÈËÒ»Ö±±È½ÏãȻ»òÕß¾õµÃºÜÖÇÄÜ£¬Ê¹µÃÔÚд³ÌÐòµÄ¹ý³Ì²»Ì«¿¼ÂÇËüµÄ¸ÐÊÜ£¬Æäʵ֪µÀһЩÄÚÔÚµÄÔÀí£¬°ïÖúÎÒÃDZàд¸ü¼ÓÓÅÐãµÄ´úÂëÊǷdz£ÓбØÒªµÄ¡£
±¾ÎÄ´ÓÒÔϼ¸¸ö·½Ãæ½øÐвûÊö£º
......
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......