jQuery MiniUI

标题: 关于loading的问题 [打印本页]

作者: flying 时间: 2017-3-1 15:25:34 标题: 关于loading的问题

页面表格加载可以正常显示，根据条件查询几次之后，重新刷新页面表格数据一直处于loading...，把项目重新部署之后，在刷新页面又可以正常显示，根据条件查询几次之后刷新页面又是loading，请问有大神知道这是怎么回事吗？前台后台都不报错

作者: flying 时间: 2017-3-1 15:39:52

[attach]8892[/attach]

作者: flying 时间: 2017-3-1 15:41:53

Dao层
public List<Course> findAllCourse() {
Connection conn = null;
List<Course> queryAll = new ArrayList<Course>();
try {
conn = DBUtil.getConnection();
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM courseinfo";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
Course course = createCourse(rs);
queryAll.add(course);
}
} catch (Exception e) {
e.printStackTrace();
}
return queryAll;
}

public Course createCourse(ResultSet rs) throws SQLException {
Course course = new Course();
course.setId(rs.getString("id"));
course.setCoursename(rs.getString("coursename"));
course.setStarttime(rs.getString("starttime"));
course.setSuitable(rs.getInt("suitable"));
course.setType(rs.getInt("type"));
course.setTotalhours(rs.getInt("totalhours"));
course.setHotlevel(rs.getInt("hotlevel"));
course.setSelectcount(rs.getInt("selectcount"));
course.setNote(rs.getString("note"));
return course;
}

@Override
public List<Course> findByName(String keys) {
Connection conn = null;
List<Course> queryName = new ArrayList<Course>();
try {
conn = DBUtil.getConnection();
String sql = "select * from courseinfo where coursename like ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "%" + keys + "%");
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
Course course = createCourse(rs);
queryName.add(course);
}
} catch (Exception e) {
e.printStackTrace();
}
return queryName;
}

@Override
public List<Course> findByType(String keys) {
int t = 0;
if (keys.trim().equals("C#")) {
t = 1;
} else if (keys.trim().equals("Java")) {
t = 2;
} else if (keys.trim().equals("C++")) {
t = 3;
}
Connection conn = null;
List<Course> queryType = new ArrayList<Course>();
try {
conn = DBUtil.getConnection();
String sql = "select * from courseinfo where type=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, t);
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
Course course = createCourse(rs);
queryType.add(course);
}
} catch (Exception e) {
e.printStackTrace();
}
return queryType;
}

作者: flying 时间: 2017-3-1 15:42:37

servlet
protected void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
res.setCharacterEncoding("utf-8");
res.setContentType("text/html");
CourseDao dao = new CourseDaoImpl();
List<Course> dataAll = new ArrayList<Course>();
String keys = req.getParameter("key");
if (keys != null) {
if (keys.trim().equals("C#") || keys.trim().equals("Java") || keys.trim().equals("C++")) {
dataAll = dao.findByType(keys);
} else {
dataAll = dao.findByName(keys);
}
} else {
dataAll = dao.findAllCourse();
}
int index = Integer.parseInt(req.getParameter("pageIndex"));
int size = Integer.parseInt(req.getParameter("pageSize"));
List<Object> data = new ArrayList<Object>();
for (int i = 0, l = dataAll.size(); i < l; i++) {
Object record = dataAll.get(i);
if (record == null)
continue;
if (index * size <= i && i < (index + 1) * size) {
data.add(record);
}
}
Map<String, Object> result = new HashMap<String, Object>();
result.put("data", data);
result.put("total", dataAll.size());
String json = JsonUtil.objectToJson(result);
res.getWriter().print(json);
}

作者: flying 时间: 2017-3-1 15:43:48

html
<h1 style="text-align: center; width: 100%;">课程信息</h1>
<div style="width: 100%;">
<div class="mini-toolbar" style="border-bottom: 0; padding: 0px;">
<table style="width: 100%;">
<tr>
<td style="width: 100%;"><a class="mini-button"
iconCls="icon-add" onclick="addcourse()" tooltip="增加...">添加课程信息</a>
<a class="mini-button" iconCls="icon-remove" onclick="removeRow()">删除选中</a>
</td>
<td style="white-space: nowrap;"><input id="key"
class="mini-combobox" emptyText="请选择查询类别..." style="width: 150px;"
onenter="onKeyEnter" data="types"/> </td>
<td style="white-space: nowrap;"><input id="key"
class="mini-textbox" emptyText="请输入关键字" style="width: 150px;"
onenter="onKeyEnter" /> <a class="mini-button" onclick="search()"
style="width: 60px;">查询</a></td>

</tr>
</table>
</div>
</div>
<div id="datagrid1" class="mini-datagrid"
style="width: 100%; height: 250px;" url="findAllCourse" idField="id"
allowResize="true" pageSize="5" multiSelect="true">
<div property="columns">
<div type="indexcolumn">序号</div>
<div type="checkcolumn"></div>
<div field="id" width="80" headerAlign="center" align="center"
allowSort="true">课程编号</div>
<div field="coursename" width="80" headerAlign="center"
align="center" allowSort="true">课程名称</div>
<div field="starttime" width="80" align="center" headerAlign="center"
dateFormat="yyyy-MM-dd">开课时间</div>
<div field="suitable" width="80" renderer="onsuit" align="center" headerAlign="center"
allowSort="true" data="type">适合人群</div>
<div field="type" width="80" renderer="ontype" allowSort="true" headerAlign="center"
align="center" data="type">课程类别</div>
<div field="totalhours" width="80" headerAlign="center"
align="center" allowSort="true">总学时</div>
<div field="hotlevel" width="80" headerAlign="center" align="center"
allowSort="true">热门程度</div>
<div field="selectcount" width="80" headerAlign="center"
align="center" allowSort="true">已学次数</div>
<div field="note" width="80" headerAlign="center"
align="center" allowSort="true">其他说明</div>

<div name="action" width="80" headerAlign="center" align="center"
renderer="onActionRenderer" cellStyle="padding:0;">操作</div>
</div>
</div>

作者: felt 时间: 2017-3-1 17:37:05

flying 发表于 2017-3-1 15:43
html
课程信息

正常是加载完成后loading是自动取消掉的，按f12看一下网络交互，检查一下是交互没完成，还是正常完成只是loading没消失。
表格可以设置showLoading="false"强制不显示loading

欢迎光临 jQuery MiniUI (http://miniui.com/discuss/)