使用FlexiGrid插件,tomcat驱动没错,页面不显示table
JSP:<link rel="stylesheet" type="text/css" href="Flexigrid-master/css/flexigrid.css">
<srcipt type="text/javascript" src="Flexigrid-master/js/flexigrid.js"></srcipt>
<srcipt type="text/javascript" src="js/jquery-1.7.js"></srcipt>
<srcipt type="text/javascript" src="js/test.js"></srcipt>
<script type="text/javascript">
var grid=$("#flex1").flexigrid({
url:'flexiGridServlet',
dataType:'json',
colModel:[
{
display:'编号',
name:'id',
width:50,
sortable:true,
align:'center'
},
{
display:'工作名称',
name:'job_name',
width:250,
sortable:true,
align:'center'
},
{
display:'工作地址',
name:'work_address',
width:100,
sortable:true,
align:'center'
}, {
display : '工资',
name : 'salary',
width : 60,
sortable : true,
align : 'center'
}, {
display : '日期',
name : 'date',
width : 120,
sortable : true,
align : 'center'
}, {
display : '语言',
name : 'languge',
width : 100,
sortable : true,
align : 'center'
}],
buttons:[
{name:'添加',bclass:'add',onpress:toolbar},
{name:'删除',bclass:'delete',onpress:toolbar},
{name:'修改',bclass:'modify',onpress:toolbar},
{separator:true}
],
searchitems:[
{display:'编号',name:'id',isdefault:true},
{display:'工作名称',name:'job_name'},
{display:'工作地址',name:'work_address'},
{display:'语言',name:'language'}
],
errormsg:'发生异常',
sortname : "id",
sortorder : "asc",
usepager : true,
title : '信息发布管理',
pagestat:'显示记录从{from}到{to},总数{total}条',
useRp : true,
checkbox : true,// 是否要多选框
rowId : 'id',// 多选框绑定行的id
rp : 10,
showTableToggleBtn : true,
width : 1000,
height : 463
});
// 上面按钮点击响应函数
function toolbar(com,grid){
if (com=='删除'){
${"action"}.value="delete";
if($('.trSelected',grid).length==0){
alert("请选择要删除的数据");
}else{
if(confirm('是否删除这 ' + $('.trSelected',grid).length + ' 条记录吗?')){
var ids ="";
for(var i=0;i<$('.trSelected',grid).length;i++){
ids+=","+$('.trSelected',grid).find("td:first").eq(i).text();//获取id
}
idsids=ids.substring(1);
$.ajax({
type: "POST",
url: "flexGridServlet.do?actionaction="+${"action"}.value,
data: "id="+ids,
dataType:"text",
success: function(msg){
if(msg=="success"){
$("#flex1").flexReload();
}else{
alert("有错误发生,msg="+msg);
}
},
error: function(msg){
alert(msg);
}
});
}
}
}else if (com=='添加'){
${"action"}.value="add";
alert("flexGridServlet.do?actionaction="+${"action"}.value);
window.location.href="flexGridServlet.do?action="+${"action"}.value;
}else if (com=='修改'){
${"action"}.value="modify";
if($(".trSelected").length==1){
alert("flexGridServlet.do?action="+${"action"}.value+"&id="+$('.trSelected',grid).find("td").eq(0).text());
window.location.href="flexGridServlet.do?action="+${"action"}.value+"&id="+$('.trSelected',grid).find("td").eq(0).text();
}else if($(".trSelected").length>1){
alert("请选择一个修改,不能同时修改多个");
}else if($(".trSelected").length==0){
alert("请选择一个您要修改的记录")
}
//$("#flex1").flexReload({});
}
}
}
// 操作函数
function formatMoney(value,pid){
return "¥" + parseFloat(value).toFixed(2);
}
</script>
</head>
<body>
<table id="flex1" style="display:none"></table>
<input id="action" type="hidden" name="action" value="null"/>
</body>
web.xml:
<servlet>
<servlet-name>FlexigridServlet</servlet-name>
<servlet-class>testServlet.FlexigridServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>FlexigridServlet</servlet-name>
<url-pattern>/servlet/FlexigridServlet</url-pattern>
</servlet-mapping>
servletpackage testServlet;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javabean.Employee;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.directwebremoting.json.types.JsonObject;
import dao.DBConnection;
public class FlexigridServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private DBConnection db = new DBConnection();
int count = 0;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
String sql="";
// 当前第几页
String pageIndex = request.getParameter("page");
// 每页多少条
String pageSize = request.getParameter("rn");
// 条件字段值
String query = new String(request.getParameter("query").getBytes("ISO8859-1"),"UTF-8");
// 条件字段
String qtype = request.getParameter("qtype");
// 排序字段
String sortname = request.getParameter("sortname");
// desc or asc
String sortorder = request.getParameter("sortorder");
// 操作符
String qop = request.getParameter("qop");
List<Employee> list = null;
try{
sql = "select count(*) as count from job_info1";
if(!query.equals("")){
sql += "where "+qtype+"like"+"'%"+query+"'%";
}
ResultSet rsResultSet1 = db.executeQuery(sql);
count = rsResultSet1.getInt(1);
sql = "select * from job_info1";
if(!query.equals("")){
sql += "where" + qtype + "like" + "'%"+query+"'%";
}
sql += "order by"+sortname+""+sortorder;
sql += "limit" + ((Integer.parseInt("pageIndex")-1)*
Integer.parseInt(pageSize)+","+pageSize);
ResultSet rsResultSet2 = db.executeQueryList(sql);
while(rsResultSet2.next()){
int a = rsResultSet2.getInt(1);
String b = rsResultSet2.getString(2);
String c = rsResultSet2.getString(3);
String d = rsResultSet2.getString(4);
String e = rsResultSet2.getString(5);
String f = rsResultSet2.getString(6);
Employee employee = new Employee();
employee.setId(a);
employee.setJob_name(b);
employee.setWork_address(c);
employee.setSalary(d);
employee.setDate(e);
employee.setLanguge(f);
list.add(employee);
}
if(list == null){
System.out.println("=====出错啦=====");
return;
}
}catch(Exception e){
e.printStackTrace();
}
Map map = new HashMap();
map.put("page", pageIndex);
map.put("total", count+"");
// to JSON
String json = toJSON(list,map);
response.getWriter().write(json);
response.getWriter().flush();
response.getWriter().close();
}
/**
* 数据JSON格式化
*/
private String toJSON(List list,Map map){
List mapList = new ArrayList();
for(int i=0;i<list.size();i++){
Map cellMap = new HashMap();
cellMap.put("id", ((Map)list.get(i)).get("id").toString());
cellMap.put("cell", new Object[]{
((Map)list.get(i)).get("id"),
((Map)list.get(i)).get("name"),
((Map)list.get(i)).get("stand"),
((Map)list.get(i)).get("money"),
((Map)list.get(i)).get("leavings"),
((Map)list.get(i)).get("orders")
});
mapList.add(cellMap);
}
map.put("row", mapList);
JsonObject object = new JsonObject();
return object.toString();
}
}
--------------------编程问答-------------------- 数据库连接:
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConnection {
String url="jdbc:sqlserver://localhost:1433;DatabaseName=MessageBoard";
String user="USER11";
String passw="123456";
Connection cn=null;
Statement st=null;
ResultSet rs=null;
PreparedStatement ps=null;
// ��ݿ�����
public DBConnection(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
cn = DriverManager.getConnection(url,user,passw);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException e){
e.printStackTrace();
}
}
public ResultSet executeQueryList(String sql){
try {
st = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public ResultSet executeQuery(String sql){
try {
st = cn.createStatement();
rs = st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
// ����
public int executeUpdate(String sql){
int rscount=0;
try {
st = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rscount;
}
public PreparedStatement PSececuteUpdate(String sql){
try {
ps = cn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return ps;
}
// �ر�����
public void close() throws SQLException{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(cn!=null){
cn.close();
}
}
}
javabean:
package javabean;
public class Employee {
private int id;
private String job_name;
private String work_address;
private String salary;
private String date;
private String languge;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getJob_name() {
return job_name;
}
public void setJob_name(String job_name) {
this.job_name = job_name;
}
public String getWork_address() {
return work_address;
}
public void setWork_address(String work_address) {
this.work_address = work_address;
}
public String getSalary() {
return salary;
}
public void setSalary(String salary) {
this.salary = salary;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
public String getLanguge() {
return languge;
}
public void setLanguge(String languge) {
this.languge = languge;
}
}
请各位高手帮帮忙!不胜感激 --------------------编程问答--------------------
补充:Java , Web 开发