校园社团活动管理系统

标签：String 管理系统 req 校园 rs zhuti bean 社团活动 活动

1、项目需求：

校园社团作为高校课外活动的重要组成部分，发展十分迅速，也受到越来越多学生的欢迎，社团规模、数量等都在日益增长，社团活动也更为多样和丰富。然而，大多数高校还没有一个完整成熟的社团管理系统，仅仅是靠人力来管理，导致效率低下，而学生也只能通过线下或者公众号的方式了解社团，另外，社团活动的通知方式也很杂乱，并没有一个信息聚合、消息发布的平台。

因此，高校有必要建立一个校园社团管理系统，使得社团管理工作规范化、系统化、程序化、科学化，提高管理工作的效率。

2.系统要求与功能设计

2.1 页面功能要求

（1）能够在Tomcat服务器中正确部署，并通过浏览器查看；

（2）网站页面整体风格统一；

 

图1 活动普查系统功能结构图

（3）主页面：要求显示发布活动信息、修改活动信息、删除活动信息、查询活动信息，活动信息浏览五个子菜单。

（4）发布活动信息页面：

①完成添加活动信息发布，基本信息和填报限制如下表所示

活动主题	字符串（不超过20个汉字）
活动目的	字符串（不超过50个汉字）
活动类型	社团竞赛、野外采风、校内集会、社团纳新（单选框）
活动时间	文本框
活动地点	文本框
活动对象	社团成员、全体学生（复选框实现）
活动内容	（文本框，不超过500个汉字）
活动日程安排	（文本框，不超过500个汉字）

 

②点击“提交”按钮，保存成功则跳转到活动基本信息浏览界面，新录入的信息置顶显示。失败则提示错误信息，返回当前页面

（5）修改活动信息页面：

输入活动主题，显示其余信息，可对活动目的、活动类型、活动时间、活动地点、活动对象、活动内容、活动日程安排进行修改。（活动目的、活动类型、活动时间、活动地点、活动对象、活动内容、活动日程安排必须符合录入要求）；如果该活动主题数据库不存在，则提示“该活动不存在”。

（6）删除活动信息页面：录入活动主题，显示详细信息后，点击“删除”按钮，弹出提示框，提示“是否确认删除该活动信息”，确认后删除该信息。

（7）浏览活动信息页面：

以列表形式显示活动基本信息，结果列表中显示活动主题、活动时间，活动类型、活动对象基本信息，点击主题，可以跳转到活动详细信息，显示全部活动信息。

① 实现以列表形式显示活动基本信息，结果列表中显示活动主题、活动时间，活动类型、活动对象基本信息

②实现跳转活动详细信息页面，显示全部活动信息。

（8）查询活动信息页面：

要求根据活动主题、活动时间、活动类型、活动地点四种条件实现模糊查询，输出结果以列表形式显示，显示显示活动主题、活动时间，活动类型、活动对象基本信息，点击列表中的活动主题，跳转到活动详细信息页面。

2.2 功能要求

（1）设计出合理的数据库和数据表，要求使用mysql、sqlserver、oracle三种数据库中一种

（2）使用Serverlet实现页面交互

（3）使用Java Bean封装数据库连接操作

 

package Bean;

public class bean {
private String zhuti;
private String mudi;
private String huodongleixing;
private String time;
private String didian;
private String duixiang;
private String neirong;
private String richenganpai;
public String getZhuti() {
	return zhuti;
}
public void setZhuti(String zhuti) {
	this.zhuti = zhuti;
}
public String getMudi() {
	return mudi;
}
public void setMudi(String mudi) {
	this.mudi = mudi;
}
public String getHuodongleixing() {
	return huodongleixing;
}
public void setHuodongleixing(String huodongleixing) {
	this.huodongleixing = huodongleixing;
}
public String getTime() {
	return time;
}
public void setTime(String time) {
	this.time = time;
}
public String getDidian() {
	return didian;
}
public void setDidian(String didian) {
	this.didian = didian;
}
public String getDuixiang() {
	return duixiang;
}
public void setDuixiang(String duixiang) {
	this.duixiang = duixiang;
}
public String getNeirong() {
	return neirong;
}
public void setNeirong(String neirong) {
	this.neirong = neirong;
}
public String getRichenganpai() {
	return richenganpai;
}
public void setRichenganpai(String richenganpai) {
	this.richenganpai = richenganpai;
}
public bean(String zhuti, String mudi, String huodongleixing, String time, String didian, String duixiang,
		String neirong, String richenganpai) {
	super();
	this.zhuti = zhuti;
	this.mudi = mudi;
	this.huodongleixing = huodongleixing;
	this.time = time;
	this.didian = didian;
	this.duixiang = duixiang;
	this.neirong = neirong;
	this.richenganpai = richenganpai;
}
public bean() {
	super();
}


}

package Dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import Bean.bean;
import util.DBUtil;
public class Dao {
	public boolean add(bean bean) {
		String sql = "insert into huodong(zhuti,mudi,huodongleixing,time,didian,duixiang,neirong,richenganpai) values('" + bean.getZhuti() + "','" + bean.getMudi() + "','" + bean.getHuodongleixing() + "','" + bean.getTime() + "','" + bean.getDidian() + "','" + bean.getDuixiang() + "','" + bean.getNeirong() + "','" + bean.getRichenganpai() + "')";
		//创建数据库链接
		Connection conn = DBUtil.getConn();
		Statement state = null;
		boolean f = false;
		int a = 0;

		try {
		state = conn.createStatement();
		a = state.executeUpdate(sql);
		} catch (Exception e) {
		e.printStackTrace();
		} finally {
		//关闭连接
		DBUtil.close(state, conn);
		}
		if (a > 0) {
			f = true;
			}
			return f;
			}
	public boolean leibie(String zhuti) {
		boolean flag = false;
		String sql = "select name from huodong where name = '" + zhuti + "'";
		Connection conn = DBUtil.getConn();
		Statement state = null;
		ResultSet rs = null;

		try {
		state = conn.createStatement();
		rs = state.executeQuery(sql);
		while (rs.next()) {
		flag = true;
		}
		} catch (SQLException e) {
		e.printStackTrace();
		} finally {
		DBUtil.close(rs, state, conn);
		}
		return flag;
		}
	
	public int delete (String zhuti) {
		
		String sql = "DELETE from huodong WHERE zhuti like '%"+zhuti+"%'";
		Connection conn = DBUtil.getConn();
		Statement state = null;
		int a = 0;

		try {
		state = conn.createStatement();
		a = state.executeUpdate(sql);
		} catch (SQLException e) {
		e.printStackTrace();
		} finally {
		DBUtil.close(state, conn);
		}

		return a;
		}
	
	public bean getByName(String name) {
		String sql = "select * from huodong where zhuti ='" + name + "'";
		Connection conn = DBUtil.getConn();
		Statement state = null;
		ResultSet rs = null;
		bean bean = null;
		try {
		state = conn.createStatement();
		rs = state.executeQuery(sql);
		while (rs.next()) {
			String zhuti =rs.getString("zhuti");
			String mudi = rs.getString("mudi");
			String huodongleixing = rs.getString("huodongleixing");
			String time = rs.getString("time");
			String didian = rs.getString("didian");
			String duixiang = rs.getString("duixiang");
			String neirong = rs.getString("neirong");
			String richenganpai = rs.getString("richenganpai");
		 bean = new bean(zhuti,mudi,huodongleixing,time,didian,duixiang,neirong,richenganpai);
		}
		} catch (Exception e) {
		e.printStackTrace();
		} finally {
		DBUtil.close(rs, state, conn);
		}

		return bean;
	}
	public bean getBy(String didian,String zhuti,String shijain,String leixing) {
		String sql = "select * from huodong where didian like '%" + didian+ "%'or zhuti like'%"+zhuti+" %'or time like'%"+shijain+" %' or huodongleixing like'%"+leixing+"%'";
        Connection conn = DBUtil.getConn();
        Statement state = null;
        ResultSet rs = null;
        bean bean= null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                String zhuti1 = rs.getString("zhuti"); 
                String didian1 = rs.getString("didian");
                String mudi1 = rs.getString("mudi");
                String time1 = rs.getString("time");
                String huodongleixing1= rs.getString("huodongleixing");
                String duixiang1 = rs.getString("duixiang");
                String neirong1 = rs.getString("neirong");
                String richenganpai1 = rs.getString("richenganpai");

                bean = new bean(zhuti1,mudi1,huodongleixing1,time1,didian1,duixiang1,neirong1,richenganpai1);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return bean;
    }
	
	public ArrayList<bean> list() {
        String sql = "select * from huodong";
        ArrayList<bean> list = new ArrayList<>();
        Connection conn = DBUtil.getConn();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            bean bean = null;
            while (rs.next()) {
//int id = Integer.parseInt(rs.getString("id"));
            	String zhuti =rs.getString("zhuti");
    			String mudi = rs.getString("mudi");
    			String huodongleixing = rs.getString("huodongleixing");
    			String time = rs.getString("time");
    			String didian = rs.getString("didian");
    			String duixiang = rs.getString("duixiang");
    			String neirong = rs.getString("neirong");
    			String richenganpai = rs.getString("richenganpai");
                bean = new bean(zhuti,mudi,huodongleixing,time,didian,duixiang,neirong,richenganpai);
                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }
        return list;

}
}

　　

package Service;

import java.util.ArrayList;
import java.util.List;

import Dao.Dao;
import Bean.bean;

/**
* Service
* 服务层
* @author Hu
*
*/
public class Service {

Dao cDao = new Dao();

/**
* 添加
* @param course
* @return
*/
public boolean add(bean bean) {
boolean f = false;
if(!cDao.leibie(bean.getZhuti())) {
cDao.add(bean);
f = true;
}
return f;
}

public int del(String zhuti) {
	
int i=cDao.delete(zhuti);
System.out.println(i);
return i;
}

public bean getBy(String didian,String zhuti,String shijain,String leixing){
    return cDao.getBy( didian,zhuti,shijain, leixing);
}
public bean getByName(String zhuti) {
    //cDao.delete(name);
    return cDao.getByName(zhuti);
}
public ArrayList<bean> list() {
    return cDao.list();
}
}

　　

package Servlet;

import java.io.IOException;
import java.util.ArrayList;

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 Bean.bean;
import Service.Service;

@WebServlet("/Servlet")
public class Servlet extends HttpServlet {

private static final long serialVersionUID = 1L;

Service service = new Service();

/**
* 方法选择
*/
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
String method = req.getParameter("method");

if ("add".equals(method)) 
{
	try {
		add(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
if ("del".equals(method)) 
{
	try {
		del(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
if ("search".equals(method)) 
{
	try {
		search(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
if ("update".equals(method)) 
{
	try {
		update(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
if ("liulan".equals(method)) 
{
	try {
		liulan(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
if ("getbyname".equals(method)) 
{
	try {
		getbyname(req,resp);
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
}
/**
* 添加
* @param req
* @param resp
* @throws IOException
* @throws ServletException
*/
private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
req.setCharacterEncoding("utf-8");
//获取数据
String zhuti = req.getParameter("zhuti");
String mudi = req.getParameter("mudi");
String huodongleixing = "";
if(req.getParameter("huodongleixing")!=null)
huodongleixing=req.getParameter("huodongleixing");
String time = req.getParameter("time");
String didian = req.getParameter("didian");
String duixiang1 = req.getParameter("duixiang1");
String duixiang2 = req.getParameter("duixiang2");
String duixiang = "";
if(duixiang1!=null)
duixiang+=duixiang1;
if(duixiang2!=null)
duixiang+=duixiang2;
String neirong = req.getParameter("neirong");
String richenganpai = req.getParameter("richenganpai");

bean bean = new bean(zhuti,mudi,huodongleixing,time,didian,duixiang,neirong,richenganpai);

//添加后消息显示
if(service.add(bean)) {
req.setAttribute("message", "添加成功");
bean bean1=service.getBy(didian,zhuti,time,huodongleixing);
req.setAttribute("bean", bean1);
req.getRequestDispatcher("List.jsp").forward(req,resp);
} else {
req.setAttribute("message", "添加失败，请重新录入");
req.getRequestDispatcher("add.jsp").forward(req,resp);
}
}

private void del(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{
    req.setCharacterEncoding("utf-8");
    String zhuti = req.getParameter("zhuti");

    service.del(zhuti);
    req.setAttribute("message", "删除成功！");
    req.getRequestDispatcher("del.jsp").forward(req,resp);
}

private void getbyname(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{
req.setCharacterEncoding("utf-8");
String zhuti = req.getParameter("zhuti");
System.out.println(zhuti);
req.setCharacterEncoding("utf-8");
bean bean=service.getByName(zhuti);
if(bean == null) {
    req.setAttribute("message", "查无此人！");
    req.getRequestDispatcher("del.jsp").forward(req,resp);
} else {
    req.setAttribute("bean", bean);
    req.getRequestDispatcher("del1.jsp").forward(req,resp);
}
}

private void search(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{
    req.setCharacterEncoding("utf-8");
//获取数据

    String zhuti = req.getParameter("zhuti");
    String huodongleixing = req.getParameter("huodongleixing");
    String time = req.getParameter("time");
    String didian= req.getParameter("didian");
    bean bean=service.getBy(didian,zhuti,time,huodongleixing);
    req.setAttribute("bean", bean);
    req.getRequestDispatcher("List.jsp").forward(req,resp);

}

private void update(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{
//    req.setCharacterEncoding("utf-8");
//    String zhuti = req.getParameter("zhuti");
//    bean bean=service.getByName(zhuti);
//    if(bean == null) {
//        req.setAttribute("message", "查无此人！");
//        req.getRequestDispatcher("del.jsp").forward(req,resp);
//    } else {
//        req.setAttribute("bean", bean);
//        req.getRequestDispatcher("detail.jsp").forward(req,resp);
//    }
	req.setCharacterEncoding("utf-8");
    String zhuti = req.getParameter("zhuti");
    bean bean=service.getByName(zhuti);
    req.setAttribute("bean", bean);
    req.getRequestDispatcher("detail.jsp").forward(req,resp);
}

private void liulan(HttpServletRequest req,HttpServletResponse resp)throws IOException,ServletException
{
    req.setCharacterEncoding("utf-8");
    ArrayList<bean> list= service.list();
//    list= service.list();
    req.setAttribute("list",list);



    req.getRequestDispatcher("liulan1.jsp").forward(req,resp);
}
}

　　

package util;
import java.sql.*;
public class DBUtil {
	static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; 
	static final String DB_URL = "jdbc:mysql://localhost:3306/shetuanhuodong?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
	static final String USER = "root";
	static final String PASS = "123456";
	public static Connection getConn () {
	Connection conn = null;
	try {
		  Class.forName(JDBC_DRIVER);	
          System.out.println("连接数据库...");
          conn = DriverManager.getConnection(DB_URL,USER,PASS);
	} catch (Exception e) {
	e.printStackTrace();
	}
	return conn;
	}
	//statement
	public static void close (Statement state, Connection conn) {
		
		if (state != null) {
		try {
		state.close();
		} catch (SQLException e) {
		e.printStackTrace();
		}
		}

		if (conn != null) {
		try {
		conn.close();
		} catch (SQLException e) {
		e.printStackTrace();
		}
		}
		}
	public static void close (ResultSet rs, Statement state, Connection conn) {
		if (rs != null) {
		try {
		rs.close();
		} catch (SQLException e) {
		e.printStackTrace();
		}
		}

		if (state != null) {
		try {
		state.close();
		} catch (SQLException e) {
		e.printStackTrace();
		}
		}

		if (conn != null) {
		try {
		conn.close();
		} catch (SQLException e) {
		e.printStackTrace();
		}
		}
		}
		

	

	
	
}

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>发布活动信息</title>

</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
<h1 style="color: black;">发布活动信息</h1>
<a href="Screen.jsp">返回主页</a>
<form name="form1" action="Servlet?method=add" method="post" onsubmit="return check()">
<div class="a">
            活动主题<input type="text" id="zhuti" name="zhuti" />
        </div>
        <div class="a">
            活动目的<input type="text" id="mudi" name="mudi" />
        </div>

        <div class="a">
            活动类型
            社团竞赛<input type="radio" name="huodongleixing" value="社团竞赛" >
            野外采风<input type="radio"name="huodongleixing" value="野外采风" >
            校内集会<input type="radio"name="huodongleixing" value="校内集会" >
            社团纳新<input type="radio"name="huodongleixing" value="社团纳新" >
        </div>
        <div class="a">
            活动时间<input type="text" id="time" name="time" />
        </div>
        <div class="a">
            活动地点<input type="text" id="didian" name="didian" />
        </div>
        <div class="a">
            活动对象：
            <label>
           <input type="checkbox" name="duixiang1" value="社团人员" />社团人员
           <input type="checkbox" name="duixiang2" value="全体学生" />全体学生
            </label>
        </div>
        <div class="a">
            活动内容<input type="text" id="neirong" name="neirong" />
        </div>
        <div class="a">
            活动日程安排<input type="text" id="richenganpai" name="richenganpai" />
        </div>


        <div class="a">
            <button type="submit" class="b">保   存</button>
             <input type="reset" value="重置" />
        </div>
    </form>
</div>
<script type="text/javascript">
    function check() {
    	var zhuti = document.getElementById("zhuti");
        var mudi = document.getElementById("mudi");
        var huodongleixing = document.getElementById("huodongleixing");
        var time = document.getElementById("time");
        var didian = document.getElementById("didian");
        var duixiang = document.getElementById("duixiang");
        var neirong = document.getElementById("neirong");
        var richanganpai = document.getElementById("richanganpai");

        if(zhuti.value == '') {
    	alert('活动主题为空');
    	zhuti.focus();
    	return false;
    	}else if(zhuti.value.length>20){
    		alert('活动主题内容超过字数限制');
    		zhuti.focus();
    		return false;
    	}
        
        if (mudi.value == '') {
            alert('活动目的为空');
            mudi.focus();
            return false;
        }else if(mudi.value.length>50){
    		alert('活动目的内容超过字数限制');
    		mudi.focus();
    		return false;
    	}
        
        if (huodongleixing.value == '') {
            alert('活动类型为空');
            huodongleixing.focus();
            return false;
        }
        
        if (didian.value == '') {
            alert('无地点');
            didian.focus();
            return false;
        }
        
        if (duixiang.value == '') {
            alert('无活动对象');
            duixiang.focus();
            return false;
        }
        
        if (neirong.value == '') {
            alert('无活动内容');
            neirong.focus();
            return false;
        }else if(neirong.value.length>500){
    		alert('活动内容超过字数限制');
    		neirong.focus();
    		return false;
    	}
        
        if(richanganpai.value == '')
        {
            alert('无日程安排');
            richanganpai.focus();
            return false;

        }else if(richanganpai.value.length>500){
    		alert('日程安排内容超过字数限制');
    		richanganpai.focus();
    		return false;
    	}
    }
</script>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>删除活动信息</title>

</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
<h1 style="color: black;">删除活动信息</h1>
<a href="Screen.jsp">返回主页</a>
<form action="Servlet?method=getbyname" method="post" onsubmit="return check()">
<div class="a">
活动主题<input type="text" id="zhuti" name="zhuti"/>
</div>
<div class="a">
<button type="submit" class="b">删  除</button>
</div>
</form>
</div>
<script type="text/javascript">
function check() {
var zhuti = document.getElementById("zhuti");

//非空
if(name.value == '') {
alert('户主名为空');
name.focus();
return false;
}
}
</script>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>信息删除</title>
    <style>
        .a{
            margin-top: 20px;
        }
        .b{
            font-size: 20px;
            width: 160px;
            color: white;
            background-color: greenyellow;
        }
        .tb, td {
            border: 1px solid black;
            font-size: 22px;
        }
    </style>
</head>
<body>
<div align="center">
    <h1 style="color: black;">信息删除</h1>
    <a href="Screen.jsp">返回主页</a>
    <table class="tb">
        <div class="a">
            <tr>
                <td>活动主题</td>
                <td>${bean.zhuti}</td>
            </tr>
            <tr>
                <td>活动目的</td>
                <td>${bean.mudi}</td>
            </tr>
            <tr>
                <td>活动类型</td>
                <td>${bean.huodongleixing}</td>
            </tr>
            <tr>
                <td>活动时间</td>
                <td>${bean.time}</td>
            </tr>
            <tr>
                <td>活动地点</td>
                <td>${bean.didian}</td>
            </tr>
            <tr>
                <td>活动对象</td>
                <td>${bean.duixiang}</td>
            </tr>
            <tr>
                <td>活动内容</td>
                <td>${bean.neirong}</td>
            </tr>
            <tr>
                <td>活动安排</td>
                <td>${bean.richenganpai}</td>
            </tr>
    </table>
    <div class="a">
        <a onclick="return check()" href="Servlet?method=del&zhuti=${bean.zhuti}">删   除</a>
    </div>

</div>

<script type="text/javascript">
    function check() {
        if (confirm("真的要删除吗？")){
            return true;
        }else{
            return false;
        }
    }
</script>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Insert title here</title>

</head>
<style>
    .a{
        margin-top: 20px;
    }
    .b{
        font-size: 20px;
        width: 160px;
        color: white;
        background-color: greenyellow;
    }
    .tb, td {
        border: 1px solid black;
        font-size: 22px;
    }
</style>
<body>
<%

    Object message = request.getAttribute("message");
    if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
    alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">信息列表</h1>
    <a href="Screen.jsp">返回主页</a>
    <table class="tb">
        
        <form action="Servlet?method=update&zhuti=${bean.zhuti}" method="post" onsubmit="return check()">
            <tr><td>活动主题</td>
            <td><input type="text" id="zhuti" name="zhuti" value="${bean.zhuti}" /></td></tr>
            <tr><td>活动目的</td>
            <td><input type="text" id="mudi" name="mudi"value="${bean.zhuti}" /></td></tr>
            <tr><td>活动类型</td>
            <td><input type="text" id="huodongleixing" name="huodongleixing value="${bean.huodongleixing}"" /></td></tr>
            <tr><td>活动时间</td>
            <td><input type="text" id="time" name="time" value="${bean.time}"/></td></tr>
            <tr><td>活动地点</td>
            <td><input type="text" id="didian" name="didian" value="${bean.didian}"/></td></tr>
            <tr><td>活动对象</td>
            <td><input type="text" id="duixiang" name="duixiang" value="${bean.duixiang}"/></td></tr>
            <tr><td>活动内容</td>
            <td><input type="text" id="neirong" name="neirong" value="${bean.neirong}" /></td></tr>
            <tr><td>活动安排</td>
            <td><input type="text" id="richenganpai" name="richenganpai" value="${bean.richenganpai}"/></td></tr>
            
        </form>
    </table>
            <td><button type="submit" class="b">修改</button></td>
</div>

</body>
</html>

　　

<%@ page import="Bean.bean" %>
<%@ page import="java.util.List" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>信息列表</title>

</head>
<style>
    .a{
        margin-top: 20px;
    }
    .b{
        font-size: 20px;
        width: 160px;
        color: white;
        background-color: greenyellow;
    }
    .tb, td {
        border: 1px solid black;
        font-size: 22px;
    }
</style>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">信息列表</h1>
    <a href="Screen.jsp">返回主页</a>
    <table class="tb">
        <tr>
        <td>活动主题</td>
        <td>活动目的</td>
        <td>活动类型</td>
        <td>活动时间</td>
        <td>活动地点</td>
        <td>活动对象</td>
        <td>活动内容</td>
        <td>活动日程安排</td>
        </tr>
        <tr>
            <td>${bean.zhuti}</td>
            <td>${bean.mudi}</td>
            <td>${bean.huodongleixing}</td>
            <td>${bean.time}</td>
            <td>${bean.didian}</td>
            <td>${bean.duixiang}</td>
            <td>${bean.neirong}</td>
            <td>${bean.richenganpai}</td>
        </tr>
    </table>
</div>
</body>
</html>

　　

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="Bean.bean" %>
<%@ page isELIgnored="false"%>
<html>
<head>
    <title>Title</title>
</head>
<style>
    .a{
        margin-top: 20px;
    }
    .b{
        font-size: 20px;
        width: 160px;
        color: white;
        background-color: greenyellow;
    }
    .tb, td {
        border: 1px solid black;
        font-size: 22px;
    }
</style>
<body>
<div align="center">
    <h1 style="color: black;">信息列表</h1>
    <a href="Screen.jsp">返回主页</a>
    <table class="tb">
        <tr>
            <td>活动主题</td>
            <td>活动目的</td>
            <td>活动类型</td>
            <td>活动时间</td>
            <td>活动地点</td>
            <td>活动对象</td>
            <td>活动内容</td>
            <td>活动日程安排</td>

        </tr>
        <%
        ArrayList<bean> list =(ArrayList<bean>)request.getAttribute("list");
            int i=list.size();

            for(int k=0;k<i;k++)
            {out.print("<tr>");
                bean p=list.get(k);
                out.println("<td>"+p.getZhuti()+"</td>"+"<td>"+p.getMudi()+"</td>"+"<td>"+p.getHuodongleixing()+"</td>"+
                        "<td>"+p.getTime()+"</td>"+"<td>"+p.getDidian()+"</td>"+"<td>"+p.getDuixiang()+"</td>"+"<td>"+p.getNeirong()+"</td>"+"<td>"+p.getRichenganpai()+"</td>");
                out.print("</tr>");
                out.print("<br>");
        %>
        <p>

                <%}

        %>
    </table>


</div>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>校园社团活动管理系统</title>

</head>
<body>
<div align="center">
<div class="a">
<font size=5>欢迎使用校园社团活动管理系统</font>
</div>
<div class="a">
<a href="add.jsp"><font size=3>发布活动信息</font></a>
</div>
<div class="a">
<a href="update.jsp"><font size=3>修改活动信息</font></a>
</div>
<div class="a">
<a href="del.jsp"><font size=3>删除活动信息</font></a>
</div>
<div class="a">
<a href="search.jsp"><font size=3>活动信息查询</font></a>
</div>
<div class="a">
<a href="Servlet?method=liulan"><font size=3>活动信息浏览</font></a>
</div>
</div>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>人口登记信息查询</title>

</head>
<body>
<div align="center">
    <h1 style="color: black;">信息查询</h1>
    <a href="Screen.jsp">返回主页</a>
    <form action="Servlet?method=search" method="post" onsubmit="return check()">
        <div class="a">
            活动主题<input type="text" id="zhuti" name="zhuti"/>
        </div>
        <div class="a">
            活动时间<input type="text" id="shijain" name="shijain" />
        </div>
        <div class="a">
            活动类型<input type="text" id="leixing" name="leixing" />
        </div>
        <div class="a">
            活动地点<input type="text" id="didian" name="didian" />
        </div>
        <div class="a">
            <button type="submit" class="b">查   询</button>
        </div>
    </form>
</div>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>修改活动信息</title>
</head>

<body>
<%
    Object message = request.getAttribute("message");
    if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
    alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">信息修改</h1>
    <a href="Screen.jsp">返回主页</a>
    <form action="Servlet?method=update" method="post" onsubmit="return check()">
        <div class="a">
            活动主题<input type="text" id="zhuti" name="zhuti"/>
        </div>
        <div class="a">
            <button type="submit" class="b">查   找</button>
        </div>
    </form>
</div>
</body>
</html>

　　

 

标签：String,管理系统,req,校园,rs,zhuti,bean,社团活动,活动
From： https://www.cnblogs.com/yitongtianxia666/p/16848331.html