rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
static String DBURL = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=c:\\db3.mdb";
static String DBUSER = "";
static String DBPASSWORD = "";
static Connection conn = null;
public static void main(String[] args){
try{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from test");
while(rs.next()){
System.out.println(rs.getObject(1));
}
}catch(Exception e){
System.out.println(e);
}
}
odbc£¿Á¬
odbcÖ»ÓÐÔÚwindowϲÅÓеİ¡
liunxÏÂÄÄÀïÀ´µÄodbc
Ä㻹ÊÇÔÚÍøÉÏÕÒÕÒjdbcÁ¬½ÓaccessµÄÁÐ×Ó°É
linuxÏÂÊÇÓÐodbcµÄ£¬ºÇºÇ£¬²»¹ýÎÒûÕÒµ½acessµÄ
6Â¥ÓÐÏ£Íû
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
´úÂëÈçÏ £¬ÎÒÏëͨ¹ý´úÀí·ÃÎÊÒ»Ð©ÍøÖ·£¬µ«ÊDz»ÖªµÀÈçºÎ²âÊÔ´úÀí³É¹¦£¬ÎÒÏëͨ¹ý·ÃÎÊ¡°http://www.blogger.com/¡±À´¿´¿´ÊÇ·ñ´úÀí³É¹¦£¬µ«ÊÇÒ²²»ÄÜ·ÃÎÊ£¬³öÏÖÒì³£¡°Unexpected end of file from server¡±£¬µ«ÊÇÈç¹û²»Õâ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......