SSM利用ajax实现新增功能

1.实体类

1.1com.airQuality.entity包中

/**
 * 空气质量实体类
 * 
 * @author Administrator
 * 
 */
public class AirQualityIndex {
    // 属性
    private Integer id;
    private Integer district_id;
    private String monitor_time;
    private Integer pm10;
    private Integer pm2_5;
    private String monitoring_station;
    private String last_modify_time;
    private District district;
}

2.com.airQuality.dao包中

2.1AirQualityIndexMapper.java中的代码

public interface AirQualityIndexMapper {
    /**
     * 新增空气质量信息（传参数@Param("district_id") 表示给district_id取个别名）
     * 
     * @param district_id
     * @param monitor_time
     * @param pm10
     * @param pm2_5
     * @param monitoring_station
     * @param last_modify_time
     */
    void addAirQualityNews(@Param("district_id") Integer district_id,
            @Param("monitor_time") String monitor_time,
            @Param("pm10") Integer pm10, @Param("pm2_5") Integer pm2_5,
            @Param("monitoring_station") String monitoring_station,
            @Param("last_time") String last_modify_time);

}

2.2AirQualityIndexMapper.xml中的代码

<mapper namespace="com.airQuality.dao.AirQualityIndexMapper"><!-- 接口的全路径名 -->
<!-- 新增空气质量信息 -->
<insert id="addAirQualityNews">
    INSERT INTO
        air_quality_index(district_id,monitor_time,pm10,pm2_5,
        monitoring_station,last_modify_time)
    VALUES(#{district_id},#{monitor_time},
        #{pm10},#{pm2_5},#{monitoring_station},#{last_time})
</insert>
</mapper>

3.com.airQuality.biz包中

3.1AirQualityIndexBiz.java中的代码

public interface AirQualityIndexBiz {
    /**
     * 新增空气质量信息
     * 
     * @param district_id
     * @param monitor_time
     * @param pm10
     * @param pm2_5
     * @param monitoring_station
     * @param last_modify_time
     */
    void addAirQualityNews(Integer district_id, String monitor_time,
            Integer pm10, Integer pm2_5, String monitoring_station,
            String last_modify_time);
}

4.com.airQuality.biz.impl包

4.1AirQualityIndexBizImpl.java中的代码

@Service
public class AirQualityIndexBizImpl implements AirQualityIndexBiz {
    // 注入
    @Resource
    private AirQualityIndexMapper airQualityIndexMapper;

    @Override
    public void addAirQualityNews(Integer district_id, String monitor_time,
            Integer pm10, Integer pm2_5, String monitoring_station,
            String last_modify_time) {
        airQualityIndexMapper.addAirQualityNews(district_id, monitor_time,
                pm10, pm2_5, monitoring_station, last_modify_time);

    }
}

5.com.airQuality.controller包中

5.1AirQualityController.java中的代码

@Controller
public class AirQualityController {
    //注入
    @Resource
    private AirQualityIndexBiz airQualityIndexBiz;

    /**
     * 新增空气质量信息
     * 
     * @param last_time
     * @return
     */
    @RequestMapping(value = "/AddNews.html")
    @ResponseBody
    /* 这条注解告诉编译器只返回方法里面的内容，不用返回网页 */
    public String AddNews(Integer district_id, String monitor_time,
            Integer pm10, Integer pm2_5, String monitoring_station,
            @RequestParam(defaultValue = "2017-01-20") String last_time) {

        /* Calendar.getInstance().getTime() 获得当前时间 */

        // 转换编码
        try {
            monitor_time = new String(monitor_time.getBytes("iso-8859-1"),
                    "utf-8");
            monitoring_station = new String(
                    monitoring_station.getBytes("iso-8859-1"), "utf-8");
            last_time = new String(last_time.getBytes("iso-8859-1"), "utf-8");
        } catch (UnsupportedEncodingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        try {
            airQualityIndexBiz.addAirQualityNews(district_id, monitor_time,
                    pm10, pm2_5, monitoring_station, last_time);

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            return "false";
        }
        return "ok";

    }
}

6.add.jsp新增页面

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

/**部分代码省略**/

<div id="all">
    <div id="top">
        <h2>空气质量检测信息库</h2>
        <div id="table">
            <table width="400" border="0">
                <tr>
                    <td>监控区域:</td>
                    <td><select><option value="0">请选择</option>
                            <c:forEach items="${districtList }" var="dis">
                                <option value="${dis.id }">${dis.name }</option>
                            </c:forEach>
                    </select></td>
                </tr>
                <tr>
                    <td>检测日期:</td>
                    <td><input type="text" name="monitor_time"
                        class="monitor_time" /></td>
                </tr>
                <tr>
                    <td>PM10值:</td>
                    <td><input type="text" name="pm10" class="pm10" /></td>
                </tr>
                <tr>
                    <td>PM2.5值:</td>
                    <td><input type="text" name="pm2_5" class="pm2_5" /></td>
                </tr>
                <tr>
                    <td>检测站:</td>
                    <td><input type="text" name="monitoring_station"
                        class="monitoring_station" /></td>
                </tr>
                <tr>
                    <td></td>
                    <td><input type="button" value="保存" class="add" />&nbsp;<input
                        type="reset" value="重置" />&nbsp;<input type="button" value="返回"
                        class="hf" /></td>
                </tr>
            </table>
        </div>
    </div>
</div>

<script type="text/javascript" src="statics/js/jquery-1.8.3.js"></script>
<script type="text/javascript">
    $(function() {
        //新增空气质量信息
        $(".add").click(function() {
            //检测区域
            var district_id = $("select option:selected").val();
            //检测日期
            var monitor_time = $(".monitor_time").val().trim();
            //PM10值
            var pm10 = $(".pm10").val().trim();
            //PM2_5值
            var pm2_5 = $(".pm2_5").val().trim();
            //检测站
            var monitoring_station = $(".monitoring_station").val().trim();

            //日期格式正则表达式
            var zz = /^\d{4}-\d{2}-\d{2}$/;
            if (zz.test(monitor_time) == false) {
                alert("监测日期必须符合日期格式。如:2013-01-01");
                return false;
            }

            //将要传到控制器中的参数保存到json中，利用ajax实现跳转新增
            var json = {
                "district_id" : district_id,
                "monitor_time" : monitor_time,
                "pm10" : pm10,
                "pm2_5" : pm2_5,
                "monitoring_station" : monitoring_station
            };

            $.get("AddNews.html", json, function(data) {
                alert(data);
                if (data == "\"ok\"") {
                    alert("保存成功！");
                } else {
                    alert("保存失败！");
                }
                //跳转到分页查询控制器中，在控制器中跳转到index.jsp页面，显示数据
                location.href = "findAllAirQualityIndexs.html";
            });
        });
    });
</script>