校园社团活动管理系统

 

 

这是我创建的目录

 

package com.xxxx.servelt;
import dao.javaBean;
import util.DBUtil;

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.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

@WebServlet("/chaxunServlet")
public class chaxunServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置编码格式
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        //获取参数
        String zhuti    =request.getParameter("zhuti");
        String shijian     = request.getParameter("shijian");
        String leixing  =request.getParameter("leixing");
        String didian =request.getParameter("didian");
        //连接
        try {
            Connection connection = DBUtil.getConnection();
            String sql = "select * from renkou01 where zhuti like ?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+zhuti+"%");
            ResultSet rs= preparedStatement.executeQuery();
            while(rs.next()){
                request.setAttribute("zhuti",rs.getString("zhuti"));
                request.setAttribute("mudi",rs.getString("mudi"));
                request.setAttribute("leixing",rs.getString("leixing"));
                request.setAttribute("shijian",rs.getString("shijian"));
                request.setAttribute("didian",rs.getString("didian"));
                request.setAttribute("duixiang",rs.getString("duixiang"));
                request.setAttribute("neirong",rs.getString("neirong"));
                request.setAttribute("anpai",rs.getString("anpai"));

                request.getRequestDispatcher("chaxun02.jsp").forward(request,response);
                rs.close();
                preparedStatement.close();
                connection.close();
            }
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}

package com.xxxx.servelt;
import dao.javaBean;
import util.DBUtil;

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.io.PrintWriter;
import java.sql.*;


@WebServlet("/deleteServlet")
public class deleteServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        String zhuti = request.getParameter("zhuti");
        PrintWriter writer = response.getWriter();
        try {
            Connection connection=DBUtil.getConnection();
            String sql = "delete from renkou01 where zhuti = ?";
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            //对应问号
            preparedStatement.setString(1,zhuti);
            int rs = preparedStatement.executeUpdate();
            if(rs>0){
//                System.out.println("删除成功");
                writer.write("删除成功");

            }else{
//                System.out.println("删除失败");
                writer.write("删除失败");
            }
            preparedStatement.close();
            connection.close();
            writer.close();
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}

package com.xxxx.servelt;
import dao.javaBean;
import util.DBUtil;

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.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

@WebServlet("/loginServlet")
public class loginServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置编译格式
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        //接收数据
        String zhuti    = request.getParameter("zhuti");
        String mudi     = request.getParameter("mudi");
        String leixing  = request.getParameter("leixing");
        String shijain  = request.getParameter("shijian");
        String didian   = request.getParameter("didian");
        String duixiang = request.getParameter("duixiang");
        String neirong   = request.getParameter("neirong");
        String anpai    = request.getParameter("anpai");


            PreparedStatement preparedStatement = null;
            Connection connection = null;
            try {
                connection = DBUtil.getConnection();
                String sql = "insert into renkou01(hubie,type,mianji,num,name,id,sex,nation,educate) values(?,?,?,?,?,?,?,?,?)";
                preparedStatement = null;
                preparedStatement = connection.prepareStatement(sql);
                preparedStatement.setString(1, zhuti   );
                preparedStatement.setString(2, mudi    );
                preparedStatement.setString(3, leixing );
                preparedStatement.setString(4, shijain );
                preparedStatement.setString(5, didian  );
                preparedStatement.setString(6, duixiang);
                preparedStatement.setString(7, neirong );
                preparedStatement.setString(8, anpai   );
                preparedStatement.executeUpdate();
            } catch (ClassNotFoundException e) {
                throw new RuntimeException(e);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            } finally {
                DBUtil.close(preparedStatement);
                DBUtil.close(connection);
            }
            request.getRequestDispatcher("liulan.jsp").forward(request,response);

    }

    private boolean isNumeric(String str) {
        for (int i = str.length();--i>=0;){
            if (!Character.isDigit(str.charAt(i))){
                return false;
            }
        }
        return true;
    }


}

package com.xxxx.servelt;
import dao.javaBean;
import util.DBUtil;

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.io.PrintWriter;
import java.sql.*;

@WebServlet("/xiugaiServlet01")
public class xiugaiServlet01 extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置编码格式
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        //获取jsp 中的 name
        String zhuti = request.getParameter("zhuti");
        //链接
        try {
            Connection connection = DBUtil.getConnection();
            String sql = "select * from renkou01 where zhuti = ?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, zhuti);
            ResultSet rs = preparedStatement.executeQuery();
            int i = 0;
            if (rs.next()) {
                i = 1;
                request.setAttribute("zhuti   ", rs.getString("zhuti   "));
                request.setAttribute("mudi    ", rs.getString("mudi    "));
                request.setAttribute("leixing ", rs.getString("leixing "));
                request.setAttribute("shijain ", rs.getString("shijain "));
                request.setAttribute("didian  ", rs.getString("didian  "));
                request.setAttribute("duixiang", rs.getString("duixiang"));
                request.setAttribute("neirong ", rs.getString("neirong "));
                request.setAttribute("anpai   ", rs.getString("anpai   "));
                rs.close();
                preparedStatement.close();
                connection.close();
            }
            if(i==1){
                request.getRequestDispatcher("xiugai02.jsp").forward(request,response);
            }
            else{
                PrintWriter write= response.getWriter();
                write.write("该社团活动不存在");
            }
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}

package com.xxxx.servelt;
import dao.javaBean;
import util.DBUtil;
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.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

@WebServlet("/xiugaiServlet02")
public class xiugaiServlet02 extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置编码
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        //从jsp接收数据
//        String name = request.getParameter("name");
//        System.out.println(name);
        String zhuti = (String) request.getSession().getAttribute("zhuti");
        System.out.println(zhuti);
        String mudi = request.getParameter("mudi");
        String leixing = request.getParameter("leixing");
        String shijian = request.getParameter("shijian");
        String didian = request.getParameter("didian");
//        String duixiang = request.getParameter("duixiang");
//        String neirong = request.getParameter("neirong");
        String anpai = request.getParameter("anpai");
        PrintWriter writer=response.getWriter();
        //连接
        try {
            Connection connection = DBUtil.getConnection();
            String sql="update renkou01 set mudi=?,leixing=?,shijian=?,num=?,didian=?,anpai=? where zhuti=?";
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,mudi);
            preparedStatement.setString(2,leixing);
            preparedStatement.setString(3,shijian);
            preparedStatement.setString(4,didian);
            preparedStatement.setString(7,zhuti);
//            preparedStatement.setString(6,id);
//            preparedStatement.setString(5,sex);
            preparedStatement.setString(5,anpai);
            int rs=preparedStatement.executeUpdate();
            if(rs>0){
                writer.write("修改成功");
            }
            else{
                writer.write("修改失败");
            }
            preparedStatement.close();
            connection.close();
            writer.close();
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>查询活动信息</title>
</head>
<body>
<form method="post" action="chaxunServlet">
  <table>
    <tr>
      <td>活动主题：</td>
      <td><input type="text" name="zhuti"></td>
    </tr>
    <tr>
      <td>活动时间：</td>
      <td><input type="text" name="shijian"> </td>
    </tr>
    <tr>
      <td>活动地点：</td>
      <td><input type="text" name="didian"></td>
    </tr>
    <tr align="center">
      <td colspan="2"><button>查询</button></td>
    </tr>
  </table>

</form>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>查询结果</title>
</head>
<body>
<table align="center"  border="1">
    <tr>
        <td>活动主题</td>
        <td>活动目的</td>
        <td>活动类型</td>
        <td>活动时间</td>
        <td>活动地点</td>
        <td>活动对象</td>
        <td>活动内容</td>
        <td>活动日程安排</td>
    </tr>
    <tr>
        <td>${zhuti}</td>
        <td>${mudi}</td>
        <td>${leixing}</td>
        <td>${shijian}</td>
        <td>${didian}</td>
        <td>${duixiang}</td>
        <td>${neirong}</td>
        <td>${anpai}</td>
    </tr>
</table>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>--%>
<html>
<head>
  <title>浏览</title>
</head>
<body>

<h2 align="center" >登记成功</h2><br>
<table align="center"  border="1">
  <tr>
    <td>活动主题</td>
    <td>活动目的</td>
    <td>活动类型</td>
    <td>活动时间</td>
    <td>活动地点</td>
    <td>活动对象</td>
    <td>活动内容</td>
    <td>活动日程安排</td>
  </tr>


  <%

    Connection connection= DBUtil.getConnection();
    PreparedStatement preparedStatement=null;
    ResultSet in=null;
    try{
//        按照添加时间排序：：
      preparedStatement=connection.prepareStatement("select * from renkou01");
      in = preparedStatement.executeQuery();
      while(in.next()){
  %>
  <tr>
    <td><%=in.getString(1)%></td>
    <td><%=in.getString(2)%></td>
    <td><%=in.getString(3)%></td>
    <td><%=in.getString(4)%></td>
    <td><%=in.getString(5)%></td>
    <td><%=in.getString(6)%></td>
    <td><%=in.getString(7)%></td>
    <td><%=in.getString(8)%></td>
    <td><%=in.getString(9)%></td>
  </tr>
  <%
      }
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }finally {
      connection.close();
      preparedStatement.close();
      in.close();
    }
  %>
</table>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>发布活动信息</title>
</head>
<body>
<form method="post"  action="loginServlet">
  <table align="center" border="1" width="600">
    <tr>
      <td>活动主题</td>
      <td>
        <input type="text" name="zhuti" ><br>
      </td>
    </tr>
    </tr>
    <tr>
      <td>活动目的</td>
      <td>
        <input type="text" name="mudi" ><br>
      </td>
    </tr>
    </tr>

    <tr>
      <td>活动类型</td>
      <td>
        <select name="leixing">
          <option value="社团竞赛">社团竞赛</option>
          <option value="野外采风">野外采风</option>
          <option value="校内聚会">校内聚会</option>
          <option value="社团纳新">社团纳新</option>
        </select>
      </td>
    </tr>


    <tr>
      <td>活动时间</td>
      <td>
        <input type="text" name="shijian"><br>
      </td>
    </tr>

    <tr>
      <td>活动地点</td>
      <td>
        <input type="text" name="didian"><br>
      </td>
    </tr>

    <tr>
      <td>活动对象</td>
      <td>

        <input type="checkbox" name="hobby" value="smoke">社团成员<br>
        <input type="checkbox" name="hobby" value="drink">全体学生<br>


      </td>
    </tr>

    <tr>
      <td>活动内容</td>
      <td>
        <input type="text" name="neirong">
      </td>
    </tr>

    <tr>
      <td>活动日程安排</td>
      <td>
        <input type="text" name="anpai">
      </td>
    </tr>


    <tr align="center">
      <td colspan="2">
        <button>提交</button>
      </td>
    </tr>
  </table>
</form>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>信息修改</title>
</head>
<body>
<form method="post" action="xiugaiServlet01">
  活动主题：<input type="text" name="zhuti"><br>
  <button>查询活动信息</button>
</form>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>修改活动信息显示</title>
</head>
<body>
<%
  String name = (String) request.getAttribute("zhuti");
  session.setAttribute("zhuti",name);
%>
<form method="post" action="xiugaiServlet02">
  <table align="center" border="1">
    <tr>
      <td>活动目的：</td>
      <td>${mudi}</td>
      <td>修改：
        <input type="text" name="mudi" ><br>
      </td>
    </tr>

    <tr>
      <td>活动类型</td>
      <td>${leixing}</td>
      <td>修改：
        <select name="leixing">
          <option value="社团竞赛">社团竞赛</option>
          <option value="野外采风">野外采风</option>
          <option value="校内聚会">校内聚会</option>
          <option value="社团纳新">社团纳新</option>
        </select>
      </td>
    </tr>

    <tr>
      <td>活动时间</td>
      <td>${shijian}</td>
      <td>修改：
        <input type="text" name="shijian" ><br>
      </td>
    </tr>

    <tr>
      <td>活动地点</td>
      <td>${didian}</td>
      <td>修改：
        <input type="text" name="didian"><br>
      </td>
    </tr>


    <tr>
      <td>对象</td>
      <td>${duixiang}</td>
      <td>
        ${duixiang}
      </td>
    </tr>

    <tr>
      <td>活动内容</td>
      <td>${neirong}</td>
      <td>修改：
        <input type="text" name="neirong">
      </td>
    </tr>

    <tr>
      <td>活动日程安排</td>
      <td>${anpai}</td>
      <td>修改：
        <input type="text" name="anpai">
      </td>
    </tr>

    <tr align="center">
      <td colspan="3"><button>保存信息</button></td>
    </tr>
  </table>
</form>
</body>
</html>

<%@ page import="java.sql.Connection" %>
<%@ page import="util.DBUtil" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>浏览页面</title>
</head>
<body>
<table align="center"  border="1">
    <tr>
        <td>活动主题</td>
        <td>活动目的</td>
        <td>活动类型</td>
        <td>活动时间</td>
        <td>活动地点</td>
        <td>活动对象</td>
        <td>活动内容</td>
        <td>活动日程安排</td>
    </tr>


        <%

    Connection connection= DBUtil.getConnection();
    PreparedStatement preparedStatement=null;
    ResultSet in=null;
    try{
        preparedStatement=connection.prepareStatement("select * from renkou01");
        in = preparedStatement.executeQuery();
        while(in.next()){
%>
    <tr>
        <td><%=in.getString(1)%></td>
        <td><%=in.getString(2)%></td>
        <td><%=in.getString(3)%></td>
        <td><%=in.getString(4)%></td>
        <td><%=in.getString(5)%></td>
        <td><%=in.getString(6)%></td>
        <td><%=in.getString(7)%></td>
        <td><%=in.getString(8)%></td>
        <td><%=in.getString(9)%></td>
    </tr>
        <%
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }finally {
        connection.close();
        preparedStatement.close();
        in.close();
        }
%>
</body>
</html>