当前位置： 首页 > news >正文

去哪找网站建设公司游戏代理推广渠道

news 2025/8/6 8:40:29
去哪找网站建设公司,游戏代理推广渠道,网站建设 中企动力宜昌,新公司注册取名之前写过一篇过于ajax异步加载jqgrid的文章，那个只是一个特殊的情况，如果创建不同数据库表的jqgrid，必须分别写servlet，dao层和连接池，很麻烦，今天我写了一个万能的写法，客官只要在前台js中写入…

之前写过一篇过于ajax异步加载jqgrid的文章，那个只是一个特殊的情况，如果创建不同数据库表的jqgrid，必须分别写servlet，dao层和连接池，很麻烦，今天我写了一个万能的写法，客官只要在前台js中写入表格名称和字段名称即可实现功能！
下面就是代码实例，关于jqgrid，ajax的介绍这里暂时不多说，有不懂的可以参考我之前的文章！

目录

    • 一、代码实例
      • 1、JSP
      • 2、JavaScript
      • 3、servlet
      • 4、service
      • 5、dao
      • 6、entity
      • 7、连接池
    • 二、效果展示
    • 三、哪吒社区

一、代码实例

1、JSP

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>定义>类型</title><link rel="stylesheet" href="css/homepage.css"><link type="text/css" rel="stylesheet" href="css/bootstrap.min.css"><link type="text/css" rel="stylesheet" href="js/JqGrid/css/font-awesome.min.css"><link type="text/css" rel="stylesheet" href="js/JqGrid/css/ui.jqgrid.css"><link type="text/css" rel="stylesheet" href="js/JqGrid/css/jquery-ui.min.css">
</head>
<body>
<div class="headerColor"><span>定义>类型</span>
</div>
<div class="row col-sm-12"><div class="frame_border"><div class="titleColor"><span>已定义模拟量测点信息</span><div id="typeDefines"><table id="typeDefine"></table><div id="typeDefinePager"></div></div></div></div>
</div>
<script  type="text/javascript" src="js/JqGrid/js/jquery.min.js"></script>
<script  type="text/javascript" src="js/JqGrid/js/jquery.jqGrid.min.js"></script>
<script  type="text/javascript" src="js/JqGrid/js/bootstrap.min.js"></script>
<script  type="text/javascript" src="js/JqGrid/js/grid.locale-en.js"></script>
<script  type="text/javascript" src="js/JqGrid/js/grid.locale-cn.js"></script>
<script  type="text/javascript" src="js/JqGrid/js/jquery.jqgrid.typedefine.js"></script>
<script  type="text/javascript">jf_initJqgrid();function jf_initJqgrid(){$("#typeDefine").jqGridTypeDefine({pager_selector:"#typeDefinePager",//分页height:"360",//表格高度width:$("#typeDefines"),//表格宽度where:{},//初始化查询条件wherestring:{},oper:"jqGridCre",tableid : "kj_typedefine",});}
</script>
</body>
</html>

2、JavaScript

;(function($){$.fn.jqGridTypeDefine = function(options){//获取jquery对象var grid_selector = this;var initDate = "{oper: ""," +"height: ""," +"width: ""," +"pager_selector: "typeDefinePager"," +"where: ""," +"wherestring: {}," +"fileds: ["id", "property", "name", "sensortype", "unit","highvalue"]," +"table:"kj_typedefine"}";$.ajax({url:"MyServlet",async:true,   //是否为异步请求cache:false,  //是否缓存结果type:"GET",dataType:"json",data :{"data" : initDate,},success : function(data){for(var i=0;i<=data.length;i++){$("#typeDefine").jqGrid('addRowData',i+1,data[i]);}}})switch(options.oper){case 'jqGridCre':jqgridCre(initDate,grid_selector);break;case 'jqGridFre':jqGridFre(initDate,grid_selector);break;}$('[id^=jqgh_typeDefine_]').css("height","20px");}function jqgridCre(initDate,grid_selector) {jQuery(grid_selector).jqGrid({colNames:['标识符','属性', '名称','传感器种类','单位/0态名称','高值/1态名称'],colModel:[{name:'id',index:'id',width: 100,},{name:'property',index:'property',width: 100,},{name:'name',index:'name',width: 100,},{name:'sensortype',index:'sensortype',width: 100,},{name:'unit',index:'unit',width: 100,},{name:'highvalue',index:'highvalue',width: 100,}],sortname : "id",sortorder : "desc",viewrecords : true,shrinkToFit : true,width: 1645,height: 500,rowNum : 20,rowList : [ 10,15,30 ],datatype: 'text',pager: "#typeDefinePager",onSelectRow:function(rowid){grid_selectRow = $(grid_selector).jqGrid("getRowData",rowid);},});}
})(jQuery);

3、servlet

package com.test.servlet;import com.test.entity.MyEntity;
import com.test.service.MyService;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;public class MyServlet extends HttpServlet {MyService service = new MyService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException{response.setContentType("text/html");request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException{response.setContentType("text/html");request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");String jqgridData = request.getParameter("data");MyEntity myEntity = new MyEntity();myEntity.setJqgridData(jqgridData);String str = service.getJqgridData(myEntity);response.getWriter().print(str);}
}

4、service

package com.test.service;import com.test.dao.MyDao;
import com.test.entity.MyEntity;public class MyService {MyDao myDao = new MyDao();public String getJqgridData(MyEntity myEntity) {String jqgridData = myDao.selectJqgridData(myEntity);return jqgridData;}
}

5、dao

package com.test.dao;import com.test.entity.MyEntity;
import com.test.entity.SecondData;
import com.test.util.MySQLFactory;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;public class MyDao {public String selectJqgridData(MyEntity myEntity) {String str = myEntity.getJqgridData();String data = "";try {JSONObject obj = new JSONObject(str);String oper = String.valueOf(obj.get("oper"));String fileds = String.valueOf(obj.get("fileds")).replace(""","").replace("[","").replace("]","");String table = String.valueOf(obj.get("table"));String sql = String.format("select %s from %s ",fileds,table);System.out.println(sql);data = MySQLFactory.queryData(sql);} catch (JSONException e) {e.printStackTrace();}return data;}
}

6、entity

package com.test.entity;public class MyEntity {private String jqgridData;public MyEntity() {}public MyEntity(String jqgridData) {this.jqgridData = jqgridData;}public String getJqgridData() {return jqgridData;}public void setJqgridData(String jqgridData) {this.jqgridData = jqgridData;}
}

7、连接池

package com.test.util;import java.sql.*;public class MySQLFactory {static final String DRVIER = "com.mysql.jdbc.Driver";static final String URL = "jdbc:mysql://localhost:3306/mysql";static final String USERNAMR = "root";static final String PASSWORD = "root";private static Connection conn = null;public static Connection getConnection(){try {Class.forName(DRVIER);conn = DriverManager.getConnection(URL, USERNAMR, PASSWORD);System.out.println("成功连接数据库");} catch (ClassNotFoundException e) {throw new RuntimeException("class not find !", e);} catch (SQLException e) {throw new RuntimeException("get connection error!", e);}return conn;}public static void executeSQL(String sql) {Statement stat = null;try {conn = getConnection();stat = conn.createStatement();} catch (Exception e) {e.printStackTrace();return;}try {stat.execute(sql);} catch (Exception e) {e.printStackTrace();return;}try {if (stat != null) stat.close();if (conn != null) conn.close();} catch (Exception e) {e.printStackTrace();}}public static String queryNoPage(String sql) {Connection conn      = null;Statement  stat      = null;ResultSet  rows      = null;StringBuffer   buff = new StringBuffer();try {conn   =  getConnection();stat   =  conn.createStatement();}catch (Exception e) {e.printStackTrace();return "[]";}try {rows    = stat.executeQuery(sql);//得到数据集的列数ResultSetMetaData rsmd = rows.getMetaData();int    colCount      = rsmd.getColumnCount();boolean first = true;buff.append("[");while (rows.next()) {String rowStr  = "";for (int i = 1; i <= colCount; i ++ ) {if (i>1) rowStr += ",";String tempValue   =  rows.getString(i);rowStr          += String.format("%s", tempValue);}rowStr = String.format(""%s"", rowStr);if (first) first = false;else buff.append(",");buff.append(rowStr);}buff.append("]");}catch (Exception e) {e.printStackTrace();return "[]";}finally {try {rows.close();stat.close();conn.close();} catch (SQLException e) {e.printStackTrace();}}return buff.toString();}public static String queryData(String sql){Connection conn      = null;Statement  stat      = null;ResultSet  rows      = null;StringBuffer   buff = new StringBuffer();try {conn   =  getConnection();stat   =  conn.createStatement();}catch (Exception e) {e.printStackTrace();return "[]";}try {rows    = stat.executeQuery(sql);//得到数据集的列数ResultSetMetaData rsmd = rows.getMetaData();int    colCount      = rsmd.getColumnCount();buff.append("[");while (rows.next()) {String rowStr  = "";buff.append("{");for (int i = 1; i <= colCount; i ++ ) {if (i>1) rowStr += ",";String name = rsmd.getColumnName(i);String tempValue   =  rows.getString(i);rowStr          += String.format(""%s":"%s"", name,tempValue);}rowStr = String.format("%s", rowStr);buff.append(rowStr);buff.append("},");}buff.append("]");} catch (SQLException e) {e.printStackTrace();return "[]";}String str = buff.toString().replace(",]","]");return str;}
}

二、效果展示

在这里插入图片描述

三、哪吒社区

1、Java从入门到项目实战
2、SQL从入门到精通
3、手把手教你学Linux
4、Python从入门到项目实战
在这里插入图片描述

http://www.lbrq.cn/news/2597653.html

相关文章：

  • 做违法网站媒体邀约
  • 怎样做企业网站建设深圳seo网络优化公司
  • 上海做网站大的公司站长统计网站统计
  • 专业做网站建设公司seo关键词排名优化报价
  • wordpress网站导航菜单插件百度域名查询官网
  • 手机触屏网站幻灯片优化推广关键词
  • 杨浦专业做网站关键词排名代做
  • 新建的网站如何做seo网络推广软文怎么写
  • 微信网站跳转链接怎么做怎么进行推广
  • 网站建设广州营销网站设计
  • 电子商务网站开发技术毕业论文百度首页广告多少钱
  • wordpress移动端底部添加菜单二十条优化疫情措施
  • 医院网站制作好吗合肥seo推广外包
  • 网站建设 成功案例seo自学网app
  • 网站建设策划长沙网络推广外包费用
  • 昆明网站建设公司电话谷歌seo培训
  • 百度网站的网址在线客服系统
  • 怎么让人搜索到自己做的网站2345网址导航桌面版
  • 金华企业自助建站系统友链交换平台
  • 建网站需要备案吗百度网络营销的概念
  • 怎么用自己的服务器做网站免费网站代理访问
  • 网站建设ftp蔡甸seo排名公司
  • 做色流网站要注意什么地方推广产品的方式有哪些
  • 做网站 图片素材怎么找收录查询工具
  • 天津商务网站建设网络关键词
  • 个人网站免费模板百度账户代运营
  • 青岛网站建设首选营销吧系统西安seo关键词查询
  • 公司要制作网站域名大全免费网站
  • 河北信息门户网站定制优化设计三年级下册数学答案
  • 做网站流程网站seo的优化怎么做
  • 暑期算法训练.14
  • GPT-5的诞生之痛：AI帝国的现实危机
  • 《C++初阶之STL》【模板参数 + 模板特化 + 分离编译】
  • 【机器学习深度学习】模型压缩简介
  • ZYNQ-按键消抖
  • shell脚本tcpdump抓取数据解析执行关机指令