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();
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÏÖÔÚÓиöÃÅ»§ÍøÕ¾£¬ÓÃStruts1.2×öµÄ£¬Ö®Ç°Ã»ÓÃajax,ÏÖÔÚÏë½áºÏajax ¿ò¼Ü ÕûºÏÉý¼¶¡£
Struts1.2 ºÍÄǸöajax ¿ò¼ÜÕûºÏµÄ±È½ÏºÃ¡£ÕûºÏÖ®ºóÌý˵ajax Õ¼ÄÚ´æÊ²Ã´¶¼²»Ð¡£¬°üÒ²²»Ð¡£¬´ó¼ÒÌÖÂÛһϰ¡¡£
ajax Êǿͻ§¶ËµÄ¶ ......