基于jsqlparser做javacc二次开发
Posted on基于jsqlparser做javacc二次开发
yiihsia[互联网后端技术]
好记性不如烂博客，nosql、分布式架构、搜索引擎、海量数据处理。
基于jsqlparser做javacc二次开发
2012年6月19日 yiihsia 发表评论 阅读评论 689
jsqlparser是个开源的sql解析方案，基于javacc，提供比较全面的sql解析和反转，对于复杂的sql解析可以基于它扩展。http://jsqlparser.sourceforge.net/
最简单的实现，就是传入一条sql，jsqlparser解析后返回一个对象。我们只需要操作这个对象就行，一般都能满足需求，但是有时间还不能满足，需要自己扩充同时不能影响原来的解析。
罗列下扩展的地方：
1、支持中文
2、支持Create Database语法
3、支持Alter Table语法
4、drop table语法中支持table带scheme
修改后的jj文件下载地址：http://code.google.com/p/my-jsqlparser/downloads/list
使用方式：
1、替换原来net.sf.jsqlparser.parser目录下的JSqlParserCC.jj文件
2、在eclipse下点击该文件选择compile with javacc
3、运行原来工程的单元测试，是否有异常
———————————— 2012.7.31更新———————————-
1、添加drop index语法 ， drop index scheme.table.indexname
2、添加create index语法， create [UNIQUE|PRIMARYKEY|ADDITIONAL] [索引类型hashmap...] index indexname on table(column)
注：自己的项目中需要根据分片规则修改表名，为了方便直接在表名前后加上/#，不需要迭代遍历。造成toString()的时候表名有/#， 可以修改net.sf.jsqlparser.schema.Table的getWholeTableName方法
分类: Java, 数据库 标签: java, javacc
你可能感兴趣
- 2012/05/30 -- javacc lookahead 教程
- 2013/01/07 -- H2 Database学习笔记一 jdbc与TcpServer的交互
- 2012/09/11 -- lua、groovy嵌入到java中的性能对比
- 2012/08/09 -- 深入浅出 Java Concurrency
- 2011/11/13 -- Java堆外内存泄露浅谈
2013年3月12日05:09 | /#1
回复 | 引用 People in the world get the loans from various creditors, because it is easy and fast.
2013年3月18日04:55 | /#2
回复 | 引用 If a mother or father lends a child $150,000, parents must declare a figure that represents the interest income with their tax return Having said that, if applying out services it really is important to note that you can spend out between http://www.paydayloansonline9.co.uk/ – payday loans online uk Speed: it is one thing that can help you in making the best choice among the Canadian companies providing the short term loans In comparison to other education loans, emergency student education loans offer less of your budget and have short terms
2013年4月17日16:17 | /#3
回复 | 引用 In caseswhere the borrower runs a business out of the commercial property bywhich the loan is placed, the lender may require additional coverage payday loans uk. Besides as a house owner quite a few financial institutions can accept an automobile, shares or another expensive property that can be used because collateral
Those investigations exist for various access place classes You only desire it at their bargain price, which cost just isn’t going to be in relation to for long
2013年4月17日18:54 | /#4
回复 | 引用 It can be one of the most comprehensive and reliable machines to diseases plus injuries, and much more preventive health purposes payday loans. ADEA itself contains a fee decrease program available for those students in extreme financial want
nbsp; The treatment of investing in instant payday loans online pretty iseasy and also secure as it’s completed on the net with ease of your home Behind your southeastern pillar, next to the Caravan Shotgun 宝贝价格
2013年4月17日21:36 | /#5
回复 | 引用 However, there many other ways to help make fast money on line, like Forex trading, MLM marketing, Cost per action marketing and Marketing via email pay day loans. If your personal bankruptcy action was under Chapter seven, you may be suitable if your generate was 2 yrs ago, you currently have steady occupation, and have correctly established and also maintained completely new credit lines
nbsp; These loans will be formulated by preserve in mind your current emergencyneeds which comes up in the middle of of the calendar month without any clue You can still get the best selection of products in these shelves, of course, in the super good deal 宝贝价格
2013年4月18日00:44 | /#6
回复 | 引用 Home loan throughout India have been one of the best demands from a numerous people payday loans. When you can get by performing a traditional re-finance, you should unquestionably do that very first, but if it’s not possible to refinance like that, you might want to contemplate Fannie Mae’s new Refi And also program taking into consideration out in 04
Details of the particular registered owner, along with chassis number, present-day registration tag, engine selection and other facts will be integrated The quantities of money that could be availed with next day payday cash loans range from One hundred to a maximum of 1500 and the repayment period can not go beyond 14 next day it has been utilized 宝贝价格
2013年4月18日00:58 | /#7
回复 | 引用 Payday cash loans are also viewed as the best choice for people who are tagged with a low credit score performance payday loans uk. In some instances, the financial institution’s collection practices have been violent or in infringement of the regulation
Advisable to get money via this setting is to save lot campaigns, energy, time and the considerably desired a person’s extra expenses Rise and Fall, Fall and rise, no end to the present rhythm,Me wont make rejection more 宝贝价格
2013年4月19日01:17 | /#8
回复 | 引用 This kind of advance will give you a backside of small amount of cash payday loans. You can even sign up for loan even though you have poor credit rating providing you meet the eligibility criteria
It’s extremely uncomfortable and a lot people will not be quite guaranteed how to approach the patient This is the time to get started along with hard funds lending 宝贝价格
2013年4月19日01:28 | /#9
回复 | 引用 Think of this because case study students recruit throughout Stacee college and university using university, eliminates a financing to be with her principal the bride and groom of several years related with pay out while research projects payday loan. You can use it to repay your healthcare expenses, grocery bills, mobile expenditures, monthly house rent, child�s school fee as well as whatever you want to
Boost fee loaning companies is often rather convincing which enables it to put up by far the most professional regarding fronts towards you world Their researchers have convinced these people that many new customers will run its balances over ever before, in the event given what they have to think can be a deal 宝贝价格
2013年4月19日03:35 | /#10
回复 | 引用 Running a vehicle is expensive, not simply the petrol, but the offering, maintenance as well as tax pay day loan. – Many current museums, specially in Western countries have collection agencies of virtually colonial amounts but deal with funding shortages
Do not get despaired, with the assistance of Want Loans, we can easily certainly lift you out of one’s monetary ab exercises For those who have paid in advance for the policy that you are going to cancel, then you certainly should be able to obtain prompt reclaim 宝贝价格
2013年4月19日08:31 | /#11
回复 | 引用 Source Ones Groceries Nicely Groceries take up a huge slice of your income since these mostly involve essentials for instance food, toiletries and cleaning products and solutions pay day loans. In summary, debt consolidation reduction loans give you a way to aid individuals decrease their credit debt and their monthly installments by incorporating high interest credit card obligations into a single loan
Doing an unsanctioned overdraft position will not only view you incur rates but will additionally further harm your by now tarnished financial record Money lenders provide these individuals a value and that computer code is e-mailed in their eyes by all those applicants 宝贝价格
2013年4月19日08:38 | /#12
回复 | 引用 Simply because you’ve never organised a credit card and also taken out an unsecured loan doesn’t mean you have good credit pay day loans. PMI property finance loan insurance is just one solution to this problem by way of insuring a lender’s interests in affording the mortgage
As long as your current commenting is insightful and not viewed as unsolicited mail, there is a likelihood that a dialog can be reach up among you and the various other blogger It is advisable to Stop questioning the same questions can i easy and adjusting for i will be making money online, start training your mind 宝贝价格
2013年4月19日08:59 | /#13
回复 | 引用 The thing along with shopping for a home loan, versus shopping for a home and then going with no matter what seller delivers as income vehicle, is the fact that when you shop for just a home loan, you will be dealing right with loan companies whose single purpose is always to make money off of your loan uk pay day loans. Your credit ranking does not present as a deterrent to acquire them
It gives consumer credit issuers including banks and mortgage firms information on how you make payment for your bills == Pros with Adjustable Amount Loans == Lower prices Adjustable fee loans ordinarily have lower costs than predetermined ones 宝贝价格
2013年4月19日11:20 | /#14
回复 | 引用 This is really cool thanks for posting: 哈哈
2013年4月19日13:24 | /#15
回复 | 引用 Start with your homework and program what it is you want to achieve payday loan. Give yourself the responsibility of dealing the best accessible secured financial loan online
The consumer must be aware of these changes and has the right to be well informed Unemployment can often be an option, nonetheless that from time to time takes time to start out receiving 宝贝价格
2013年4月19日13:28 | /#16
回复 | 引用 As we discussed, there are ways to safeguard yourself via getting into debt you really wouldn’t like instant payday loans. It is therefore important to set realistic goals for your project finance investigating your own features first
To get your obtain accepted of those same day lending options one forced to meet the subsequent circumstances which have been : – you must become adult, you will need a reputable bank account, you should be at the present employed, you have to obtain monthly salary Each one incorporates its unique plus dissimilar features 宝贝价格
2013年4月19日16:11 | /#17
回复 | 引用 It is usually pertaining to larger ranges, up to virtually the entire borrowing limit on the credit card payday loans. Because of their redundancy and less-than-perfect credit record, these types of peopleare unable to receive the money they gotta have in order to get an auto
Now with the net method you are able to apply for bank loan directly from at your house as there are lots of lender online providing financial loan at a diverse rate that can be done a proper research online and decided on a best deal by yourself you have populate an online application form with few detail with 24 time the loan request will be okayed and settled in your bill These loans turn out to be fruitful when you are supposed to complete some emergent requires 宝贝价格
2013年4月19日16:48 | /#18
回复 | 引用 Even so secured loans feature lower interest rates than unsecured finance uk pay day loans. This isn’t entirely correct, as it offers some kind of reason
The fifth issue to ask in advance of spending money is Is there a product warranty Cash possesses risen for being king just as before as credit ratings is nowhere fast to be had as well as Dow cannot promise the particular returns it once did 宝贝价格
2013年4月19日19:00 | /#19
回复 | 引用 Through consolidating obligations, you can watch the movements of your hard cash more handily and thoroughly payday loan. Precisely why the idea to generate money,have personal freedom is unattractive
Cash loans are believed to be as a fascinating loan solution as it enable you to access to the income without any publicity and difficulty Thus, there are many areas of curiosity on the Internet that provides extra money 宝贝价格
2013年4月19日20:42 | /#20
回复 | 引用 2 government agencies, Work of the Comptroller with the Currency as well as the Office involving Thrift Supervision, started to concern joint stories containing an extensive picture of approximately 66% of the mortgages in the United States pay day loans. It could be also applied to provide workers his or her salary
Know What You’re Buying In picking your new rv, there are several things to take into consideration These loans are quite useful in dealing with the problems of individuals on credit ratings crisis 宝贝价格
2013年4月19日20:56 | /#21
回复 | 引用 A few) Abuses in lending You will find a form of neglect in lender out financial products to borrowers which is known as Predatory loans’ pay day loans. Nearly everyone products proposal a particular quantity of unique location (2 to 4 on everyday) for each $ used up
Periodically, your note publication must be totalled with your standard bank statements In addition, a person required to send us any of your documents although applying with us 宝贝价格
2013年4月19日23:20 | /#22
回复 | 引用 Ones structured settlement deal money would probably serve as a person’s retirement savings payday loans online. In a situation of any job decline one has to cave in all the components held by means of them caused by non-repayment of the mortgage loan
These financing options are also likely to be the most expensive This is certainly likely to be in which the individual is and so desperate and it has no choice that they are gonna accept whichever terms they are offered Individual debts are made up of associated with debt which includes mortgages, college loans, credit card debt, secured car loans and short term loans 宝贝价格
2013年4月20日00:24 | /#23
回复 | 引用 Over the entire period with the agreement, these kinds of financial savings is actually a large amount byby itself payday loan. How to Post for you to Newsgroups — Directions — Step one) You do not need in order to re-type this entire correspondence to do your posting
As a result, loan officers often engage in predatory methods, particularly for sub-prime consumers The folks are taking one of those loans in a really increased rate and the banking institutions and other lender companies in addition to institutions show in their reviews that they are the favourite loans by the people these days 宝贝价格
2013年4月20日02:37 | /#24
回复 | 引用 This will bring you in a whole lot worse trouble when compared with you started out there it pay day loan. Debt management ideas, debt consolidation, DRO etc can be of greater assist to you, in order to avoid chapter 7 and choose its easily affordable alternate options
The concept will depend on the idea that the house has a repaired value on the market today are dependent, for example, $ 250,000 Nevertheless, this is to become expected since loan themselves caters to subwoofer prime, higher-risk borrowers 宝贝价格
2013年4月21日23:35 | /#25
回复 | 引用 buy tramadol overnight cod where to buy tramadol – buy tramadol cod
2013年4月24日10:15 | /#26
回复 | 引用 tramadol 50mg order tramadol – order tramadol online mastercard
2013年4月26日13:07 | /#27
回复 | 引用 buy tramadol180 buy tramadol cod online – where to buy tramadol online
2013年5月2日17:37 | /#28
回复 | 引用 Along with secured personal cash loan the benefit is that you simply would get a better apr on your amount of the loan payday loans. The excuse is clear:It really is clear these particular individuals are great payers
You can inquire any amount you could reasonably afford the lender if you find yourself paid, by using commonly of course amounts about $3,000 For the reason that you have no power in reducing a loan
2013年5月2日17:52 | /#29
回复 | 引用 Granted becoming fitter you co-sign a personal student loan for the child who may have not yet had the opportunity to establish the credit history, although as far as many people asking for this kind of favor within you, stand solid and say no payday loans uk. It can be demanding to be considering that every thirty days and it surely imposes limits to the price range
You wish to continue to purchase savings from your paycheck when you get paid at the same time The total cost of borrowing from the bank money goes beyond just basic interest rates
2013年5月2日18:10 | /#30
回复 | 引用 Once 1 provides the loan provider with a evidence ownership, the other get loans which range from $5,500 to $75,Thousand depending on the price of ones property payday loans. They are machinery work and even the particular details participate in crucial component
Building your own merchant credit card for credit-based card processing and installing a shopping cart can potentially run into large sums of money Subprime lending products are commonly used for home loans, car financing, credit cards and private loans
2013年5月5日16:24 | /#31
回复 | 引用 buy tramadol cod next day delivery generic tramadol online – buy tramadolwithout prescriptions
2013年5月8日10:08 | /#32
回复 | 引用 http://www.achildsplace.org/banners/tramadolonline//#2493 buy tramadolno prescription – tramadol online overnight
2013年5月9日12:18 | /#33
回复 | 引用 The following decline in home based prices in addition led to home loan business the number of dollars outs, the news supply says pay day loans. Pawn brokers will give you credit in exchange for a private item worthwhile
Just for this kind of funding, the cash advance is perfect for a lot of, if only because of the speed of your reply A number of lenders demand as much as 31 pounds every 100 fat covered, however, if you purchased handle separately this can be as little as A couple of pounds 65 pence 宝贝价格
2013年5月9日13:03 | /#34
回复 | 引用 Youve fulfilled your current side in the business offer, cut costs tothe bone fragments and approved these cost savings onto your clients in the form of incentivesand discount rates payday loans online direct lenders. Then, money will be relocated in couple of hours and you can have used them without any burden
By way of only a few private along with financial information and facts, it allows a probable consumer to immediately evaluate the fees and charges with diverse car financing Seeing that floating costs are rates that go up and down with adjustments in the prime amount 宝贝价格
2013年5月10日02:26 | /#35
回复 | 引用 Unsecured loans are those financial products which are secured by investments with a cost that equals, or surpasses, the amount of the borrowed funds uk payday loans. Suppose you need fast cash enhance payday loan, you need to do what regarding responsibility with regard to repaying your debt
Enter in things like “avoid personal bankruptcy,” “credit unit card debt relief,In . and “debt settlement” while searching bar merely to get a sense of your options Depending on the availed account, term in order to reimbursement may vary more or less coming from 2 weeks so that you can 4 weeks 宝贝价格
2013年5月10日02:46 | /#36
回复 | 引用 There are so many ways to save on your next vehicle instant loans. Consider the item or thing you want Is the idea absolutely necessary
Everybody is together a seller and a buyer The lenders that will help are going to be the internets special funding lenders 宝贝价格
2013年5月10日15:10 | /#37
回复 | 引用 By using these previously mentioned discussed items, borrowers can certainly surely solve all their complications in a reduced period of time payday loans online. With the time period payments that will out of a structured settlement, it would be very difficult to obtain these tasks
The most prevalent reasons why persons apply for hel-home equity loans are with regard to debt consolidation, renovations and getaways The Arc Mortgage Program delivers interest free postponed loans which are repayable over a period which can be extended around five years 宝贝价格
2013年5月10日15:53 | /#38
回复 | 引用 It is found that agreement businessmen relationship with the most effective hard cash lenders with an easy going instant online payday loans. Do not pity us – I know I’m going to be okay – However do have little stomach ache
On the web auto loan information mill available in a large number to let you understand the dream about owning a car at the best possible rate They give an opportunity for individuals create or even restore a favorable credit rating 宝贝价格
2013年5月10日16:40 | /#39
回复 | 引用 Most people as a mortgage lender are minimum interested in your own past credit score records payday loans. (The balloon particular date is the particular date that the whole balance on the loan comes due, regardless of if the loan is definitely amortized or not)
Tips 3: Quickly Earn income in Nana Turismo 5 So as to earn more money in Gran Turismo Several, you must possess a fast car or truck and continue the test observe on Ohydrates and every a couple of laps you’ll earn A hundred and fifty,000CR As it’s an unsecured loan, you don’t have of a guarantee 宝贝价格
2013年5月14日13:36 | /#40
回复 | 引用 buy misoprostol online ireland – buy misoprostol online no prescription – where can i buy cytotec philippines
2013年5月14日20:13 | /#41
回复 | 引用 buy cytotec forum – buy cytotec canada – buy generic cytotec online
2013年5月15日11:41 | /#42
回复 | 引用 Buy Cytotec Online – buy cytotec and mifeprex – buy cytotec manila
2013年5月17日16:53 | /#43
回复 | 引用 tramadol online overnight buy tramadol onlinereviews – buy tramadol overnight shipping
2013年5月18日02:20 | /#44
回复 | 引用 buy tramadol cod online tramadol no prescription – buy tramadoltablets
2013年5月20日01:42 | /#45
回复 | 引用 Just inspected my gain today by using Credit Professional and it is 778 – a record illustrious quick payday loans. The type of technique used will certainly differ from business to business making this very puzzling for some staff members
For availing these loans, you should have permanent job for a lot more than 5 many months Thus, it can be advised to implement the moisture infused style, as the water present in your powder can moisturize your sensitive skin 宝贝价格
2013年5月20日19:05 | /#46
回复 | 引用 Buy Tramadol Online order tramadol online mastercard – buy tramadol cod
2013年5月28日22:21 | /#47
回复 | 引用 buy ambien tijuana ambien order canada – how to buy ambien
2013年5月29日05:30 | /#48
回复 | 引用 order ambien cr buy ambien online fast shipping – buy ambien 12.5 mg
2013年6月5日14:46 | /#49
回复 | 引用 buy generic tramadol online buy tramadolwithout prescriptions – order tramadol online without prescription
2013年6月6日00:17 | /#50
回复 | 引用 Buy Tramadol Online tramadol generic – buy tramadol without prescriptions
2013年7月14日02:37 | /#51
回复 | 引用 Lululemon Outlet I enjoy what you guys are usually up too. This sort of clever work and reporting! Keep up the amazing works guys I’ve included you guys to our blogroll.
2013年8月4日07:03 | /#52
回复 | 引用 read more buying tramadol online reviews – tramadol dosage human
2013年8月6日05:28 | /#53
回复 | 引用 order tramadol no prescription buy tramadol egypt – tramadol hcl 500mg
2013年8月11日13:35 | /#54
回复 | 引用 Go Here tramadol withdrawal while pregnant – buy tramadol using mastercard
2013年8月11日15:34 | /#55
回复 | 引用 buy tramadol online us pharmacy no prescription tramadol – tramadol withdrawal method
2013年8月11日15:57 | /#56
回复 | 引用 http://worldfineart.com/online/tramadol/ tramadol addiction detox – buy tramadol health solutions network
2013年8月11日16:28 | /#57
回复 | 引用 buy valium online long will 10mg valium last – buy valium uk 2012
2013年8月11日17:03 | /#58
回复 | 引用 http://cooperembloc.udg.edu/wp-content/buytramadol//#3681 tramadol no prescription pharmacy – tramadol normal dosage
2013年8月11日17:59 | /#59
回复 | 引用 generic adderall online adderall online prescription no membership – adderall xr abuse potential
2013年8月11日18:47 | /#60
回复 | 引用 buy adderall max adderall dosage 24 hours – vitamins help adderall withdrawal
2013年8月11日19:25 | /#61
回复 | 引用 http://aviation-history.com/aip/buytramadol//#34571 side effects of ultram tramadol – what is tramadol ultram 50 mg
2013年8月11日19:47 | /#62
回复 | 引用 buy tramadol online buy tramadol c.o.d saturday delivery – generic tramadol er
2013年8月11日20:26 | /#63
回复 | 引用 buy valium online valium dosage 10mg – what is a valium pill for
2013年8月11日22:14 | /#64
回复 | 引用 buy tramadol buy tramadol cod overnight delivery – good place buy tramadol online
2013年8月11日23:37 | /#65
回复 | 引用 http://worldfineart.com/online/tramadol/ where to buy tramadol forum – tramadol get high off
2013年8月12日01:17 | /#66
回复 | 引用 this link buy adderall online from usa – buy adderall online no prescription membership
2013年8月12日01:47 | /#67
回复 | 引用 what is adderall adderall side effects uti – adderall abuse drug test
2013年8月12日04:24 | /#68
回复 | 引用 buy valium valium lyrics – buy valium bali
2013年8月12日05:56 | /#69
回复 | 引用 tramadol 50mg tramadol hcl 50 mg get you high – buy tramadol online overnight
2013年8月12日20:25 | /#70
回复 | 引用 download adderall shortage – adderall xr side effects long term
2013年8月12日20:46 | /#71
回复 | 引用 buy tramadol tramadol hcl or tramadol – tramadol 50mg value
2013年8月12日23:13 | /#72
回复 | 引用 xanax online buy xanax online 2mg – side effects of 1mg xanax 昵称 (必填)
电子邮箱 (我们会为您保密) (必填) 网址
验证码 /* 深入浅出 Java Concurrency javacc lookahead 教程
搜索：
标签
cache Cassandra Concurrent Django Dynamo event google HBase http io ipad java javacc JBoss jvm linux lucene MapReduce mongodb mysql nio nosql python redis RFS Scala Siege spark SSD TokyoCabine TokyoTyrant Voldemort 分布式 多线程 实时 实时计算 并发 招聘 架构 测试 海量数据 消息队列 源码分析 爬虫 高性能
分类目录
- Apple (3)
- Java (16)
- Linux (4)
- Nosql (40)
- other (1)
- 互联网 (8)
- 分布式 (16)
- 实时计算 (8)
- 抄袭工厂 (20)
- 搜索引擎 (3)
- 数据库 (11)
- 架构 (8)
- 海量数据 (21)
算法 (12)
近期文章
- H2 Database学习笔记一 jdbc与TcpServer的交互
- lua、groovy嵌入到java中的性能对比
- 深入浅出 Java Concurrency
- 基于jsqlparser做javacc二次开发
近期评论
- kqqvmykczx 发表在《基于jsqlparser做javacc二次开发》
- yukDPlqiXX 发表在《基于jsqlparser做javacc二次开发》
- PANjZObHFw 发表在《使用JConsole监控远程jboss》
- jSypZUbVZd 发表在《Quick install HBase in “pseudo distributed” mode and connect from Java》
- KkEDjasVnX 发表在《基于jsqlparser做javacc二次开发》
Views
热门文章
我关注的
我还在
- 围脖
- 知乎
-
Archives
- 2013 年一月
- 2012 年九月
- 2012 年八月
- 2012 年六月
- 2012 年五月
- 2012 年二月
- 2011 年十二月
- 2011 年十一月
- 2011 年九月
- 2011 年八月
- 2011 年七月
- 2011 年六月
- 2011 年五月
- 2011 年四月
- 2011 年三月
- 2011 年二月
- 2011 年一月
- 2010 年十二月
- 2010 年十一月
Meta
版权所有 © 2010-2013 yiihsia[互联网后端技术] 主题由 NeoEase 提供, 通过 XHTML 1.1 和 CSS 3 验证.
