表格换色

 $("tr:odd").addClass("odd");
 $("tr:even").addClass("even");

很简单就实现了.

  <c:forEach items="${list}" var="sales">
                <td>${sales.customername}</td>
                <td>${sales.visitdate}</td>
                <td>${sales.visitobj}</td>
                <td>${sales.workevent}</td>
                <td>${sales.jobpurpose}</td>
                <td>${sales.unfinishedreason}</td>
                <td>${sales.needhelp}</td>
                <td><span><button ><a data-toggle="modal" href="#myModal" class="a-font" onclick="update(${sales.id});">编辑</a></button>
                        <button><a href="delsales.json?id=${sales.id}" class="a-font">删除</a></button> </span></td>
            </tr>

        </c:forEach>

<div id="myModal" class="modal hide fade" tabindex="-1" data-width="760">
    <form action="updatesales.json" method="post" id="updatesales" class="updatesales">
        <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
            <h3>修改</h3>
        </div>
        <div class="modal-body">
            <div class="row-fluid">
                <div class="span6">
                    <p><label for="customername">客户名称:</label>
                        <input type="text" class="span12" name="customername" id="customername"   <%--datatype="s6-18" errormsg="昵称至少6个字符,最多18个字符！"--%>/></p>
                    <p><label for="visitdate">拜访日期:</label>
                        <input type="date" class="span12" name="visitdate" id="visitdate" /></p>
                    <p><label for="visitobj">拜访对象:</label>
                        <input type="text" class="span12" name="visitobj" id="visitobj"/></p>
                    <p><label for="workevent">工作事件:</label>
                        <input type="text" class="span12" name="workevent" id="workevent"/></p>
                </div>
                <div class="span6">
                    <p><label for="jobpurpose">工作目的:</label>
                        <input type="text" class="span12" name="jobpurpose" id="jobpurpose"/></p>
                    <p><label for="unfinishedreason">未完成原因:</label>
                        <input type="text" class="span12" name="unfinishedreason" id="unfinishedreason"/>
                    </p>
                    <p><label for="needhelp">所需帮助:</label>
                        <input type="text" class="span12" name="needhelp" id="needhelp"/></p>
                    <input type="hidden" id="id" name="id"/>
                </div>
            </div>
        </div>
        <div class="modal-footer">
            <button type="button" data-dismiss="modal" class="btn">关闭</button>
            <button type="submit" class="btn btn-primary">aa</button>
        </div>
    </form>
</div>

 <script>
     function update(obj){
        $("#id").val(obj);
     }
 </script>

这样很方便的就把值传过去了.

 <td id="${cust.id}">${cust.companyname}</td>

同样也很方便的用jquery选择器获得值

mybatis 模糊查找的

 <select id="selectByTypeOrName" resultMap="BaseResultMap">
    SELECT * FROM customer WHERE 1=1
    <if test="custtype !=null">
       AND custtype=#{custtype,jdbcType=TINYINT}
    </if>
    <if test="companyname!=null">
      and companyname LIKE concat('%','${companyname}','%')
    </if>
  </select>

用concat(‘%’,’${companyname}’,’%’) 感觉很方便