Myeclipse6.0连接Oracle10g数据库实例源码-CSDN博客

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class oracle{
public static final String racleDriverName = "oracle.jdbc.driver.OracleDriver";
public static void main(String []args)
{

  try{
   Class.forName(oracleDriverName);
   String racleUrlToConnect = "jdbc:oracle:thin:@PC-201009240853:1521:orcl";
   String user="scott";
   String password="a126";
   Connection myConnection=DriverManager.getConnection(oracleUrlToConnect,user,password);
   Statement st=myConnection.createStatement();
   ResultSet rs=st.executeQuery("select * from emp");
   while(rs.next())
   {
    System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)
     +"\t"+rs.getString(5)+"\t"+rs.getString(6));
   }
  }catch(Exception e)
  {
   e.printStackTrace();
   System.out.println(e.getStackTrace());
  }
}
}