package com.gc.action;

public class gf {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		String sql = "select * from db.tbhm01";
		System.out.println(sql.toUpperCase().indexOf("FROM"));
		int startPos = sql.toUpperCase().indexOf("FROM") + 4;
		String strStart = sql.substring(startPos).trim();
		System.out.println(strStart);
		char[] sqlStr = strStart.toCharArray();
		int endPos = 0;
		for (int i = 0; sqlStr != null && sqlStr.length > i; i++) {
			if (" ".equals(String.valueOf(sqlStr[i])) || ",".equals(String.valueOf(sqlStr[i]))) {
				endPos = i;
				System.out.println(endPos);
				break;
		    } else {
		    	endPos = i + 1;
				System.out.println(endPos);
		    }
		}
		String table = strStart.substring(0, endPos);
		System.out.println(table);
	}

}