import java.sql.*;
public class dbtest{
    public static void main(String[] args) throws Exception
    {
      int i=0;
      String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
      Class.forName("oracle.jdbc.OracleDriver");
  
      Connection conn = DriverManager.getConnection(url, "tt", "tt");
      ResultSet rs = null;
      PreparedStatement pstmt = null;
      String sql = "SELECT * FROM PERSON";
      //String sql = "SELECT * FROM PERSON where id ='lxh'";
      try{
      pstmt = conn.prepareStatement(sql);
      //pstmt.setString(1, "lxh");//设置上边第一个问号里填的值
      rs = pstmt.executeQuery();
      while(rs.next())
      {
    i++;
    System.out.println("第"+i+"行数据");
    System.out.print(rs.getString("id")+" ");
    System.out.print(rs.getString("name")+" ");
    System.out.print(rs.getString("password")+" ");
    System.out.print("\n");
      }
  }
  finally{
      if(rs != null){
    try{rs.close();}catch(SQLException e){}
      }
      if(pstmt != null){
    try{pstmt.close();}catch(SQLException e){}
      }
      if(conn != null){
    try{conn.close();}catch(SQLException e){}
      }
  }
    }
}