ajax servlet mybatis 案例

最新推荐文章于 2024-10-01 18:51:18 发布

d-will8

最新推荐文章于 2024-10-01 18:51:18 发布

阅读量134

点赞数

分类专栏：案例文章标签： jquery java mybatis

本文链接：https://blog.csdn.net/deron345/article/details/112532324

版权

案例专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.index.html文件

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Hello Maven</title>
    <!--<link rel="stylesheet" type="text/css" href="css/style.css">-->
    <script type="text/javascript" src="js/jquery-3.3.1.js"></script>
</head>
<body>
<button id="view">View Mysql By Ajax + MyBatis</button>
<table id="data">
    <tr>
        <th>ID</th>
        <th>Name</th>
        <th>Age</th>
    </tr>
</table>
</body>
<script>
    $(function () {
        //为id=view的按钮提供click方法
        $("#view").click(function () {
            //发送ajax请求
            $.ajax({
                // url: encodeURI("sql"),
                url: "/ddd/UserServlet",
                type: "get",
                dataType: "json"
            })
            //访问成功
                .done(function (msg) {
                    //清空id=data的表格第一行（表头）以外的数据
                    $("#data tr:not(:first)").empty();
                    //遍历返回的json数组
                    $.each(msg, function (index, user) {
                        //向表格中添加json数组每个元素的内容
                        $("#data").append("<tr>" +
                            "<td>" + user.id + "</td>" +
                            "<td>" + user.name + "</td>" +
                            "<td>" + user.pwd + "</td>" +
                            "</tr>")
                    })
                })
                //访问失败
                .fail(function () {
                    alert("ERROR!")
                })
        })
    })
</script>

2 User.java

package com.dd.pojo;

/**
 * @author d-will
 * @create 2021--01--12 14:22
 */
public class User {
    private int id;
    private  String name;
    private  String pwd;

    public User() {
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }
}

3 mybatis相关文件
UserMapper.java

package com.dd.dao;

import com.dd.pojo.User;

import java.util.List;

/**
 * @author d-will
 * @create 2021--01--11 11:03
 */
public interface UserMapper {
//    查询所有用户
    List<User> getUserList();
//    通过ID返回用户
    User getUserById(int id);
//    插入用户
    int addUser(User user);
//    更新
    int updateUser(User user);
//    删除
    int delUser(int id);
}

UserMapper.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="com.dd.dao.UserMapper">
    <select id="getUserList" resultType="com.dd.pojo.User">
        select * from mybatis.user;
    </select>
    <select id="getUserById" resultType="com.dd.pojo.User" parameterType="int">
    SELECT * from mybatis.user where id=#{id};
    </select>
    <insert id="addUser" parameterType="com.dd.pojo.User" >
        INSERT  into mybatis.user(id, name, pwd) VALUES (#{id},#{name},#{pwd})
    </insert>
    <update id="updateUser" parameterType="com.dd.pojo.User">
        UPDATE mybatis.user SET name=#{name},pwd=#{pwd} where id=#{id};
    </update>
    <delete id="delUser" parameterType="int">
        DELETE FROM mybatis.user where id =#{id};
    </delete>
</mapper>

MybatisUtils.java

package com.dd.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
/**
 * @author d-will
 * @create 2021--01--12 14:25
 */
public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSession getSqlSession() {
        return sqlSessionFactory.openSession();
    }
}

UserUtil.java

package com.dd.utils;

import com.dd.dao.UserMapper;
import com.dd.pojo.User;
import org.apache.ibatis.session.SqlSession;
import java.util.List;

/**
 * @author d-will
 * @create 2021--01--12 14:29
 */
public class UserUtil {
    public static List<User> getAllUsers() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = userMapper.getUserList();
        sqlSession.close();
        return userList;
    }
}

UserServlet.java

package com.dd.service;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.dd.pojo.User;
import com.dd.utils.UserUtil;
import com.sun.deploy.net.HttpRequest;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @author d-will
 * @create 2021--01--12 14:35
 */
//@WebServlet("/service/UserServlet")
public class UserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        List<User> usersList = UserUtil.getAllUsers();
        //JSON转字符串写入resp
        resp.getWriter().append(JSON.toJSONString(usersList));
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

poem.xml加载properties xml文件需要内容

    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

web.xml配置文件

<!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>
    <servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>*.js</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>*.html</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>UserServlet</servlet-name>
        <servlet-class>com.dd.service.UserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>UserServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>