Java连接Oracle数据库代码范例

下载 http://mirrors.ibiblio.org/maven/mule/dependencies/maven1/oracle-jdbc/jars/ojdbc14.jar 导入到工程中。

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLTest {
	private final static String URL = "jdbc:oracle:thin:@192.168.0.80:1521:mgdb01";
	// private final static String URL = "jdbc:oracle:thin:@(description=(address_list=(address=(host=192.168.0.80)(protocol=tcp)(port=1521))(load_balance=yes)(failover=on))(connect_data=(service_name=mgdb01)))";
	private final static String USERNAME = "dbuser";
	private final static String PASSWORD = "dbpassword";

	public static void main(String[] args) {

		Connection connection = null;

		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

			String query = "select * from u_user";
			Statement statement = connection.createStatement();
			ResultSet rs = statement.executeQuery(query);

			while (rs.next()) {
				String userID = rs.getString("USER_ID");
				String nickName = rs.getString("USER_NICK_NAME");
				String password = rs.getString("USER_PASSWORD");
				System.out.println(userID + " " + nickName + " " + password);
			}
			rs.close();
			statement.close();

		} catch (Exception e) {
			try {
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}

			e.printStackTrace();
		}
	}
}