代码中包含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();