图书借阅微信小程序，内含前台和后台完整代码，附送小程序学习视频地址

package com.geowind.HiaRead.select; import java.io.IOException; import java.net.URLDecoder; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletContext; 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.geowind.HiaRead.SQL.SQLBasic; import net.sf.json.JSONObject; /** * 推荐个人喜好的书籍 * 随机从数据库里面拿出三条数据 返回的信息是 书名 作者 藏书量 封面 版本号，类别 name author collection picture version */ @WebServlet("/select/SelectPersonBooks") public class SelectPersonBooks extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public SelectPersonBooks() { super(); // TODO Auto-generated constructor stub } @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO 自动生成的方法存根 //获取请求参数 List<JSONObject> list = new ArrayList<>();//数组 ServletContext application=this.getServletContext(); //因为客户端那里发送过来的是中文 而且请求方式是get 所以我们要先编码，，再解码 String query = request.getQueryString(); String queryStr = URLDecoder.decode(query,"UTF-8"); String params[] = queryStr.split("&"); String mess[] = new String[5];//省市区 图书馆名 int i=0; for(String param:params) { String []value = param.split("="); mess[i] = value[1]; i++; } //然后得到 用户 数据库连接对象 Connection connection = (Connection) application.getAttribute("connUser"); if(connection == null) { connection = new SQLBasic("HiaRead_Users").getConn(); application.setAttribute("connUser", connection); } //得到数据库对象后，，就得获取目前用户的那个 最近浏览书籍类别 String sql = "select 最近浏览书籍类别 from searched where 手机号='"+mess[0]+"'"; String cla = null; Statement statement = null; ResultSet set = null; try { statement = connection.createStatement(); set = statement.executeQuery(sql); if(set.next()) { cla = set.getString(1); }else { cla = "自动化技术、计算机技术"; } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } //获取 书籍 数据库连接对象 connection = (Connection) application.getAttribute("connBooks"); if(connection == null) { connection = new SQLBasic("HiaRead_Books").getConn(); application.setAttribute("connBooks", connection); } //select top 3 标题,作者,藏书量,封面,版本号 FROM [HiaRead_Books].[dbo].[book] where 类别='自动化技术、计算机技术' // and 图书馆所在省='湖南省' and 图书馆所在市='衡阳市' and 图书馆所在区='蒸湘区' and 图书馆名='南华大学图书馆' // order by newid() sql = "select top 3 标题,作者,藏书量,封面,版本号,类别 from book where 类别='"+cla+"' and 图书馆所在省='"+mess[1]+"' " + "and 图书馆所在市='"+mess[2]+"' and 图书馆所在区='"+mess[3]+"' and 图书馆名='"+mess[4]+"' order by newid() "; try { statement = connection.createStatement(); set = statement.executeQuery(sql); while(set.next()) { JSONObject object = new JSONObject(); object.put("name", set.getString(1)); object.put("author",set.getString(2)); object.put("collection", set.getInt(3)); object.put("picture", set.getString(4)); object.put("version", set.getString(5)); object.put("class", set.getString(6)); list.add(object); } response.setContentType("application/json;charSet=UTF-8"); response.getWriter().write(list.toString()); } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } } }