I am trying to fetch results from my sqlite database by providing a date range. I have been able to fetch results by providing 3 filters
1. Name (textfield1)
2. From (date)(textfield2)
3. To (date)(textfield3)
我正在使用以下代码,将这些实地数值从形式上加进表温。
Statement statement6 = db.createStatement("INSERT INTO Temp(date,amount_bill,narration) select date,amount,narration from Bills where name= "+TextField1.getText()+" AND substr(date,7)||substr(date,4,2)||substr(date,1,2) <= substr ( "+TextField3.getText()+" ,7)||substr ( "+TextField3.getText()+" ,4,2)||substr ( "+TextField3.getText()+" ,1,2) AND substr(date,7)||substr(date,4,2)||substr(date,1,2) >= substr ( "+TextField2.getText()+" ,7)||substr ( "+TextField2.getText()+" ,4,2)||substr ( "+TextField2.getText()+" ,1,2) ");
statement6.prepare();
statement6.execute();
statement6.close();
现在,如果我以我的形式为上述过滤器输入以下投入:
1.Ricky
2.01/02/2012
3.28/02/2012
It fetches date between these date ranges perfectly. But now i want to insert values that are below and above these 2 date ranges provided.
我尝试使用这一法典。 但它确实显示出任何结果。 我只字不提错误在哪里。
下面的代码是找到日期低于1/02/2012和超过28/02/2012的条目。
Statement statementVII = db.createStatement("INSERT INTO Temp5(date,amount_rec,narration) select date,amount,narration from Bills where name= "+TextField1.getText()+" AND substr(date,7)||substr(date,4,2)||substr(date,1,2) < substr ( "+TextField2.getText()+" ,7)||substr ( "+TextField2.getText()+" ,4,2)||substr ( "+TextField2.getText()+" ,1,2) AND substr(date,7)||substr(date,4,2)||substr(date,1,2) > substr ( "+TextField3.getText()+" ,7)||substr ( "+TextField3.getText()+" ,4,2)||substr ( "+TextField3.getText()+" ,1,2)");
statementVII.prepare();
statementVII.execute();
statementVII.close();
本条指南的任何内容。 感谢。