java连接oracle数据库

1.DBUtil.java

//DBUtil.javaimport java.io.IOException;import java.io.InputStream;import java.sql.*;import java.util.Properties;public class DBUtil {private static Connection connection=null;private static Properties properties=null;static {properties=getProperties();try {Class.forName(properties.getProperty(\"driverClass\"));} catch (ClassNotFoundException e) {e.printStackTrace();}}public static Properties getProperties(){InputStream is=DBUtil.class.getClassLoader().getResourceAsStream(\"db.properties\");Properties p=new Properties();try {p.load(is);} catch (IOException e) {e.printStackTrace();}return p;}public static Connection getConnection(){try {String url=properties.getProperty(\"url\");String user=properties.getProperty(\"user\");String password=properties.getProperty(\"password\");connection= DriverManager.getConnection(url, user, password);}  catch (SQLException e) {e.printStackTrace();}return connection;}public static void main(String[] args) {System.out.println(getConnection());}public static void JDBCClose(Connection connection, Statement statement, ResultSet rs){if (connection!=null){try {connection.close();} catch (SQLException e) {e.printStackTrace();}}if (statement!=null){try {statement.close();} catch (SQLException e) {e.printStackTrace();}}if (rs!=null){try {rs.close();} catch (SQLException e) {e.printStackTrace();}}}}

2.db.properties

driverClass=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@x.x.x.x（ip地址）:1521（端口号）:XEuser=xx(用户名)password=123456