上一篇講了python 爬取糗事百科的數(shù)據(jù)到數(shù)據(jù)庫(kù)中，本篇講解java web接口開(kāi)發(fā)，以json的形式展示接口
準(zhǔn)備：java 環(huán)境蝎抽，tomcat環(huán)境，eclipse路克，eclipse集成tomcat ,json.jar,mysql-connect-java .jar
eclipse新建Dynamic web project,目錄層級(jí)如下：
image.png
將jar包復(fù)制到lib目錄下樟结，然后add build to path
下面詳述代碼：
1.創(chuàng)建糗事百科實(shí)體類Qiushibaike
package com.entity;
public class Qiushibaike {
private int id;
private String imgurl;
private String username;
private String vote;
private String comments;
private String content;
private String imgpath;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getImgurl() {
return imgurl;
}
public void setImgurl(String imgurl) {
this.imgurl = imgurl;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getVote() {
return vote;
}
public void setVote(String vote) {
this.vote = vote;
}
public String getComments() {
return comments;
}
public void setComments(String comments) {
this.comments = comments;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getImgpath() {
return imgpath;
}
public void setImgpath(String imgpath) {
this.imgpath = imgpath;
}
}
2.寫(xiě)一個(gè)分頁(yè)實(shí)體類QiushiPage：
package com.entity;
import java.util.List;
public class QiushiPage {
private int currentPage;//當(dāng)前頁(yè)
private int totalPage;//總頁(yè)數(shù)
private int count;//一頁(yè)多少條數(shù)據(jù)
private int totalCount;//數(shù)據(jù)總條數(shù)
private List<Qiushibaike> qiushibaikes;//當(dāng)前頁(yè)的數(shù)據(jù)
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
public List<Qiushibaike> getQiushibaikes() {
return qiushibaikes;
}
public void setQiushibaikes(List<Qiushibaike> qiushibaikes) {
this.qiushibaikes = qiushibaikes;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public int getTotalPage() {
return totalPage;
}
public void setTotalPage(int totalPage) {
this.totalPage = totalPage;
}
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
}
3.數(shù)據(jù)庫(kù)操作類QiushiDaoImpl：
package com.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.entity.Qiushibaike;
public class QiushiDaoImpl {
private PreparedStatement ptmt = null;
private ResultSet rs = null;
//獲取表中的數(shù)據(jù)精算，放入list,并返回
public List<Qiushibaike> getCaseAll(int page, int count) {
// TODO Auto-generated method stub
List<Qiushibaike> list = new ArrayList<Qiushibaike>();
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/shop?useunicuee=true& characterEncoding=utf8";
String username="root";
String password="root";
Connection conn=DriverManager.getConnection(url,username,password);
String sql="select id,imgurl,comments,username,content,vote,imgpath from qiushibaike LIMIT ?,?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, (page-1)*count);
ps.setInt(2, count);
ResultSet rs=ps.executeQuery();
//查詢實(shí)體放入list
while(rs.next()){
Qiushibaike qiushibaike=new Qiushibaike();
//查詢的每個(gè)字段值放入到實(shí)體中
qiushibaike.setId(rs.getInt("id"));
qiushibaike.setImgurl(rs.getString("imgurl"));
qiushibaike.setComments(rs.getString("comments"));
qiushibaike.setUsername(rs.getString("username"));
qiushibaike.setContent(rs.getString("content"));
qiushibaike.setVote(rs.getString("vote"));
qiushibaike.setImgpath(rs.getString("imgpath"));
list.add(qiushibaike);
}
rs.close();
ps.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
//查詢表中的記錄數(shù)瓢宦，并返回
public int count() throws SQLException {
int count = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/test?useunicuee=true& characterEncoding=utf8";
String username="root";
String password="root";
Connection conn=DriverManager.getConnection(url,username,password);
if(conn==null){
throw new NullPointerException("conn is null");
}
PreparedStatement ps = conn.prepareStatement("SELECT COUNT(*) FROM qiushibaike");
if(ps==null){
throw new NullPointerException("ps is null");
}
ResultSet rs = ps.executeQuery();
if(rs==null){
throw new NullPointerException("rs is null");
}
if (rs.next()) {
count = rs.getInt(1);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return count;
}
}
4.數(shù)據(jù)分頁(yè)類QiushiServiceImpl:
package com.dao;
import java.sql.SQLException;
import java.util.List;
import com.entity.QiushiPage;
import com.entity.Qiushibaike;
public class QiushiServiceImpl {
private QiushiDaoImpl qiushiDaoImpl = new QiushiDaoImpl();
public QiushiPage findPage(int page, int count) {
if(qiushiDaoImpl==null){
qiushiDaoImpl = new QiushiDaoImpl();
}
try {
List<Qiushibaike> qiushibaikes = qiushiDaoImpl.getCaseAll(page, count);
System.out.println(qiushibaikes);
int totle = qiushiDaoImpl.count();
System.out.println(totle);
QiushiPage p=new QiushiPage();
p.setQiushibaikes(qiushibaikes);;
p.setCurrentPage(page);
p.setCount(count);
p.setTotalCount(totle);
int totlePage = totle%count==0?totle/count:(totle/count)+1;
p.setTotalPage(totlePage);
return p;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}
5.servlet類QiushiServlet：
package com.servlet;
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 com.dao.QiushiDaoImpl;
import com.dao.QiushiServiceImpl;
import com.entity.QiushiPage;
import com.entity.Qiushibaike;
import com.google.gson.Gson;
/**
* Servlet implementation class TestAdd
*/
public class QiushiServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public QiushiServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
QiushiServiceImpl qiushiServiceImpl=new QiushiServiceImpl();
int currentPage=1;
//每一頁(yè)15條數(shù)據(jù)
int count=15;
String value = request.getParameter("page");
if(value!=null&&!"".equals(value)){
currentPage = Integer.parseInt(value);
}
//轉(zhuǎn)化成json
QiushiPage page = qiushiServiceImpl.findPage(currentPage, count);
Gson gson = new Gson();
String json = gson.toJson(page);
// 輸出到界面
System.out.println(json);
//response.setCharacterEncoding("utf-8");
response.setContentType("text/json;charset=utf-8");
//PrintWriter out = response.getWriter();
PrintWriter out = new PrintWriter(response.getWriter());
out.print(json);
out.flush();
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
6.WEB-INF 目錄下新建一個(gè)xml文件web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
<display-name></display-name>
<servlet>
<servlet-name>QiushiServlet</servlet-name>
<servlet-class>com.servlet.QiushiServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>QiushiServlet</servlet-name>
<url-pattern>/QiushiServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
7.WebContent下新建一個(gè)jsp文件：
<%@ 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>首頁(yè)</title>
</head>
<body>
<a href = "QiushiServlet">點(diǎn)擊接口</a><br>
</body>
</html>
代碼部分就是這樣，附上代碼結(jié)構(gòu)圖：
image.png
最有右擊項(xiàng)目灰羽，run on server結(jié)果如圖
image.png
點(diǎn)擊上圖的按鈕跳轉(zhuǎn)到接口界面：
image.png
需要訪問(wèn)第二頁(yè)時(shí)輸入如下網(wǎng)址驮履，page后面的數(shù)字表示頁(yè)數(shù)：
http://localhost:8080/QiuShiSample/QiushiServlet?page=2
