JDBC连接Oracle 11g
1.简单查询 打印结果
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class ConnectionOracle {public static void main(String[] args){try{Class.forName("oracle.jdbc.OracleDriver");String url="jdbc:oracle:thin:@127.0.0.1:1521:king11g";String name="programmer";String pass="password";String sqlStr="select username,email from o_user";Connection conn=DriverManager.getConnection(url,name,pass);Statement stmt=conn.createStatement();ResultSet resultSet=stmt.executeQuery(sqlStr);while(resultSet.next()){String str1=resultSet.getString(1);String str2=resultSet.getString(2);System.out.println(str1+" "+str2);}if(resultSet!=null){resultSet.close();}if(stmt!=null){stmt.close();}if(conn!=null){conn.close();}}catch(SQLException se){se.printStackTrace();}catch(ClassNotFoundException ce){ce.printStackTrace();}}}