Java连接Oracle数据库

import java.sql.*;
public class linkdatabase
    {
    public static void main(String []args)throws Exception
        {
        Class.forName("oracle.jdbc.OracleDriver");
        String ur1="jdbc:oracle:thin:@192.168.10.111:1521:basic";
        //修改相应的IP及SID为自己的
        java.sql.Connection cn=DriverManager.getConnection(ur1,"yn","112233");
        //修改相应的数据库访问用户名和密码为自己的
        Statement stat=cn.createStatement();
        ResultSet rs=stat.executeQuery("select * from H");
        //修改相应的表及表中字段结构为自己的(本例的表为H,表中有三个字段)
        while(rs.next())
            {
            System.out.println(rs.getString("id"));
            System.out.println(rs.getString("name"));
            System.out.println(rs.getString("nr"));
            }
        stat.close();
        cn.close();
        }
    }