连接Oracle数据库示例

查询数据库：

import java.sql.*;
import oracle.jdbc.OracleDriver;
import oracle.i18n.*;
public class Conn_Oracle {
    public static void main(String[] args) {
        Connection conn=null; //连接对象
        Statement stmt=null; //语句对象
        ResultSet rs=null; //结果集对象

     String driverClassName = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@202.200.119.143:1521:orcl";
        String userName = "hdptdep";
        String passWord = "123456";
        String sql="select * from DYZWLXXXB order by ZWID";
        try{
            DriverManager.registerDriver(new OracleDriver()); //注册驱动程序
            conn=DriverManager.getConnection(url,userName,passWord);
            System.out.println(conn.isClosed()); //若Connection对象的isClosed()方法返回false，
            //那么表示数据库是打开的
            stmt=conn.createStatement();
            //执行查询语句
            rs=stmt.executeQuery(sql);
            while(rs.next()){
                System.out.println("-------------------------");
                System.out.println(rs.getInt(1)+""+rs.getString(2));
            }

            //关闭连接
            if(!conn.isClosed())
                conn.close();

        }catch(SQLException e){
            e.printStackTrace();
        }
    }
}