0、效果展示

1、概述

高校学生社团是高校学生依据兴趣爱好自愿组成，按照章程自主开展活动的学生组织。学生社团是高校校园文化的重要载体，是高校第二课堂的重要组成部分，参与学生社团，是学生丰富校园生活，培养兴趣爱好，扩大求知领域，增加交际范围，充实内心世界的重要方式。它既是学生思想政治工作的一个渠道，又是高校育人的有效途径；它对于营造学校的文化氛围，构筑学校的历史传统，都有着重要的意义。随着教育体制改革的不断深入以及大学生学习、生活方式的变化，高校学生社团日益成为高校中具有重大影响力和凝聚力的群体。

2、社团管理网站搭建环境

本文以实现一个社团管理网站为目标，从环境搭建到编码实现全过程讲述

我们使用javaweb、J2EE来构建社团管理网站，环境使用最新版jdk和tomcat，配合mysql数据库

开发工具使用idea（也可以使用eclipse），数据库管理工具使用Navicat Premium

开发框架使用JavaBean Servlet MVC结构；

没有使用SSH（Struts+Spring+Hibernate）或SSM（Spring+SpringMVC+MyBatis），这两个框架我们在别的项目中再介绍开发过程

3、数据表结构

?4、后端代码示例

package com.action;import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.orm.Tuser;import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tpingjia;
import com.orm.Tshetuan;
import com.service.liuService;public class shetuan_servlet extends HttpServlet {public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {String type = req.getParameter("type");if (type.endsWith("shetuanAddPre")) {shetuanAddPre(req, res);}if (type.endsWith("shetuanAdd")) {shetuanAdd(req, res);}if (type.endsWith("shetuanMana")) {shetuanMana(req, res);}if (type.endsWith("shetuanDel")) {shetuanDel(req, res);}if (type.endsWith("shetuanTongguo")) {shetuanTongguo(req, res);}if (type.endsWith("shetuanNOTongguo")) {shetuanNOTongguo(req, res);}if (type.endsWith("shetuanDetailHou")) {shetuanDetailHou(req, res);}if (type.endsWith("shetuanDetailHouSave")) {shetuanDetailHouSave(req, res);}if (type.endsWith("shetuanEditPre")) {shetuanEditPre(req, res);}if (type.endsWith("shetuanEdit")) {shetuanEdit(req, res);}if (type.endsWith("shetuan_suoyou")) {shetuan_suoyou(req, res);}if (type.endsWith("shetuanAll")) {shetuanAll(req, res);}if (type.endsWith("shetuanDetailQian")) {shetuanDetailQian(req, res);}if (type.endsWith("shetuan_search")) {shetuan_search(req, res);}}public void shetuanAddPre(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {List userList = new ArrayList();String sql = "select * from t_user where del='no'";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tuser user = new Tuser();user.setId(rs.getString("id"));user.setName(rs.getString("name"));userList.add(user);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("userList", userList);req.getRequestDispatcher("admin/shetuan/shetuanAdd.jsp").forward(req, res);}public void shetuanAdd(HttpServletRequest req, HttpServletResponse res) {String mingcheng = req.getParameter("mingcheng");String fuzeren = req.getParameter("fuzeren");String jieshao = req.getParameter("jieshao");String lishijian = req.getParameter("lishijian");String jiaoshi = req.getParameter("jiaoshi");String typename = req.getParameter("typename");String del = "no";String sql = "insert into t_shetuan(mingcheng,typename,fuzeren,jieshao,lishijian,del,jiaoshi) values(?,?,?,?,?,?,?)";Object[] params = { mingcheng, typename, fuzeren, jieshao, lishijian, del, jiaoshi };DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void shetuanMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {String userid = "";if (req.getSession().getAttribute("user") != null) {Tuser user = (Tuser) req.getSession().getAttribute("user");userid = user.getId();}List shetuanList = new ArrayList();String sql = "select * from t_shetuan where del='no'";if (req.getSession().getAttribute("user") != null)sql += " and  fuzeren='" + userid + "' ";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tshetuan shetuan = new Tshetuan();shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setTypename(rs.getString("typename"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setJieshao((rs.getString("jieshao")));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuan.setSenhe(rs.getString("senhe"));shetuan.setDel(rs.getString("del"));shetuan.setUser(liuService.getUser(rs.getString("fuzeren")));shetuanList.add(shetuan);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shetuanList", shetuanList);req.getRequestDispatcher("admin/shetuan/shetuanMana.jsp").forward(req, res);}// 删除public void shetuanDel(HttpServletRequest req, HttpServletResponse res) {String sql = "update t_shetuan set del='yes' where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 通过public void shetuanTongguo(HttpServletRequest req, HttpServletResponse res) {String sql = "update t_shetuan set senhe='通过' where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 不通过public void shetuanNOTongguo(HttpServletRequest req, HttpServletResponse res) {String sql = "update t_shetuan set senhe='不通过' where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void shetuanEditPre(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {String id = req.getParameter("id");List userList = new ArrayList();String sql = "select * from t_user where del='no'";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tuser user = new Tuser();user.setId(rs.getString("id"));user.setName(rs.getString("name"));userList.add(user);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("userList", userList);req.setAttribute("id", id);req.getRequestDispatcher("admin/shetuan/shetuanEditPre.jsp").forward(req, res);}public void shetuanEdit(HttpServletRequest req, HttpServletResponse res) {String fuzeren = req.getParameter("fuzeren");String id = req.getParameter("id");String sql = "update t_shetuan set fuzeren=? where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = { fuzeren };DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void shetuanDetailHou(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {Tshetuan shetuan = new Tshetuan();String sql = "select * from t_shetuan where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setTypename(rs.getString("typename"));shetuan.setJieshao(rs.getString("jieshao"));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuan.setDel(rs.getString("del"));}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("id", req.getParameter("id"));req.setAttribute("shetuan", shetuan);req.getRequestDispatcher("admin/shetuan/shetuanDetailHou.jsp").forward(req, res);}public void shetuanDetailHouSave(HttpServletRequest req, HttpServletResponse res) {String id = req.getParameter("id");String mingcheng = req.getParameter("mingcheng");String jieshao = req.getParameter("jieshao");String lishijian = req.getParameter("lishijian");String jiaoshi = req.getParameter("jiaoshi");String typename = req.getParameter("typename");String sql = "update t_shetuan set mingcheng=?,jieshao=?,lishijian=?,jiaoshi=?,typename=? where id="+ Integer.parseInt(req.getParameter("id"));Object[] params = { mingcheng, jieshao, lishijian, jiaoshi, typename };DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shetuan?type=shetuanMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void shetuan_suoyou(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {String userid = "";if (req.getSession().getAttribute("user") != null) {Tuser user = (Tuser) req.getSession().getAttribute("user");userid = user.getId();}List shetuanList = new ArrayList();String sql = "select * from t_shetuan where del='no'";if (req.getSession().getAttribute("user") != null)sql += " and  fuzeren='" + userid + "' ";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tshetuan shetuan = new Tshetuan();shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setTypename(rs.getString("typename"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setJieshao((rs.getString("jieshao")));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setDel(rs.getString("del"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuanList.add(shetuan);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shetuanList", shetuanList);req.getRequestDispatcher("admin/shetuan/shetuan_suoyou.jsp").forward(req, res);}public void shetuanAll(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {List shetuanList = new ArrayList();String sql = "select * from t_shetuan where del='no' and senhe='通过'";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tshetuan shetuan = new Tshetuan();shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setTypename(rs.getString("typename"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setJieshao(rs.getString("jieshao"));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setDel(rs.getString("del"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuanList.add(shetuan);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shetuanList", shetuanList);req.getRequestDispatcher("qiantai/shetuan/shetuanAll.jsp").forward(req, res);}public void shetuanDetailQian(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException {Tshetuan shetuan = new Tshetuan();String sql = "select * from t_shetuan where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setTypename(rs.getString("typename"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setJieshao(rs.getString("jieshao"));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setDel(rs.getString("del"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuan.setUser(liuService.getUser(rs.getString("fuzeren")));}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();// 评价信息List pingjiaList = new ArrayList();sql = "select * from t_pingjia where del='no' and shetuan_id=? order by shetuan_id";Object[] params1 = { req.getParameter("id") };mydb = new DB();try {mydb.doPstm(sql, params1);ResultSet rs = mydb.getRs();while (rs.next()) {Tpingjia pingjia = new Tpingjia();pingjia.setId(rs.getInt("id"));pingjia.setShetuan_id(rs.getInt("shetuan_id"));pingjia.setNeirong(rs.getString("neirong"));pingjia.setShijian(rs.getString("shijian"));pingjia.setHuifu(rs.getString("huifu"));pingjia.setDel(rs.getString("del"));pingjia.setShetuan(liuService.get_shetuan(rs.getInt("shetuan_id")));pingjiaList.add(pingjia);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("pingjiaList", pingjiaList);req.setAttribute("shetuan", shetuan);req.getRequestDispatcher("qiantai/shetuan/shetuanDetailQian.jsp").forward(req, res);}public void shetuan_search(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {List shetuanList = new ArrayList();String sql = "select * from t_shetuan where del='no' and mingcheng like '%"+ req.getParameter("mingcheng").trim() + "%'";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tshetuan shetuan = new Tshetuan();shetuan.setId(rs.getInt("id"));shetuan.setMingcheng(rs.getString("mingcheng"));shetuan.setFuzeren(rs.getString("fuzeren"));shetuan.setTypename(rs.getString("typename"));shetuan.setJieshao(rs.getString("jieshao"));shetuan.setLishijian(rs.getString("lishijian"));shetuan.setDel(rs.getString("del"));shetuan.setJiaoshi(rs.getString("jiaoshi"));shetuanList.add(shetuan);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shetuanList", shetuanList);req.getRequestDispatcher("qiantai/shetuan/shetuanAll.jsp").forward(req, res);}public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);try {dispatch.forward(request, response);return;} catch (ServletException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}public void init(ServletConfig config) throws ServletException {super.init(config);}public void destroy() {}
}

5、前端代码示例