?? linkaccess.java
字號:
//linkaccess.java:不配置ODBC數(shù)據(jù)源,用JDBC-ODBC橋連接Access數(shù)據(jù)庫
import java.sql.*;
class linkaccess{
public static void main (String args[]) throws Exception{
Connection con;
Statement stmt;
try{
//Load JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//注意DBQ的寫法
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\jdk1.3.1\\javaprograms\\jdbc.mdb";
con = DriverManager.getConnection(url,"sa","");
stmt = con.createStatement();
String query = "select * from userInfo where name = 'bi'";
ResultSet rs = stmt.executeQuery(query);
while ( rs.next() )
{
System.out.print("connecting is ok" );
}
//close db
try{
if(!con.isClosed())
con.close();
}catch(SQLException err){
System.err.println(err.toString());
}
}
catch( Exception e ){
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -