drop.java

查询分析器java

import java.sql.*;
public class Drop {
    String sql=null;
    Conn conn=null;
    String result=null;
    Drop(String sql,Conn conn)
    {
        this.sql=sql;
        this.conn=conn;
    }
    public String dropMethod()
    {
        if(sql.substring(5, 10).equals("table"))
        {
            try {
                conn.stmt.executeUpdate(sql);
                result="\n" + "表已丢弃";
                //return result;
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(5, 9).toLowerCase().compareTo("user")==0)
        {
            try {
                conn.stmt.executeUpdate(sql);
                result="\n" + "用户名已丢弃";
               //return result;
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(5, 9).toLowerCase().compareTo("view")==0||sql.substring(5, 19).toLowerCase().compareTo("or replace view")==0||sql.substring(5, 14).toLowerCase().compareTo("force view")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "视图已丢弃";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(5, 11).toLowerCase().compareTo("synonym")==0||sql.substring(5, 22).toLowerCase().compareTo("or replace synonym")==0||sql.substring(5, 29).toLowerCase().compareTo("or replace public synonym")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "同义词已丢弃";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(5,12).toLowerCase().compareTo("sequence")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "序列已丢弃";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(5,9).toLowerCase().compareTo("index")==0||sql.substring(5,16).toLowerCase().compareTo("unique index")==0||sql.substring(5,16).toLowerCase().compareTo("bitmap index")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "索引已丢弃";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        return result;
    }

}