【Saas-export项目】4--（企业管理）查询

---

---

显示页面

后台代码

CompanyController.java

• src\main\java\com\smp\web\controller\company

    //list.action->list------>查询
    //访问company/list.do
    @RequestMapping(path = "/toList",method = RequestMethod.GET)
    public String toList(Model model){
        List<Company> list=iCompanyService.findAll();
        l.info("list list="+list);
        model.addAttribute("list",list);
        return "company/company-list";
    }

TestCompanyService.java测试

• src\test\java\com\smp\service\company

@Test
    public void test01(){
        //编写业务逻辑测试
        //左边接口，右边实现类
        //ICompanyService service= new CompanyServiceImpl();
        List<Company> list=service.findAll();
        System.out.println(list);
    }

ICompanyService.java

• src\main\java\com\smp\service\company

 List<Company> findAll();

CompanyServiceImpl.java

• src\main\java\com\smp\service\company\impl

@Autowired
    ICompanyDao iCompanyDao;
public List<Company> findAll() {
        return iCompanyDao.findAll();
    }

ICompanyDao.java

• src\main\java\com\smp\dao\company

//查询所有的公司纪录
    //select * from ss_company;
    List<Company> findAll();

ICompanyDao.xml

• src\main\resources\com\smp\dao\company

<!--<select id="findAll" resultType="company">
select
	id,
	name ,
	expiration_date as expirationDate ,
	address,
	license_id as licenseId  ,
	representative ,
	phone  ,
	company_size as companySize  ,
	industry  ,
	remarks ,
	state,
	balance ,
	city
from ss_company
    </select>-->

    <!--//查询所有的公司纪录
    //select * from ss_company;
    List<Company> findAll();-->
    <resultMap id="companyMap" type="company">
        <id column="id" property="id"/>
        <result column="expiration_date" property="expirationDate"/>
        <result column="license_id" property="licenseId"/>
        <result column="company_size" property="companySize"/>
    </resultMap>
    <select id="findAll" resultMap="companyMap">
        select * from ss_company
    </select>

前台代码

CompanyController.java

• src\main\java\com\smp\web\controller\company

    //list.action->list------>查询
    //访问company/list.do
    @RequestMapping(path = "/toList",method = RequestMethod.GET)
    public String toList(Model model){
        List<Company> list=iCompanyService.findAll();
        l.info("list list="+list);
        model.addAttribute("list",list);
        return "company/company-list";
    }

company-list.jsp

• src\main\webapp\WEB-INF\pages\company

<!-- 正文区域 -->
    <section class="content">

        <!-- .box-body -->
        <div class="box box-primary">
            <div class="box-header with-border">
                <h3 class="box-title">列表</h3>
            </div>

            <div class="box-body">

                <!-- 数据表格 -->
                <div class="table-box">

                    <!--工具栏-->
                    <div class="pull-left">
                        <div class="form-group form-inline">
                            <div class="btn-group">
                                <button type="button" class="btn btn-default" title="新建" onclick='location.href="/company/toAdd.do"'><i class="fa fa-file-o"></i> 新建</button>
                                <button type="button" class="btn btn-default" title="删除" onclick='deleteById()'><i class="fa fa-trash-o"></i> 删除</button>
                                <button type="button" class="btn btn-default" title="刷新" onclick="window.location.reload();"><i class="fa fa-refresh"></i> 刷新</button>
                            </div>
                        </div>
                    </div>
                    <div class="box-tools pull-right">
                        <div class="has-feedback">
                            <input type="text" class="form-control input-sm" placeholder="搜索">
                            <span class="glyphicon glyphicon-search form-control-feedback"></span>
                        </div>
                    </div>
                    <!--工具栏/-->

                    <!--数据列表-->
                    <table id="dataList" class="table table-bordered table-striped table-hover dataTable">
                        <thead>
                        <tr>
                            <th class="" style="padding-right:0px;">

                            </th>
                            <th class="sorting">企业名称</th>
                            <th class="sorting">所在地</th>
                            <th class="sorting">地址</th>
                            <th class="sorting">企业法人</th>
                            <th class="sorting">联系方式</th>
                            <th class="sorting">所属行业</th>
                            <th class="sorting">状态</th>
                            <th class="sorting">余额</th>
                            <th class="text-center">操作</th>
                        </tr>
                        </thead>
                        <tbody>
                        <c:forEach items="${list}" var="item">
                            <tr>
                                <td><input name="ids" value="${item.id}" type="checkbox"></td>
                                <td>
                                        ${item.name}
                                </td>
                                <td>${item.city}</td>
                                <td>${item.address}</td>
                                <td>${item.representative}</td>
                                <td>${item.phone}</td>
                                <td>${item.industry}</td>
                                <td>${item.state ==0?'未审核':'已审核'}</td>
                                <td class="text-center">${item.balance}</td>
                                <td class="text-center">
                                    <button type="button" class="btn bg-olive btn-xs" onclick='location.href="${path}/company/toEdit.do?id=${item.id}"'>编辑</button>
                                </td>
                            </tr>
                        </c:forEach>
                        </tbody>
                    </table>
                </div>
            </div>
            <!-- /.box-body -->

            <!-- .box-footer-->
            <div class="box-footer">
                <div class="pull-left">
                    <div class="form-group form-inline">
                        总共2 页，共14 条数据。 每页
                        <select class="form-control">
                            <option>10</option>
                            <option>15</option>
                            <option>20</option>
                            <option>50</option>
                            <option>80</option>
                        </select> 条
                    </div>
                </div>

                <div class="box-tools pull-right">
                    <ul class="pagination">
                        <li>
                            <a href="#" aria-label="Previous">首页</a>
                        </li>
                        <li><a href="#">上一页</a></li>
                        <li><a href="#">1</a></li>
                        <li><a href="#">2</a></li>
                        <li><a href="#">3</a></li>
                        <li><a href="#">4</a></li>
                        <li><a href="#">5</a></li>
                        <li><a href="#">下一页</a></li>
                        <li>
                            <a href="#" aria-label="Next">尾页</a>
                        </li>
                    </ul>
                </div>

            </div>


            <%--        <div class="box-footer">
                        <jsp:include page="../common/page.jsp">
                            <jsp:param value="${ctx}/company/list.do" name="pageUrl"/>
                        </jsp:include>
                    </div>--%>
            <!-- /.box-footer-->

        </div>
    </section>