关于期中考试的一篇小结（内含源代码）

感想------“熟练度不够”

提前一周就开始焦虑啦啊喂，好在是终于过去啦！本次考试我主要是利用MyBatis实现的，有些细节还不够完善，这是主要的扣分点，希望期末考试能够更加顺利一些吧！

过程

在考试过程中，我本人是很紧张的，有些知识盲区是现场查资料得出来的（好在是查出来啦！成就虽然很小，但是成就感还是有的嗷），然后又根据要求，一条一条地去实现的；

结果

说句实话，还是挺失望的，没有达到预想的分数吧，细节真的会把人按死在沙滩上。

事后，我总结出了我犯的几个错误，主要包括以下几点：

1、对MyBatis使用不熟练，在进行数据库中判断是否存在该条消息时，无法根据“已经存在”这个特性，跳转到错误界面；
2、对于录入数据进行查询这一块，我选择走了捷径，只是点击链接进行修改、删除啥的，没有利用输入框这个东西（也算是没有按照要求来吧）；
3、浏览界面不够规范，只是将数据浏览出来，并没有将界面进行美化，没有实行列表式浏览；

好啦！以上就是我的期中考试总结啦！

期待下次的表现啦！

源代码在这里：（友情提示：对Maven项目不熟悉的，请不要轻易尝试，可以作为一个学习MyBatis和Maven的参考）

后端代码：

//User.java
package org.example.Bean;

public class User {
    private String theme;
    private String mudi;
    private String lei;
    private String shijian;
    private String whe;
    private String shui;
    private String neirong;
    private String anpai;


    public void setTheme(String theme){
        this.theme=theme;
    }
    public String getTheme(){
        return theme;
    }
    public void setMudi(String mudi){
        this.mudi=mudi;
    }
    public String getMudi(){
        return mudi;
    }
    public void setLei(String lei){
        this.lei=lei;
    }
    public String getLei(){
        return lei;
    }

    public void setShijian(String shijian){
        this.shijian=shijian;
    }
    public String getShijian(){
        return shijian;
    }
    public void setWhe(String whe){
        this.whe=whe;
    }
    public String getWhe(){
        return whe;
    }
    public void setShui(String shui){
        this.shui=shui;
    }
    public String getShui(){
        return shui;
    }
    public void setNeirong(String neirong){
        this.neirong=neirong;
    }
    public String getNeirong(){
        return neirong;
    }
    public void setAnpai(String anpai){
        this.anpai=anpai;
    }
    public String getAnpai(){
        return anpai;
    }

    public User(){super();}
    public User(String theme,String mudi,String lei,String shijian,String whe,String shui,String neirong,String anpai){
        this.theme=theme;
        this.mudi=mudi;
        this.lei=lei;
        this.shijian=shijian;
        this.whe=whe;
        this.shui=shui;
        this.neirong=neirong;
        this.anpai=anpai;
    }
}

//UserMapper.java
package org.example.mapper;

import org.apache.ibatis.annotations.*;
import org.example.Bean.User;

import java.util.List;

public interface UserMapper {
    //查询所有
    @Select("select * from huodong")
    List<User> selectAll();

    //添加信息
    @Insert("insert ignore into huodong values(#{theme},#{mudi},#{lei},#{shijian},#{whe},#{shui},#{neirong},#{anpai})")
    int add(User user);

    //修改信息
    @Select("select * from huodong where theme=#{theme}")
    User selectByOne(String theme);

    @Update("update huodong set mudi=#{mudi},lei=#{lei},shijian=#{shijian},whe=#{whe},shui=#{shui},neirong=#{neirong},anpai=#{anpai} where theme=#{theme}")
    void update(User user);

    //删除信息
    @Select("select * from huodong where theme=#{theme}")
    List<User> selectByTwo(String theme);

    @Delete("delete from huodong where theme=#{theme}")
    void delete(String theme);

    //根据name查询信息
    @Select("select * from huodong where theme like concat('%',#{theme},'%') or shijian like concat('%',#{shijian},'%') or lei like concat('%',#{lei},'%') or whe like concat('%',#{whe},'%')")
    List<User> selectByName(String theme);

    //查询数据是否存在在数据库里面
    @Select("select 1 from huodong where theme=#{theme}")
    Boolean selectExists(@Param("theme") String theme);


}

//UserService.java
package org.example.Service;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.example.Bean.User;
import org.example.Utils.SqlSessionFactoryUtils;
import org.example.mapper.UserMapper;

import java.util.List;

public class UserService {
    //调用UserMapper方法

    //查询所有
    public List<User> selectAll(){

        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        List<User> list=userMapper.selectAll();
        sqlSession.close();
        return list;
    }

    //添加信息
    public int add(User user){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        int count=userMapper.add(user);
        sqlSession.commit();
        sqlSession.close();
        return count;
    }

    //修改信息

    public User selectByOne(String name){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        User user=userMapper.selectByOne(name);
        sqlSession.close();
        return user;
    }

    public void update(User user){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        userMapper.update(user);
        sqlSession.commit();
        sqlSession.close();
    }

    //删除信息
    public List<User> selectByTwo(String name){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        List<User> user=userMapper.selectByTwo(name);
        sqlSession.close();
        return user;
    }

    public void delete(String name){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        userMapper.delete(name);
        sqlSession.commit();
        sqlSession.close();
    }

    //根据name查询
    public List<User> selectByName(String name){
        SqlSessionFactory sqlSessionFactory= SqlSessionFactoryUtils.getSqlSessionFactory();

        SqlSession sqlSession=sqlSessionFactory.openSession();

        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        List<User> list=userMapper.selectByName(name);
        sqlSession.close();
        return list;
    }

//addServlet.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.Arrays;

@WebServlet("/addServlet")
public class addServlet extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        String mudi=req.getParameter("mudi");
        String lei=req.getParameter("lei");
        String shijian=req.getParameter("shijian");
        String whe=req.getParameter("whe");
        String[] shuis = req.getParameterValues("shui");

        String sh= Arrays.toString(shuis);

        String neirong=req.getParameter("neirong");
        String anpai=req.getParameter("anpai");

        User user=new User();
        user.setTheme(theme);
        user.setMudi(mudi);
        user.setLei(lei);
        user.setShijian(shijian);
        user.setWhe(whe);
        user.setShui(sh);
        user.setNeirong(neirong);
        user.setAnpai(anpai);

        //Boolean b=us.selectExists(theme);


            int count=us.add(user);
            if(count==1){
                resp.getWriter().write("添加成功！");
                req.getRequestDispatcher("aServlet").forward(req, resp);
            }else{
                req.getRequestDispatcher("Failed.jsp").forward(req,resp);
            }


    }


    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

//aServlet.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/aServlet")
public class AServlet extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        List<User> list=us.selectAll();

        req.setAttribute("list",list);
        req.getRequestDispatcher("index.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

//checkServlet.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/checkServlet")
public class checkServlet extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        List<User> list=us.selectByName(theme);

        req.setAttribute("list",list);
        req.getRequestDispatcher("check.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

    }
}

//checkServlet1.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/checkServlet1")
public class checkServlet1 extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        List<User> list=us.selectByName(theme);

        System.out.println(list);

        if(list.equals("[]")){
            resp.getWriter().write("不存在该信息！");
            req.getRequestDispatcher("check.jsp").forward(req,resp);
        }else{
            req.setAttribute("list",list);
            req.getRequestDispatcher("check2.jsp").forward(req,resp);

        }


    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

//checkServlet2.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/checkServlet2")
public class checkServlet2 extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        List<User> list=us.selectByName(theme);

        req.setAttribute("list",list);
        req.getRequestDispatcher("check3.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

//deleteServlet.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;

@WebServlet("/deleteServlet")
public class deleteServlet extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        us.delete(theme);

        req.getRequestDispatcher("aServlet").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

//selectByOne.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/selectByOne")
public class selectByOne extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");

        User user=us.selectByOne(theme);

        req.setAttribute("user",user);
        req.getRequestDispatcher("update.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //super.doPost(req, resp);
    }
}

//selectByTwo.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.List;

@WebServlet("/selectByTwo")
public class selectByTwo extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        List<User> list=us.selectByTwo(theme);

        req.setAttribute("list",list);
        req.getRequestDispatcher("delete.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

//updateServlet.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

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 java.io.IOException;
import java.util.Arrays;

@WebServlet("/updateServlet")
public class updateServlet extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");




        String theme=req.getParameter("theme");
        String mudi=req.getParameter("mudi");
        String lei=req.getParameter("lei");
        String shijian=req.getParameter("shijian");
        String whe=req.getParameter("whe");

        String[] shuis = req.getParameterValues("shui");

        String sh= Arrays.toString(shuis);

        String neirong=req.getParameter("neirong");
        String anpai=req.getParameter("anpai");

        User user=new User();
        user.setTheme(theme);
        user.setMudi(mudi);
        user.setLei(lei);
        user.setShijian(shijian);
        user.setWhe(whe);
        user.setShui(sh);
        user.setNeirong(neirong);
        user.setAnpai(anpai);

        us.update(user);

        req.getRequestDispatcher("aServlet").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

//updateSetvlet1.java
package org.example.Servlet;

import org.example.Bean.User;
import org.example.Service.UserService;

import javax.servlet.Servlet;
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 java.io.IOException;
import java.util.List;

@WebServlet("/updateServlet1")
public class updateServlet1 extends HttpServlet {
    private UserService us=new UserService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        String theme=req.getParameter("theme");
        List<User> list=us.selectByTwo(theme);

        req.setAttribute("list",list);
        req.getRequestDispatcher("update.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

//SqlSessionFactoryUtils.java
package org.example.Utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class SqlSessionFactoryUtils {
    private static SqlSessionFactory sqlSessionFactory;
    static{
        String resource = "mybatis-config.xml";
        InputStream inputStream = null;
        try {
            inputStream = Resources.getResourceAsStream(resource);
        } catch (IOException e) {
            e.printStackTrace();
        }
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    }

    public static SqlSessionFactory getSqlSessionFactory(){
        return sqlSessionFactory;
    }
}

页面代码：

//add.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>添加界面</title>
</head>
<body>

<script>
    function check(){
        var theme=document.forms["myForm"]["theme"].value;
        if(theme.length>20){
            alert("活动主题字数过多!");
            return false;
        }

        var mudi=document.forms["myForm"]["mudi"].value;
        if(mudi.length>50){
            alert("活动目的字数过多!");
            return false;
        }

        var neirong=document.forms["myForm"]["neirong"].value;
        if(neirong.length>500){
            alert("活动内容字数过多!");
            return false;
        }
        var anpai=document.forms["myForm"]["anpai"].value;
        if(anpai.length>500){
            alert("活动日程安排字数过多!");
            return false;
        }
    }
</script>

<center>
    <form name="myForm" action="addServlet" method="post">
        <tr>
            <td>活动主题：</td>
            <td><input type="text" name="theme" placeholder="请输入活动主题"></td>
        </tr>
        <p>
            <tr>
                <td>活动目的：</td>
                <td><input type="text" name="mudi" placeholder="请输入活动目的"></td>
            </tr>
        <p>
        <tr>
            <td>活动类型：</td>
            <td><input type="radio" name="lei" value="社团竞赛">社团竞赛</td>
            <td><input type="radio" name="lei" value="野外采风">野外采风</td>
            <td><input type="radio" name="lei" value="校内集会">校内集会</td>
            <td><input type="radio" name="lei" value="社团纳新">社团纳新</td>
        </tr>
        <p>
        <tr>
            <td>活动时间：</td>
            <td><input type="text" name="shijian"></td>
        </tr>
        <p>
        <tr>
            <td>活动地点：</td>
            <td><input type="text" name="whe"></td>
        </tr>
        <p>
        <tr>
            <td>活动对象：</td>
            <td><input type="checkbox" name="shui" value="社团成员">社团成员</td>
            <td><input type="checkbox" name="shui" value="全体学生">全体学生</td>
        </tr>
        <p>
        <tr>
            <td>活动内容：</td>
            <td><input type="textarea" name="neirong" placeholder="不超过500个字"></td>
        </tr>
        <p>
        <tr>
            <td>活动日程安排：</td>
            <td><input type="textarea" name="anpai" placeholder="不超过500个字"></td>
        </tr>
        <p>
        <tr>
            <button type="submit" value="提交" onclick="return check()">提交</button>
        </tr>
    </form>
</center>
</body>
</html>

//check.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>详情界面</title>
</head>
<body>
<center>
    <form>
        <table id="tab1" border="1px" align="center">
            <tr>
                <td colspan="9" align="center" ><h2>活动信息表</h2></td>
            </tr>
            <tr>
            <td>活动主题</td>
            <td>活动目的</td>
            <td>活动类型</td>
            <td>活动时间</td>
            <td>活动地点</td>
            <td>活动对象</td>
            <td>活动内容</td>
            <td>活动日程安排</td>
        </tr>

        <c:forEach items="${list}" var="user">
            <tr>
            <td>${user.theme}</td>
            <td>${user.mudi}</td>
            <td>${user.lei}</td>
            <td>${user.shijian}</td>
            <td>${user.whe}</td>
            <td>${user.shui}</td>
            <td>${user.neirong}</td>
            <td>${user.anpai}</td>
            </tr>
        </c:forEach>
    </form>
</center>
</body>
</html>

//check1.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>详情界面</title>
</head>
<body>
<center>
    <form action="checkServlet1" method="post">
        <tr>
            <td><input type="text" name="theme" placeholder="请输入你想要查询的内容"></td>
        </tr>
        <p>
        <tr>
            <button type="submit" value="查询">查询</button>
        </tr>
    </form>
</center>
</body>
</html>

//check2.jap
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>查询界面</title>
</head>
<body>
<center>
    <form>
        <table id="tab1" border="1px" align="center">
            <tr>
                <td colspan="5" align="center" ><h2>活动信息表</h2></td>
            </tr>
        <tr>
            <td>活动主题</td>
            <td>活动时间</td>
            <td>活动类型</td>
            <td>活动对象</td>
            <td>详细信息</td>
        </tr>
            <c:forEach items="${list}" var="user">
            <tr>
        <td>${user.theme}</td>
        <td>${user.shijian}</td>
        <td>${user.lei}</td>
        <td>${user.shui}</td>
        <td><a href="checkServlet2?theme=${user.theme}">查看详情</a></td>
            </tr>
        </c:forEach>
    </form>
</center>
</body>
</html>

//check3.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>详情界面</title>
</head>
<body>
<center>
<form>
  <table id="tab1" border="1px" align="center">
    <tr>
      <td colspan="2" align="center" ><h2>某活动详细信息</h2></td>
    </tr>

    <c:forEach items="${list}" var="user">
  <tr>
  <td>活动主题:</td><td>${user.theme}</td>
  </tr>
      <tr>
  <td>活动目的:</td><td>${user.mudi}</td>
      </tr>
      <tr>
  <td>活动类型:</td><td>${user.lei}</td>
      </tr>
      <tr>
  <td>活动时间:</td><td>${user.shijian}</td>
      </tr>
      <tr>
  <td>活动地点:</td><td>${user.whe}</td>
      </tr>
      <tr>
  <td>活动对象:</td><td>${user.shui}</td>
      </tr>
      <tr>
  <td>活动内容:</td><td>${user.neirong}</td>
      </tr>
      <tr>
  <td>活动日程安排:</td><td>${user.anpai}</td>
  </tr>
  </c:forEach>
  </table>
</form>
</center>
</body>
</html>

//delete.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>删除界面</title>
</head>
<body>
<center>
    <table id="tab1" border="1px" align="center">
        <tr>
            <td colspan="2" align="center" ><h2>某活动详细信息</h2></td>
        </tr>

        <c:forEach items="${list}" var="user">
            <tr>
                <td>活动主题:</td><td>${user.theme}</td>
            </tr>
            <tr>
                <td>活动目的:</td><td>${user.mudi}</td>
            </tr>
            <tr>
                <td>活动类型:</td><td>${user.lei}</td>
            </tr>
            <tr>
                <td>活动时间:</td><td>${user.shijian}</td>
            </tr>
            <tr>
                <td>活动地点:</td><td>${user.whe}</td>
            </tr>
            <tr>
                <td>活动对象:</td><td>${user.shui}</td>
            </tr>
            <tr>
                <td>活动内容:</td><td>${user.neirong}</td>
            </tr>
            <tr>
                <td>活动日程安排:</td><td>${user.anpai}</td>
            </tr>
        <tr>
            <td>删除操作</td>
        <td><a href="deleteServlet?theme=${user.theme}" onclick='return confirm("确定要删除嘛？")'>删除信息</a></td>
        </tr>
        </c:forEach>
    </table>

</center>
</body>
</html>

//Failed.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>失败界面</title>
</head>
<body>
<h1>失败!</h1>
<a href="add.jsp">回到添加界面</a>
</body>
</html>

//index.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>操作界面</title>
  </head>
  <body>
  <center>
      <tr>
        <td><button type="submit" value="添加" onclick="window.location.href='add.jsp'">添加</button></td>
        <td><button type="submit" value="查询" onclick="window.location.href='check1.jsp'">查询</button></td>
      </tr>
      <p>

    <table id="tab1" border="1px" align="center">
      <tr>
        <td colspan="9" align="center" ><h2>活动信息表</h2></td>
      </tr>
        <tr>
          <td align="center" >活动主题</td>
          <td align="center" >活动目的</td>
          <td align="center" >活动类型</td>
          <td align="center" >活动时间</td>
          <td align="center" >活动地点</td>
          <td align="center" >活动对象</td>
          <td align="center" >活动内容</td>
          <td align="center" >活动日程安排</td>
          <td align="center" >操作</td>
        </tr>
      <c:forEach items="${list}" var="user" varStatus="userStatus">
    <tr>
        <td align="center" >${user.theme}</td>
        <td align="center" >${user.mudi}</td>
        <td align="center" >${user.lei}</td>
        <td align="center" >${user.shijian}</td>
        <td align="center" >${user.whe}</td>
        <td align="center" >${user.shui}</td>
        <td align="center" >${user.neirong}</td>
        <td align="center" >${user.anpai}</td>
      <td align="center" ><a href="selectByOne?theme=${user.theme}">修改</a> <a href="selectByTwo?theme=${user.theme}">删除</a> <a href="checkServlet?theme=${user.theme}">查看详情</a></td>
    </tr>
        </c:forEach>
  </table>
  </center>
  </body>
</html>

//Main.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>主界面</title>
</head>
<body>
<center>
    <h1>校园社团活动管理系统</h1>
<a href="aServlet">查询所有信息</a><p>
    <a href="aServlet">发布活动信息</a><p>
    <a href="aServlet">删除活动信息</a><p>
    <a href="aServlet">修改活动信息</a><p>
    <a href="aServlet">查询活动信息</a><p>
</center>
</body>
</html>

//update.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改界面</title>
</head>
<body>

<script>
    function check(){
        var theme=document.forms["myForm"]["theme"].value;
        if(theme.length>20){
            alert("活动主题字数过多!");
            return false;
        }

        var mudi=document.forms["myForm"]["mudi"].value;
        if(mudi.length>50){
            alert("活动目的字数过多!");
            return false;
        }

        var neirong=document.forms["myForm"]["neirong"].value;
        if(neirong.length>500){
            alert("活动内容字数过多!");
            return false;
        }
        var anpai=document.forms["myForm"]["anpai"].value;
        if(anpai.length>500){
            alert("活动日程安排字数过多!");
            return false;
        }

        var obj=document.getElementsByName("shui");
        var s='';
        for(var i=0;i<obj.length;i++){
            if(obj[i].checked){
                s+=obj[i].value+',';
            }
        }
    }
</script>

<center>
    <form name="myForm" action="updateServlet" method="post">
        <tr>
            <td><input type="hidden" name="theme" placeholder="请输入活动主题" value="${user.theme}"></td>
        </tr>
        <p>

            <tr>
                <td>活动目的：</td>
                <td><input type="text" name="mudi" value="${user.mudi}" placeholder="请输入活动目的"></td>
            </tr>
        <p>
            <tr>
                <td>活动类型：</td>
                <td><input type="radio" name="lei" value="社团竞赛" <c:if test="${user.lei eq '社团竞赛'}"> checked="checked"</c:if>>社团竞赛</td>
                <td><input type="radio" name="lei" value="野外采风" <c:if test="${user.lei eq '野外采风'}"> checked="checked"</c:if>>野外采风</td>
                <td><input type="radio" name="lei" value="校内集会" <c:if test="${user.lei eq '校内集会'}"> checked="checked"</c:if>>校内集会</td>
                <td><input type="radio" name="lei" value="社团纳新" <c:if test="${user.lei eq '社团纳新'}"> checked="checked"</c:if>>社团纳新</td>
            </tr>
        <p>
            <tr>
                <td>活动时间：</td>
                <td><input type="text" name="shijian" value="${user.shijian}"></td>
            </tr>
        <p>
            <tr>
                <td>活动地点：</td>
                <td><input type="text" name="whe" value="${user.whe}"></td>
            </tr>
        <p>
            <tr>
                <td>活动对象：</td>
                <td><input type="checkbox" name="shui" value="社团成员" <c:if test="${fn:contains(user.shui,'社团成员') }"> checked="checked"</c:if>>社团成员</td>
                <td><input type="checkbox" name="shui" value="全体学生" <c:if test="${fn:contains(user.shui,'全体学生') }"> checked="checked"</c:if>>全体学生</td>
            </tr>
        <p>
            <tr>
                <td>活动内容：</td>
                <td><input type="textarea" name="neirong" value="${user.neirong}" placeholder="不超过500个字"></td>
            </tr>
        <p>
            <tr>
                <td>活动日程安排：</td>
                <td><input type="textarea" name="anpai" value="${user.anpai}" placeholder="不超过500个字"></td>
            </tr>
        <p>
            <tr>
                <button type="submit" value="提交" onclick="return check()">修改</button>
            </tr>
    </form>
</center>
</body>
</html>

//MyBatis连接数据库
//mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--数据库连接信息-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ad?useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="20214063"/>
            </dataSource>
        </environment>
    </environments>

//UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!--
namespace:名称空间
-->
<mapper namespace="org.example.mapper.UserMapper">

    <resultMap id="UserResultMap" type="org.example.Bean.User">
        <result column="theme" property="theme"/>
        <result column="mudi" property="mudi"/>
    </resultMap>

</mapper>

Maven项目的导包部分自己应该都会，就先不发啦！
主要有：mysql-connect*jstl***servlet**standard**mybatis**这五个包

posted @ 2022-10-29 12:45 yesyes1 阅读(34) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

liuzijin

关于期中考试的一篇小结（内含源代码）

感想------“熟练度不够”

过程

结果

好啦！以上就是我的期中考试总结啦！

后端代码：

页面代码：

公告