通用SQL语句解析类SqlParser(JAVA版)
项目中已使用的一个比较简单的SQL语句查询字段解析工具类
java版本的SQL语句解析源代码,包含demo(zql)
SQL语句解析java包,含源代码:
SELECT ANTIQUEOWNERS.OWNERLASTNAME, ANTIQUEOWNERS.OWNERFIRSTNAME
FROM ANTIQUEOWNERS, ANTIQUES
WHERE ANTIQUES.BUYERID = ANTIQUEOWNERS.OWNERID AND ANTIQUES.ITEM = 'Chair';
Will result in a ZqlQuery structure.
ZqlQuery's getSelect(), getFrom() and getWhere() methods will extract the
SELECT, FROM and WHERE parts of the query.
getSelect() will return a Vector of ZSelectItem, data structures that give
information about the columns and/or operations requested (including
SQL expression support, like in SELECT a+b FROM num;).
getFrom() will return a Vector of ZFromItem, data structures that give
information about the tables involved in the query.
getWhere() will return a SQL expression, a data structure that represents
ANTIQUES.BUYERID = ANTIQUEOWNERS.OWNERID AND ANTIQUES.ITEM = 'Chair'
in the example above (the expression evaluator that comes with
Zql can evaluate such expressions, for a given data tuple).
封装好的一套javascript操作Excel的javabean
实现javascript操作Excel进行报表输出的javabean接口类,通过调用bean的方法快速生成客户端的javascript来操作Excel,实现读取Excel模板,添加记录,打印设置,打印预览,自动保存文件等功能,本人多年的web开发经验积累,吐血推荐大家下载回去研究研究。
java 实现成员方法的ajax自动注册类
java中使用Ajax的最简单实现,经典,绝对值得研究学习!
相关说明如下:
Xajax类功能描叙:Xajax将服务器端JavaBean中以on开始的函数生成客户端可供javascript调用的同名函数,从而实现 服务器端响应客户端事件进行处理的功.JavaBean中调用XajaxResponse生成XML文档返回客户端进行处理
调用方法:
Xajax ajax=new Xajax(request,response,URL);
ajax.registerClass(JavaBeanClassName);
ajax.processRequests();
ajax.getJavascript();//获取head嵌入head中的javascript语句
在JavaBean中以on开始的方法中,返回处理结果调用如下:
class testAjax{
public String onGetSampleInfomation(String param){
XajaxResponse resp=new XajaxResponse();
resp.addAlert(s);
return resp.getXML();
}
}