import java.sql.*;

Connection conn;
ResultSet rs;
Statement stmt;
// tolstii client
conn= DriverManager.getConnection("jdbc:oracle:oci8:@" + srv, usr, pwd);
//tonkii client
conn= DriverManager.getConnection("jdbc:oracle:thin:@HOST:PORT:SID", USER, PWD);

stmt = conn.createStatement();
rs = stmt.executeQuery("Select * from table");
while(rs.next())
{
name= rs.getString(1);
}
udachi ;)