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();
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......