SSM框架在线答疑网站-在线问答网站-智能问答网站-问题匹配搜索推荐答案算法 (idea开发javaweb-php-asp.netC#-j2ee-springboot)

1 概述

 

2 数据库表

 

表4.4 t_tiwen  提问人表

名称

类型

说明

id

int(11)

编号

Tbianhao

longtext

用户名

name1

longtext

姓名

sex

longtext

性别

age

longtext

年龄

loginpw

longtext

密码

3 关键代码

 

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Thuifu;
import com.orm.Tstu;
import com.orm.Ttea;
import com.orm.Twenti;
import com.service.liuService;

public class wenti_servlet extends HttpServlet {
	public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String type = req.getParameter("type");
		
		if (type.endsWith("wenti_tijiao")) {
			wenti_tijiao(req, res);
		}if (type.endsWith("wenti_manage")) {
			wenti_manage(req, res);
		}
		if (type.endsWith("wenti_mime")) {
			wenti_mime(req, res);
		}if (type.endsWith("huifu_mime")) {
			huifu_mime(req, res);
		}
		if (type.endsWith("wenti_all")) {
			wenti_all(req, res);
		}
		if (type.endsWith("wenti_huifu")) {
			wenti_huifu(req, res);
		}
		if (type.endsWith("wenti_jieshu")) {
			wenti_jieshu(req, res);
		}
		if (type.endsWith("wenti_del")) {
			wenti_del(req, res);
		}
		if (type.endsWith("wenti_delqiantai")) {
			wenti_delqiantai(req, res);
		}
		if (type.endsWith("huifu_delqiantai")) {
			huifu_delqiantai(req, res);
		}
		if (type.endsWith("huifu_show")) {
			huifu_show(req, res);
		}
	}

	// 学生添加问题
	public void wenti_tijiao(HttpServletRequest req, HttpServletResponse res) {
		HttpSession session = req.getSession();
		Tstu stu = (Tstu) session.getAttribute("stu");

		String mingcheng = req.getParameter("mingcheng");
		String content = req.getParameter("content");
		String tag = req.getParameter("tag");
		String fujian = req.getParameter("fujian");
		String fujianYuanshiming = req.getParameter("fujianYuanshiming");

		String shijian_shangchuan = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
		String huifuneirong = "";
		String shijian_huifu = "";
		int stu_id = stu.getId();

		String sql = "INSERT INTO  `t_wenti` (  `mingcheng`, `content`, `tag`, `fujian`, `fujianYuanshiming`, `shijian_shangchuan`, `stu_id`, `status`) VALUES (  ?, ?, ?, ?, ?, ?, ?, ?); ";
		Object[] params = {  mingcheng, content,tag,fujian, fujianYuanshiming, shijian_shangchuan, 				stu_id,0 };
		DB mydb = new DB();
		mydb.doPstm(sql, params);
		mydb.closed();

		req.setAttribute("msg", "问题提交完毕");
		String targetURL = "/common/msg.jsp";
		dispatch(targetURL, req, res);

	}

	// 前台教师回复列表
	public void huifu_mime(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		HttpSession session = req.getSession();
		Ttea tea = (Ttea) session.getAttribute("tea");

		List huifuList = new ArrayList();
		String sql = "select * from t_huifu where tea_id=?";
		Object[] params = { tea.getId() };
		DB mydb = new DB();
		try {
			mydb.doPstm(sql, params);
			ResultSet rs = mydb.getRs();
			while (rs.next()) {
				Thuifu huifu = new Thuifu();

				huifu.setId(rs.getInt("id"));
				huifu.setContent(rs.getString("content"));
				huifu.setShijian(rs.getString("shijian"));
				huifu.setTeaname(rs.getString("teaname"));

				huifu.setTea_id(rs.getInt("tea_id"));

				huifu.setTea(liuService.getTea(rs.getInt("tea_id")));

				// 加载问题内容
				String mingcheng = "";
				Twenti wenti = new Twenti();
				String sqlre = "select * from t_wenti where  id=?";
				Object[] paramsre = { rs.getString("wenti_id") };
				DB mydbre = new DB();
				try {
					mydb.doPstm(sqlre, paramsre);
					ResultSet rsre = mydb.getRs();
					while (rsre.next()) {

						mingcheng = rsre.getString("mingcheng");

					}
					rsre.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
				wenti.setMingcheng(mingcheng);
				huifu.setWenti(wenti);

				huifuList.add(huifu);
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb.closed();

		req.setAttribute("huifuList", huifuList);
		req.getRequestDispatcher("qiantai/wenti/huifu_mime.jsp").forward(req, res);
	}

	// 前台学生的问题列表
	public void wenti_mime(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		HttpSession session = req.getSession();
		Tstu stu = (Tstu) session.getAttribute("stu");

		List wentiList = new ArrayList();
		String sql = "select * from t_wenti where stu_id=?";
		Object[] params = { stu.getId() };
		DB mydb = new DB();
		try {
			mydb.doPstm(sql, params);
			ResultSet rs = mydb.getRs();
			while (rs.next()) {
				Twenti wenti = new Twenti();

				wenti.setId(rs.getInt("id"));
				wenti.setMingcheng(rs.getString("mingcheng"));
				wenti.setFujian(rs.getString("fujian"));
				wenti.setFujianYuanshiming(rs.getString("fujianYuanshiming"));

				wenti.setShijian_shangchuan(rs.getString("shijian_shangchuan"));
				wenti.setStu_id(rs.getInt("stu_id"));

				wenti.setStatus(rs.getInt("status"));
				wenti.setStu(liuService.getStu(rs.getInt("stu_id")));

				// 加载回复内容
				String huifuneirong = "无";
				String sqlre = "select * from t_huifu where wenti_id=?";
				Object[] paramsre = { rs.getString("id") };
				DB mydbre = new DB();
				try {
					mydb.doPstm(sqlre, paramsre);
					ResultSet rsre = mydb.getRs();
					while (rsre.next()) {

						huifuneirong = "有";

					}
					rsre.close();
				} catch (Exception e) {
					e.printStackTrace();
				}

				wenti.setHuifuneirong(huifuneirong);

				wentiList.add(wenti);
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb.closed();

		req.setAttribute("wentiList", wentiList);
		req.getRequestDispatcher("qiantai/wenti/wenti_mime.jsp").forward(req, res);
	}

	// 所有的问题列表
	public void wenti_all(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String page1 = req.getParameter("page");
		if (page1 == null) {
			page1 = "1";
		}
		// 分页设置
		int EVERYPAGENUM = 20;// 每页条数
		int page = Integer.parseInt(page1); // 传递过来的当前页
		int cou = 1;// 得到信息总数
		int pagecount = 1; // 总页数
		String sql1 = "select count(*) as cou from t_wenti where 1=1 ";
		if (req.getParameter("mingcheng") != null)
			sql1 += " AND mingcheng like '%" + req.getParameter("mingcheng").trim() + "%'";
		if (req.getParameter("tag") != null) {

			String strPtname = new String(req.getParameter("tag").getBytes("ISO-8859-1"), "UTF-8");
			sql1 += " AND FIND_IN_SET('" + strPtname + "',tag)  ";
		}
		Object[] params1 = {};
		DB mydb1 = new DB();
		try {
			mydb1.doPstm(sql1, params1);
			ResultSet rs = mydb1.getRs();
			while (rs.next()) {
				cou = rs.getInt("cou");
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb1.closed();

		if (cou % EVERYPAGENUM == 0) {
			pagecount = cou / EVERYPAGENUM;
		} else {
			pagecount = cou / EVERYPAGENUM + 1;
		}

		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);

		List wentiList = new ArrayList();
		String sql = "select * from t_wenti where 1=1 ";
		if (req.getParameter("mingcheng") != null)
			sql += " AND mingcheng like '%" + req.getParameter("mingcheng").trim() + "%'";
		if (req.getParameter("tag") != null) {

			String strPtname = new String(req.getParameter("tag").getBytes("ISO-8859-1"), "UTF-8");
			sql += " AND FIND_IN_SET('" + strPtname + "',tag)  ";
		}

		sql += " order by id desc";

		Object[] params = {};
		DB mydb = new DB();
		try {
			mydb.doPstm(sql, params);
			ResultSet rs = mydb.getRs();
			for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
				rs.next();
			}
			for (int t = 0; t < EVERYPAGENUM; t++) {
				if (rs.next()) {
					Twenti wenti = new Twenti();

					wenti.setId(rs.getInt("id"));
					wenti.setMingcheng(rs.getString("mingcheng"));
					wenti.setFujian(rs.getString("fujian"));
					wenti.setFujianYuanshiming(rs.getString("fujianYuanshiming"));

					wenti.setShijian_shangchuan(rs.getString("shijian_shangchuan"));
					wenti.setStu_id(rs.getInt("stu_id"));
					// 加载回复内容
					String huifuneirong = "无";
					String sqlre = "select * from t_huifu where wenti_id=?";
					Object[] paramsre = { rs.getString("id") };
					DB mydbre = new DB();
					try {
						mydb.doPstm(sqlre, paramsre);
						ResultSet rsre = mydb.getRs();
						while (rsre.next()) {

							huifuneirong = "有";

						}
						rsre.close();
					} catch (Exception e) {
						e.printStackTrace();
					}

					wenti.setHuifuneirong(huifuneirong);
					wenti.setStu(liuService.getStu(rs.getInt("stu_id")));

					wentiList.add(wenti);
				} else {
					break; // 减少空循环的时间
				}
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb.closed();

		// 获取tag
		String tags = "";
		String sql12 = "select * from t_wenti ";
		Object[] params12 = {};
		DB mydb12 = new DB();
		try {
			mydb12.doPstm(sql12, params12);
			ResultSet rs12 = mydb12.getRs();
			while (rs12.next()) {

				tags += rs12.getString("tag") + ",";

			}
			rs12.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb12.closed();

		String[] tags_array = tags.split(",");

		// 数组去重
		Set<String> set = new HashSet<>();
		for (int i = 0; i < tags_array.length; i++) {
			set.add(tags_array[i]);
		}
		String[] arrayResult = (String[]) set.toArray(new String[set.size()]);
		System.out.println(Arrays.toString(arrayResult));

		req.setAttribute("wentitagList", arrayResult);
		req.setAttribute("wentiList", wentiList);
		req.getRequestDispatcher("qiantai/wenti/wenti_all.jsp").forward(req, res);
	}

	// 根据问题ID显示说明的回复内容
	public void huifu_show(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String id = req.getParameter("id");

		List huifuList = new ArrayList();
		String sql = "select * from t_huifu where wenti_id='" + id + "'";
		Object[] params = {};
		DB mydb = new DB();
		try {
			mydb.doPstm(sql, params);
			ResultSet rs = mydb.getRs();
			while (rs.next()) {
				Thuifu huifu = new Thuifu();

				huifu.setId(rs.getInt("id"));
				huifu.setContent(rs.getString("content"));
				huifu.setShijian(rs.getString("shijian"));
				huifu.setTeaname(rs.getString("teaname"));

				huifu.setTea_id(rs.getInt("tea_id"));

				huifu.setTea(liuService.getTea(rs.getInt("tea_id")));

				huifuList.add(huifu);
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb.closed();

		Twenti wenti = new Twenti();

		String sql1 = "select * from t_wenti where id=?";
		Object[] params1 = { id };
		DB mydb1 = new DB();
		try {
			mydb1.doPstm(sql1, params1);
			ResultSet rs1 = mydb1.getRs();
			while (rs1.next()) {

				wenti.setId(rs1.getInt("id"));
				wenti.setMingcheng(rs1.getString("mingcheng"));
				wenti.setFujian(rs1.getString("fujian"));
				wenti.setFujianYuanshiming(rs1.getString("fujianYuanshiming"));

				wenti.setContent(rs1.getString("content"));
				wenti.setTag(rs1.getString("tag"));
				wenti.setStatus(rs1.getInt("status"));
				wenti.setShijian_shangchuan(rs1.getString("shijian_shangchuan"));
				wenti.setStu_id(rs1.getInt("stu_id"));

				wenti.setStu(liuService.getStu(rs1.getInt("stu_id")));

			}
			rs1.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb1.closed();

		req.setAttribute("wenti", wenti);
		req.setAttribute("huifuList", huifuList);
		req.getRequestDispatcher("qiantai/wenti/wenti_showhuifu.jsp").forward(req, res);
	}

	// 教师保存回复
	public void wenti_huifu(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String huifuneirong = req.getParameter("huifuneirong");
		String wenti_id = req.getParameter("wenti_id");

		String shijian = new Date().toLocaleString();
		// String name=sessionScope.tea.name

		HttpSession session = req.getSession();
		Ttea tea = (Ttea) session.getAttribute("tea");

		int tea_id = tea.getId();

		String sql = "INSERT INTO  `t_huifu` ( `wenti_id`, `content`, `tea_id`, `shijian`, `teaname`) VALUES ( ?, ?, ?, ?, ?);";
		Object[] params = { wenti_id, huifuneirong, tea_id, shijian, "" };
		DB mydb = new DB();
		mydb.doPstm(sql, params);
		mydb.closed();

		req.setAttribute("message", "问题回复完毕");
		req.setAttribute("path", "wenti?type=huifu_show&id=" + wenti_id);

		String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);

	}

	// 后台的问题列表
	public void wenti_manage(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String page1 = req.getParameter("page");
		if (page1 == null) {
			page1 = "1";
		}
		// 分页设置
		int EVERYPAGENUM = 20;// 每页条数
		int page = Integer.parseInt(page1); // 传递过来的当前页
		int cou = 1;// 得到信息总数
		int pagecount = 1; // 总页数
		String sql1 = "select count(*) as cou from t_wenti where 1=1 ";
		if (req.getParameter("mingcheng") != null)
			sql1 += " AND mingcheng like '%" + req.getParameter("mingcheng").trim() + "%'";
		if (req.getParameter("tag") != null) {

			String strPtname = new String(req.getParameter("tag").getBytes("ISO-8859-1"), "UTF-8");
			sql1 += " AND FIND_IN_SET('" + strPtname + "',tag)  ";
		}
		Object[] params1 = {};
		DB mydb1 = new DB();
		try {
			mydb1.doPstm(sql1, params1);
			ResultSet rs = mydb1.getRs();
			while (rs.next()) {
				cou = rs.getInt("cou");
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb1.closed();

		if (cou % EVERYPAGENUM == 0) {
			pagecount = cou / EVERYPAGENUM;
		} else {
			pagecount = cou / EVERYPAGENUM + 1;
		}

		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);

		List wentiList = new ArrayList();
		String sql = "select * from t_wenti where 1=1 ";
		if (req.getParameter("mingcheng") != null)
			sql += " AND mingcheng like '%" + req.getParameter("mingcheng").trim() + "%'";
		if (req.getParameter("tag") != null) {

			String strPtname = new String(req.getParameter("tag").getBytes("ISO-8859-1"), "UTF-8");
			sql += " AND FIND_IN_SET('" + strPtname + "',tag)  ";
		}

		sql += " order by id desc";

		Object[] params = {};
		DB mydb = new DB();
		try {
			mydb.doPstm(sql, params);
			ResultSet rs = mydb.getRs();
			for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
				rs.next();
			}
			for (int t = 0; t < EVERYPAGENUM; t++) {
				if (rs.next()) {
					Twenti wenti = new Twenti();

					wenti.setId(rs.getInt("id"));
					wenti.setMingcheng(rs.getString("mingcheng"));
					wenti.setFujian(rs.getString("fujian"));
					wenti.setFujianYuanshiming(rs.getString("fujianYuanshiming"));

					wenti.setShijian_shangchuan(rs.getString("shijian_shangchuan"));
					wenti.setStu_id(rs.getInt("stu_id"));
					// 加载回复内容
					String huifuneirong = "无";
					String sqlre = "select * from t_huifu where wenti_id=?";
					Object[] paramsre = { rs.getString("id") };
					DB mydbre = new DB();
					try {
						mydb.doPstm(sqlre, paramsre);
						ResultSet rsre = mydb.getRs();
						while (rsre.next()) {

							huifuneirong = "有";

						}
						rsre.close();
					} catch (Exception e) {
						e.printStackTrace();
					}

					wenti.setHuifuneirong(huifuneirong);
					wenti.setStu(liuService.getStu(rs.getInt("stu_id")));

					wentiList.add(wenti);
				} else {
					break; // 减少空循环的时间
				}
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb.closed();

		// 获取tag
		String tags = "";
		String sql12 = "select * from t_wenti ";
		Object[] params12 = {};
		DB mydb12 = new DB();
		try {
			mydb12.doPstm(sql12, params12);
			ResultSet rs12 = mydb12.getRs();
			while (rs12.next()) {

				tags += rs12.getString("tag") + ",";

			}
			rs12.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		mydb12.closed();

		String[] tags_array = tags.split(",");

		// 数组去重
		Set<String> set = new HashSet<>();
		for (int i = 0; i < tags_array.length; i++) {
			set.add(tags_array[i]);
		}
		String[] arrayResult = (String[]) set.toArray(new String[set.size()]);
		System.out.println(Arrays.toString(arrayResult));

		req.setAttribute("wentitagList", arrayResult);
		req.setAttribute("wentiList", wentiList);
		req.getRequestDispatcher("admin/wenti/wentiMana.jsp").forward(req, res);
	}

	// 后台问题删除
	public void wenti_del(HttpServletRequest req, HttpServletResponse res) {
		String id = req.getParameter("id");

		String sql = "delete from t_wenti where id=?";
		Object[] params = { id };
		DB mydb = new DB();
		mydb.doPstm(sql, params);

		sql = "delete from t_huifu where wenti_id=?";
		Object[] params1 = { id };
		mydb.doPstm(sql, params1);

		mydb.closed();

		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "wenti?type=wenti_manage");

		String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}

	// 前台学生问题删除
	public void wenti_delqiantai(HttpServletRequest req, HttpServletResponse res) {
		String id = req.getParameter("id");

		String sql = "delete from t_wenti where id=?";
		Object[] params = { id };
		DB mydb = new DB();
		mydb.doPstm(sql, params);

		sql = "delete from t_huifu where wenti_id=?";
		Object[] params1 = { id };
		mydb.doPstm(sql, params1);

		mydb.closed();

		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "wenti?type=wenti_mime");

		String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}

	// 前台教师回复删除
	public void huifu_delqiantai(HttpServletRequest req, HttpServletResponse res) {
		String id = req.getParameter("id");

		String sql = "delete from t_huifu where id=?";
		Object[] params1 = { id };
		DB mydb = new DB();
		mydb.doPstm(sql, params1);

		mydb.closed();

		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "wenti?type=huifu_mime");

		String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}

	
	//问题结束
	public void wenti_jieshu(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		String id = req.getParameter("id");
		String status = req.getParameter("status");

		String sql = "update t_wenti set status='" + status + "' where  id=" + Integer.parseInt(id);
		Object[] params = {};
		DB mydb = new DB();
		mydb.doPstm(sql, params);
		mydb.closed();

		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "wenti?type=wenti_mime");

		String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}

	public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try {
			dispatch.forward(request, response);
			return;
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {

			e.printStackTrace();
		}
	}

	public void init(ServletConfig config) throws ServletException {
		super.init(config);
	}

	public void destroy() {

	}
}

4 效果演示

 

idea或eclipse开发,mysql数据库

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

计算机程序设计开发

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值