JDBC连接Oracle与MySQL的URL格式

Oracle：

import java.sql.*;
public class JDBC {
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//new oracle.jdbc.OracleDriver();
		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("select * from emp");
		while(rs.next()){
			System.out.println(rs.getString("sal"));
		}
		rs.close();
		stmt.close();
		conn.close();
		
		
	}
}

URL格式：jdbc：oracle：thin：@localhost：1521：orcl

1521为端口号，orcl为需连接的数据库名称，scott为用户名，tiger为密码。

MySQL

import java.sql.*;

public class find_sql {
	String result = "";
	public find_sql(){
		Statement stmt = null;
		Connection conn = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/booksmanagement", "root",
					"mysql");
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM tb_book");
			while (rs.next()){
				result += rs.getString("b_id")+"\t"+ rs.getString("b_name") +"\t"+ rs.getString("b_author") +"\t"+ rs.getString("b_state") +"\t"+ rs.getString("b_date") +"\t"+ rs.getString("b_stu") +"\n";
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			
		}
	}
}

URL格式：jdbc：mysql：//localhost：3306/booksmanagement

3306为端口号，booksmanagement为需连接的数据库名称，root为用户名，mysql为密码。

我是一个初学者，以上为我学习过程中遇到的问题，拿出来希望对初学者有帮助，可能有很多不足之处，希望大家批评指正，我定虚心改正。