帮我写个java版本的访问Oracle数据库代码
时间: 2023-03-13 08:30:47 浏览: 44
我可以给你一些参考代码:import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class OracleDBExample { public static void main(String[] args) {
// Connection string
String hostName = "hostname";
String sid = "database_name";
String user = "username";
String password = "password";
String url = "jdbc:oracle:thin:@" + hostName + ":" + sid; try {
// Get the connection
Connection conn = DriverManager.getConnection(url, user, password);
// Create a Statement
Statement stmt = conn.createStatement();
// Execute the query
ResultSet rs = stmt.executeQuery("SELECT * FROM table_name");
// Fetch the data and print it
while (rs.next()) {
System.out.println(rs.getString("column_name"));
}
// Close the connection
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}