String URL="jdbc:oracle:Stest";
Connection con=DriverManager.getConnection(URL,"scott","tiger");
抛出这个异常,
java.sql.SQLException: Sub Protocol must be specified in connection URL
该怎么办呀???
Connection con=DriverManager.getConnection(URL,"scott","tiger");
抛出这个异常,
java.sql.SQLException: Sub Protocol must be specified in connection URL
该怎么办呀???
用到的库为classes12.jar
private static Connection conn = null;
public Connection connectDatabase() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:Stest",
"scott",
"tiger");
} catch (Exception ex) {
ex.printStackTrace();
} finally {
return conn;
}
}
public static void main(String args[]) throws SQLException {
OracleDal orac = new OracleDal();
Connection conn = orac.connectDatabase();
Statement stmt=conn.createStatement();
String strSQL = "select * from FSys_UserCompany";
ResultSet rs=stmt.executeQuery(strSQL);
while(rs.next())
{
System.out.println(rs.getString("CompanyName"));
System.out.println(rs.getString("CompanyID"));
}
关闭连接、释放资源
rs.close();
stmt.close();
conn.close();
}
连接方式: thin 还有一种我忘记了
@主机地址:可以是localhost也可以是IP
数据库全局名称(SIDName):可以在ORCALE配制文件中找到 可以修改,修改以后要重新开监听器SIDNam才会起作用
conn =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:Stest",
"scott",
"tiger");
它们的URL格式如下:
drivername:@driver_information
1.drivername主要有以下两种
jdbc:oracle:thin (thin驱动程序)
jdbc:oracle:oci (oci驱动程序)
2.driver_information
host_nameort:database_sid
连接方式: thin 还有一种我忘记了
@主机地址:可以是localhost也可以是IP
数据库全局名称(SIDName):可以在ORCALE配制文件中找到 可以修改,修改以后要重新开监听器SIDNam才会起作用
Connection connection=null;
try {
Class.forName("oracle.jdbc.OracleDriver");
connection = DriverManager.getConnection(connectionURL, username,
password);
log.info("Connection ok!");
} catch (ClassNotFoundException e) {
log.error(e.toString());
} catch (SQLException e) {
log.error(e.toString());
}
Connection connection=null;
try {
Class.forName("oracle.jdbc.OracleDriver");
connection = DriverManager.getConnection(connectionURL, username,
password);
log.info("Connection ok!");
} catch (ClassNotFoundException e) {
log.error(e.toString());
} catch (SQLException e) {
log.error(e.toString());
}