scanner.lex.java

有关JDBC的使用一些编程实例,有关与数据库连接的代码

			79, 79, 79, 79, 79, 79, 35, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 60, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 59, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 57, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 84, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 69, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			68, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 74, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 75, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 38, 79,
			79, 79, 79, 79, 79, 79, 40, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 63, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 70, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			72, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 42, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 44, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 82, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 46, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 48, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 50, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 51,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 52, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 81,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 79, 79, 79, 80, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 91,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		},
		{ -1, -1, -1, -1, -1, -1, -1, -1,
			-1, -1, 79, -1, -1, -1, -1, 79,
			79, 79, 79, 90, 79, 79, 79, 79,
			79, 79, 79, 79, 79, 79, 79, 79,
			79, 79, 79, 79, -1, 79 
		}
	};
	public token yylex ()
		throws java.io.IOException {
		byte yy_lookahead;
		int yy_anchor = YY_NO_ANCHOR;
		int yy_state = yy_state_dtrans[yy_lexical_state];
		int yy_next_state = YY_NO_STATE;
		int yy_last_accept_state = YY_NO_STATE;
		boolean yy_initial = true;
		int yy_this_accept;
		java.lang.String yytext;

		yy_mark_start();
		yy_this_accept = yy_acpt[yy_state];
		if (YY_NOT_ACCEPT != yy_this_accept) {
			yy_last_accept_state = yy_state;
			yy_mark_end();
		}
		while (true) {
			yy_lookahead = yy_advance();
			yy_next_state = YY_F;
			if (YYEOF != yy_lookahead) {
				yy_next_state = yy_nxt[yy_rmap[yy_state]][yy_cmap[yy_lookahead]];
			}
			if (YY_F != yy_next_state) {
				yy_state = yy_next_state;
				yy_initial = false;
				yy_this_accept = yy_acpt[yy_state];
				if (YY_NOT_ACCEPT != yy_this_accept) {
					yy_last_accept_state = yy_state;
					yy_mark_end();
				}
			}
			else {
				if (YYEOF == yy_lookahead && true == yy_initial) {

return (new token(sym.EOF));
				}
				else if (YY_NO_STATE == yy_last_accept_state) {
					throw (new Error("Lexical Error: Unmatched Input."));
				}
				else {
					yy_to_mark();
					yy_anchor = yy_acpt[yy_last_accept_state];
					if (0 != (YY_END & yy_anchor)) {
						yy_pushback();
					}
					if (0 != (YY_START & yy_anchor)) {
						yy_move_start();
					}
					yytext = yy_gettext();
					switch (yy_last_accept_state) {
					case 1:
						{ }
					case -2:
						break;
					case 2:
						{ return new token (sym.LPAREN); }
					case -3:
						break;
					case 3:
						{ return new token (sym.RPAREN); }
					case -4:
						break;
					case 4:
						{ return new token (sym.ASTERISK); }
					case -5:
						break;
					case 5:
						{ return new token (sym.COMMA); }
					case -6:
						break;
					case 6:
						{ return new token (sym.PERIOD); }
					case -7:
						break;
					case 7:
						{ return new str_token (sym.INT_NUM, yytext) ; }
					case -8:
						break;
					case 8:
						{ return new token (sym.SEMI); }
					case -9:
						break;
					case 9:
						{ return new str_token (sym.COMPARISON, yytext); }
					case -10:
						break;
					case 10:
						{ return new str_token (sym.NAME, yytext); }
					case -11:
						break;
					case 11:
						{ return new str_token (sym.STRING, 
                            yytext.substring(1, yytext.length() - 1)) ; }
					case -12:
						break;
					case 12:
						{ return new str_token (sym.STRING, 
                            yytext.substring(1, yytext.length() - 1)) ; }
					case -13:
						break;
					case 13:
						{ return new token (sym.AND); }
					case -14:
						break;
					case 14:
						{ return new token (sym.INTEGER); }
					case -15:
						break;
					case 15:
						{ return new token (sym.SET); }
					case -16:
						break;
					case 16:
						{ return new token (sym.CHARACTER); }
					case -17:
						break;
					case 17:
						{ return new token (sym.DROP); }
					case -18:
						break;
					case 18:
						{ return new token (sym.FROM); }
					case -19:
						break;
					case 19:
						{ return new token (sym.INTO); }
					case -20:
						break;
					case 20:
						{ return new token (sym.TABLE); }
					case -21:
						break;
					case 21:
						{ return new token (sym.WHERE); }
					case -22:
						break;
					case 22:
						{ return new token (sym.CREATE); }
					case -23:
						break;
					case 23:
						{ return new token (sym.DELETE); }
					case -24:
						break;
					case 24:
						{ return new token (sym.INSERT); }
					case -25:
						break;
					case 25:
						{ return new token (sym.SELECT); }
					case -26:
						break;
					case 26:
						{ return new token (sym.UPDATE); }
					case -27:
						break;
					case 27:
						{ return new token (sym.VALUES); }
					case -28:
						break;
					case 28:
						{ return new token (sym.NUMERIC); }
					case -29:
						break;
					case 30:
						{ return new str_token (sym.COMPARISON, yytext); }
					case -30:
						break;
					case 31:
						{ return new str_token (sym.NAME, yytext); }
					case -31:
						break;
					case 32:
						{ return new str_token (sym.STRING, 
                            yytext.substring(1, yytext.length() - 1)) ; }
					case -32:
						break;
					case 33:
						{ return new str_token (sym.STRING, 
                            yytext.substring(1, yytext.length() - 1)) ; }
					case -33:
						break;
					case 34:
						{ return new token (sym.INTEGER); }
					case -34:
						break;
					case 35:
						{ return new token (sym.CHARACTER); }
					case -35:
						break;
					case 37:
						{ return new str_token (sym.COMPARISON, yytext); }
					case -36:
						break;
					case 38:
						{ return new str_token (sym.NAME, yytext); }
					case -37:
						break;
					case 40:
						{ return new str_token (sym.NAME, yytext); }
					case -38:
						break;
					case 42:
						{ return new str_token (sym.NAME, yytext); }
					case -39:
						break;
					case 44:
						{ return new str_token (sym.NAME, yytext); }
					case -40:
						break;
					case 46:
						{ return new str_token (sym.NAME, yytext); }
					case -41:
						break;
					case 48:
						{ return new str_token (sym.NAME, yytext); }
					case -42:
						break;
					case 50:
						{ return new str_token (sym.NAME, yytext); }
					case -43:
						break;
					case 51:
						{ return new str_token (sym.NAME, yytext); }
					case -44:
						break;
					case 52:
						{ return new str_token (sym.NAME, yytext); }
					case -45:
						break;
					case 53:
						{ return new str_token (sym.NAME, yytext); }
					case -46:
						break;
					case 54:
						{ return new str_token (sym.NAME, yytext); }
					case -47:
						break;
					case 55:
						{ return new str_token (sym.NAME, yytext); }
					case -48:
						break;
					case 56:
						{ return new str_token (sym.NAME, yytext); }
					case -49:
						break;
					case 57:
						{ return new str_token (sym.NAME, yytext); }
					case -50:
						break;
					case 58:
						{ return new str_token (sym.NAME, yytext); }
					case -51:
						break;
					case 59:
						{ return new str_token (sym.NAME, yytext); }
					case -52:
						break;
					case 60:
						{ return new str_token (sym.NAME, yytext); }
					case -53:
						break;
					case 61:
						{ return new str_token (sym.NAME, yytext); }
					case -54:
						break;
					case 62:
						{ return new str_token (sym.NAME, yytext); }
					case -55:
						break;
					case 63:
						{ return new str_token (sym.NAME, yytext); }
					case -56:
						break;
					case 64:
						{ return new str_token (sym.NAME, yytext); }
					case -57:
						break;
					case 65:
						{ return new str_token (sym.NAME, yytext); }
					case -58:
						break;
					case 66:
						{ return new str_token (sym.NAME, yytext); }
					case -59:
						break;
					case 67:
						{ return new str_token (sym.NAME, yytext); }
					case -60:
						break;
					case 68:
						{ return new str_token (sym.NAME, yytext); }
					case -61:
						break;
					case 69:
						{ return new str_token (sym.NAME, yytext); }
					case -62:
						break;
					case 70:
						{ return new str_token (sym.NAME, yytext); }
					case -63:
						break;
					case 71:
						{ return new str_token (sym.NAME, yytext); }
					case -64:
						break;
					case 72:
						{ return new str_token (sym.NAME, yytext); }
					case -65:
						break;
					case 73:
						{ return new str_token (sym.NAME, yytext); }
					case -66:
						break;
					case 74:
						{ return new str_token (sym.NAME, yytext); }
					case -67:
						break;
					case 75:
						{ return new str_token (sym.NAME, yytext); }
					case -68:
						break;
					case 76:
						{ return new str_token (sym.NAME, yytext); }
					case -69:
						break;
					case 77:
						{ return new str_token (sym.NAME, yytext); }
					case -70:
						break;
					case 78:
						{ return new str_token (sym.NAME, yytext); }
					case -71:
						break;
					case 79:
						{ return new str_token (sym.NAME, yytext); }
					case -72:
						break;
					case 80:
						{ return new str_token (sym.NAME, yytext); }
					case -73:
						break;
					case 81:
						{ return new str_token (sym.NAME, yytext); }
					case -74:
						break;
					case 82:
						{ return new str_token (sym.NAME, yytext); }
					case -75:
						break;
					case 83:
						{ return new str_token (sym.NAME, yytext); }
					case -76:
						break;
					case 84:
						{ return new str_token (sym.NAME, yytext); }
					case -77:
						break;
					case 85:
						{ return new str_token (sym.NAME, yytext); }
					case -78:
						break;
					case 86:
						{ return new str_token (sym.NAME, yytext); }
					case -79:
						break;
					case 87:
						{ return new str_token (sym.NAME, yytext); }
					case -80:
						break;
					case 88:
						{ return new str_token (sym.NAME, yytext); }
					case -81:
						break;
					case 89:
						{ return new str_token (sym.NAME, yytext); }
					case -82:
						break;
					case 90:
						{ return new str_token (sym.NAME, yytext); }
					case -83:
						break;
					case 91:
						{ return new str_token (sym.NAME, yytext); }
					case -84:
						break;
					case 92:
						{ return new str_token (sym.NAME, yytext); }
					case -85:
						break;
					case 93:
						{ return new str_token (sym.NAME, yytext); }
					case -86:
						break;
					case 94:
						{ return new str_token (sym.NAME, yytext); }
					case -87:
						break;
					case 95:
						{ return new str_token (sym.NAME, yytext); }
					case -88:
						break;
					case 96:
						{ return new str_token (sym.NAME, yytext); }
					case -89:
						break;
					case 97:
						{ return new str_token (sym.NAME, yytext); }
					case -90:
						break;
					case 98:
						{ return new str_token (sym.NAME, yytext); }
					case -91:
						break;
					case 99:
						{ return new str_token (sym.NAME, yytext); }
					case -92:
						break;
					case 100:
						{ return new str_token (sym.NAME, yytext); }
					case -93:
						break;
					case 101:
						{ return new str_token (sym.NAME, yytext); }
					case -94:
						break;
					case 102:
						{ return new str_token (sym.NAME, yytext); }
					case -95:
						break;
					default:
						yy_error(YY_E_INTERNAL,false);
					case -1:
					}
					yy_initial = true;
					yy_state = yy_state_dtrans[yy_lexical_state];
					yy_next_state = YY_NO_STATE;
					yy_last_accept_state = YY_NO_STATE;
					yy_mark_start();
					yy_this_accept = yy_acpt[yy_state];
					if (YY_NOT_ACCEPT != yy_this_accept) {
						yy_last_accept_state = yy_state;
					}
				}
			}
		}
	}
}