java實現(xiàn)連接access數(shù)據(jù)庫并讀取數(shù)據(jù)的操作

import?Java.sql.Connection; import?java.sql.DriverManager;  /** ?*?獲取Access連接 ?*? ?*?@author?dofun ?* ?*/ public?class?AccessDbUtil { ????public?static?Connection?getDbConnection() ????{ ????	//?數(shù)據(jù)庫url ????????String?url?=?"jdbc:Access:///E:ICD10.mdb"; ????????Connection?conn?=?null; ????????try ????????{ ????????	//?驅(qū)動加載 ????????????Class.forName("com.hxtt.sql.access.AccessDriver").newInstance(); ????????????conn?=?DriverManager.getConnection(url); ????????????return?conn; ????????} ????????catch?(Exception?e) ????????{ ????????????System.out.println("Access連接失敗"); ????????} ????????return?conn; ????} }

/** ?????*?同步疾病，手術(shù) ?????*? ?????*?@return ?????*/ ????@RequestMapping(value?=?"importJbbm") ????@ResponseBody ????public?String?importJbbm() ????{ ????	//?獲取數(shù)據(jù)庫連接 ????????Connection?conn?=?AccessDbUtil.getDbConnection(); ????????PreparedStatement?pst?=?null; ????????ResultSet?rs?=?null; ????????Boolean?a?=?true; ????????int?id?=?30000; ????????try ????????{ ????????????for?(int?i?=?1;?i?&gt;?0;?i++) ????????????{ ???????????????? ????????????????//?手術(shù) ????????????????pst?=?conn.prepareStatement("select?*?from?sJBBMML?where?id?&gt;?"?+?id?+?"?and?LB?=?'S'?"); ????????????????List<icdssbm>?jbs?=?new?ArrayList(); ???????????????? ????????????????rs?=?pst.executeQuery(); ????????????????while?(a?==?rs.next()) ????????????????{ ????????????????????if?(StringUtils.isNotBlank(rs.getString(2))) ????????????????????{ ????????????????????????IcdSsbm?jb?=?new?IcdSsbm(); ????????????????????????jb.setCode(rs.getString(2)); ????????????????????????jb.setName(rs.getString(5)); ????????????????????????jb.setType(rs.getString(11)); ????????????????????????jbs.add(jb); ????????????????????} ????????????????????else ????????????????????{ ????????????????????????a?=?false; ????????????????????????i?=?0; ????????????????????} ????????????????????//?System.out.println(rs.getString(2)); ????????????????????//?System.out.println(rs.getString(5)); ????????????????????//?System.out.println(rs.getString(11)); ????????????????} ????????????????if?(ListUtils.isNotEmpty(jbs)) ????????????????{ ????????????????????//?批量保存 ????????????????????icdSsbmService.saveBatch(jbs); ????????????????} ????????????????id?+=?1000; ????????????} ????????} ????????catch?(SQLException?e) ????????{ ????????} ????????finally ????????{ ????????????try ????????????{ ????????????????//?關(guān)閉資源 ????????????????rs.close(); ????????????????pst.close(); ????????????????conn.close(); ????????????} ????????????catch?(SQLException?e) ????????????{ ????????????} ????????} ????????return?"導入完成"; ????}</icdssbm>