Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java+Access( javaÊý¾Ý¿â±à³Ì£©

1£ºÏȶÔһЩ¸ÅÄîµÄÀí½â£º
JDBC£ºJava DataBase Connection
±¾¼¾Ä¿±ê
1¡¢JDBCµÄ·ÖÀà
2¡¢JDBCµÄÖ÷Òª²Ù×÷ÀàºÍ½Ó¿Ú£º
DriverManager¡¢Connection¡¢Statement¡¢PreparedStatement¡¢ResultSet
3¡¢ÈçºÎʹÓÃJDBCÁ¬½ÓMySQLÊý¾Ý¿â
www.mldn.cnÉÏÓÐMYSQLµÄ½Ì³Ì¡£
1¡¢Ê²Ã´ÊÇJDBC£¿
JDBCÊÇJAVAÌṩµÄÒ»¸ö·þÎñ£¬×¨ÃÅÓÃÓÚ·ÃÎÊÊý¾Ý¿â²Ù×÷£¬¶øÇÒ×¢Ò⣺JDBC¶¨ÒåµÄÊÇÒ»¸öÊý¾Ý¿â·ÃÎʵıê×¼£¬ËùÒÔÀïÃæ»ù±¾É϶¼ÊÇһϵÁеĽӿڡ£¸÷¸öÊý¾Ý¿â³§ÉÌÈç¹ûÒªÏëÖ§³ÖJDBC²Ù×÷£¬Ôò¿Ï¶¨ÒªÌṩһ×éÏà¹ØµÄÀ࣬ÕâЩÀà¿Ï¶¨¶¼ÊÇÌṩ½Ó¿Ú×ÓÀàʵÏÖ¡£
2¡¢JDBCµÄ·ÖÀà
·JDBC-ODBCÇÅÁ¬½Ó
·JDBCÖ±½ÓÁ¬½Ó
·JDBCÍøÂçÁ¬½Ó
3¡¢Ê²Ã´ÊÇODBC£¿
ODBCÊÇ΢Èí¹«Ë¾¶¨ÒåµÄÒ»¸ö¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó£¨Open DataBase Connection£©£¬Ê¹ÓÃODBC¿ÉÒÔÁ¬½Ó¸÷ÖÖÊý¾Ý¿â£¨Ç°Ì᣺±ØÐëÔÚwindowsÖа²×°ºÃÇý¶¯²Å¿ÉÒÔ£©¡£ÔÚSUN µÄJDKÖÐĬÈÏÌṩÁË´ËÊý¾Ý¿âµÄÇý¶¯³ÌÐò£¬ËùÒÔJDK±¾Éí¿ÉÒÔÖ±½ÓʹÓÃJDBC-ODBC½øÐзÃÎÊ¡£
·ÃÎʵĹý³Ì£º
JDBC --> ODBC --> Êý¾Ý¿â £¨ÐÔÄܱȽϵͣ©
Èç¹ûÖ±½ÓʹÓÃJDBC·ÃÎÊ£¬·ÃÎʹý³Ì£ºJDBC --> Êý¾Ý¿â£¨ÐÔÄܽϸߣ©
4¡¢Ö÷Òª²Ù×÷½Ó¿Ú
· Connection£º±íʾÁ¬½ÓÊý¾Ý¿âµÄ½Ó¿Ú
· Statement£º±íʾ²Ù×÷Êý¾Ý¿âµÄ½Ó¿Ú£¨Ö´ÐÐSQLÓï¾ä£©
|- PreparedStatement£º²Ù×÷SQLÓï¾ä£¬µ«ÊÇ¿ÉÒÔ½øÐÐÔ¤´¦Àí²Ù×÷¡£
· ResultSet£º±íʾ²éѯ֮ºóµÄ·µ»Ø½á¹û
5¡¢Ê¹ÓÃJDBC-ODBC²Ù×÷AccessÊý¾Ý¿â
н¨Ò»¸öaccess Êý¾Ý¿â£º
н¨Ò»¸öaccess, ÃüÃû£ºmydb.mdb  -------- ½¨Á¢Ò»ÕÅperson±í:id:×Ô¶¯Ôö³¤£»name:ÐÕÃû£»age:ÄêÁä
ÒòΪÎÒÃǵÄÄ¿µÄÊÇʹÓÃJDBC-ODBCÇÅÁ¬½Ó²Ù×÷Êý¾Ý¿â£¬ËùÒÔ´Ë´¦±ØÐëÏÈÅäÖÃODBCÊý¾ÝÔ´£º¹ÜÀí¹¤¾ß --> Êý¾ÝÔ´
Ìí¼ÓÒ»¸öÊý¾ÝÔ´ÊÇ£ºMs Access Diver(*.mdb)
ÔÚODBCÉÏÉèÖÃÁËÒ»¸öÊý¾Ý¿âµÄ±ðÃû£¬´Ë±ðÃûtestDB´ú±ímydb.mdb¡£ÒÔºóÔÚ²Ù×÷µÄʱºò¾ÍÊÇʹÓÃtestDB¼´¿É¡£
±£´æ²¢¹Ø±ÕaccessÊý¾Ý¿â
1¡¢²Ù×÷Êý¾Ý¿âµÄ²½Ö裨JDBC£©
· ¼ÓÔØÊý¾Ý¿âµÄÇý¶¯³ÌÐò£ºClass.forName("Çý¶¯³ÌÐò") ;
· ͨ¹ýÁ¬½Ó¹ÜÀíÆ÷£¬È¡µÃÒ»¸öÊý¾Ý¿âµÄÁ¬½Ó£ºDriverManager.getConnection(Á¬½ÓµØÖ·)
· ͨ¹ýÁ¬½Ó´´½¨Êý¾Ý¿âµÄ²Ù×÷¶ÔÏó£ºStatement
· ²Ù×÷Êý¾Ý¿â --> Ö´ÐÐSQLÓï¾ä
· ¹Ø±ÕÊý¾Ý¿â²Ù×÷
ÓÐЩÊý¾Ý¿ÉÒÔÖ±½Ó´Ó¼üÅÌÉÏÊäÈë
package org.sunxin.struts2.ch02.action;
import java.io.BufferedReader;
import java.


Ïà¹ØÎĵµ£º

Java 6 ÖÐÒ²¿ÉÒÔÔËÐÐ javascript à¶ (ת)

¸ø Java SE ×¢Èë½Å±¾ÓïÑԵĻîÁ¦
Mustang µÄ½Å±¾ÓïÑÔÐÂÌØÐÔ

ÎĵµÑ¡Ïî

½«´ËÒ³×÷Ϊµç×ÓÓʼþ·¢ËÍ

½«´ËÒ³×÷Ϊµç×ÓÓʼþ·¢ËÍ



¼¶±ð£º Öм¶
Îâ 玥ò« (wuyuehao@cn.ibm.com), Èí¼þ¹¤³Ìʦ, IBM
2006 Äê 10 ÔÂ 30 ÈÕ
ÔÚ¼´½«·¢²¼µÄ Java SE6£¨Mustang£©ÖУ¬Ôö¼ÓÁ˶Խű¾ÓïÑÔµÄÖ§³Ö¡£Í¨¹ý¶Ô½Å± ......

ÓÉJava toy programme µÃ³öµÄ¾­Ñé¼°½Ìѵ

ѧϰJava´ó¸ÅÒ»¸öÔÂÁË£¬ÓÉÓÚÒÔǰÓÐc/c++»ù´¡£¬ËùÒÔÔÚJ2SE²¿·ÖµÄѧϰÊDZȽϿìµÄ£¬½ñÌìÔÚÂÛ̳¿´µ½Ò»¸öÍøÓѵÄÇóÖúÌû£¬Òª½«Ó²ÅÌÉÏÁ½¸öÎļþºÏ²¢ÎªÒ»¸ö²¢É¾³ýÔ­Îļþ£¬ÓÚÊDZãдÁ˲âÊÔ³ÌÐò¡£ºóÀ´ÔÚɾ³ýÎļþʱ£¬ÓÉÓÚûÓаѶµ½ÎļþÉϵÄÊä³öÁ÷¹Ø±Õ£¬µ¼ÖÂÔõôҲÎÞ·¨É¾³ý¡£¶øÇÒÒ»Ö±²é²»³öÔ­Òò£¬ºóÀ´ÒÔΪÊÇdelete·½·¨Ö»ÄÜɾ³ý¿ÕÎļþ£¬Ò»g ......

ËĸöÓꦵÄjava±à³Ìϰ¹ß

John O'Hanley µÄÕâÆªÎÄÕÂÁоÙÁËËĸöÓꦵÄjava±àÂëϰ¹ß£¬²¢Ìá³öÁ˸ÄÕý·½°¸¡£
ÕâËĸöϰ¹ßÆÕ±é´æÔÚÓÚjava³ÌÐòÔ±ÖУ¬²¢ÇÒÒѾ­±»¹ã·º½ÓÊÜ£¬´ó¼Ò¶¼Ï°ÒÔΪ³££¬Á÷¶¾ÉõÔ¶¡£
1.¶Ô¾Ö²¿±äÁ¿(local variables)£¬×Ö¶Î(fields)£¬²ÎÊý(method arguments)ÕâÈýÖÖ±äÁ¿µÄÃüÃûûÓÐÇø·Ö£¬Ôì³ÉÁË´úÂëµÄÔĶÁÀ§ÄÑ£¬Ôö¼ÓÁË´úÂëµÄά»¤³É±¾¡£
×÷Õß ......

ɾ³ý.svn .cvsµÈÎļþ¼ÐµÄjava´úÂë

ÏîÄ¿ÖÐÓеÄÎļþ¼ÐÔ­À´ÊÇsvn°æ±¾¿ØÖƵģ¬ÏÖÔÚ²»Ïë¿ØÖÆÁË£¬¾ÍÏñ°ÑÕâ¸öÎļþ¼Ð´«¸ø±ðÈË»òÕß×Ô¼º±¸·Ý£¬µ«ÊÇ¿´µ½ÄÇô¶à.svnÎļþ¼ÐʵÔÚ²»Êæ·þ£¬Ð´ÁËÏÂÃæµÄ¼òµ¥³ÌÐòÓÃÀ´É¾³ýÕâЩÎļþ£¬ÒÔºóÐèҪɾ³ýµÄ»°£¬ÉèÖúÃÎļþ¼Ð·¾¶ºÍҪɾ³ýµÄÎļþ¼ÐÃû×ÖÅÜһϾÍÐÐÁË¡£
import java.io.File;
/*
* To change this template, choose Tools ......

java swing ×é¼þ

JCheckBox: 
        ¸´Ñ¡¿ò;
JComboBox:
       ÏÂÀ­Áбí;
JTextField:
         ÔÊÐí±à¼­µ¥ÐÐÎı¾;
JTextArea: 
        ÔÊÐí±à¼­µÄ¶àÐÐÎı¾ÇøÓò;
JTextPa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ