con= DriverManager.getConnection(url);</p> } catch (SQLException e) {4 m! C- l9 x* V; x1 j
// TODO Auto-generated catch block
& F: J. o' Y5 }( d+ | e.printStackTrace();' y0 C$ z% G" P3 b" K$ z5 w
}4 M/ V; Q. o& x; `9 N& u) f& U; D
return con;1 p8 i' b$ p0 X" p8 S& b5 P7 D
}
L; k8 H4 I! b5 h /**) ], ]! k: A8 U8 O
* @param args
8 t0 x+ F# H: _, r2 j, K */
. @4 q2 y4 b5 B' m/ ?8 H2 p public static void main(String[] args) {4 b# d4 Y1 a q; v0 l' f$ A
//得到连接
# n- R. V# x% W Connection con = ConnectionManager.getConnection();6 l: I8 i9 O- |# q* K9 }6 ~
try {! {- B% w( Z, r- Z, ~
PreparedStatement st = con.prepareStatement("select id,name from test1 ");
2 D# U6 H2 S1 k% H ResultSet rs = st.executeQuery();' m& u8 f& c% }
while (rs.next()){
7 E6 T5 s2 d: k9 V- { String id");
8 }- C0 T Y% S( D" I# h) w String name");
0 z6 B$ W2 d2 A# {: F( G+ y5 {$ S System.out.println("id:"+id+" name: "+name );
' D. t4 X% _& }/ {. X1 T) c }9 {* t1 B, T& _# Y
rs.close();* _) i" o" d; @9 X! q3 c% j2 x
st.close();7 k/ s" g/ L7 C
con.close();
k3 h( U: Y$ }( }! J } catch (SQLException e) {
q4 @' |. v$ } // TODO Auto-generated catch block
Q3 X# Y* z6 o' d e.printStackTrace();9 \' q2 c r' l3 \; t/ j
}
* k, O6 s; M! a2 R n4 g }- w- ?& ^( U0 v- I& W
} |