在jsp里面使用下拉菜单进行查询

最新推荐文章于 2019-04-18 16:13:51 发布

overmind

最新推荐文章于 2019-04-18 16:13:51 发布

阅读量1.7k

点赞数 1

分类专栏： jboss+struts+bv+hpunix 文章标签： jsp query javascript user action function

本文链接：https://blog.csdn.net/overmind/article/details/268814

版权

jboss+struts+bv+hpunix 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

  Audit jsp

                 </select>


                    </strong> 报价方式>><strong>
                    <select name="quoteType" onChange="autoSubmit()" size="1">
                       <option value="-1"
                      <%
                      if("-1".equals(contestForm.getQuoteType())){
                        out.println("selected");
                      }
                      %>
                      >
                      所有
                      </option>

                      <option value="0"
                      <%
                      if("0".equals(contestForm.getQuoteType())){
                        out.println("selected");
                      }
                      %>
                      >
                      公开
                      </option>

                      <option value="1"
                      <%
                      if("1".equals(contestForm.getQuoteType())){
                        out.println("selected");
                      }
                      %>
                      >
                      隐藏
                      </option>
</select>

<script language="javascript">
function autoSubmit()
{
document.contestForm.submit();
}
</script>
<form action="contest.do" name="contestForm">
<input type="hidden" name="formAction" value="auditRequest">

-----------------------------------------------------------------------------------------------

ContestLogic.java

            String query = "select c.CONTEST_TYPE,p.name,c.OID,c.PROJECT_CODE,c.PROJECT_NAME,SUPP_USER_ID,s.APPROVE,c.BUYER_COMPANY_NAME,QUOTE_TYPE,SUPP_ACCT_ID,ACCEPT,SUPP_ACCT_NAME "
                +
                "from DT_CONTEST_STOCK c,DT_CONTEST_SUPP s,bv_user_profile p "
                + "WHERE c.BUYER_ID='" + buyerId + "' "
                + "AND c.OID=s.OID "
                + "AND s.ACCEPT='1' "
                + "And p.user_id=s.supp_user_id ";
            if("0".equals(contestType)){
                  query=query+" AND CONTEST_TYPE='0'";
            }
            else if("1".equals(contestType)){
                  query = query + " AND CONTEST_TYPE='1'";
            }

            query = query + " Order By creation_time Desc ";