ssm+mysql实现简易用户发帖

package org.fkit.controller; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.apache.ibatis.session.SqlSession; import org.fkit.domain.Article; import org.fkit.factory.FKSqlSessionFactory; import org.fkit.mapper.ArticleMapper; import org.fkit.service.ArticleService; import org.fkit.service.CommentService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; @Controller public class NoteController { public static SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式 public static Article article=new Article();// 当前正在查看的帖子 public static int article_id; @Autowired @Qualifier("articleService") ArticleService articleService; /** * 用户个人发帖汇总查看 */ @RequestMapping(value="/lookArticle") public String lookArticle(Model model){ List<Article> article_list=articleService.allUserArticle(UserController.user.getId()); model.addAttribute("article_list",article_list); /* for(Article ar:list_article){ System.out.println(ar); } */ return "notes"; } /** * 用户查看所有帖子 */ @RequestMapping(value="/lookAllArticle") public String lookAllArticle(Model model){ List<Article> allArticle = articleService.getAllArticle(); model.addAttribute("allArticle", allArticle); return "allNotes"; } /** * 实现用户发帖，提出问题功能 * */ @RequestMapping(value = "/postNote", method = RequestMethod.POST) public String postNews(@RequestParam("title") String title, @RequestParam("article") String article) { Article articles=new Article(); articles.setTitle(title); articles.setArticle(article); articles.setFound_time(df.format(new Date())); articles.setUser_id(UserController.user.getId()); articles.setUsername(UserController.user.getUsername()); SqlSession session = FKSqlSessionFactory.getSqlSession(); ArticleMapper am=session.getMapper(ArticleMapper.class); am.saveArticle(articles); session.commit(); session.close(); return "main"; } /** * 实现帖子删除功能 * */ @RequestMapping(value="/deleteNote",method=RequestMethod.POST) public String delete(@RequestParam("articleId") Integer articleId){ SqlSession session = FKSqlSessionFactory.getSqlSession(); ArticleMapper am=session.getMapper(ArticleMapper.class); am.deleteArticle(articleId); session.commit(); session.close(); return "main"; } /** * 编辑帖子 * @param articleId * @return */ @RequestMapping(value="/reviseNote",method=RequestMethod.POST) public String reviseNote(Model model, @RequestParam("title") String title, @RequestParam("article") String article){ Article articles=new Article(); SqlSession session = FKSqlSessionFactory.getSqlSession(); ArticleMapper am=session.getMapper(ArticleMapper.class); articles=am.selectArticleByIds(article_id); //赋值给当然正在查看的帖子 articles.setTitle(title); articles.setArticle(article); articles.setFound_time(df.format(new Date())); articles.setUser_id(UserController.user.getId()); am.reviseArticle(articles); session.commit(); session.close(); return "main"; } /** * 用户点击超链接查看帖子功能 * pageIndex请求的页数 * 帖子和评论一对多 */; @Autowired CommentService commentService; @RequestMapping(value = "/lookNote") public String lookNote(HttpServletRequest request,Integer pageIndex, Integer articleId, Model model){ if(articleId!=null) article_id=articleId; //分页对象 commentService.showCommentByPage(request, model,article_id); //实现帖子查找 SqlSession session = FKSqlSessionFactory.getSqlSession(); ArticleMapper am=session.getMapper(ArticleMapper.class); //UserMapper um=session.getMapper(UserMapper.class); article=am.selectArticleBYID(article_id); //赋值给当然正在查看的帖子 model.addAttribute("article",article); //实现帖子评论多对一功能 /* List<Comment> comment_list=commentService.allComment(articleId); model.addAttribute("comment_list",comment_list); //获取帖子的用户名 User getUserNote=new User(); getUserNote=um.selectUserById(article.getUser_id()); model.addAttribute("getUserNote",getUserNote); */ session.commit(); session.close(); return "noteContent"; } @RequestMapping(value="/NoteNote") public String NoteNote(@RequestParam("articleId")Integer articleId){ article_id=articleId; return "revisenote"; } }