class BaseDAO {
private static final String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
private static final String driver = "oracle.jdbc.driver.OracleDriver";
private static final String user = "chen4568278";
private static final String pwd = "woairexue";
protected Connection conn;
protected Statement stmt; private void connect() {
useJDBC();
// useJNDI();
} private void useJNDI() {
try {
Context ctx = new InitialContext();
String strLookup = "java:comp/env/jdbc/hot";
DataSource ds = (DataSource)ctx.lookup(strLookup);
conn = ds.getConnection();
stmt = conn.createStatement();
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
} private void useJDBC() {
try {
loadDriver();
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
} catch (SQLException e) {
System.err.println("数据库连接错误!");
e.printStackTrace();
} } private void loadDriver() {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
System.err.println("驱动装载错误!");
e.printStackTrace();
}
} protected void close() {
try {
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
} protected ResultSet query(String sql) {
connect();
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
} protected void update(String sql) {
connect();
try {
stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
close();
}
}
public static void main(String[] args) {
new BaseDAO().connect();
}
}异常:数据库连接错误!
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
private static final String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
private static final String driver = "oracle.jdbc.driver.OracleDriver";
private static final String user = "chen4568278";
private static final String pwd = "woairexue";
protected Connection conn;
protected Statement stmt; private void connect() {
useJDBC();
// useJNDI();
} private void useJNDI() {
try {
Context ctx = new InitialContext();
String strLookup = "java:comp/env/jdbc/hot";
DataSource ds = (DataSource)ctx.lookup(strLookup);
conn = ds.getConnection();
stmt = conn.createStatement();
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
} private void useJDBC() {
try {
loadDriver();
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
} catch (SQLException e) {
System.err.println("数据库连接错误!");
e.printStackTrace();
} } private void loadDriver() {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
System.err.println("驱动装载错误!");
e.printStackTrace();
}
} protected void close() {
try {
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
} protected ResultSet query(String sql) {
connect();
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
} protected void update(String sql) {
connect();
try {
stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
close();
}
}
public static void main(String[] args) {
new BaseDAO().connect();
}
}异常:数据库连接错误!
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
端口:1521(默认的)
用户名:chen4568278
密码:woairexue