datagrid-expandrow(Java+Mysql+EasyUi实现)

最新推荐文章于 2023-05-05 08:41:59 发布

一生所Ai

最新推荐文章于 2023-05-05 08:41:59 发布

阅读量758

点赞数

分类专栏： JavaWeb easyui 文章标签： datagrid-expandrow

本文链接：https://blog.csdn.net/qq_40180411/article/details/83387261

版权

JavaWeb 同时被 2 个专栏收录

42 篇文章 0 订阅

订阅专栏

easyui

1 篇文章 0 订阅

订阅专栏

数据库:m_goods

看完效果图：直接上代码

1.test.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <html>  
    <head>  
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">  
    <meta name="keywords" content="jquery,ui,easy,easyui,web">  
    <meta name="description"  
        content="easyui help you build your web page easily!">  
    <title>Expand row in DataGrid to show subgrid - jQuery EasyUI  
        Demo</title>  
    <link rel="stylesheet" type="text/css"  
        href="http://www.jeasyui.com/easyui/themes/default/easyui.css">  
    <link rel="stylesheet" type="text/css"  
        href="http://www.jeasyui.com/easyui/themes/icon.css">  
    <link rel="stylesheet" type="text/css"  
        href="http://www.jeasyui.com/easyui/demo/demo.css">  
    <script type="text/javascript"  
        src="http://code.jquery.com/jquery-1.4.4.min.js"></script>  
    <script type="text/javascript"  
        src="http://www.jeasyui.com/easyui/jquery.easyui.min.js"></script>  
    <script type="text/javascript" src="http://www.jeasyui.com/easyui/datagrid-detailview.js"></script> 
    </head>  
    <body>  
          <table id="dg" style="width:1850px;height:850px"
            url="goods/onshow2"
            pagination="true" sortName="itemid" sortOrder="desc"
            title="扩展行"
            singleSelect="true" fitColumns="true">
        <thead>
            <tr>
             	<th field="gid" width="60">商品id</th>	
                <th field="gname" width="60">商品名</th>
                <th field="price" width="80">商品单价</th>
                <th field="count" align="right" width="70">商品库存</th>
                <th field="factory" align="right" width="70">生产厂商</th>
            </tr>
        </thead>
    </table>
        <script type="text/javascript">  
        $('#dg').datagrid({
            view: detailview,
            detailFormatter:function(index,row){
                return '<div class="ddv" style="padding:5px 0"></div>';
            },
            onExpandRow: function(index,row){
                var ddv = $(this).datagrid('getRowDetail',index).find('div.ddv');
                ddv.panel({
                    border:false,
                    cache:false,
                    href:'ShowGoodsDetails?gid='+row.gid,
                    onLoad:function(){
                        $('#dg').datagrid('fixDetailRowHeight',index);
                    }
                });
                $('#dg').datagrid('fixDetailRowHeight',index);
            }
        });
        </script>  
    </body>  
    </html>

2.GoodsOnShowServlet2

package com.xintouyun.medicine.background.servlet;

import java.io.IOException;
import java.io.PrintWriter;

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 javax.servlet.http.HttpSession;

import com.google.gson.Gson;
import com.xintouyun.medicine.entity.Goods;
import com.xintouyun.medicine.entity.Provider;
import com.xintouyun.medicine.entity.User;
import com.xintouyun.medicine.model.DataGrid;
import com.xintouyun.medicine.service.GoodsService;
import com.xintouyun.medicine.service.UserService;
import com.xintouyun.medicine.service.impl.GoodsServiceImpl;
import com.xintouyun.medicine.service.impl.UserServiceImpl;
@WebServlet("/goods/onshow2")
public class GoodsOnShowServlet2 extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{		
		
		PrintWriter out=response.getWriter();
		
		int pid=1;
		//1.获取参数
		String page=request.getParameter("page");
		String rows=request.getParameter("rows");
		 // 2.业务响应		
		GoodsService goodsService = new GoodsServiceImpl();
		DataGrid<Goods> data= goodsService.shop_goods_OnList(Integer.parseInt(page),Integer.parseInt(rows), pid);
		 //3.响应
		Gson gson=new Gson();
		String json=gson.toJson(data);
		out.print(json);
		out.close();
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{		
		this.doGet(request, response);
	}
}

3.ShowGoodsDetails

package com.xintouyun.medicine.servlet;

import java.io.IOException;

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 javax.servlet.http.HttpSession;

import com.xintouyun.medicine.entity.Goods;
import com.xintouyun.medicine.model.Page;
import com.xintouyun.medicine.service.GoodsService;
import com.xintouyun.medicine.service.impl.GoodsServiceImpl;
@WebServlet("/ShowGoodsDetails")
public class ShowGoodsDetails extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		HttpSession session = request.getSession();
		//1.获取参数........
		String gid=request.getParameter("gid");
		System.out.println("gid:"+gid);
		GoodsService goodsService = new GoodsServiceImpl();
		Goods goods = goodsService.show_goods_details(Integer.parseInt(gid));
		session.setAttribute("goods", goods);
		System.out.println("gname:"+goods.getGname());
		request.getRequestDispatcher("goodsDetail.jsp").forward(request, response);
	}
	
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		this.doGet(request, response);
		
	}
}

4.showgoodsDetail.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>   
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table class="dv-table" border="0" style="width:100%;">
    <tr>
        <td rowspan="3" style="width:60px">
            	<img src="${goods.fileName }"></img>
        </td>
        <td class="dv-label">商品名: </td>
        <td>${goods.gname }</td>
        <td class="dv-label">商品单价:</td>
        <td>${goods.price }</td>
    </tr>
    <tr>
        <td class="dv-label">商品库存: </td>
        <td>${goods.price }</td>
        <td class="dv-label">生产厂商:</td>
        <td>${goods.factory }</td>
    </tr>
    <tr>
        <td class="dv-label">商品详情: </td>
        <td colspan="3">${goods.content }</td>
    </tr>
</table>
</body>
</html>

一生所Ai

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
datagrid-expandrow(Java+Mysql+EasyUi实现)

数据库:m_goods 看完效果图：直接上代码1.test.jsp&lt;%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%&gt; &lt;html&gt; &lt;head&gt; &lt;meta htt
复制链接

扫一扫

专栏目录