jsp下拉框选择实现与JavaBean JDBC操作示例

第一种JSP页面：
<select name="prpLassistFeeAuditStatus">   
              <option value="0" <%=prpLassistFeeDto1.getAuditStatus().equals("0") ? "selected" : ""%>>定损交互</option>                   
              <option value="1" <%=prpLassistFeeDto1.getAuditStatus().equals("1") ? "selected" : ""%>>删除</option>
              <option value="2" <%=prpLassistFeeDto1.getAuditStatus().equals("2") ? "selected" : ""%>>需修改</option>
              <option value="3" <%=prpLassistFeeDto1.getAuditStatus().equals("3") ? "selected" : ""%>>合格</option>
              </select>

------------------------------------------------------
第二种JAVABEAN+JDBC实现
    public List<EmCustHorExpensesList> getEmCustHorExpensesList(int owner){
        List<EmCustHorExpensesList> arrayPage = new ArrayList<EmCustHorExpensesList>();
        Session session = super.getSession();
        Connection conn = session.connection();
        try{
            String sql = "select a.id,b.custName,a.status,a.custHor,a.auditTime,a.total,"
                        +"(select sum(custHor) from EM_CustHorExpenses where owner = a.owner "
                        +" and year(createTime) = year(a.createTime) and month(createTime) = month(a.createTime) and createTime <= a.createTime) as csum,"
                        +"0.05*(select sum(totalAmount) from DM_DeliveryOrder where company = a.owner and datediff(mm,createTime,a.createTime) between 1 and 3)/3 as nsum"
                        +" from EM_CustHorExpenses a left join BS_Customer b on a.customer = b.id "
                        +" left join SM_Staff c on a.auditPeople = c.id "
                        +" where a.owner =?";
            PreparedStatement stmt = conn.prepareStatement(sql);
            stmt.setInt(1,owner);
            ResultSet rs = stmt.executeQuery();
            
            while(rs.next()){
                EmCustHorExpensesList e=new EmCustHorExpensesList();
                int id = rs.getInt(1);
                String custName = rs.getString(2);