java发芽访谒access数据库
2 K+ W& d; I+ C$ L$ npackage chapter10;5 E; T0 X% j* ?/ o9 v9 P
import java.sql.*;+ M+ E. s. X: q+ N4 f: `
public class AccessData {/ X2 l( I. P( o. J6 ?3 p
public AccessData()
4 a' j8 U6 w3 d. P5 k{6 x; ~$ _9 `$ d8 Q6 i: b7 z
}
7 ]) q6 t5 f& l9 h* C" z: Xpublic static void main(String[] args) {
1 [( W& @# Q( m( g5 u5 Enew AccessData();& ]* b5 \% ]$ H6 k: D% ? F
String url=“jdbc:odbc:mydbaccess”;
/ R6 ]; r; t9 {' JString query,name,mark;
* q y6 F8 }5 |" o' ^! I/ x# m- }Connection conn=null;
3 t; E# _+ o: `Statement statement=null;' {/ h2 N, i& `. B$ S5 r, h
ResultSet resultSet=null; {4 b6 e6 y2 G5 T! C3 N
try{
, ~9 D( f9 [' a% h: s5 NClass.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);$ F5 K: K6 R9 l/ f, K7 D9 E
conn=DriverManager.getConnection(url);+ \* u# Z- w W* X
statement=conn.createStatement();
+ B. d% L7 f6 F0 N/ uquery=“select * from student”;
: m' e# C' \. m, ^% M- g4 `* CresultSet=statement.executeQuery(query);
% [! u! x5 n% C8 p+ W# Z; rwhile(resultSet.next())
0 ^- Z( f& E5 X{$ t- e4 T- Y8 r) [1 f+ ^1 C
name=resultSet.getString(“name”);) ?3 Q! i0 i. ]; J' G2 N' G
mark=resultSet.getString(“mark”);
$ O3 j5 t; |, M+ @ y6 ^System.out.print(“姓名: ”+name);
# k. H1 ^# f9 Q* R; GSystem.out.println(“ 分数: ”+mark);
9 @- q1 \8 {/ t5 q( r( @}
$ M( B7 L# Q, l( c+ ]4 G2 O}
* `! H- n* P! U# L t8 {6 F; Qcatch(SQLException e)
7 r/ i5 {9 T4 K. W{+ W; W' a6 U. x; h3 f. W
e.printStackTrace();' ~: s l+ _" t w! b' o
}
9 w0 |& u$ B7 w) Y9 k b& Rcatch(Exception e)4 n0 F/ W4 H$ J4 K9 K& \
1 O+ p4 n0 G' |/ X' N1 F: R$ @{ |