java发芽访谒access数据库
& `* s) D6 N( ]package chapter10;
, b' H$ C- `3 s& p: A8 Uimport java.sql.*;5 ~/ Y3 u0 [ U. o8 X. T" c s1 x
public class AccessData {9 p5 d" k5 i: O+ ~ `6 a
public AccessData()
9 I# V; I( Z$ y3 x# t2 m/ a2 g6 [6 ^{6 N1 a) R& Y8 u$ M. x+ d) s
}( {" w) G w/ ]4 F5 q
public static void main(String[] args) {) ^) C0 W6 J) x! D
new AccessData();
2 V, f( t$ x% Q Y) wString url=“jdbc:odbc:mydbaccess”;
+ k% t n, D+ }5 W0 t8 X8 z% ?String query,name,mark;" X5 X8 z1 ?+ N2 g# F% v
Connection conn=null;
0 _9 O! I9 Z( K0 U* [$ u- M, v4 Q8 x9 oStatement statement=null;# V& l- A* L7 h; Q
ResultSet resultSet=null;
/ C' X0 Q. h) ^6 k* p5 M+ ztry{
: F9 ]& q9 A2 J5 T( u* I! Y, _Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);' s7 ^ C: Y- S/ f4 |! u
conn=DriverManager.getConnection(url);
( d% M+ J+ S- t$ q6 [statement=conn.createStatement();
# D, k' v6 r8 c9 _# k) yquery=“select * from student”;
& k1 v0 K, m% [+ l4 n, eresultSet=statement.executeQuery(query);
$ J( ]* r- k. l: {while(resultSet.next()). K$ C2 W$ c7 M, f I* I
{
, g* M3 y4 \% X1 F R7 ]& yname=resultSet.getString(“name”);, c6 h1 i, ^% {
mark=resultSet.getString(“mark”);) Q- p2 l$ U7 x) B
System.out.print(“姓名: ”+name);
- R ]1 N+ [1 [! vSystem.out.println(“ 分数: ”+mark);+ u) i" W9 h9 n0 o
}3 Y3 C; S, s) j) ~4 r8 W, w
}" u# D9 i3 h1 o) L0 W9 f! s. @
catch(SQLException e)- I/ H- g/ o( b; R2 X
{
' Z% A( s' p& we.printStackTrace();
5 m4 }1 B x: q; m0 \}
7 h6 j6 w# S. B4 b' J' _catch(Exception e)
: [7 m+ B- e1 h
\5 o( }0 k) d, T) o{ |