1、prepareStatement实现模糊查询

public List<Leave> sercher(String keywords) {
        List<Leave> leaveList = new ArrayList<Leave>();
        Leave leave;
        String sql = "select * from `leave` where ";
        StringBuffer stringBufferqlsb = new StringBuffer();
        stringBufferqlsb.append("leave_id like ? or ");
        stringBufferqlsb.append("opinion like ?");
        sql+=stringBufferqlsb;

        try {
            int index = 1;
            conn = DBUtils.getConnection();
            ps = conn.prepareStatement(sql);
            ps.setString(index++,"%"+keywords+"%");//自动添加单引号 （包装后的参数）
            ps.setString(index++,"%"+keywords+"%");//自动添加单引号 （包装后的参数）
            rs = ps.executeQuery();
            while (rs.next()) {
                index = 1;
                leave = new Leave();
                leave.setLeaveId(rs.getString(index++));
                leave.setStudentId(rs.getString(index++));
                leave.setDepartmentId(rs.getString(index++));
                leave.setCourseId(rs.getString(index++));
                leave.setReason(rs.getString(index++));
                leave.setDaynum(rs.getInt(index++));
                leave.setApplyTime(rs.getDate(index++));
                leave.setAuditTime(rs.getDate(index++));
                leave.setStatus(rs.getInt(index++));
                leave.setOpinion(rs.getString(index++));

                leaveList.add(leave);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(rs,ps,conn);
        }
        return leaveList;
    }

 

2、jsp页面使用layer弹窗组件

  • 官网下载连接
  • 导入（My97DatePicker的压缩包文件目录不能改变） 
     <script src="<%=path%>/js/layer/layer.js"></script>

     

    SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
  • 使用 
    <input type="text" class="Wdate" name="applyTime" style="width: 240px; color: #0000AA;" onfocus="WdatePicker({lang:'zh-cn', dateFmt:'yyyy-MM-dd'})"/>

     

3、jsp页面使用MY97日期组件

  • 官网下载连接
  • 导入（My97DatePicker的压缩包文件目录不能改变） 
    <script src="<%=path%>/js/My97DatePicker/My97DatePicker/WdatePicker.js"></script>
  • 使用 
    <input type="text" class="Wdate" name="applyTime" style="width: 240px; color: #0000AA;" onfocus="WdatePicker({lang:'zh-cn', dateFmt:'yyyy-MM-dd'})"/>

     

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄