mysql及oracle的jdbc驱动使用

代码中包含mysql及oracle数据源和驱动

需先加载jar包

<!--oracle的驱动-->
<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc6 -->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>12.1.0.1-atlassian-hosted</version>
</dependency>

<!--mysql的驱动-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.47</version>
</dependency>

实现查询代码

//配置信息
//useUnicode=true&characterEncoding=utf-8 解决中文乱码
//mysql
String url="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
//oracle ORCL是SID名
String url="jdbc:oracle:thin:@localhost:1521:ORCL";
String username = "root";
String password = "123456";

//1.加载驱动
//mysql
Class.forName("com.mysql.jdbc.Driver");
//oracle
Class.forName("oracle.jdbc.driver.OracleDriver");

//2.连接数据库,代表数据库
Connection connection = DriverManager.getConnection(url, username, password);

//3.向数据库发送SQL的对象Statement,PreparedStatement : CRUD
Statement statement = connection.createStatement();

//4.编写SQL
String sql = "select * from tab_user";

//5.执行查询SQL，返回一个 ResultSet  ： 结果集
ResultSet rs = statement.executeQuery(sql);

while (rs.next()){
    System.out.println("id="+rs.getObject("userid"));
    System.out.println("name="+rs.getObject("userna"));
    System.out.println("password="+rs.getObject("passwd"));
}

//6.关闭连接，释放资源（一定要做） 先开后关
rs.close();
statement.close();
connection.close();