使用基本MVC2模式创建新闻网站

一、登录界面

 

二、操作界面

 

 

三、项目结构和关键代码

 

package myJava;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import java.util.List;

public final class DBConn {
    @Test
    //连接数据库
    public  static SqlSession getSqlSession() {
        String resource = "myXML/mybatis-config.xml";
        InputStream inputStream = null;
        SqlSession session = null;
        try {
            inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            session = sqlSessionFactory.openSession();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return session;
    }

    //校验用户信息
    public static Boolean check(Employee emp){
        SqlSession sqlSession = getSqlSession();
        try {
            //selectOne的第一个参数为Mapper.xml的mapper的namespace+id
            //参数二为映射的需要传入的参数
            Employee employee = sqlSession.selectOne(
                    "EmployeeMapper.selectEmployee_name", emp.getName());
            if (employee!=null && employee.getPassword().equals(emp.getPassword()))
                return true;
            else
                return false;
        } finally {
            free(sqlSession);
        }
    }

    //获取数据库的全部数据
    public static List<News> getAllNews(){
        SqlSession sqlSession = getSqlSession();
        List<News> list = sqlSession.selectList("EmployeeMapper.selectNews");
        free(sqlSession);
        return list;
    }

    public static News getNewsById(int id){
        SqlSession sqlSession = getSqlSession();
        News news = sqlSession.selectOne("EmployeeMapper.selectById",id);
        free(sqlSession);
        return news;
    }

    //向数据库添加数据,并且需要sqlSession.commit()
    public static void insertNews(News news){
        SqlSession sqlSession = getSqlSession();
        int result =sqlSession.insert("EmployeeMapper.insertNews",news);
        sqlSession.commit();
        free(sqlSession);
    }

    //删除新闻
    public static int deleteNews(int id){
        SqlSession sqlSession = getSqlSession();
        int result = sqlSession.delete("EmployeeMapper.deleteNewsById",id);
        sqlSession.commit();
        free(sqlSession);
        return result;
    }



    //修改新闻信息
    public static int upDataNewsById(News news){
        SqlSession sqlSession = getSqlSession();
        int res = sqlSession.update("EmployeeMapper.upDataNewsById",news);
        sqlSession.commit();
        free(sqlSession);
        return res;
    }


    //释放Sqlsession
    public static void free(SqlSession sqlSession){
        sqlSession.close();
    }
}

 

package mySpringMVC;
import myJava.DBConn;
import myJava.Employee;
import myJava.Modify;
import myJava.News;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import java.util.Date;
import java.util.List;


@Controller
@RequestMapping("/utf8")
public class HelloWorld{

    @RequestMapping("/helloWorld")
    public String showNews(News news){
        System.out.println("Hello World!");
        System.out.println(news);
//        String exec = new ActionEnter(request, rootPath).exec();
        return "success";
    }

    @RequestMapping("/back")
    public ModelAndView back(){
        return getAllData();
    }

    @RequestMapping("/login")
    public ModelAndView checkLogin(Employee employee){
        //判断用户账号和密码
        Boolean isTrue = DBConn.check(employee);
        if (isTrue)
        {
            return getAllData();
        }
        else
            return new ModelAndView("loginAgain");//在视图解析器中添加前缀和后缀
    }

    @RequestMapping("/Info")
    public ModelAndView newsInfo(@RequestParam("id") int id){
        News news =DBConn.getNewsById(id);
        ModelAndView modelAndView = new ModelAndView("info");
        modelAndView.addObject("one",news);
        return modelAndView;
    }

    @RequestMapping(value = "/AddNews")
    public ModelAndView addNews(@RequestParam("title") String title, @RequestParam("author") String author,
                                @RequestParam("content") String content){

        News news = new News();
        news.setTitle(title);
        news.setAuthor(author);
        news.setContent(content);
        news.setTime(new Date());

        if (!Modify.modify){
            //向数据库写入数据
            DBConn.insertNews(news);
        }
        else{
            news.setId(Modify.modifyId);
            DBConn.upDataNewsById(news);
            //重置Modify为默认状态
            Modify.modify = false;
            Modify.modifyId = -1;
        }
        return getAllData();
    }

    @RequestMapping("/delete")
    public ModelAndView deleteNews(@RequestParam("id") int id){
        DBConn.deleteNews(id);
        return getAllData();
    }

    @RequestMapping("/upData")
    public ModelAndView upDataMethod(@RequestParam("id") int id){
        //数据库获取待修改的新闻信息
        News news = DBConn.getNewsById(id);
        //将数据发送至新闻编辑页面进行填充
        ModelAndView modelAndView = new ModelAndView("addNews");
        modelAndView.addObject("updata",news);
        //设置修改操作的标识
        Modify.modify = true;
        //设置修改的新闻id
        Modify.modifyId = id;
        return modelAndView;
    }


    public ModelAndView getAllData(){
        List<News> list = DBConn.getAllNews();
        //创建返回数据的ModelAndView
        ModelAndView modelAndView = new ModelAndView("newsPublish");
        modelAndView.addObject("list",list);
        return modelAndView;
    }
}