DriverManager.registerDriver(Driver driver)
Class.forName("DriverName");
String url = "jdbc:odbc:student"; //student是在数据源管理器中创建的数据源名字 Connection con = DriverManager.getConnection(url); //一下语句是采用了一种无数据源连接数据库的方式 con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver(*.mdb)}; DBQ=d:\\xsgl.mdb")
package com.bjpowernode.java_learning; import java.sql.Statement; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; public class D134_1_JDBCConnection { public static void main(String[] args) { Statement stmt = null; ResultSet rs = null; Connection conn = null; try { //1.注册数据库的驱动程序 Class.forName("com.hxtt.sql.access.AccessDriver"); //2.通过DriverManager获取数据库连接 conn = DriverManager.getConnection("jbdc:Access:///e:xsgl.mdb"); //3.通过Connection对象获取Statement对象 stmt = conn.createStatement(); //4.使用Statement执行SQL语句 String sql = "select * from studentInfo"; rs = stmt.executeQuery(sql); //5.操作ResultSet结果集 System.out.println("studentID | studentName | studentSEX"); while(rs.next()) { int id = rs.getInt("studentID");//通过列名获取指定字段的值 String name = rs.getString("studentName"); String psw = rs.getString("studentSEX"); System.out.println(id + " | " + name + " | " + psw); } }catch(Exception e) { e.printStackTrace(); }finally { //6.回收数据库资源 if (rs != null) { try { rs.close(); }catch(SQLException e) { e.printStackTrace(); } rs = null; } if(stmt != null) { try { stmt.close(); }catch(SQLException e) { e.printStackTrace(); } stmt = null; } if (conn != null) { try { conn.close(); }catch(SQLException e) { e.printStackTrace(); } conn = null; } } } }
原文链接:https://www.cnblogs.com/ruigege0000/p/13460865.html