json获取数据库数据并将数据返回前台

最新推荐文章于 2022-06-14 09:20:01 发布

灵感大王

最新推荐文章于 2022-06-14 09:20:01 发布

阅读量897

点赞数 1

本文链接：https://blog.csdn.net/weixin_45747732/article/details/102771496

版权

这是目录：
在这里插入图片描述
这是页面：

下边首先是jsp代码：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'indes.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<script src="js/jquery.js"></script>
<style type="text/css">
body{
background-color:blue;
}
table,td {
	border: 1px solid black;
	border-collapse: collapse;
}

td {
	text-align: center;
	width: 150px;
	height: 30px;
}
</style>
<script type="text/javascript">
	$(function() {
		$(":button").on(
				"click",
				function() {
					$.ajax({
						url : "Select",
						type : "post",
						dataType : "json",
						success : function(data) {
							$("tbody").empty();
							$.each(data, function(i) {
								var trString = "";
								trString = "<tr><td>" + data[i].id
										+ "</td><td>" + data[i].name
										+ "</td><td>" + data[i].author
										+ "</td><td>" + data[i].isbn
										+ "</td><td>" + data[i].publish
										+ "</td></tr>";
								$("tbody").append(trString);
							});
						}
					});
				});
	});
</script>
</head>

<body>
	<center>
		<input type="button" value="获取数据" />
		<table>
			<thead>
				<tr>
					<td>ID</td>
					<td>图书名称</td>
					<td>图书作者</td>
					<td>图书编号</td>
					<td>图书出版社</td>
				</tr>
			</thead>
			<tbody></tbody>
		</table>
	</center>
</body>
</html>

javaBean代码：

package com.hnpi.bean;

public class Book {
	private Integer id;// ID
	private String name;// 图书名称
	private String author;// 图书作者
	private String isbn;// 图书编号
	private String publish;// 图书出版社
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	public String getIsbn() {
		return isbn;
	}
	public void setIsbn(String isbn) {
		this.isbn = isbn;
	}
	public String getPublish() {
		return publish;
	}
	public void setPublish(String publish) {
		this.publish = publish;
	}
	public Book() {
		super();
		// TODO Auto-generated constructor stub
	}
}

service代码：

package com.hnpi.service;
import java.util.List;

import com.hnpi.bean.Book;
public interface BookService {
	List<Book> list();
}

impl代码：

package com.hnpi.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.hnpi.bean.Book;
import com.hnpi.service.BookService;
import com.hnpi.util.DButil;

public class BookServiceImpl implements BookService {

	public List<Book> list() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<Book> list = new ArrayList<Book>();
		try {
			conn = DButil.getConn();
			String sql = "select * from book";
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				Book book = new Book();
				book.setId(rs.getInt(1));
				book.setName(rs.getString(2));
				book.setAuthor(rs.getString(3));
				book.setIsbn(rs.getString(4));
				book.setPublish(rs.getString(5));
				list.add(book);
			}
		} catch (SQLException e) {
			// TODO: handle exception
		} finally {
			DButil.close(rs, ps, conn);
		}
		return list;
	}

}

select代码：

package com.hnpi.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

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

import com.alibaba.fastjson.JSON;
import com.hnpi.bean.Book;
import com.hnpi.service.BookService;
import com.hnpi.service.impl.BookServiceImpl;
public class Select extends HttpServlet {

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

		doPost(request, response);
	}

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

		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset = utf-8");
		PrintWriter out = response.getWriter();		
		BookService service = new BookServiceImpl();
		List<Book> lists = service.list();
		String json = JSON.toJSONString(lists);
		out.print(json);		
		out.flush();
		out.close();
	}

}

DButil代码：

package com.hnpi.util;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DButil {
	public static Connection getConn() {
		Connection conn = null;
		try {
			Driver.class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=MyDB", "sa", "1");
		}catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	public static void close(ResultSet rs,PreparedStatement ps,Connection conn) {
		try {
			if(rs != null)
				rs.close();
			if(ps != null)
				ps.close();
			if(conn != null)
				conn.close();
		}catch (Exception e) {
			e.printStackTrace();
		}
	}
}

温馨提示：数据库数据请自行添加

灵感大王

关注

1
点赞
踩
5

收藏

觉得还不错? 一键收藏
0
评论
json获取数据库数据并将数据返回前台

这是目录：这是页面：下边首先是jsp代码：<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + ...
复制链接

扫一扫