测试java连接Oracle数据库!
1.[代码][Java]代码
package com.just;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String args[]) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
String url = "jdbc:oracle:thin:@192.168.1.21:1521:CONG";
String userName = "CONG";
String password = "123123";
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);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from users");
while (rset.next())
System.out.println(rset.getString(1));
}
}