一个Servlet项目包含数据库，直接在ide里面以maven方式打开即可

import bean.Data; import bean.NewsResult; import bean.Result; import manager.DBTools; import manager.ResponseHandler; 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 java.io.IOException; import java.io.PrintWriter; import java.sql.*; import java.util.ArrayList; @WebServlet("/news") public class NewsServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req,resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("UTF-8");//请求编码类型 String type = req.getParameter("type"); if (type!=null && type.equals("newslist")){ queryNewsList(req,resp); }else if(type !=null && type.equals("addnews")){ addNews(req,resp); }else if(type !=null && type.equals("addlist")){ addList(req,resp); }else if (type !=null && type.equals("adddata")){ addData(req,resp); }else if (type !=null && type.equals("register")){ register(req,resp); } } private void register(HttpServletRequest req, HttpServletResponse resp) throws ServletException,IOException{ String phone = req.getParameter("phone"); // 接下来查询手机号是否存在，存在就说明已经注册过了，返回已注册的提示 System.out.print(phone); } private void addData(HttpServletRequest req, HttpServletResponse resp) throws ServletException,IOException{ NewsResult newsResult = ResponseHandler.getInstance().getNewsResult2(); Result result = newsResult.getResult(); for (Data datum : result.getData()) { String dataid = datum.getDataid(); String date = datum.getDate(); String category = datum.getCategory(); String authorName = datum.getAuthorName(); String isContent = datum.getIsContent(); String title = datum.getTitle(); String uniquekey = datum.getUniquekey(); String url = datum.getUrl(); String thumbnailPicS = datum.getThumbnailPicS(); String thumbnailPicS02 = datum.getThumbnailPicS02(); String thumbnailPicS03 = datum.getThumbnailPicS03(); String sql = "insert into Data values('"+uniquekey+"','"+dataid+"','"+title+"','"+date+"','"+category+"'," + "'"+authorName+"','"+url+"','"+thumbnailPicS+"','"+thumbnailPicS02+"','"+thumbnailPicS03+"','"+isContent+"');"; try { Connection connection = DBTools.createConnection(); DBTools.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } } resp.getWriter().write("adddata success."); } private void addList(HttpServletRequest req, HttpServletResponse resp) throws ServletException,IOException{ NewsResult newsResult2 = ResponseHandler.getInstance().getNewsResult2(); int id = 0; String reason = newsResult2.getReason(); int error_code = newsResult2.getError_code(); String dataid = newsResult2.getDataid(); Result result = newsResult2.getResult(); String stat = result.getStat(); String pageSize = result.getPageSize(); String page = result.getPage(); String sql = "insert into NewsResult values('"+id+"','"+reason+"','"+error_code+"','"+stat+"','"+page+"'," + "'"+pageSize+"','"+dataid+"');"; try { Connection connection = DBTools.createConnection(); DBTools.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } resp.getWriter().write("addlist success."); } private void addNews(HttpServletRequest req, HttpServletResponse resp) throws ServletException,IOException{ // 这里做增操作 int id = 0; String name = "google"; String grent = "banji"; String result = "80"; // String id = req.getParameter("id"); // String name = req.getParameter("name"); // String grent = req.getParameter("grent"); // String result = req.getParameter("result"); String sql = "insert into student values('"+id+"','"+name+"','"+grent+"','"+result+"');"; try { Connection connection = DBTools.createConnection(); DBTools.executeUpdate(sql); resp.getWriter().write("insert into student"+name+grent+result); } catch (SQLException e) { e.printStackTrace(); } } private void queryNewsList(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ // 这里做查询操作 resp.setCharacterEncoding("UTF-8");//响应编码类型 resp.setContentType("application/json");//响应数据类型 String newsResult = ResponseHandler.getInstance().getNewsResult(); resp.getWriter().write(newsResult); System.out.print(newsResult+"\n"); } }