美文网首页
Springmvc数据库

Springmvc数据库

作者: 6ce8f0bcb829 | 来源:发表于2017-04-12 19:27 被阅读0次
    结构图

    Controller:
    package cn.nokia.controller;
    import java.util.ArrayList;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;

    import org.springframework.beans.factory.annotation.Autowire;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;

    import cn.nokia.service.HellowService;;

    @Controller
    public class HellowController {
    @Autowired
    private HellowService helloservice;

    @RequestMapping("index")
    public @ResponseBody List doindex() {
    return helloservice.doHello();
    }
    }

    mapper:
    package cn.nokia.mapper;

    import java.util.List;
    import java.util.Map;

    public interface kpimapper {
    List<Map<String,String>>selectall();
    List<Map<String,String>>selectkpi();

    }

    mapper.xml:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="cn.nokia.mapper.kpimapper">

    <select id="selectall" resultType="java.util.HashMap">
    select pm_date as datetime,enb_id as enbid,cell_id as cellid,cell_avail_rate as rate from QIYUEFANV2 where rownum < 100
    </select>

    <select id="selectkpi" resultType="java.util.HashMap">

         select  enb_id as enbid,cell_id as cellid,cell_avail_rate as rate from QIYUEFANV2  where rownum < 100   
    

    </select>

    </mapper>

    Service:

    package cn.nokia.service;

    import java.util.List;

    public interface HellowService {
    public List doHello();

    }

    Service impl:
    package cn.nokia.service.impl;
    import java.util.List;

    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;

    import cn.nokia.mapper.kpimapper;
    import cn.nokia.service.HellowService;

    @Service("helloservice")
    public class HellowServiceImpl implements HellowService{
    @Autowired
    private kpimapper kpimaper;
    @Override
    public List doHello(){
    /*List<Map<String, String>> list = new ArrayList<>();
    Map<String,String> map = new HashMap<>();
    map.put("name", "zouwei");
    map.put("age", "24");

        list.add(map);*/
        return kpimaper.selectkpi();    
    }   
    

    }

    Error 删除多余内容

    相关文章

      网友评论

          本文标题:Springmvc数据库

          本文链接:https://www.haomeiwen.com/subject/ztweattx.html