create.java

来自「oracle的sqlplusworksheet」· Java 代码 · 共 76 行

import java.sql.*;
public class Create {
    String sql=null;
    Conn conn=null;
    String result=null;
    Create(String sql,Conn conn)
    {
        this.sql=sql;
        this.conn=conn;
    }
    public String createMethod()
    {
        if(sql.substring(7, 12).equals("table"))
        {
            try {
                conn.stmt.executeUpdate(sql);
                result="\n" + "表已创建";
                //return result;
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(7, 11).toLowerCase().compareTo("user")==0)
        {
            try {
                conn.stmt.executeUpdate(sql);
               result="\n" + "用户已创建";
               //return result;
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(7, 11).toLowerCase().compareTo("view")==0||sql.substring(7, 22).toLowerCase().compareTo("or replace view")==0||sql.substring(7, 23).toLowerCase().compareTo("force view")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "视图已创建";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(7, 14).toLowerCase().compareTo("synonym")==0||sql.substring(7, 25).toLowerCase().compareTo("or replace synonym")==0||sql.substring(7, 32).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(7,15).toLowerCase().compareTo("sequence")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "序列已创建";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        else if(sql.substring(7,12).toLowerCase().compareTo("index")==0||sql.substring(7,19).toLowerCase().compareTo("unique index")==0||sql.substring(7,19).toLowerCase().compareTo("bitmap index")==0)
        {
            try
            {
                conn.stmt.executeUpdate(sql);
                result="\n" + "索引已创建";
            } catch (Exception ex) {
                result="\n" + ex.getMessage();
            }
        }
        return result;
    }
}