maven-mysql,oracle,sqlServer数据库连接器

最新推荐文章于 2021-05-26 10:55:32 发布

原创最新推荐文章于 2021-05-26 10:55:32 发布

· 565 阅读

1 ·

版权

文章标签：

#sql #jdbc

java 同时被 2 个专栏收录

66 篇文章

订阅专栏

12 篇文章

订阅专栏

本文详细介绍了如何使用Maven管理mysql、oracle和sqlServer的数据库驱动依赖，并提供了JDBC连接测试的示例代码，展示了如何通过Java进行数据库连接验证。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

maven坐标：

<!-- jdbc,mysql实现 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>
<!-- jdbc,oracle实现 -->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.1.0</version>
</dependency>
<!-- jdbc,sqlServer实现 -->
<dependency>
    <groupId>net.sourceforge.jtds</groupId>
    <artifactId>jtds</artifactId>
    <version>1.3.1</version>
</dependency>

注意：oracle数据库在maven中不存在，需要手动安装到本地

jdbc测试用例

package com.szhis.frsoft;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;

public class JdbcTest {

	@Test
	public void test_mysql() throws ClassNotFoundException, SQLException {
		String jdbcName = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/interview?useSSL=false";
		String username = "root";
		String password = "1234";

		Class.forName(jdbcName);
		Connection con = DriverManager.getConnection(url, username, password);
		if (con != null) {
			System.out.println("连接成功" + con);
		}

		//		Statement statement = con.createStatement();
		//		ResultSet resultSet = statement.executeQuery("select * from student");
		//		while (resultSet.next()) {
		//			System.out.println(resultSet.getString("stunm"));
		//		}
	}

	// jdbc连接oracle数据库
	@Test
	public void test_oracle() throws ClassNotFoundException, SQLException {
		String jdbcName = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@127.0.0.1:1521/orcl";
		String username = "jaden";
		String password = "1234";

		Class.forName(jdbcName);
		Connection con = DriverManager.getConnection(url, username, password);
		if (con != null) {
			System.out.println("连接成功" + con);
		}

		//		Statement statement = con.createStatement();
		//		ResultSet resultSet = statement.executeQuery("select * from \"t_person\"");
		//		while (resultSet.next()) {
		//			System.out.println(resultSet.getString("name"));
		//		}
	}

	// jdbc连接sql server数据库
	@Test
	public void test_mssql() throws ClassNotFoundException, SQLException {
		String jdbcName = "net.sourceforge.jtds.jdbc.Driver";
		String url = "jdbc:jtds:sqlserver://127.0.0.1:1433/interview";
		String username = "sa";
		String password = "1234";

		Class.forName(jdbcName);
		Connection con = DriverManager.getConnection(url, username, password);
		if (con != null) {
			System.out.println("连接成功" + con);
		}

		//		Statement statement = con.createStatement();
		//		ResultSet resultSet = statement.executeQuery("select * from student");
		//		while (resultSet.next()) {
		//			System.out.println(resultSet.getString("stunm"));
		//		}
	}

}