java- JDBC连接各种数据库小结

关注

原创最新推荐文章于 2026-04-12 10:36:20 发布 514 阅读 AI 写同款· GEO 优化 ›

Java JDBC连接Oracle详解一）JDBC简介 JDBC是一种数据库连接，全称Java Database Connectivity，简称JDBC。作用：主要是用来规范客户端如何访问数据库的应用程序接口，提供了增删改查等API接口。 API概述： DriverManager：负责加载各种不同的驱动，并返回对应的数据库连接。 Connection：数据库连接，负责和数据库通讯。 PreparedStatemen... 阅读详情

JDBC连接--Mysql

private static final String driver = "com.mysql.jdbc.Driver";
private static final String dbURL = "jdbc:mysql://localhost:3306/studb";
private static final String user = "root";
private static final String password = "123456";

JDBC连接--Orcal

private static final String driver = "oracle.jdbc.driver.OracleDriver";
private static final String dbURL = "jdbc:oracle:thin:@localhost:1521:ORCL";
private static final String user = "newuser";
private static final String password = "newuser";

JDBC连接--Access

private static final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
private static final String dbURL="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=access数据库文件位置";

JDBC连接--Sqlserver
private static final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;databaseName";
private static final String user = "newuser";
private static final String password = "newuser";