Question

Java连接Oracle数据库的连接字符串怎么写？

。。。

Answer 1

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:@localhost:1521:orcl";
String user = "sa";
String password = "123456";
Connection conn = DriverManager.getConnection(url,user,password);

Answer 2

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

public class OraclTest
{
public static void main(String[] args)
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
//oracle IP地址+端口号/recruit
String url = "jdbc:oracle:thin:@192.168.8.19:1521:recruit";
Connection con = DriverManager.getConnection(url,"username","password");
con.close();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}

}
}

Answer 3

c = DriverManager.getConnection("jdbc:oracle:thin:@10.23.45.67:1521:agent","username","password");