Java 6 ÖÐ×Ô´øµÄ Java DB(derby) Êý¾Ý¿â
а²×°ÁË JDK 6 µÄ³ÌÐòÔ±ÃÇÒ²Ðí»á·¢ÏÖ£¬³ýÁË´«Í³µÄ bin¡¢jre µÈĿ¼£¬JDK 6 ÐÂÔöÁËÒ»¸öÃûΪ db µÄĿ¼¡£Õâ±ãÊÇ Java 6 µÄгÉÔ±£ºJava DB¡£ÕâÊÇÒ»¸ö´¿ Java ʵÏÖ¡¢¿ªÔ´µÄÊý¾Ý¿â¹ÜÀíϵͳ£¨DBMS£©£¬Ô´ÓÚ Apache Èí¼þ»ù½ð»á£¨ASF£©ÃûϵÄÏîÄ¿ Derby¡£ËüÖ»ÓÐ 2MB ´óС£¬¶Ô±È¶¯éüÉÏ G µÄÊý¾Ý¿âÀ´Ëµ¿ÉνÐäÕä¡£µ«Õâ²¢²»·Á° Derby ¹¦ÄÜÆë±¸£¬Ö§³Ö¼¸ºõ´ó²¿·ÖµÄÊý¾Ý¿âÓ¦ÓÃËùÐèÒªµÄÌØÐÔ¡£¸üÄÑÄܿɹóµÄÊÇ£¬ÒÀÍÐÓÚ ASF Ç¿´óµÄÉçÇøÁ¦Á¿£¬Derby µÃµ½Á˰üÀ¨ IBM ºÍ Sun µÈ´ó¹«Ë¾ÒÔ¼°È«ÊÀ½çÓÅÐã³ÌÐòÔ±ÃǵÄÖ§³Ö¡£ÕâÒ²ÄÑ¹Ö Sun ¹«Ë¾»áÑ¡ÔñÆä 10.2.2 °æ±¾ÄÉÈëµ½ JDK 6 ÖУ¬×÷ΪÄÚǶµÄÊý¾Ý¿â¡£Õâ¾ÍºÃÏñΪ JDK ×¢ÈëÁËÒ»¹ÉȫеĻîÁ¦£ºJava ³ÌÐòÔ±²»ÔÙÐèÒªºÄ·Ñ´óÁ¿¾«Á¦°²×°ºÍÅäÖÃÊý¾Ý¿â£¬¾ÍÄܽøÐа²È«¡¢Ò×Óᢱê×¼¡¢²¢ÇÒÃâ·ÑµÄÊý¾Ý¿â±à³Ì¡£ÔÚÕâÒ»ÕÂÖУ¬ÎÒÃǽ«³õ¿ú Java DB µÄÊÀ½ç£¬À´Ì½¾¿ÈçºÎʹÓÃËü±àд³ö¹¦ÄܷḻµÄ³ÌÐò¡£
1~&ex r4f^ B NuJt0Hello, Java DB£ºÄÚǶģʽµÄ Derby
2[E(`+}JS3|sE0¼ÈÈ»ÓÐÁËÄÚǶ£¨embedded£©µÄÊý¾Ý¿â£¬¾ÍÈÃÎÒÃÇ´ÓÒ»¸ö¼òµ¥µÄ·¶Àý¿ªÊ¼£¬ÊÔ×ÅʹÓÃËü°É¡£Õâ¸ö³ÌÐò×öÁË´ó¶àÊýÊý¾Ý¿âÓ¦Óö¼¿ÉÄÜ»á×öµÄ²Ù×÷£ºÔÚ DBMS Öд´½¨ÁËÒ»¸öÃûΪ helloDB µÄÊý¾Ý¿â£»´´½¨ÁËÒ»ÕÅÊý¾Ý±í£¬È¡ÃûΪ hellotable£»Ïò±íÄÚ²åÈëÁËÁ½ÌõÊý¾Ý£»È»ºó£¬²éѯÊý¾Ý²¢½«½á¹û´òÓ¡ÔÚ¿ØÖÆÌ¨ÉÏ£»×îºó£¬É¾³ý±íºÍÊý¾Ý¿â£¬ÊÍ·Å×ÊÔ´¡£
$J,D6T9\ b,g0public class HelloJavaDB {
:\xB f-v e[,K0public static void main(String[] args) { ÖÐÎÄJAVA¼¼ÊõÍø0A r&^9b S s'E)x
try { // load the driver
5vF1i] u3yU%t+xW.?0Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
Ei.[0MbJ0System.out.println("Load the embedded driver");
@v/YhRo#l0Connection conn = null; ÖÐÎÄJAVA¼¼ÊõÍø1t|O7r$`WOT
Properties props = new Properties(); ÖÐÎÄJAVA¼¼ÊõÍø(D#i8}YgW%]u
props.put("user", "user1"); props.put("password", "user1"); ÖÐÎÄJAVA¼¼ÊõÍø-q:d9@P"F4E9wa R
//create and connect the database named helloDB ÖÐÎÄJAVA¼¼ÊõÍø1]T^OT-{Nu3o w
conn=DriverManager.getConnection("jdbc:derby:helloDB;create=true", props); ÖÐÎÄJAVA¼¼ÊõÍøakm1k4? y
System.out.println("create and connect to helloDB"); ÖÐÎÄJAVA¼¼ÊõÍø6|f__ ];O
conn.setAutoCommit(false); ÖÐÎÄJAVA¼¼ÊõÍøX;K?Cm3@;D7
Ïà¹ØÎĵµ£º
ÓÐÈçÏÂÇé¿öÏ¿ÉÒÔÓõ½ÄÚ´æÎļþÓ³Éä¼¼Êõ½â¾öÎÊÌâ:
1.²»Òª¸´ÖÆÎļþÖÐËùÓеÄÊý¾Ý£¬Ö»ÐèÒªÐÞ¸ÄÎļþÖоֲ¿µÄÊý¾Ý¡£
2.²¢ÐÐ\·Ö¶Î´¦Àí´óÎļþ¡£
ÈçÏ´úÂëʾʹÓÃjavaNIO¾Ö²¿ÐÞ¸ÄÎļþÖÐÖ¸¶¨Î»ÖõIJ¿·ÖÊý¾Ý£º
Java´úÂë
/**
* ÐÞ¸ÄÎļþÖеÄijһ²¿·ÖµÄÊý¾ ......
½Ó¿ÚµÄ×÷ÓÃ
½Ó¿ÚµÄ×÷Óüòµ¥Ò»µã¾ÍÊÇ:½Ó¿ÚÊÇÓÃÀ´±ê¼ÇÀàµÄ£¬²»Í¬µÄÀàÊôÓÚ²»Í¬µÄ½Ó¿Ú£¨Í¨¹ýÏòÉÏתÐÍ£©£¬¹ÜÀí½Ó¿Ú±È¹ÜÀí¸÷ÖÖ¸÷ÑùµÄÀà·½±ã¶àÁË£¬½Ó¿ÚÌåÏÖÁ˳éÏóµÄ¹Ûµã,ʲôÊdzéÏ󣿳éÏó¾ÍÊÇ"³éÈ¥ÏñµÄ²¿·Ö"¡£
ʹÓýӿڽâ¾öÎÊÌâ
ÎÊÌâ:ÏÖÔÚÎÒÃÇҪд¸öÁ¬½ÓÊý¾Ý¿âµÄÀà¸øÓû§Ê¹Óã¬ÓÐÁ½¸öº¯Êý:Ò»¸ö·µ»ØConnection ......
ΪÁ˱£Ö¤Ê¾Àý³ÌÐòµÄÔËÐУ¬±ØÐë°²×°Java 2 sdk1.4.0 ºÍJakarta POI£¬Jakarta POIµÄWebÕ¾µãÊÇ: http://jakarta.apache.org/poi/
ʾÀý1½«ÑÝʾÈçºÎÀûÓÃJakarta POI API ´´½¨Excel Îĵµ¡£
ʾÀý1³ÌÐòÈçÏ£º
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import
org.apache.poi.hssf.usermodel.HSSFSheet;
impo ......
XMLÏÖÔÚÒѾ³ÉΪһÖÖͨÓõÄÊý¾Ý½»»»¸ñʽ,ƽ̨µÄÎÞ¹ØÐÔʹµÃºÜ¶à³¡ºÏ¶¼ÐèÒªÓõ½XML¡£±¾ÎĽ«Ïêϸ½éÉÜÓÃJava½âÎöXMLµÄËÄÖÖ·½·¨¡£
XMLÏÖÔÚÒѾ³ÉΪһÖÖͨÓõÄÊý¾Ý½»»»¸ñʽ,ËüµÄƽ̨ÎÞ¹ØÐÔ,ÓïÑÔÎÞ¹ØÐÔ,ϵͳÎÞ¹ØÐÔ,¸øÊý¾Ý¼¯³ÉÓë½»»¥´øÀ´Á˼«´óµÄ·½±ã¡£¶ÔÓÚXML±¾ÉíµÄÓ﷨֪ʶÓë¼¼Êõϸ½Ú,ÐèÒªÔĶÁÏà¹ØµÄ¼¼ÊõÎÄÏ×,ÕâÀïÃæ°üÀ¨µÄÄÚÈÝ ......
http://www.onjava.com
O'ReillyµÄJavaÍøÕ¾. ÿÖܶ¼ÓÐÐÂÎÄÕÂ
http://java.sun.com
¹Ù·½µÄJava¿ª·¢ÕßÍøÕ¾ - ÿÖܶ¼ÓÐÐÂÎÄÕ·¢±í
http://www.developer.com/java
ÓÉGamelan.com ά»¤µÄJava¼¼ÊõÎÄÕÂÍøÕ¾
http://www.java.net
&nb ......