JqGrid完整例子，springboot面试题及答案高级

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;

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

开源完整内容戳这里

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;