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;
}
}