Java连接Access数据库应用.docxVIP

Access 数据库 public  class  myJDBC { public  static  void  main(String arg[]){ selectAll  (); } // 获得 SQL Server  数据库连接  pass public static Connection getAccessConnection(){ Connection conn = null ; try { Class. forName ( sun.jdbc.odbc.JdbcOdbcDriver  ); String  dbur1  = jdbc:odbc:TicketSystem  ; //  此为 ODBC 连接方式 username  conn = null ; conn = DriverManager. , password );  getConnection  (dbur1, } catch (Exception e){ e.printStackTrace(); } return conn; } //  查询表中所有数据，测试通过 public static void selectAll(){ Connection con = getAccessConnection String sql = select * from Persons try { Statement stm = con.createStatement(); ResultSet rs = stm.executeQuery(sql); while (rs.next()){ System. out .println(rs.getString(1)+ +rs.getInt(2)+ +rs.getString(3)); } stm.close(); con.close(); } catch (SQLException e) { e.printStackTrace();  (); ;  } try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } // 新建表，测试通过 public static void createTable(){ Connection con = getAccessConnection (); String sql = create table Persons(name varchar(10), age int, gender varchar(2)) ; try { Statement stm = con.createStatement(); stm.execute(sql); stm.close(); con.close(); } catch (SQLException e) { e.printStackTrace(); } try { con.close(); } catch (SQLException e) { } e.printStackTrace(); } // 删除表，测试通过 public static void dropTable(){ Connection con = getAccessConnection (); String sql = drop table Persons ; try { Statement stm = con.createStatement(); stm.execute(sql); stm.close(); con.close(); } catch (SQLException e) { e.printStackTrace(); } try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } // 通过姓名查询记录，测试通过 public static void selectInfo(String name){ Connection con = getAccessConnection (); String sql = select * from Persons where name = +name+ ; try { Statement stm = con.createStatement(); ResultSet rs = stm.executeQuery(sql); while (rs.next()){ System. out .println(rs.getString(1)+ +rs.getInt(2)+ +rs.getString(3));  } stm.close();