oracle jdbc案例,JAVA中JDBC方式访问ORACLE的简单案例

package com.broada.email.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUtil {

/**

* 获取链接

*

* @return

*/

public static Connection getConnection() {

Connection conn = null;

String url = "jdbc:oracle:thin:@192.168.22.220:1521:orcl";

String username = "system";

String password = "broada";

try {

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

conn = DriverManager.getConnection(url, username, password);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static void main(String[] args) {

Connection conn = getConnection();

ResultSet rs = null;

String sql = "select * from VERSION";

PreparedStatement ps = null;

try {

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

while (rs.next()) {

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

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

} 此程序需要oracle-jdbc.jar包