Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install oracle database Cloud Virtual Machine". In daily operation, I believe many people have doubts about how to install oracle database Cloud Virtual Machine. Xiaobian consulted all kinds of materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to install oracle database Cloud Virtual Machine"! Next, please follow the small series to learn together!

download resources

First, find the Oracle installation directory from the database server where Oracle is installed, and then copy the jdbc\lib\classes12.jar file in this directory to a directory of the WEB publishing server. Suppose you put it directly in the C:\root directory, and then add the path to the system--advanced--environment variable named CLASSPATH? values, such as:

D:\Program Files\SQLLIB\java\db2java.zip;D:\Program Files\SQLLIB\java\runtime.zip;c:classes12.jar; That is, java can find this package.

Register Load Driver

Driver name: DRIVER="oracle.jdbc.driver.OracleDriver";

Class.forName("Driver Class Name");

obtain a connection

Database address: URL="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";

Connection conn = DriverManager.getConnection(database address, username, password);

System.out.println("Connect successfully");

Creating a Statement Object

The Statement class is primarily an object used to execute a static SQL statement and return the results it generates. A Statement object can be created through the createStatement() method of the Connection object. For example: Statement statement = connection.createStatement(); Specific examples Create Statement objects

Statement statamentMySQL =connectMySQL.createStatement();

At this point, the study of "how to install oracle database Cloud Virtual Machine" is over, I hope to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.