简单的图书管理系统

最新推荐文章于 2024-04-14 19:58:23 发布

ITEMN

最新推荐文章于 2024-04-14 19:58:23 发布

阅读量415

点赞数

本文链接：https://blog.csdn.net/ITEMN/article/details/102772184

版权

<%@ 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>
<title>首頁</title>
<style type="text/css">
table {
	margin-top: 36px; text-align : center;
	border-collapse: collapse;
	text-align: center;
}
</style>
<script type="text/javascript"src="JS/jQuery.js"
 ></script>
</head>
<body>
<input type="button" value="查看图书" onclick="show()" />
	<table border="1" align="center">
		<thead>
			<tr>
				<td>Id</td>
				<td>书名</td>
				<td>作者</td>
				<td>编号</td>
				<td>出版社</td>
			</tr>
		</thead>
		<tbody id="body">
		
		</tbody>
	</table>
	<script type="text/javascript">
		$(function() {
		$(function show(){
			$.ajax({
				url : "JsonServlet",
				type : "post",
				dataType : "json",
				success : function(data) {
					//console.log(data);
					$("#body").empty(); 
					var trStr = "";
					for (var i = 0; i < data.length; i++) {
						trStr += "<tr><td>" + data[i].Id + "</td><td>" + data[i].Name + "</td><td>" + data[i].People + "</td><td>" + data[i].Num + "</td><td>" + data[i].Publish + "</td></tr>"
					}
					$("#body").show().append(trStr);
				},
				error : function() {
					alert('请求失败');
				}
			});
		});
		});
	</script>
</body>
</html>

package bean;

public class books {

	private Integer Id;
	private String Name;
	private String People;
	private String Num;
	private String Publish;
	public Integer getId() {
		return Id;
	}
	public void setId(Integer id) {
		Id = id;
	}
	public String getName() {
		return Name;
	}
	public void setName(String name) {
		Name = name;
	}
	public String getPeople() {
		return People;
	}
	public void setPeople(String people) {
		People = people;
	}
	public String getNum() {
		return Num;
	}
	public void setNum(String num) {
		Num = num;
	}
	public String getPublish() {
		return Publish;
	}
	public void setPublish(String publish) {
		Publish = publish;
	}
	
	public books() {
		super();
		// TODO Auto-generated constructor stub
	}
	public books(Integer Id, String Name, String People, String Num, String Publish) {
		super();
		this.Id = Id;
		this.Name = Name;
		this.People = People;
		this.Num = Num;
		this.Publish = Publish;
	}


}

package servlet;

import java.awt.print.Book;
import java.io.IOException;
import java.io.PrintWriter;
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 javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;

import bean.books;

import util.DBUtil;

	public class JsonServlet 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.setContentType("text/html;charset=utf-8");
			request.setCharacterEncoding("utf-8");
			PrintWriter out = response.getWriter();
		
			PreparedStatement ps = null;
			ResultSet rs = null;
			Connection conn = DBUtil.getConn();
			try {	
				String sql = "select * from Book";
				ps = conn.prepareStatement(sql);
				rs = ps.executeQuery();
				List<books> books = new ArrayList<books>();
				while (rs.next()) { // next（）获取里面的内容
					books book = new books();
					book.setId(rs.getInt(1));
					book.setName(rs.getString(2));
					book.setPeople(rs.getString(3));
					book.setNum(rs.getString(4));
					book.setPublish(rs.getString(5));
					books.add(book);
				}
				String json = JSON.toJSONString(books);
				out.print(json);
			
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				DBUtil.close(rs, ps, conn);
			}
			out.flush();
			out.close();
		}
	}