JqGrid完整例子，offer拿到手软

“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_selectR

《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》

【docs.qq.com/doc/DSmxTbFJ1cmN1R2dB】 完整内容开源分享

ow = $(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();