?1 package ?login;
?2 import ?java.sql. * ;
?3
?4 // 連接數據庫；
?5 // aa?表示數據源名稱；
?6
?7
?8 public ? class ?DBcon? {
?9 ???? private ?Connection?con = null ;
10 ???? public ? void ?GetConn() {
11 ???????? try ? {
12 ????????????Class.forName( " sun.jdbc.odbc.JdbcOdbcDriver " );
13 ????????????con? = ?DriverManager.getConnection( " jdbc:odbc:aa " ,? " sa " ,? "" );
14 ????????????System.out.print( " open?is?ok " );
15 ????????} ? catch ?(SQLException?ex)? {
16 ????????????ex.printStackTrace();
17 ????????} ? catch ?(ClassNotFoundException?ex)? {
18 ????????????ex.printStackTrace();
19 ????????}
20
21 ????}
22 // 關閉數據庫連接
23 ???? public ? void ?CloseConn() {
24 ???????? try ? {
25 ???????????? if ?( ! con.isClosed())? {
26 ????????????????con.close();
27 ????????????????System.out.print( " close?is?ok " );
28 ????????????}
29 ????????} ? catch ?(SQLException?ex)? {
30
31 ????????????ex.printStackTrace();
32 ????????}
33 ????}
34 ? // 對數據庫進行增刪該的通用方法
35 ? // i?表示影響的行數
36 ???? public ? int ?Excute(String?sql) {
37 ???? int ?i = 0 ;
38 ???? try ? {
39 ????????Statement?sta? = ?con.createStatement();
40 ????????i? = ?sta.executeUpdate(sql);
41 ????} ? catch ?(SQLException?ex)? {
42 ????}
43 ???? return ?i;
44 ????}
45 ? // 對數據庫進行查詢的通用方法
46 ???? public ?ResultSet?Search(String?sql) {
47 ????ResultSet?rs = null ;
48 ???? try ? {
49 ????????Statement?sta? = ?con.createStatement();
50 ????????rs? = ?sta.executeQuery(sql);
51 ?????????System.out.print( " select?is?ok " );
52 ????} ? catch ?(SQLException?ex)? {
53 ????}
54 ???? return ?rs;
55 ????}
56 }
57
58