python增删改查的框架layui_layui增删改查

最新推荐文章于 2024-09-13 21:30:00 发布

weixin_39575502

最新推荐文章于 2024-09-13 21:30:00 发布

阅读量446

点赞数

文章标签： python增删改查的框架layui

该博客介绍了如何使用 Java MVC 架构与 layui 前端框架实现数据的增删改查操作。内容包括 DAO 层的 SQL 查询与更新方法，Action 层的业务逻辑处理，以及 JSP 页面与 JS 交互，实现了搜索、分页、编辑和删除功能。

摘要由CSDN通过智能技术生成

首先要导入layui的css以及js

dao层

packagecom.hmc.dao;importjava.io.UnsupportedEncodingException;importjava.sql.SQLException;importjava.util.List;importjava.util.Map;importjavax.servlet.http.HttpServletRequest;importcom.hmc.entity.Book;importcom.hmc.util.BaseDao;importcom.hmc.util.JsonBaseDao;importcom.hmc.util.JsonUtils;importcom.hmc.util.PageBean;importcom.hmc.util.StringUtils;public class MVC_Book_dao extendsJsonBaseDao{/*** 查询分页

*@parampaMap

*@parampageBean

*@return*@throwsException

*@throwsException*/

public List> list(Map paMap,PageBean pageBean) throwsInstantiationException, IllegalAccessException, SQLException, Exception{//String sql="SELECT * FROM t_book";

String bid=JsonUtils.getParamVal(paMap, "bid");

String sql="SELECT * FROM t_mvc_book ";if(StringUtils.isNotBlank(bid)) {

sql+=" where bid like '%"+bid+"%'";

}return super.executeQuery(sql, pageBean);

}/***修改

*@throwsSQLException

*@throwsIllegalAccessException

*@throwsIllegalArgumentException

*@throwsSecurityException

*@throwsNoSuchFieldException*/

public int upbook(Map paMap,PageBean pageBean) throwsNoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {

String sql="update t_mvc_book set bname=?,price=? where bid=?";return executeUpdate(sql, new String[] {"bname","price","bid"}, paMap);

}/*** 新增

*@parampaMap

*@parampageBean

*@return*@throwsNoSuchFieldException

*@throwsSecurityException

*@throwsIllegalArgumentException

*@throwsIllegalAccessException

*@throwsSQLException*/

public int adbook(Map paMap,PageBean pageBean) throwsNoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {

String sql="insert into t_mvc_book (bname,price) values(?,?)";return executeUpdate(sql, new String[] {"bname","price"}, paMap);

}/***删除

*@parampaMap

*@parampageBean

*@return*@throwsNoSuchFieldException

*@throwsSecurityException

*@throwsIllegalArgumentException

*@throwsIllegalAccessException

*@throwsSQLException*/

public int dele(Map paMap,PageBean pageBean) throwsNoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {

String bid=JsonUtils.getParamVal(paMap, "bid");

String sql="delete from t_mvc_book where bid=?";

System.out.println(sql);return executeUpdate(sql, new String[] {"bid"}, paMap);

}

action层

packagecom.hmc.action;importjava.net.URL;importjava.net.URLDecoder;importjava.sql.SQLException;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.fasterxml.jackson.databind.ObjectMapper;importcom.hmc.dao.MVC_Book_dao;importcom.hmc.entity.Book;importcom.hmc.util.PageBean;importcom.zking.framework.ActionSupport;public class MVC_Book_Action extendsActionSupport{private MVC_Book_dao book_dao=newMVC_Book_dao();private ObjectMapper mapper=newObjectMapper();/*** 书籍查询所有加分页

*@paramrequest

*@paramresponse

*@return*@throwsException*/

public String list(HttpServletRequest request,HttpServletResponse response) throwsException {

request.setCharacterEncoding("utf-8");

PageBean pageBean=newPageBean();

pageBean.setRequest(request);

List> list = this.book_dao.list(request.getParameterMap(), pageBean);

Map map=new HashMap<>();

map.put("count", pageBean.getTotal());

map.put("data", list);

map.put("code", 0);

map.put("limit", pageBean.getRows());

mapper.writeValue(response.getOutputStream(),map);return null;

}public String updeBook(HttpServletRequest request,HttpServletResponse response) throwsException {int upbook = this.book_dao.upbook(request.getParameterMap(), null);

Map map=new HashMap<>();

map.put("code", 0);

mapper.writeValue(response.getOutputStream(),map);return null;

}/*** 新增书籍

*@paramrequest

*@paramresponse

*@return*@throwsException*/

public String adBook(HttpServletRequest request,HttpServletResponse response) throwsException {int adbook = this.book_dao.adbook(request.getParameterMap(), null);

Map map=new HashMap<>();

map.put("code", 0);

mapper.writeValue(response.getOutputStream(),map);return null;

}/*** 删除书籍

*@paramrequest

*@paramresponse

*@return*@throwsException*/

public String dele(HttpServletRequest request,HttpServletResponse response) throwsException {int adbook = this.book_dao.dele(request.getParameterMap(), null);

Map map=new HashMap<>();

map.put("code", 0);

mapper.writeValue(response.getOutputStream(),map);return null;

}

jsp页面

Insert title here

搜索ID：

搜索

查看

编辑

删除

点击上传，或将文件拖拽到此处

js代码

version:'1560414887305' //为了更新 js 缓存，可忽略

});

layui.use(['laydate', 'laypage', 'layer', 'table', 'carousel', 'upload', 'element', 'slider'], function(){

var laydate= layui.laydate //日期

,laypage = layui.laypage //分页

,layer = layui.layer //弹层

,table = layui.table //表格

,upload = layui.upload //上传

,element = layui.element //元素操作

,slider = layui.slider //滑块

tables();

var text;

$('#btn').click(function(){

text=$('#demoReload').val();

tables();

});//执行一个 table 实例

function tables(){

table.render({

elem:'#demo',height:420,url:'bookAction.action?methodName=list&&bid='+text+'' //数据接口

,title: '用户表',totalRow :true,page:true //开启分页

,toolbar: 'default' //开启工具栏，此处显示默认图标，可以自定义模板，详见文档

,totalRow: true //开启合计行

,cols: [[ //表头

{type: 'checkbox', fixed: 'left'}

,{field:'bid', title: 'ID', width:300, align:'center', sort: true, fixed: 'left', totalRowText: '合计：'}

,{field:'bname', title: '书本名称', width:300 ,align:'center'}

,{field:'price', title: '价格', width: 300,align:'center', sort: true, totalRow: true}

,{fixed:'right', width: 400, align:'center', toolbar: '#barDemo'}

]]

});

}//监听头工具栏事件

table.on('toolbar(test)', function(obj){

var checkStatus=table.checkStatus(obj.config.id)

,data= checkStatus.data; //获取选中的数据

switch(obj.event){case 'add':

add();break;case 'update':if(data.length === 0){

layer.msg('请选择一行');

}else if(data.length > 1){

layer.msg('只能同时编辑一个');

}else{

layer.alert('编辑 [id]：'+ checkStatus.data[0].bid);

}break;case 'delete':if(data.length === 0){

layer.msg('请选择一行');

}else{

layer.msg('删除');

}break;

};

});//监听行工具事件

table.on('tool(test)', function(obj){ //注：tool 是工具条事件名，test 是 table 原始容器的属性 lay-filter="对应的值"

var data = obj.data //获得当前行数据

,layEvent = obj.event; //获得 lay-event 对应的值

if(layEvent === 'detail'){

layer.msg('查看操作');

}else if(layEvent === 'del'){

layer.confirm('真的删除行么', function(index){//obj.del();//删除对应行(tr)的DOM结构

var params={'bid':data.bid,

}

dele(params);

layer.close(index);//向服务端发送删除指令

});

}else if(layEvent === 'edit'){

edit(data)

}

});//分页

laypage.render({

elem:'pageDemo' //分页容器的id

,count: 100 //总页数

,skin: '#1E9FFF' //自定义选中色值//,skip: true//开启跳页

,jump: function(obj, first){if(!first){

layer.msg('第'+ obj.curr +'页', {offset: 'b'});

}

});

function edit(data){

layer.open({

type :2,

title :'修改',

area : ['500px', '300px'],

offset :'160px',

shadeClose :true, //点击遮罩关闭

btn : ['保存','取消'],

content :'bookDetail.jsp',

success : function(layero, index) {//成功弹出后回调

layer.iframeAuto(index);

var body= layer.getChildFrame('body', index); //巧妙的地方在这里哦

body.contents().find("#bname").val(data.bname);

body.contents().find("#price").val(data.price);

body.contents().find("#bid").val(data.bid);

yes : function(index, layero) {//保存按钮回调函数//获取iframe层的body

var body = layer.getChildFrame('body', index); //巧妙的地方在这里哦//找到隐藏的提交按钮模拟点击提交//body.find('#permissionSubmit').click();

var name = body.contents().find("#bname").val();

var price=body.contents().find("#price").val();

var bid= body.contents().find("#bid").val();

var params={'bname':name,'price':price,'bid':bid

};

upbook(params);

layer.close(index);

btn2 : function(index, layero) {//取消按钮回调函数

layer.close(index); //关闭弹出层

}

});

}

function add(){

layer.open({

type :2,

title :'新增书本',

area : ['500px', '300px'],

offset :'160px',

shadeClose :true, //点击遮罩关闭

btn : ['保存','取消'],

content :'bookDetail.jsp',

success : function(layero, index) {//成功弹出后回调

yes : function(index, layero) {//保存按钮回调函数//获取iframe层的body//var body = layer.getChildFrame('body', index);//找到隐藏的提交按钮模拟点击提交//body.find('#permissionSubmit').click();

layer.iframeAuto(index);

var body= layer.getChildFrame('body', index); //巧妙的地方在这里哦

var bname=body.contents().find("#bname").val();

var price=body.contents().find("#price").val();

var params={'bname':bname,'price':price,

};

addtabls(params);

layer.close(index);

btn2 : function(index, layero) {//取消按钮回调函数

layer.close(index); //关闭弹出层

}

});