string strSql="SELECT * FROM Trade ";
string strWhere="";
if(this.txtCardID.Text!="")
{
strWhere=" WHERE (CardID='"+this.txtCardID.Text.Trim()+"')";
}
if(this.txtStartTime.Text!="")
{
if(strWhere=="")
{
strWhere+="WHERE (TradeDate>='"+this.txtStartTime.Text.Trim()+"')";
}
else
{
strWhere+=" AND (TradeDate>='"+this.txtStartTime.Text.Trim()+"')";
}
}
if(this.txtEndTime.Text!="")
{
if(strWhere=="")
{
strWhere+="WHERE (TradeDate<='"+this.txtStartTime.Text.Trim()+"')";
}
else
{
strWhere+="AND (TradeDate<='"+this.txtStartTime.Text.Trim()+"')";
}
}
strSql+=strWhere;
string strWhere="";
if(this.txtCardID.Text!="")
{
strWhere=" WHERE (CardID='"+this.txtCardID.Text.Trim()+"')";
}
if(this.txtStartTime.Text!="")
{
if(strWhere=="")
{
strWhere+="WHERE (TradeDate>='"+this.txtStartTime.Text.Trim()+"')";
}
else
{
strWhere+=" AND (TradeDate>='"+this.txtStartTime.Text.Trim()+"')";
}
}
if(this.txtEndTime.Text!="")
{
if(strWhere=="")
{
strWhere+="WHERE (TradeDate<='"+this.txtStartTime.Text.Trim()+"')";
}
else
{
strWhere+="AND (TradeDate<='"+this.txtStartTime.Text.Trim()+"')";
}
}
strSql+=strWhere;
解决方案 »
- hibernate什么问题啊
- 如何获取一个工程中方法的调用关系,寻觅很多年
- javascript,实现一个功能,文本框内只能输入数字。。
- 使用JDICplus 0.2.2怎么判断当前网页加载完成?
- Struts2的Iterator标签。。。。简单问题,大家帮忙
- SQL 语句难题!
- 谁去过浙江支付宝 面试过?
- 关于struts配置后,网页跳转时*.do文件找不到的问题
- 怎么用nested:iterate显示Action里面查询到的数据?
- idea 大家用过没有.配置如何?
- spring配置文件中,注入的另一个问题,希望高手帮帮忙,小弟只有5分了,所以不能给分了哦,希望大虾们多多的理解啊
- 算法问题
if(txt1==null||txt1.equals("")){
txt1=" and id='"+txt1+"'";
sql.append(txt1);
}
if(txt2==null||txt2.equals("")){
txt2=" and name='"+txt2+"'";
sql.append(txt3);
}
if(txt3==null||txt3.equals("")){
txt3=" and address='"+txt3+"'";
sql.append(txt3);
}
if(txt1!=null&&!txt1.equals("")){
txt1=" and id='"+txt1+"'";
sql.append(txt1);
}
if(txt2!=null&&!txt2.equals("")){
txt2=" and name='"+txt2+"'";
sql.append(txt3);
}
if(txt3!=null&&!txt3.equals("")){
txt3=" and address='"+txt3+"'";
sql.append(txt3);
}
"select * from TableName where field1 like ? and field2 like ? and field3 like ?";pst.setString(1,"%"+value1+"%");
pst.setString(2,"%"+value2+"%");
pst.setString(3,"%"+value3+"%");
rs=pst.executeQuery();当然这只能针对字段类型都是字符串时