FileDocCategorySizeDatePackage
LikeEscapeSyntax.javaAPI DocExample1767Thu Jun 14 17:50:24 BST 2001None

LikeEscapeSyntax

public class LikeEscapeSyntax extends Object

Fields Summary
Connection
conn
Constructors Summary
public LikeEscapeSyntax()

    try {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection(
      "jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");
    }
    catch (SQLException e) {
      System.err.println(e.getMessage());
      e.printStackTrace();
    }
Methods Summary
public voidexecuteSelect(java.lang.String sql)

    java.util.Date inactive_date = null;
    int            rows          = 0;
    ResultSet      rslt          = null;
    Statement      stmt          = null;

    System.out.println(sql);
    try {
      stmt = conn.createStatement();
      rslt = stmt.executeQuery(sql);
      while (rslt.next()) {
       rows++;
       System.out.println(rslt.getString(1));
      }
      System.out.println(Integer.toString(rows) + " rows selected");
      System.out.println(" ");
    }
    catch (SQLException e) {
      System.err.println(e.getMessage());
    }
    finally {
      if (rslt != null)
        try { rslt.close(); } catch (SQLException ignore) { }
      if (stmt != null)
        try { stmt.close(); } catch (SQLException ignore) { }
    }
protected voidfinalize()

    if (conn != null) 
      try { conn.close(); } catch (SQLException ignore) { }
    super.finalize();
public static voidmain(java.lang.String[] args)

    LikeEscapeSyntax iud = new LikeEscapeSyntax();

    iud.executeSelect(
     "select table_name " + 
     "from   all_tables " + 
     "where  table_name like '%\\_%' {escape '\\'}");