Home Database Mysql Tutorial JAVA连接Oracle的代码

JAVA连接Oracle的代码

Jun 07, 2016 pm 04:20 PM
java oracle code connect

最新做了一个连接Oracle的代码,要配好环境变量: ClassPath=.;E:j2sdk14lib ools.jar;E:oracleora90jdbclibclasses12.zip 测试的电脑已经装好Oracle客户端,而且用SQLplus可以连接上。 /* * This sample shows how to list all the names from the EMP tabl

  最新做了一个连接Oracle的代码,要配好环境变量: ClassPath=.;E:j2sdk14lib ools.jar;E:oracleora90jdbclibclasses12.zip

  测试的电脑已经装好Oracle客户端,,而且用SQLplus可以连接上。

  /*

  * This sample shows how to list all the names from the EMP table

  *

  * It uses the JDBC THIN driver. See the same program in the

  * oci8 samples Directory to see how to use the other drivers.

  */ // You need to import the Java.sql package to use JDBC

  import java.sql.*; class Test

  {

  public static void main (String args [])

  throws SQLException

  {

  // Load the Oracle JDBC driver

  DriverManager.registerDriver(new oracle.jdbc.OracleDriver());

  /* try{

  Class.forName("oracle.jdbc.driver.OracleDriver");

  }catch(Exception e){

  System.out.println("No Driver!");

  }

  */

  // Connect to the database

  // You must put a database name after the @ sign in the connection URL.

  // You can use either the fully specified SQL*net syntax or a short cut

  // syntax as ::. The example uses the short cut syntax.

  String url = "jdbc:oracle:thin:@172.28.31.85:1521:YIKATONG";

  String userName = "scott";

  String passWord = "tiger"; if (args.length > 0) url = args[0];

  if (args.length > 1) userName = args[1];

  if (args.length > 2) password = args[2];

  System.out.println(url);

  System.out.println(userName);

  System.out.println(password);

  Connection conn =

  DriverManager.getConnection (url, userName, password); // Create a Statement

  Statement stmt = conn.createStatement (); // Select the ENAME column from the EMP table

  ResultSet rset = stmt.executeQuery ("select * from Test"); // Iterate through the result and print the employee names

  while (rset.next ())

  System.out.println (rset.getString (1));

  }

  }

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Perfect Number in Java Perfect Number in Java Aug 30, 2024 pm 04:28 PM

Guide to Perfect Number in Java. Here we discuss the Definition, How to check Perfect number in Java?, examples with code implementation.

Random Number Generator in Java Random Number Generator in Java Aug 30, 2024 pm 04:27 PM

Guide to Random Number Generator in Java. Here we discuss Functions in Java with examples and two different Generators with ther examples.

Weka in Java Weka in Java Aug 30, 2024 pm 04:28 PM

Guide to Weka in Java. Here we discuss the Introduction, how to use weka java, the type of platform, and advantages with examples.

Smith Number in Java Smith Number in Java Aug 30, 2024 pm 04:28 PM

Guide to Smith Number in Java. Here we discuss the Definition, How to check smith number in Java? example with code implementation.

Java Spring Interview Questions Java Spring Interview Questions Aug 30, 2024 pm 04:29 PM

In this article, we have kept the most asked Java Spring Interview Questions with their detailed answers. So that you can crack the interview.

Break or return from Java 8 stream forEach? Break or return from Java 8 stream forEach? Feb 07, 2025 pm 12:09 PM

Java 8 introduces the Stream API, providing a powerful and expressive way to process data collections. However, a common question when using Stream is: How to break or return from a forEach operation? Traditional loops allow for early interruption or return, but Stream's forEach method does not directly support this method. This article will explain the reasons and explore alternative methods for implementing premature termination in Stream processing systems. Further reading: Java Stream API improvements Understand Stream forEach The forEach method is a terminal operation that performs one operation on each element in the Stream. Its design intention is

Java Made Simple: A Beginner's Guide to Programming Power Java Made Simple: A Beginner's Guide to Programming Power Oct 11, 2024 pm 06:30 PM

Java Made Simple: A Beginner's Guide to Programming Power Introduction Java is a powerful programming language used in everything from mobile applications to enterprise-level systems. For beginners, Java's syntax is simple and easy to understand, making it an ideal choice for learning programming. Basic Syntax Java uses a class-based object-oriented programming paradigm. Classes are templates that organize related data and behavior together. Here is a simple Java class example: publicclassPerson{privateStringname;privateintage;

Create the Future: Java Programming for Absolute Beginners Create the Future: Java Programming for Absolute Beginners Oct 13, 2024 pm 01:32 PM

Java is a popular programming language that can be learned by both beginners and experienced developers. This tutorial starts with basic concepts and progresses through advanced topics. After installing the Java Development Kit, you can practice programming by creating a simple "Hello, World!" program. After you understand the code, use the command prompt to compile and run the program, and "Hello, World!" will be output on the console. Learning Java starts your programming journey, and as your mastery deepens, you can create more complex applications.

See all articles