关于Java后台的Json数据的传递问题

Java使用Json数据格式需要导入六个jar包:
如下:



完整代码如下:
index.jsp页面如下:
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <!-- <link rel="stylesheet" href="CSS/login1.css"> -->
    <script src="js/jquery-3.2.1.js"></script>
</head>
<body>
<div class="max" style="width: 60%;margin:0 auto;">
<template>
    <tr>
        <td>{id}</td>
        <td>{name}</td>
        <td>{password}</td>
    </tr>
</template>
<table style="width: 200px;margin:0 auto;border:1px solid red;text-align:center;">
    <tr>
        <td>id</td>
        <td>姓名</td>
        <td>密码</td>
    </tr>
    <tr></tr>
</table>
</div>
</body>
<script>
     $('body').ready(function(){
        var templatehtml = $('template').html();
        
        var html = '';
        $.getJSON('JsonServlet',function(data){
            for(var i = 0;i<data.length;i++) {
                html += templatehtml.replace('{id}',data[i].id).replace('{name}',data[i].name).replace('{password}',data[i].password);
            };
            $('table').html(html);
        });
    });
</script>
</html>

后台Servelt代买如下:
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;

import com.sf.Dao.Userdaoinferce;
import com.sf.DaoImpl.Userdaoimpl;
import com.sf.bean.Userbean;

@WebServlet("/JsonServlet")
public class JsonServlet extends HttpServlet {
public JsonServlet() {
super();
}

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

response.setContentType("text/html");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
doPost(request, response);
out.close();
}

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

response.setContentType("text/html");
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
Userdaoinferce udao = new Userdaoimpl();
List<Userbean> list = new ArrayList<Userbean>();
list = udao.findeAllUser();
        JSONArray obj = JSONArray.fromObject(list); //Java数组转换为JSON字符串
        String str = obj.toString();
        
        out.println(str);//将Servlet的内容输出到页面
out.close();
}

}
daoImpl层代码:

package com.sf.DaoImpl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.sf.Dao.Userdaoinferce;
import com.sf.bean.PageBean;
import com.sf.bean.Userbean;
import com.sf.database.Db;

public class Userdaoimpl extends Db implements Userdaoinferce{
List<Userbean> list =new ArrayList<Userbean>();
@Override
public List findeAllUser() {
try{
conn=this.getConnection();
String sql = "select * from user";
stmt=conn.prepareStatement(sql);
rs=stmt.executeQuery();
while(rs.next()){
Userbean userbean = new Userbean();
userbean.setId(rs.getInt("id"));
userbean.setName(rs.getString("name"));
userbean.setPassword(rs.getString("password"));
userbean.setUserClass(rs.getString("userClass"));
list.add(userbean);
}
}catch(Exception e){
e.printStackTrace();
}
finally{
this.closeAll();
}
return list;
}
}

UserBean.java
package com.sf.bean;

public class Userbean {
private int id;
private String name;
private String password;
private String userClass;
private String imgaddress;
public String getImgaddress() {
return imgaddress;
}
public void setImgaddress(String imgaddress) {
this.imgaddress = imgaddress;
}
public String getUserClass() {
return userClass;
}
public void setUserClass(String userClass) {
this.userClass = userClass;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值