easyui datagrid 指定servlet路径问题 -

Fs_sky

浏览: 10370 次
性别:

最近访客更多访客>>

u013227524

zhlace

dexlind

CForward

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

easyui datagrid 指定servlet路径问题

servlet

[size=small]JSP代码[/size]
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>datagrid 测试</title>

<script type="text/javascript" src="../js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="../js/jquery.min.js"></script>

<link rel="stylesheet" type="text/css" href="../css/easyui.css">
<link rel="stylesheet" type="text/css" href="../css/icon.css">
<link rel="stylesheet" type="text/css" href="../css/demo.css">
<script type="text/javascript" src="../js/jquery.easyui.min.js"></script>
<script type="text/javascript" src="../js/easyloader.js"></script>

<script type="text/javascript">
$(function(){
loadMessage();

});
function loadMessage(){

//加载数据

$('#a').datagrid({

      url:'http://localhost:8080/BXpro/servlet/BranchSerDatagridDemo',

      columns:[[
{field:'UID',title:'用户ID',width:100},
          {field:'ID',title:'主键ID',width:100},
          {field:'BNAME',title:'部门',width:100}
     ]]

});

}
</script>
</head>
<body>
<div style="margin-top:100px;">
<table id="a" ></table>
</div>

</body>
</html>

servlet 代码

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

response.setContentType("text/html");
PrintWriter out = response.getWriter();
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
//String id = request.getParameter("id");
//String bname = request.getParameter("bname");
//System.out.println(id+":"+bname);

Dao dao = new Dao();
Object o []= new Object[0];

List<Map> list = dao.doquery("select * from branch", o);
System.out.println("list------"+list);
//输出 list------[{UID=1, ID=1, BNAME=行政部}, {UID=1, ID=2, BNAME=软件产品事业部}, {UID=1, ID=3, BNAME=市场部}, {UID=1, ID=4, BNAME=销售部}, {UID=1, ID=6, BNAME=管理部}]
if(list != null){

out.print(list);
//response.encodeURL("/test/datagridDemo.jsp");

}

}

DAO代码

public List <Map> doquery(String sql,Object...o){
List list = new ArrayList();
//1、获取数据库连接
DbmysqlConn dbmysql = new DbmysqlConn();
c = dbmysql.getConn();
//2、将SQL作为preparedStatement 参数传入
try {
ps = c.prepareStatement(sql);
setprepareValue(ps,o);      //给PS赋值
rs= ps.executeQuery();
//获取字段列数
rsm= rs.getMetaData();
int count = rsm.getColumnCount();
/*遍历出列数,列的值
* key :字段的名称
* value:字段的值
*/
while(rs.next()){
Map map = new HashMap();
for(int i=1;i<=count;i++){
map.put(rsm.getColumnName(i).toUpperCase(), rs.getObject(rsm.getColumnName(i)));
}
list.add(map);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
//释放资源
close(rs,ps,c);
}

return list;
}

但是没有查询出数据是怎么回事？第一次使用easyui datagrid 指定servlet路径，请大家指教下。。。。