Java JDBC±à³Ì×ܽá[z]
Hibernate¡¢TopLinkµÈOR Mapping²Ù×÷Êý¾Ý¿âµÄ¼¼Êõ¶¼Êǽ¨Á¢JDBC¼¼ÊõÖ®Éϵģ¬Êµ¼ÊÀ´Ëµ£¬ËûÃǵÄÐÔÄܺÍJDBCÊÇÓкܴó²î¾àµÄ£¬µ«·´¹ýÀ´Ëµ£¬Èç¹ûJDBCÓò»ºÃ£¬»¹²»Èç hibernateÄØ¡£ÔÝÇÒ²»ËµÕâЩÊëÓÅÊëÁӵϰÁË£¬ÔÙ´ÎÖ÷ÒªÊǶÔJavaµÄ»ù´¡¼¼Êõ×ö¸ö×ܽᣬÒÔ¼ÓÉîÈÏʶ¡£
Ò»¡¢JDBCµÄ»ù±¾ÔÀí
JDBCÊÇJava²Ù×÷Êý¾Ý¿âµÄ¼¼Êõ¹æ·¶¡£Ëûʵ¼ÊÉ϶¨ÒåÁËÒ»×é±ê×¼µÄ²Ù×÷Êý¾Ý¿âµÄ½Ó¿Ú¡£ÎªÁËÄÜÈÃJava²Ù×÷Êý¾Ý¿â£¬±ØÐëÒªÓÐʵÏÖÁËJDBCÕâЩ½Ó¿ÚµÄÀ࣬²»Í¬µÄÊý¾Ý¿â³§ÉÌΪÁËÈÃJavaÓïÑÔÄܲÙ×÷×Ô¼ºµÄÊý¾Ý¿â£¬¶¼ÌṩÁ˶ÔJDBC½Ó¿ÚµÄʵÏÖ--ÕâЩʵÏÖÁËJDBC½Ó¿ÚµÄÀà´ò³ÉÒ»¸öjar°ü£¬¾ÍÊÇÎÒÃÇÆ½Ê±¿´µ½µÄÊý¾Ý¿âÇý¶¯¡£ÓÉÓÚ²»Í¬µÄÊý¾Ý¿â²Ù×÷Êý¾ÝµÄ»úÖÆ²»Ò»Ñù£¬Òò´ËJDBCµÄ¾ßÌåʵÏÖÒ²¾Íǧ²îÍò±ð£¬µ«ÊÇÄã×÷Ϊjava³ÌÐòÔ±£¬ÄãÖ»ºÍJava JDBCµÄ½Ó¿Ú´ò½»µ½£¬²Å²»ÓÃÀí»áËûÃÇÔõôʵÏֵģ¡ºÇºÇ£¬ÏÖÔÚÖªµÀJDBCÇý¶¯ÊÇÔõô»ØÊÂÁË¡£µ±È»£¬ÕâЩÀà¿ÉÒÔ×Ô¼ºÈ¥Ð´--Èç¹ûÄãºÜÅ££¡
¶þ¡¢JDBC±à³ÌµÄ²½Öè
ΪÁË˵Ã÷Õâ¸ö²½Ö裬¼ÙÉèÄãҪͨ¹ýjava³ÌÐòÖ´ÐÐÒ»¸ösql²éѯ£¬ÄãÐèÒª°´ÕÕÈçϵIJ½ÖèÈ¥×ߣº
1¡¢´´½¨Ö¸¶¨Êý¾Ý¿âµÄURL
Õâ¸öURLʵ¼ÊÉÏ»¹ÊÇͳһ×ÊÔ´¶¨Î»Æ÷£¬ÀïÃæ°üº¬ÁËһЩÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢£ºÊý¾Ý¿âÀàÐÍ¡¢¶Ë¿Ú¡¢Çý¶¯ÀàÐÍ¡¢Á¬½Ó·½Ê½¡¢Êý¾Ý¿â·þÎñÆ÷µÄip(»òÃû×Ö)¡¢Êý¾Ý¿âÃû£¨ÓеÄÊDZðÃû£©µÈ¡£Æä¸ñʽÈçÏ£º
jdbc:subProtocol:subName://DBserverIP:port/DatabaseName
ÀýÈçmysqlµÄÒ»¸öurl£ºjdbc:mysql://192.168.3.143:3306/zfvims
2¡¢¼ÓÔØÇý¶¯ÀൽJVMÄÚ´æÇøÓòÖÐ
ÓÐÁ½ÖÖ·½·¨£º
Ò»ÖÖÊÇÓÃClass.forName()·½·¨¼ÓÔØÖ¸¶¨µÄÇý¶¯³ÌÐò¡£
Ò»ÖÖÊǽ«Çý¶¯³ÌÐòÌí¼Óµ½java.lang.SystemµÄÊôÐÔjdbc.driversÖС£
×îºó˵Ã÷Ò»µã£¬ÓÐʱºòÌí¼Óµ½ÏµÍ³µÄCLASSPATH»·¾³±äÁ¿ÊDz»Ðеģ¬ÔÒòÊÇÔÚʹÓÃJDBC½Ó¿Ú²Ù×÷Êý¾Ý¿âǰ£¬JVM»¹Ã»ÓмÓÔØÉÏÇý¶¯¡£
Class.forName("com.mysql.jdbc.Driver")
3¡¢¡¢Í¨¹ýDriverManagerÀà¹ÜÀíÇý¶¯¡¢´´½¨Êý¾Ý¿âÁ¬½Ó¡£
DriverManagerÀà×÷ÓÃÓÚ³ÌÐòÔ±ºÍJDBCÇý¶¯³ÌÐòÖ®¼ä£¬Ìṩע²á¹ÜÀíÇý¶¯½¨Á¢Á¬½Óϸ½ÚµÈ·½·¨£¬ËüËùÓгÉÔ±¾ùΪ¾²Ì¬µÄ¡£Í¨¹ýÆägetConnection·½·¨»á´´½¨Ò»¸öJDBC Connection¶ÔÏó¡£
Connection conn=DriverManager.registerDriver("jdbc:mysql://192.168.3.143:3306/zfvims","lavasoft","password");
4¡¢ConnectionÀà--Êý¾Ý¿âÁ¬½Ó
ÕâÀïËù˵µÄConnectionÀàʵ¼ÊÉÏÊÇʵÏÖÁËJDBCµÄConnection½Ó¿ÚµÄÀ࣬Õâ¸öÀàÒ»°ã¶¼ÊÇjdbcÇý¶¯³ÌÐòʵÏÖÁË¡£ ConnectionÀà±íʾÁËÊý¾Ý¿âÁ¬½Ó£¬Í¨¹ýÆä¶ÔÏó¿ÉÒÔ»ñȡһ¸ö»ñÈ¡Êý¾Ý¿âºÍ±í
Ïà¹ØÎĵµ£º
°²×°ÓëÉèÖÃJDK
Sun JDKµÄ°²×°»ù±¾ÉÏÓÐÁ½ÖÖ·½Ê½:
1. ͨ¹ýUbuntuÌṩµÄ°ü¹ÜÀí¹¤¾ß½øÐа²×°
UbuntuÔÚÆä°ü²Ö¿âÀï¶¼°üÀ¨ÓÐJDKµÄ°²×°£¬Ö»Òªsources.listÉèÖÃÕýÈ·£¬Í¨
¹ýapt-get, aptitude, Synaptic Package
ManagerµÈ¶¼Äܰ²×°£¬¶øÇÒÏà¹ØµÄÉèÖÃÒ²ÈÝÒ׵öࣻÔÚUbuntuµÄÐÂ
·¢²¼°æ±¾Àï¶¼´øÁËJDK5.0,ºÍJDK6.0µÄ°²×°Ö§³Ö,¶øÇÒ ......
java»º´æ¼¼ÊõÒ»£¨×ª£©
¿´Ò»Á£É³ÖеÄÊÀ½ç£¬ Ò»¶äÒ°»¨ÖеÄÌìÌᣠ°ÑÎÞÏÞÎÕÓÚÕÆÖУ¬ °ÑÓÀºãÎÕÓÚ˲¼ä¡£——ÍþÁ®• ²¼À³¿Ë
¿ªÊ¼ÌÖÂÛ»º´æÖ®Ç°,ÈÃÎÒÃÇÏÈÀ´ÌÖÂÛÌÖÂÛÁíÍâÒ»¸öÎÊÌâ:ÀíÂÛºÍʵ¼ù.´Óahuaxuan½Ó´¥µÄ³ÌÐòÔ±À´¿´,ÓеijÌÐòԱƫʵ¼ù,ÓеijÌÐòԱƫÀíÂÛ,µ«ÊÇÕâ¶¼ÊDz»ºÃµÄÐÐΪ,ÀíÂÛºÍʵ¼ùͬÑùÖØÒª,ÎÒÃÇÔÚ×öºÜ¶àº ......
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Properties;
public class SystemProperties
{
public static String LINE_SEPARATOR = "line.separator";
public static String FILE_SEPARATOR = "file.separator";
public static String USER_LANGUAGE = "user.language";
......
2009-04-14 15:37
ËäÈ»ÏÖÔÚÓÃAPACHE COMMONS DBCP¿ÉÒԷdz£·½±ãµÄ½¨Á¢Êý¾Ý¿âÁ¬½Ó³Ø£¬
µ«ÊÇÏñÕâÆªÎÄÕ°ÑÊý¾Ý¿âÁ¬½Ó³ØµÄÄÚ²¿ÔÀíдµÄÕâô͸³¹£¬×¢ÊÓÕâôÍêÕû£¬
ÕæÊǷdz£Äѵã¬Èÿª·¢ÈËÔ±¿ÉÒÔ¸üÉî²ã´ÎµÄÀí½âÊý¾Ý¿âÁ¬½Ó³Ø£¬ÕæÊǷdz£¸Ð
лÕâÆªÎÄÕµÄ×÷Õß¡£
import java.sql.Connection;
import java.sql.DatabaseMetaData;
......
ÕªÒª£º±¾ÎĽ«Ì¸Ì¸ÔÚJavaÓ¦ÓóÌÐòÖÐʹÓÃJfreechartÅäÖã¬JFreeChartÊÇÓÃJava¿ª·¢µÄÒ»¸öÃâ·ÑµÄchartͼÐδ¦ÀíÀà¿â¡£
²âÊÔ»·¾³£º
OS¡¡£ºWindowsXP
Java£ºjdk1.5.0_06
JFreeChart£º1.0.9£¨2008Äê3Ô¡¡×îа汾£©
ÒòΪJFreeChart²ÉÓÃJava¿ª·¢¶ø³É£¬ËùÒÔÔÚÆäËûϵͳҲÄÜÕý³£ÔËÐС£
JFreeChartµÄ°²×°
1£¬ÏÂÔØ
´ÓSourceforge. ......