Android——“i 分享”APP开发Day08

最新推荐文章于 2021-06-30 17:31:09 发布
最新推荐文章于 2021-06-30 17:31:09 发布
阅读量225 收藏 1
点赞数 1
分类专栏： Android 文章标签： servlet 增删查改
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/YanMeiHe/article/details/90301865
版权

主页上4个Tab的功能基本就已经完善了，接下来准备实现跳转详情页的功能。在此之前，明确一下详情页将会实现的功能，优先处理后台代码

  • 根据内容ID查找到与内容相关的所有信息——内容简述、内容详情、内容作者、点赞数、内容类型
  • 点赞——点击后，点赞数加一
  • 用户是否已经收藏该内容——通过传过来的用户昵称和文章内容ID判断用户是否已经收藏该内容
  • 取消收藏——从收藏表中将对应的收藏行删除
  • 添加到我的收藏——将用户和内容信息插入到收藏表中
  • 评论功能——用户可以评论
  • 删除内容——当作者就是用户时，可以删除内容，且在删除文章时对应删除收藏表的对应行以及评论表对应的内容

 

1.明确上述几个后台处理逻辑之后，首先要在数据库ishare中新建一张收藏表——focus，还有1张评论表——comment

  • 和之前的用户表、内容表一样，在数据库ishare中新建一张表，命名为focus具体的表结构如下：
  • focus_id为int类型，自增；username对应收藏的用户；info_id对应收藏的内容

  •  在ishare中新建一张表，命名为comment，具体表结构设计如下：
  • comment_id是int类型，自增；comment_user是评论者；comment_info是评论文章的id;comment_detail是评论的具体内容

2. 建好表之后就开始处理通过Id查找内容的servlet文件QueryInfoById.java

  • 和之前新建servlet一样，在myServlet.data包下新建servlet命名为QueryInfoById
  • 在web.xml中添加配置：

<servlet>
    <servlet-name>QueryInfoById</servlet-name>
    <servlet-class>myServlet.data.QueryInfoById</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>QueryInfoById</servlet-name>
    <url-pattern>/servlet/QueryInfoById</url-pattern>
  </servlet-mapping>

  • 具体实现也是和之前查询类似，将数据库返回的内容封装成JsonArray返回，具体代码如下 
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import com.sun.rowset.CachedRowSetImpl;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class QueryInfoById
 */
@WebServlet("/QueryInfoById")
public class QueryInfoById extends HttpServlet {
	private static final long serialVersionUID = 1L;
	CachedRowSetImpl rowSet = null;    //存储表中全部记录的行集对象
	int pageSize=10; //每页加载数量
    int pageNum=1;   //第几页
    int totalRecord;  //总记录数
    
    /**
     * @see HttpServlet#HttpServlet()
     */
    public QueryInfoById() {
        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
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        String infoId = request.getParameter("infoId");	
        
        if(infoId == null||infoId.length()==0) {
			return;
		}
	
        String condition ="select * from info where info_id="+infoId;   //按id查找
    
	
		Connection connection = null;
		Statement sql = null;
		ResultSet rs = null;

		try {
			connection = JdbcUtils.getConnection();
			sql = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
			rs = sql.executeQuery(condition);
			
			
			rowSet = new CachedRowSetImpl();  //创建行集对象
			rowSet.populate(rs);
			
			response.setContentType("text/html;charset=utf-8");
			response.setCharacterEncoding("utf-8");
			JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
			
			//将rowSet的数据提取到Map
			List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
			try {
				rowSet.last();    //移到随后一行
	    		totalRecord = rowSet.getRow();
	    		
	    		int index = (pageNum-1)*pageSize+1;
    			rowSet.absolute(index);   //查询位置移动到查询页的起始记录位置
    			boolean boo = true;
    			
    			for(int i=1; i<=totalRecord&&boo;i++){	
    				int id = rowSet.getInt(1);    //内容ID	    				
    				String infoTitle = rowSet.getString(2);   //内容标题    				
    				String infoDescribe = rowSet.getString(3);   //内容简述
    				String infoDetail = rowSet.getString("info_detail");   //内容详情
    				
    				String type = rowSet.getString(5);    //类型：0表示日记，1表示趣事
    				String support = rowSet.getString(6);   //点赞数
    				String infoAuthor = rowSet.getString(7);  //作者     
    				
    				Map<String,Object> map = new HashMap<String,Object>();
    				map.put("infoId", id);
    				map.put("infoTitle", infoTitle);
    				map.put("infoDescribe", infoDescribe);
    				map.put("infoDetail", infoDetail);
    				map.put("infoType", type);
    				map.put("infoSupport", support);
    				map.put("infoAuthor", infoAuthor);
    				
    				data.add(map);
					boo = rowSet.next();
    			}
    			jsonArray = JsonUtils.formatRsToJsonArray(data);
    			
    			out.println(jsonArray.toString());  //返回json
    			
			}catch(Exception e) {
				out.println("null"); 
			}
		} catch (Exception e) {	
			out.println(condition+"异常："+e.toString());
			e.printStackTrace();
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.statementClose(connection, sql, rs);
		}
	}

	/**
	 * @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);
	}

}

 

3. 实现点赞，对应servlet文件AddSupport.java

  • 一样在myServlet.data包下新建servlet文件,命名为AddSupport
  • 在web.xml中配置：

 <servlet>
    <servlet-name>AddSupport</servlet-name>
    <servlet-class>myServlet.data.AddSupport</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>AddSupport</servlet-name>
    <url-pattern>/servlet/AddSupport</url-pattern>
  </servlet-mapping>

  •  AddSupport.java通过参数获取到info_id，查询到info表中的对应点赞数，然后在当前点赞数的基础上加一之后更新到info表对应的内容点赞数中，具体代码如下：
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class AddSupport
 */
@WebServlet("/AddSupport")
public class AddSupport extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AddSupport() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
       
		String infoId = request.getParameter("InfoId").trim();
/*		String supportNum = request.getParameter("supportNum").trim();*/
		
		if(infoId == null) {
			infoId = "";
		}
		
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		PreparedStatement prepareStatement2 = null;
		ResultSet rs = null;
		ResultSet rs2 =null;
		
		String backnews="";
		boolean boo = false;
		
		boo = infoId.length()>0;
		
		try {
			connection = JdbcUtils.getConnection();
		
			//3.获取statement
			String sql ="select * from info where info_id=?";
			prepareStatement = connection.prepareStatement(sql);
			prepareStatement.setString(1, infoId);
			
			if(boo) {
    			//4.执行sql
    			rs = prepareStatement.executeQuery();
    			boolean m = rs.next();
    			int support = rs.getInt(6);
    			support = support+1;
    			
    			
    			if(m==true) {
    				//查询成功
    				String changeSql = "update info set info_support=? where info_id=?";
    				prepareStatement2 = connection.prepareStatement(changeSql);
    				prepareStatement2.setInt(1, support);
    				prepareStatement2.setString(2, infoId);
    				
    			    prepareStatement2.execute();
    			    
					JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
    				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
 
    			
    				Map<String,Object> map = new HashMap<String,Object>();
    				map.put("addOk", true);
			
					data.add(map);
					jsonArray = JsonUtils.formatRsToJsonArray(data);
					out.println(jsonArray.toString());  //返回json
    				
    				
    			}else {
    				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
    				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
 
    			
    				Map<String,Object> map = new HashMap<String,Object>();
    				map.put("addOk", false);
			
					data.add(map);
					jsonArray = JsonUtils.formatRsToJsonArray(data);
					out.println(jsonArray.toString());  //返回json
    			}
			}else {
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();

			
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("addOk", false);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
			}
			out.print(backnews.toString());
		} catch (Exception e) {
			backnews="修改失败"+e.toString();
			out.print(backnews); 
			e.printStackTrace();
		
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, rs);
			JdbcUtils.close(connection, prepareStatement2, rs2);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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);
	}

}

4.判断用户是否已经收藏内容——IfAddFocus.java

  • 在myServlet.java包下新建servlet命名为IfAddFocus
  • 在web.xml中配置：

<servlet>
    <servlet-name>IfAddFocus</servlet-name>
    <servlet-class>myServlet.data.IfAddFocus</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>IfAddFocus</servlet-name>
    <url-pattern>/servlet/IfAddFocus</url-pattern>
  </servlet-mapping>

  • 通过参数获取到用户名和内容id，根据用户名和id查询focu表是否已经存在该信息，若是则返回true，具体代码如下：
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class IfAddlike
 */
@WebServlet("/IfAddlike")
public class IfAddFocus extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public IfAddFocus() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
	          
		String username = request.getParameter("username").trim();
		String infoId = request.getParameter("infoId").trim();
		int focusId = 0;

        
		if(username == null) {
			username = "";
		}
		
		if(infoId == null) {
			infoId = "";
		}
      
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		ResultSet rs = null;
		boolean boo = false;
		
		boo = username.length()>0&&infoId.length()>0;
		
		try {
			connection = JdbcUtils.getConnection();
			
			//3.获取statement
			//String sql ="insert into user(logname,password,phone,address,realname) value(?,?,?,?,?) ";
			String sql ="select * from focus where username=? and info_id=?";
			prepareStatement = connection.prepareStatement(sql);
			prepareStatement.setString(1, username);
			prepareStatement.setString(2, infoId);
			
			if(boo) {
    			//4.执行sql
				boolean m =false;
				
    			rs = prepareStatement.executeQuery();
    			while(rs.next()) {
    				m = true;
    				focusId = rs.getInt(1);
    			}
    			
    			if(m==true) {
    			
    				success(request,response,focusId);
    				
    			}else {
    				fail(request,response);
    			}
			}else {
				fail(request,response);
			}
			
  
		} catch (Exception e) {
			e.printStackTrace();
			fail(request,response);
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, rs);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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);
	}
	
	public void success(HttpServletRequest request, HttpServletResponse response, int focusId) {
		try {
			JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
			List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
			
			PrintWriter out = response.getWriter();
	
			Map<String,Object> map = new HashMap<String,Object>();
			map.put("isFocus", true);
			map.put("focusId", focusId);
	
			data.add(map);
			jsonArray = JsonUtils.formatRsToJsonArray(data);
			out.println(jsonArray.toString());  //返回json
		}catch(IOException e) {
			e.printStackTrace();
		}
	}
	
	public void fail(HttpServletRequest request, HttpServletResponse response) {
		response.setContentType("text/html;charset=utf-8");
		try {
			JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
			List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
			
			PrintWriter out = response.getWriter();
	
			Map<String,Object> map = new HashMap<String,Object>();
			map.put("isFocus", false);
	
			data.add(map);
			jsonArray = JsonUtils.formatRsToJsonArray(data);
			out.println(jsonArray.toString());  //返回json
		}catch(IOException e) {
			e.printStackTrace();
		}
	}

}

5.取消收藏——RemoveFocus.java

  • 在myServlet.data包下创建servlet并命名为RemoveFocus
  • 在web.xml添加配置

<servlet>
    <servlet-name>RemoveFocus</servlet-name>
    <servlet-class>myServlet.data.RemoveFocus</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>RemoveFocus</servlet-name>
    <url-pattern>/servlet/RemoveFocus</url-pattern>
  </servlet-mapping>

  •  通过获取到用户名和内容Id，将focus表中对应的收藏信息删除，具体代码如下：
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class RemoveFocus
 */
@WebServlet("/RemoveFocus")
public class RemoveFocus extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public RemoveFocus() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        
      
		String focusId = request.getParameter("focusId").trim();
		
		if(focusId == null||focusId == "") {
			return;
		}
	
		
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		ResultSet rs = null;

		
		boolean boo = false;
		
		boo = focusId.length()>0;
		
		try {
			connection = JdbcUtils.getConnection();
		
			//3.获取statement
			String sql ="delete from focus where focus_id=?";
			prepareStatement = connection.prepareStatement(sql);
			prepareStatement.setString(1, focusId);
			
			if(boo) {
    			//4.执行sql
    			prepareStatement.execute();
    			   
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("removeOk", true);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json		
    		
			}else {
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();

			
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("removeOk", false);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
			}
			
		} catch (Exception e) {
			JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
			List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();

		
			Map<String,Object> map = new HashMap<String,Object>();
			map.put("removeOk", false);
	
			data.add(map);
			jsonArray = JsonUtils.formatRsToJsonArray(data);
			out.println(jsonArray.toString());  //返回json
		
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, rs);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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.添加到我的收藏

  • 在myServlet.data下新建文件AddFocus.java
  • 在web.xml下添加配置：

<servlet>
    <servlet-name>AddFocus</servlet-name>
    <servlet-class>myServlet.data.AddFocus</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>AddFocus</servlet-name>
    <url-pattern>/servlet/AddFocus</url-pattern>
  </servlet-mapping>

  • 通过参数获取到用户名和内容ID，将信息插入到收藏表focus中，具体代码如下：
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class AddFocus
 */
@WebServlet("/AddFocus")
public class AddFocus extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AddFocus() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        
      
		String infoId = request.getParameter("InfoId").trim();
		String username = request.getParameter("username").trim();
		
		if(infoId == null||infoId == "") {
			return;
		}
		
		if(username == null||username == "") {
			return;
		}
		
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		PreparedStatement prepareStatement2 = null;
		ResultSet rs = null;
		ResultSet rs2 =null;
		
		String backnews="";
		boolean boo = false;
		
		boo = infoId.length()>0;
		
		try {
			connection = JdbcUtils.getConnection();
		
			//3.获取statement
			String sql ="select * from focus where info_id=? and username=?";
			prepareStatement = connection.prepareStatement(sql);
			prepareStatement.setString(1, infoId);
			prepareStatement.setString(2, username);
			
			if(boo) {
    			//4.执行sql
    			rs = prepareStatement.executeQuery();
    			boolean m = rs.next();
    			
    			if(m!=true) {
    				String changeSql = "INSERT INTO focus VALUES(?,?,?)";
    				prepareStatement2 = connection.prepareStatement(changeSql);
    				prepareStatement2.setInt(1, 0);
    				prepareStatement2.setString(2, username);
    				prepareStatement2.setString(3, infoId);
    				
    			    prepareStatement2.execute();
    			    
					JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
    				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
    				Map<String,Object> map = new HashMap<String,Object>();
    				map.put("addOk", true);
			
					data.add(map);
					jsonArray = JsonUtils.formatRsToJsonArray(data);
					out.println(jsonArray.toString());  //返回json
    				
    			}else {
    				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
    				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
 
    			
    				Map<String,Object> map = new HashMap<String,Object>();
    				map.put("addOk", false);
			
					data.add(map);
					jsonArray = JsonUtils.formatRsToJsonArray(data);
					out.println(jsonArray.toString());  //返回json
    			}
			}else {
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();

			
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("addOk", false);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
			}
			out.print(backnews.toString());
		} catch (Exception e) {
			backnews="修改失败"+e.toString();
			out.print(backnews); 
			e.printStackTrace();
		
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, rs);
			JdbcUtils.close(connection, prepareStatement2, rs2);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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);
	}

}

7.评论内容

  • 在myServlet.data下新建servlet并命名为AddComment
  • 在web.xml中添加配置

<servlet>
    <servlet-name>AddComment</servlet-name>
    <servlet-class>myServlet.data.AddComment</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>AddComment</servlet-name>
    <url-pattern>/servlet/AddComment</url-pattern>
  </servlet-mapping>

  • 同参数获取到用户的ID、内容ID、评论的内容插入到评论表中，具体代码如下
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class AddComment
 */
@WebServlet("/AddComment")
public class AddComment extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AddComment() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        
        Integer commentId =0;    //内容ID,默认设置为0
        String infoIdStr = request.getParameter("infoId");   //内容标题
        String commentUser =request.getParameter("commentUser");   //内容简述
        String commentDetail = request.getParameter("commentDetail");   //内容详情

        if(infoIdStr == null||infoIdStr == "") {
        	infoIdStr = "";
		}
        
        if(commentUser == null||commentUser == "") {
        	commentUser = "";
		}
        
        if(commentDetail == null||commentDetail == "") {
        	commentDetail = "";
		}
      
        
        Boolean m = infoIdStr.length()>0&&commentUser.length()>0&&commentDetail.length()>0;
        
        int infoId = 0;
        try {
        	infoId = Integer.parseInt(infoIdStr);    //内容类型
        } catch (NumberFormatException e) {
            e.printStackTrace();
        }       
		 
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		try {
			connection = JdbcUtils.getConnection();
			//3.获取statement
			String sql ="INSERT INTO comment VALUES(?,?,?,?)";
			prepareStatement = connection.prepareStatement(sql);
			
			if(m) {
				prepareStatement.setInt(1, commentId);  //自增
				prepareStatement.setString(2, commentUser);
				prepareStatement.setInt(3, infoId);
				prepareStatement.setString(4, commentDetail);
				
				//4.执行sql
				prepareStatement.execute();
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("addOk", true);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
				
			}else {
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("addOk", false);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
			}
			
  
		} catch (Exception e) {
			JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
			List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
			Map<String,Object> map = new HashMap<String,Object>();
			map.put("addOk", false);
	
			data.add(map);
			jsonArray = JsonUtils.formatRsToJsonArray(data);
			out.println(jsonArray.toString());  //返回json
			
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, null);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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);
	}

}

 

8.删除分享内容

  • 在myServlet.data下新建servlet并命名为DeleteInfo
  • 在web.xml中添加配置：

<servlet>
    <servlet-name>DeleteInfo</servlet-name>
    <servlet-class>myServlet.data.DeleteInfo</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>DeleteInfo</servlet-name>
    <url-pattern>/servlet/DeleteInfo</url-pattern>
  </servlet-mapping>

  • 通过参数获取到内容ID，对应删除收藏表中的相关内容，然后再删除info表中的内容，具体代码如下：
package myServlet.data;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.utils.JdbcUtils;
import org.utils.JsonUtils;

import net.sf.json.JSONArray;

/**
 * Servlet implementation class DeleteInfo
 */
@WebServlet("/DeleteInfo")
public class DeleteInfo extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DeleteInfo() {
        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
		response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        
      
		String infoId = request.getParameter("infoId").trim();
		
		if(infoId == null||infoId == "") {
			return;
		}
	
		
	 	Connection connection = null;
		PreparedStatement prepareStatement = null;
		ResultSet rs = null;
		


		PreparedStatement prepareStatement3 = null;
		ResultSet rs3 =null;
		String backnews="";
		boolean boo = false;
		
		boo = infoId.length()>0;
		
		try {
			connection = JdbcUtils.getConnection();
		
			//3.获取statement
			String sql ="delete from focus where info_id=?";
			prepareStatement = connection.prepareStatement(sql);
			prepareStatement.setString(1, infoId);
			
			if(boo) {
    			//4.执行sql
    			prepareStatement.execute();
    		
    			
    			String changeSql = "delete from info where info_id=?";
				prepareStatement3 = connection.prepareStatement(changeSql);
				prepareStatement3.setString(1, infoId);
				prepareStatement3.execute();
				
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("deleteOk", true);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json		
    		
			}else {
				JSONArray jsonArray = new JSONArray();//存放返回的jsonOjbect数组
				List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();

			
				Map<String,Object> map = new HashMap<String,Object>();
				map.put("deleteOk", false);
		
				data.add(map);
				jsonArray = JsonUtils.formatRsToJsonArray(data);
				out.println(jsonArray.toString());  //返回json
			}
			out.print(backnews.toString());
		} catch (Exception e) {
			backnews="修改失败"+e.toString();
			out.print(backnews); 
			e.printStackTrace();
		
		}finally {
			//5.释放资源 connection prepareStatement
			JdbcUtils.close(connection, prepareStatement, rs);
			JdbcUtils.close(connection, prepareStatement2, rs2);
			JdbcUtils.close(connection, prepareStatement3, rs3);
		}
	     out.flush();
	     out.close();
	}

	/**
	 * @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);
	}

}

 

丫omi
关注
专栏目录
安卓开发——做一个能定时唤起其他APP的闹钟程序
joe337347889的博客
06-06 7811
安卓开发——做一个能定时唤起其他APP的闹钟程序 准备工作： 要让一个app唤起另一个app，首先要做的是要知道被唤起app的包名，一般在手机的 文件管理->Android->data就能看到已安装的app的包名了。 比如这里的com.baidu.BaiduMap和com.baidu.netdisk对应的就是“百度地图”和“百度网盘”这两个app。 本次博客我将用QQ、微信和新浪微博这三个app作为闹钟唤起的例子，想用闹钟唤起其他app，只需要把程序里的包名和相关位置的描述性文字进行修改，就能
javaEE期末复习指南
m0_51148715的博客
12-16 1772
准备 项目结构 数据库 Book表 usertab表 jar包 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:
xuanke java_HandleLogin.java
weixin_33205735的博客
03-01 259
package myservlet.control;import mybean.data.*;import java.sql.*;import java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.util.*;public class HandleLogin extends HttpServlet{pub...
Android——“i 分享”APP开发Day02
YanMeiHe的博客
05-22 390
设计my_tab_content.xml即“我的”Tab对应的页面 采用相对布局RelativeLayout，顶部是LinearLayout用于放头像和用户信息或者登陆、注册按钮 主要内容部分是ScrollView，放“我的”页面的主要功能，在这里我暂时分为两个区分别是“关于设置”和“关于我的”，在设置下有账号管理、更新签名、修改密码三项；我的下面有趣事分享、日记分享、我的收藏和关于I分享这四个...
Android——“i分享”APP开发Day11
YanMeiHe的博客
05-22 502
通过前面一篇，“我的”页面的后台就搭建完整了，接下来就继续处理一下Android端下“我的”页面剩余还未完成的功能——修改密码、查看我的分享、查看我的日记、查看我的收藏、查看iShare相关 1.修改密码的页面设计——activity_change_password.xml 页面包括旧密码输入框、新密码输入框，具体代码如下： <?xml version="1.0" encoding="...
Android——“i 分享”APP开发Day04
YanMeiHe的博客
05-22 206
在前一天已经建好了存放内容的表，也在QueryDiscover.java中实现了对info 表的查询，接下来就是在Android端的“发现”页实现分页加载Info表的功能 首先需要有用于动态加载数据的卡片布局，在这里用的是比较简单的实现方案——ListView。使用该方案首先在之前就已经建好并测试过的“发现”页（discover_tab_content.xml）添加ListView，添加后的代码...
Android——“i 分享”APP开发Day09
YanMeiHe的博客
05-22 297
在上一篇已经搭建好详情页的后台，接下来主要完成Android页面的功能逻辑，内容包括以下几个部分 根据不同的内容类型显示不同的页面结构——分享图片类型的内容详情带有图片，其他类型的内容隐藏图片显示框 详情页包括的内容有：标题、作者、简述、详情、点赞数 进入该页面时判断文章是否属于用户本人，是的话就显示删除按钮，并可以进行删除文章的操作 进入详情页之后还需要判断用户是否已经收藏该内容，收藏的...
Android——“i 分享”APP开发Day03
YanMeiHe的博客
05-22 188
通过前两天的开发，已经实现了应用的注册登录功能，考虑到后面主功能的测试需要，所以今天优先处理一下退出登录的功能 创建账号管理的页面——activity_account_manage.xml <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android...
Android——“i 分享”APP开发Day06
YanMeiHe的博客
05-22 242
继续上一篇的内容，写FindFragment.java文件，在上一篇的三个函数基础上基本就可以展示出热门内容了，接下来主要就是处理找人和找文按钮的事件 因为之后还需要实现找人的功能，所以要先给创建一个存放用户信息的bean文件 在com.example.bean包下面创建一个java文件——FindPeople.java 处理对用户相关属性的设置与获取 ——FindPeople.java文件完...
Android——“i 分享”APP开发Day05
YanMeiHe的博客
05-22 217
在上一篇已经完成了发现页的分页加载功能，接下来就开始实现查找页的功能，在这个模块会分成找人和找文两个查找方向，初步设计是通过查找相关用户昵称的关键字以及文章标题和简述的关键字进行查找；另外在进入该查找页时希望会展示前十的热门文章，其中热门的判定标准是点赞数 在myEclipse的myServlet.data包下创建查询热门文章的servlet——QueryHotInfo.java，该文件主要就是...
Android开发——带价格的自定义日历
qq_40913813的博客
11-21 720
  最近开发中需要好多各式各样的控件，其中就有一个是日历控件，网络上的自定义日历控件质量参差不齐，看了好多发现源码中都有bug，加上时间比较紧张，就找了一个普通的日历控件，二次封装了一下，希望能给大家提供帮助。（PS：原谅我技术不太好QAQ，但我觉得应该勉强能入眼吧） //因为是公司项目不方便给大家放项目源码，所以我尽量写的详细一点QAQ  给你们看下效果图，可以左右滑动切换月份 //导入...
android——学生信息显示和添加
TBMmagic的博客
06-30 1949
android——学生信息显示和添加学生类使用ListView显示学生信息效果演示 学生类 package com.example.test; import android.widget.RadioButton; import java.io.Serializable; /** * Created by TBM on 2021/3/14 */ public class Student implements Serializable { private String name; p
android 单词本代码,android 背单词app源码(MVP架构)
weixin_30016961的博客
05-29 3569
【实例简介】基于安卓平台的背单词软件，该app支持英语单词/句子 点击开始朗读【实例截图】【核心代码】package com.example.wero.a1_20154816395.mvp.home;import android.support.v4.widget.SwipeRefreshLayout;import android.view.View;import android.widget.B...
小白用网格布局实现简单的计算器 ——Android
YanMeiHe的博客
03-16 4524
目的：采用网格布局，实现计算器的简单功能 开发工具：Android Studio3.3.2 开发环境： 实现过程： 第一步，创建一个Android项目，在这我把项目命名为MyApplication。 第二步，打开MyApplication/app/src/main/res/layout/activity_main.xml，使用text模式编写代码。 使用网格布局（...
AlertDialog实现普通对话框和登录对话框——Android
YanMeiHe的博客
03-31 2147
目的：实现普通对话框和登录对话框 开发工具：Android Studio3.3.2 实现过程： 第一步：在布局文件activity_main.xml中添加两个Button用于打开对话框，并将按钮设置为水平和竖直方向都居中 要让按钮在页面居中需要在父级元素添加 android:gravity="center" 如果希望按钮宽度自适应且在竖直方向排列，则需要在父级元素中添加android...
通过触摸屏事件实现在屏幕移动小球——Android
YanMeiHe的博客
04-05 1839
目的：在屏幕上可自由移动小球，当把小球移到矩形框内时关闭程序 开发工具：Android Studio3.3.2 实现过程： 第一步：新建一个designView.java文件用于设计自定义组件 图形绘制类designView继承于Android.view.View 设置小球的初始坐标，并定义方法getXY()用于记录触摸屏事件传递的小球坐标 定义方法ifLocation()...
通过触摸屏事件实现在图片上涂鸦——Android
YanMeiHe的博客
04-05 911
目的：记录在屏幕上滑动的轨迹，实现在图片上涂鸦的功能 开发工具：Android Studio3.3.2 实现过程： 第一步：新建drawBoard.java用于自定义view 将图片放到drawable文件夹下，用BitmapFactory.decodeResource加载图片，然后建立原始图像的位图 定义函数clear()：将处理后的图像Bitmap new2_Bitmap设...
进度条对话框、日期选择对话框和时间选择对话框——Android
YanMeiHe的博客
03-31 645
目的：实现常用的三种对话框——进度条、日期选择、时间选择 开发工具：Android Studio3.3.2 实现过程： 第一步：在布局文件中添加三个Button用于打开三种不同类型的对话框，并将按钮设置为水平和竖直方向都居中，然后添加两个TextView用于显示用户选择的日期和时间 要让按钮在页面居中需要在父级元素添加 android:gravity="center" 如果希...
“i分享”完整项目运行指导——数据库设计
YanMeiHe的博客
10-16 314
1概述 1-1应用介绍 这是一个Android App，可以称之为“i分享”即“爱”分享之意，该应用的开发就是为了给用户提供一个分享交流的地方，在这里用户可以自由的分享、查找、评论、收藏有趣的内容。通过开发这个应用，让我们更加熟悉地掌握和应用Android相关知识。 APP的客户端程序是在Android Studio上开发和运行，服务器端程序是在myeclipse上编写并运行在Tom...
局域网即时通讯APP开发实践——基于Android平台
资源摘要信息:"Android即时通讯局域网APP开发教程及源码分析" 知识点: 1. Android开发基础: 本资源标题中提到的“Android即时通讯APP程序”表明所涉及的知识点首先包括Android应用开发的基础。Android是Google开发...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值