测试java连接Oracle数据库,javaoracle数据库,测试java连接Orac
分享于 点击 38626 次 点评:241
测试java连接Oracle数据库,javaoracle数据库,测试java连接Orac
测试java连接Oracle数据库!
[Java]代码
package cn.outofmemory;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)); }}
用户点评