你要先把oracle的JDBC驱动装上
这就是URL
"jdbc:oracle:thin:@192.168.0.24:1521@log"
意思为
用JDBC方式:是oracle:用thin方式连接:@主机IP:端口号@SID
然后试一下这个import java.sql.*;
public class DBconn {
String DBDriver = "oracle.jdbc.driver.OracleDriver()";
String ConnStr = ("jdbc:oracle:thin:@192.168.0.24:1521@log");
Connection conn = null;
ResultSet rs = null;
public DBconn {
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//与DBMS建立连接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage()); return rs;
}
}
}
这就是URL
"jdbc:oracle:thin:@192.168.0.24:1521@log"
意思为
用JDBC方式:是oracle:用thin方式连接:@主机IP:端口号@SID
然后试一下这个import java.sql.*;
public class DBconn {
String DBDriver = "oracle.jdbc.driver.OracleDriver()";
String ConnStr = ("jdbc:oracle:thin:@192.168.0.24:1521@log");
Connection conn = null;
ResultSet rs = null;
public DBconn {
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//与DBMS建立连接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage()); return rs;
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货