myBatis+Spring mvc+ajax 初学

最新推荐文章于 2022-09-19 00:03:20 发布

open_curry

最新推荐文章于 2022-09-19 00:03:20 发布

阅读量2.9k

点赞数 3

分类专栏：网站文章标签： spring mvc mybatis jquery ajax

本文链接：https://blog.csdn.net/open_curry/article/details/52164200

版权

网站专栏收录该内容

11 篇文章 0 订阅

订阅专栏

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
  <display-name>Archetype Created Web Application</display-name>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

web.xml文件中的配置，主要是servlet部分的配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">

    <!-- scan the package and the sub package 扫描器 -->
    <context:component-scan base-package="com.hundsun.zdr"/>

    <!-- don't handle the static resource -->
    <mvc:default-servlet-handler />

    <!-- if you use annotation you must configure following setting 注解驱动 -->
    <mvc:annotation-driven />

    <!-- 视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"
          id="internalResourceViewResolver">
        <!-- 前缀 -->
        <property name="prefix" value="/WEB-INF/" />
        <!-- 后缀 -->
        <property name="suffix" value=".jsp" />
    </bean>
</beans>

dispatcher-servlet.xml文件中的配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接信息 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://127.0.0.1/test"/>
                <property name="username" value="root" />
                <property name="password" value="1234" />
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <!-- 注册userMapper.xml文件，
        userMapper.xml位于me.gacl.mapping这个包下，所以resource写成me/gacl/mapping/userMapper.xml-->
        <mapper resource="me/gacl/mapping/userMapper.xml"/>
    </mappers>

</configuration>

关键的部分，在resource文件夹下建立conf.xml文件，将数据库的配置写入，并且关联me.gacl.mapping这个包下的userMapper.xml文件。接下来写userMapper.xml的文件，将具体的SQL的语句写到该文件中

<?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="me.gacl.mapping.userMapper">
    <select id="getUser1" parameterType="com.hundsun.zdr.Stu"
            resultType="com.hundsun.zdr.Stu">
        SELECT * FROM Stu WHERE id=#{id}
    </select>
    <select id="getUser"
            resultType="com.hundsun.zdr.Stu">
        SELECT * FROM Stu WHERE TRUE
        <if test="id!=null">
            AND id = #{id}
        </if>
        <if test="name!=null">
            AND name like CONCAT('%', #{name},'%')
        </if>
        <if test="birthday!=null">
            AND birthday like CONCAT('%', #{birthday},'%')
        </if>
        <if test="sex!=null">
            AND sex like CONCAT(#{sex},'%')
        </if>
        <if test="address!=null">
            AND address like CONCAT('%', #{address},'%')
        </if>
        <if test="teacher!=null">
            AND teacher like CONCAT('%', #{teacher},'%')
        </if>
    </select>
</mapper>

userMapper.xml文件

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>学生信息查询</title>
    <script src="js/jquery.min.js"></script>
    <script type="text/javascript"></script>
    <script>
        $(document).ready(function(){//页面加载完成后执行的函数 document相当于网页这个对象
            $("#search").click(function(){//点击按钮的事件
                $('#searchResult tr').empty();//删除之前的数据
                $.ajax({//ajax向后台发送数据
                    type: "POST",
                    url: "hello",
                    data: {//发送的数据部分
                        id: $("#staffId").val(),
                        name: $("#staffname").val(),
                        birthday: $("#staffbirthday").val(),
                        sex: $("#staffsex").val(),
                        address: $("#staffaddress").val(),
                        teacher: $("#staffteacher").val()
                    },
                    dataType: "json",
                    success: function(data){//接受后台发送的数据
                        var s = '';
                        for (i in data) s += '<tr><td>' + data[i].id + '</td><td>' + data[i].name + '</td><td>' + data[i].birthday + '</td>'
                                + '<td>' + data[i].sex + '</td><td>' + data[i].address +  '</td><td>' + data[i].teacher +  '</td></tr>';
                        $('#searchResult').append(s);
                    },
                    error: function(jqXHR){
                        alert("发生错误：" + jqXHR.status);
                    },
                });
            });
        });
    </script>
</head>
<body>

id    
<input type="text" id="staffId"><br>
name   
<input type="text" id="staffname"><br>
birt   
<input type="text" id="staffbirthday"><br>
sex    
<select id="staffsex">
    <option></option>
    <option>female</option>
    <option>male</option>
</select><br>
addr   
<input type="text" id="staffaddress"><br>
lead   
<input type="text" id="staffteacher">
<br>
<button id="search">查询</button>
<br>
<table border="1" cellpadding="20" cellspacing="0">
    <thead>
    <tr>
        <th>学号</th>
        <th>姓名</th>
        <th>生日</th>
        <th>性别</th>
        <th>地址</th>
        <th>辅导员</th>
    </tr>
    </thead>
    <tbody id="searchResult"></tbody>
</table>
</body>

</html>

前端部分代码

package com.hundsun.zdr;

import com.google.gson.Gson;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by ZDR on 2016/8/8.
 */
@Controller//标识为控制类
//@RequestMapping("/mvc")
public class mvcController {
    @RequestMapping(value = "/hello",produces = "text/html;charset=UTF-8")//value指定请求的实际地址,produces指定返回的内容类型
    @ResponseBody
    public String hello(@RequestParam(value="id")String id,@RequestParam(value="name")String name,@RequestParam(value="birthday")String birthday,
                        @RequestParam(value="sex")String sex,@RequestParam(value="address")String address,@RequestParam(value="teacher")String teacher){
        System.out.println("======controller start=========="+sex);
        //mybatis的配置文件
        String resource = "conf.xml";
        //使用类加载器加载mybatis的配置文件（它也加载关联的映射文件）
        InputStream is = Stu.class.getClassLoader().getResourceAsStream(resource);
        //构建sqlSession的工厂
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
        //创建能执行映射文件中sql的sqlSession
        SqlSession session = sessionFactory.openSession();
        /**
         * 映射sql的标识字符串，
         * me.gacl.mapping.userMapper是userMapper.xml文件中mapper标签的namespace属性的值，
         * getUser是select标签的id属性值，通过select标签的id属性值就可以找到要执行的SQL
         */
        String statement = "me.gacl.mapping.userMapper.getUser";//映射sql的标识字符串
        //执行查询

        Stu checkStu = new Stu();
        checkStu.setId(id);
        checkStu.setName(name);
        checkStu.setSex(sex);
        checkStu.setBirthday(birthday);
        checkStu.setAddress(address);
        checkStu.setTeacher(teacher);

        List<Stu> resultList = new ArrayList<Stu>();
        resultList = session.selectList(statement,checkStu);
        System.out.println("===result==="+resultList.toString());
        return (new Gson()).toJson(resultList);//数据返回给页面
    }
}

控制类的代码，因为处理的逻辑很简单，逻辑部分和控制类写在的一起，以后做较大的项目时，应该把逻辑部分建立一个新的类，层次清晰。

package com.hundsun.zdr;

/**
 * Created by ZDR on 2016/8/8.
 */
public class Stu {
    public String name;
    public String id;
    public String birthday;
    public String sex;
    public String address;
    public String teacher;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getTeacher() {
        return teacher;
    }

    public void setTeacher(String teacher) {
        this.teacher = teacher;
    }

    public Stu(){

    }
    public Stu(String name, String id, String birthday, String sex, String address, String teacher) {
        this.name = name;
        this.id = id;
        this.birthday = birthday;
        this.sex = sex;
        this.address = address;
        this.teacher = teacher;
    }

    @Override
    public String toString() {
        return "Stu{" +
                "name='" + name + '\'' +
                ", id='" + id + '\'' +
                ", birthday='" + birthday + '\'' +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                ", teacher='" + teacher + '\'' +
                '}';
    }
}

这一部分就不多解释了，实体类。值得一提的是实体类的属性名称要和数据库中字段名一致，这样在userMapper.xml文件中才能直接使用参数名称！即使名称不一致也应该有方法解决，但是名称一致是麻烦最少的方法了。

这次算是之前项目的升级吧，添加了Spring mvc框架、使用了myBatis。前端部分还是基本延续了之前的项目

以上部分就是我个人的学习感受，对于WEB这一块我还是个小白，有不妥的地方还请各位大牛指出，谢谢大家