linuxÏÂjavaÈçºÎ¶ÁÈ¡accessÊý¾Ý¿âÎļþ
×î½üÏîÄ¿ÐèÒªÔÚredhat el4ÏÂͨ¹ýjava¶ÁÈ¡accessÊý¾Ý,ÓÉÓÚÒµÎñÔÒò,Ö»ÄÜÓÃaccessÊý¾Ý¿â.ÔÚÍøÉÏÕÒÁËһЩ·½·¨,µ«¶¼Ê§°Ü.
ÇëÎÊÓÐûÓÐ×ö¹ýÕâ·½ÃæµÄ¸ßÊÖ¸ø¸ö½â¾ö°ì·¨,»òÓгɹ¦µÄ°²×°¹ý³ÌÒ²¿É
ÒѰ²×°¹ýunixodbc,mdbtools,mdbtools-odbc
ÎҵĴúÂëÒ»Ö±Ö´ÐÐʧ°Ü,ÊÇ·ñ´úÂëÓÐÎÊÌâ:
*************************************
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class RAccess{
public static void main(String[] args){
try{
Driver driver = (Driver) Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
DriverManager.registerDriver(driver);
Connection connection = DriverManager.getConnection(args[0]);
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
ResultSet set = statement.executeQuery("SELECT * from RECORD");
while(set.next()){
System.out.println(set.getObject(1));
}
set.close();
statement.close();
Ïà¹ØÎÊ´ð£º
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
¸÷λ´ó¸ç:
ÏîÄ¿ÖÐÓö¼ûÒ»¸öÄÑÌâ,ÄǾÍÊÇÈçºÎÔÚÐÞ¸ÄÊý¾Ý¿âÀïÃæµÄij¸ö×Ö¶ÎÊÇÄܲúÉúÒ»¸öÏûÏ¢,ʵʱÌáÐѵ½Ê×Ò³ÄØ?
¶øÇÒ¿Í»§ÒªÇó¿ÉÒÔ×Ô¼º¶¨ÖÆÄÄЩ×Ö¶Î,±ÈÈçÓÐA,B,C×Ö¶Î,ÎÒ¿ÉÒÔÑ¡ÔñÆäÖÐÒ»¸ö»òÁ½¸ö×Ö¶Î,µ±ÕâÁ½¸ö×Ö¶Î ......