java web连oracle数据库,联接oracle数据库

Java codepackage zmy.db;

import java.sql.*;

public class DBUtil {

public static Connection getConnection() {

Connection conn = null;

try {

String driver = "oracle.jdbc.driver.OracleDriver";

String dbName = "dbname";

String dbURL = "jdbc:oracle:thin:@localhost:1521:";

String username = "scott";

String password = "triger";

Class.forName(driver).newInstance();

conn = DriverManager.getConnection(dbURL + dbName, username,

password);

} catch (SQLException e) {

e.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public static boolean closeConnection(Connection conn) {

try {

conn.close();

return true;

} catch (SQLException e) {

e.printStackTrace();

return false;

} catch (Exception e) {

e.printStackTrace();

return false;

}

}

}

------解决方案--------------------Java codepackage zmy.db;

import java.sql.*;

public class DBUtil {

public static Connection getConnection() {

Connection conn = null;

try {

String driver = "oracle.jdbc.driver.OracleDriver";

String dbName = "dbname";

String dbURL = "jdbc:oracle:thin:@localhost:1521:";

String username = "scott";

String password = "triger";

Class.forName(driver).newInstance();

conn = DriverManager.getConnection(dbURL + dbName, username,

password);

} catch (SQLException e) {

e.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public static boolean closeConnection(Connection conn) {

try {

conn.close();

return true;

} catch (SQLException e) {

e.printStackTrace();

return false;

} catch (Exception e) {

e.printStackTrace();

return false;

}

}

}