Layui和Ajax实现增删改查

最新推荐文章于 2024-02-22 10:18:29 发布

Java程序猿哦~

最新推荐文章于 2024-02-22 10:18:29 发布

阅读量1k

点赞数 2

文章标签： ajax layui javascript

本文链接：https://blog.csdn.net/m0_64896985/article/details/122443925

版权

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--<!DOCTYPE html>--%>
<html>

<head>
    <meta charset="utf-8">
    <title>table模块快速使用</title>
    <link rel="stylesheet" href="plugins/layui/css/layui.css" media="all">
</head>

<body>
<script src="plugins/layui/layui.js"></script>
<script>
    layui.use(['table','layer'],function () {
        var table = layui.table;
        var layer = layui.layer;
        var $ = layui.jquery;
        table.on('tool(test)',function (obj){
           var value=obj.value;
           var data=obj.data;
           var field=obj.field;
           layEvent=obj.event;
           if(layEvent=="detal"){
               layer.open({
                   type:2,
                   title:"公寓管理员信息",
                   content:"detail?id="+data.teacher_ID,
                   area:['400px','600px'],
                   shade:0.4
               });
           }else if(layEvent=="deleted"){
                $.ajax({
                   url:"delete?id="+data.teacher_ID,
                   type: "get",
                   dataType:"text",
                   success:function (data){
                       if (data==1){
                           location.reload();

                       }else {
                           layer.msg("删除失败！");
                       }
                   }
                });
           }else if(layEvent=="edit"){
               $.ajax({
                   url:"editServlet",//+JSON.stringify(data),
                   type: "post",
                   dataType:"text",
                   data:{
                     teacherID:data.teacher_ID,
                     teacherSex:data.teacher_Sex,
                     teacherPwd:data.teacher_Password,
                     teacherName:data.teacher_Name,
                     teacherTel:data.teacher_Tel,
                     teacherUsername:data.teacher_Username
                   },
                   success:function (data){
                       if (data==1){
                           layer.msg("编辑成功");
                       }else{
                           layer.msg("编辑失败");
                       }
                   }
               });
           }else if(layEvent=="add"){
               layer.open({
                  type:2,
                  title: "添加公寓管理员",
                   content: "add.jsp",
                   area: ['400px','600px'],
                   shade: 0.4,
                   maxmin:true,
                   end:function (){
                      location.reload();
                   }
               });
           }
        });

        var active={
            reload:function () {
                var sers = $("#search").val();
                if (sers==""){
                    layer.msg("不可以搜索空值")
                }else {
                    table.reload("test",{
                        where:{
                            sers:sers
                        },
                        page:{
                            curr:1
                        }
                    });
                }
            }
        }
        $("#btnSearch").click(function (){
            var type = $(this).data("type");
            active[type]?active[type].call(this):"";
        });
    });
</script>
<div class="layui-form-item">
    <label class="layui-form-label">查找用户</label>
    <div class="layui-form-label">
        <input type="text"id="search"class="layui-input"width="100px" />
        <div class="layui-form-label"style="float: left">
            <a class="layui-btn"data-type="reload"id="btnSearch">搜索</a>
        </div>
    </div>
</div>
<table class="layui-table" lay-data="{height:315, url:'findallteacher', page:true, id:'test'}" lay-filter="test" id="test">
    <thead>
    <tr>
        <th lay-data="{field:'teacher_ID', width:100, sort: true}">ID</th>
        <th lay-data="{field:'teacher_Username', width:150,edit:true}">用户账号</th>
        <th lay-data="{field:'teacher_Password', width:150,edit:true}">用户密码</th>
        <th lay-data="{field:'teacher_Name', width:150,edit:true}">真实姓名</th>
        <th lay-data="{field:'teacher_Sex', width:150, sort: true,edit:true}">性别</th>
        <th lay-data="{field:'teacher_Tel', width:150, sort: true,edit:true}">电话</th>
        <th lay-data="{title:'操作',alige:'center',width:400,toolbar:'#barDemo'}">操作</th>
    </tr>
    </thead>
</table>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-xs" lay-event="detal">查看</a>
    <a class="layui-btn layui-btn-normal" lay-event="edit">编辑</a>
    <a class="layui-btn layui-btn-danger" lay-event="deleted">删除</a>
    <a class="layui-btn layui-btn-warm" lay-event="add">添加</a>
</script>
</body>

</html>

查询


@WebServlet(name = "DetailTeacherServlet", value = "/detail")
public class DetailTeacherServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id=request.getParameter("id");
        System.out.println(id);
        TeacherDao tea=new teacherImDao();
        teacher t=tea.allTeacher(Integer.parseInt(id));
        request.getSession().setAttribute("tea",t);
        response.sendRedirect("detail.jsp");
    }

删除

@WebServlet(name = "DeleteTeacherServlet", value = "/delete")
public class DeleteTeacherServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id=request.getParameter("id");
        TeacherDao teacherDao=new teacherImDao();
        int t=teacherDao.DelTeacher(Integer.parseInt(id));
        if (t>0){
            response.getWriter().write("1");
        }
    }

修改

@WebServlet(name = "EditTeacherServlet", value = "/editServlet")
public class EditTeacherServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //String str=request.getParameter("str");
        //将字符串转换为对象
        //teacher t=JSONObject.toJavaObject(JSONObject.parseObject(str),teacher.class);
        String teacherID=request.getParameter("teacherID");
        String teacherSex=request.getParameter("teacherSex");
        String teacherPwd=request.getParameter("teacherPwd");
        String teacherName=request.getParameter("teacherName");
        String teacherTel=request.getParameter("teacherTel");
        String teacherUsername=request.getParameter("teacherUsername");
        TeacherDao tea=new teacherImDao();
        // int count=tea.UpdTeacher(t);
        int count=tea.UpdTeacher(teacherID,teacherSex,teacherPwd,teacherName,teacherTel,teacherUsername);
        if (count>0){
            response.getWriter().write("1");
        }
    }
}

添加

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link rel="stylesheet" href="plugins/layui/css/layui.css" media="all">
</head>
<body>
<script src="plugins/layui/layui.js"></script>
<script type="text/javascript">
    layui.use(['form','layer'],function (){
        var form=layui.form;
        var layer=layui.layer;
        var $=layui.jquery;
        var index=parent.layer.getFrameIndex(window.name);

        form.on("submit(formDemo)",function (data){
            $.ajax({
                url:"addServlet?teacherSex="+$("[name=teacher_Sex]").val()+"&teacherPwd="+$("[name=teacher_Password]").val()+"&teacherName="+$("[name=teacher_Name]").val()+"&teacherTel="+$("[name=teacher_Tel]").val()+"&teacherUsername="+$("[name=teacher_Username]").val(),//+JSON.stringify(data.field),
                type:"post",
                dataType:"text",
                success:function (data){
                    if (data==1){
                        layer.msg("添加成功");
                        parent.layer.close(index);
                    }
                }
            });
            return false;
        });
    });
</script>
<form class="layui-form layui-form-pane"action="#"method="post">
    <div class="layui-form-item">
        <label class="layui-form-label">昵称</label>
        <div class="layui-input-block">
            <input type="text"name="teacher_Username"class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">密码</label>
        <div class="layui-input-block">
            <input type="text"name="teacher_Password"class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">姓名</label>
        <div class="layui-input-block">
            <input type="text"name="teacher_Name"class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">性别</label>
        <div class="layui-input-block">
            <input type="text"name="teacher_Sex"class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">电话</label>
        <div class="layui-input-block">
            <input type="text"name="teacher_Tel"class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <button class="layui-btn layui-btn-fluid layui-btn-radius" lay-submit lay-filter="formDemo">提交</button>
    </div>
</form>
</body>
</html>

@WebServlet(name = "allServlet", value = "/allServlet")
public class allServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name=request.getParameter("userName");
        String pwd=request.getParameter("password");
        String role=request.getParameter("role");
        if(role.equals("1")){
            AdminDao ad=new adminImDao();
            List<admin> adminList=ad.adminAll(name,pwd);
            if (adminList.size()>0){
                request.getSession().setAttribute("adminList",adminList);
                response.sendRedirect("index.jsp");
            }else {
                response.sendRedirect("login.jsp");
            }
        }else {
            response.sendRedirect("login.jsp");
        }
    }
}

方法的重写

package ImDao;

import Dao.TeacherDao;
import JDBC.DBHelper;
import user.teacher;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class teacherImDao implements TeacherDao{
    @Override
    public List<teacher> teaAll() {
        Connection conn= DBHelper.getConn();
        String sql="select*from teacher";
        List<teacher> list=new ArrayList<teacher>();
        teacher tea=null;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ResultSet rs=ps.executeQuery();
            while (rs.next()){
                tea=new teacher(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));
                list.add(tea);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

    @Override
    public List<teacher> teaAll(int pagesize, int pagecloud) {
        Connection conn= DBHelper.getConn();
        String sql="select*from teacher limit ?,?";
        List<teacher> list=new ArrayList<teacher>();
        teacher tea=null;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setInt(1,(pagecloud-1)*pagesize);
            ps.setInt(2,pagesize);
            ResultSet rs=ps.executeQuery();
            while (rs.next()){
                tea=new teacher(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));
                list.add(tea);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

    @Override
    public int getCount() {
        Connection conn= DBHelper.getConn();
        String sql="select count(*) from teacher";
        int count=0;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ResultSet rs=ps.executeQuery();
            if(rs.next()){
                count=rs.getInt(1);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return count;
    }

    @Override
    public List<teacher> teaNameAll(String name) {
        Connection conn= DBHelper.getConn();
        String sql="select*from teacher where Teacher_Name like'%"+name+"%'";
        List<teacher> list=new ArrayList<teacher>();
        teacher tea=null;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ResultSet rs=ps.executeQuery();
            while (rs.next()){
                tea=new teacher(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));
                list.add(tea);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

    @Override
    public teacher allTeacher(int id) {
        Connection conn= DBHelper.getConn();
        String sql="select*from teacher where Teacher_ID =?";
        teacher tea=null;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setInt(1,id);
            ResultSet rs=ps.executeQuery();
            if (rs.next()){
                tea=new teacher(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return tea;
    }

    @Override
    public int DelTeacher(int id) {
        Connection conn= DBHelper.getConn();
        String sql="delete from teacher where Teacher_ID =?";
        int rs=0;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setInt(1,id);
            rs=ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    @Override
    public int UpdTeacher(teacher tea) {
        Connection conn= DBHelper.getConn();
        String sql="update teacher set Teacher_Username=?,Teacher_Password=?,Teacher_Name=?,Teacher_Sex=?,Teacher_Tel=? where Teacher_ID=?";
        int rs=0;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setString(1,tea.getTeacher_Username());
            ps.setString(2,tea.getTeacher_Password());
            ps.setString(3,tea.getTeacher_Name());
            ps.setString(4,tea.getTeacher_Sex());
            ps.setString(5,tea.getTeacher_Tel());
            ps.setString(6,tea.getTeacher_ID());
            rs=ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    @Override
    public int UpdTeacher(String teacherID, String teacherSex, String teacherPwd, String teacherName, String teacherTel, String teacherUsername) {
        Connection conn= DBHelper.getConn();
        String sql="update teacher set Teacher_Username=?,Teacher_Password=?,Teacher_Name=?,Teacher_Sex=?,Teacher_Tel=? where Teacher_ID=?";
        int rs=0;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setString(1,teacherUsername);
            ps.setString(2,teacherPwd);
            ps.setString(3,teacherName);
            ps.setString(4,teacherSex);
            ps.setString(5,teacherTel);
            ps.setString(6,teacherID);
            rs=ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    @Override
    public int AddTeacher(String teacherSex, String teacherPwd, String teacherName, String teacherTel, String teacherUsername) {
        Connection conn= DBHelper.getConn();
        String sql="INSERT INTO `teacher` VALUES (null,?,?,?,?,?)";
        int rs=0;
        try {
            PreparedStatement ps= conn.prepareStatement(sql);
            ps.setString(1,teacherUsername);
            ps.setString(2,teacherPwd);
            ps.setString(3,teacherName);
            ps.setString(4,teacherSex);
            ps.setString(5,teacherTel);
            rs=ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }
}

Java程序猿哦~

关注

2
点赞
踩
10

收藏

觉得还不错? 一键收藏
0
评论
Layui和Ajax实现增删改查

<%@ page contentType="text/html;charset=UTF-8" language="java" %><%--<!DOCTYPE html>--%><html><head> <meta charset="utf-8"> <title>table模块快速使用</title> <link rel="stylesheet" href="plugins/.
复制链接

扫一扫