期中考试——校园社团程序
package com.Bean;
public class Userbean {
private String zhuti;
private String mudi;
private String leixing;
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 getleixing() {
return leixing;
}
public void setleixing(String leixing) {
this.leixing = leixing;
}
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;
}
}
package com.Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.Bean.Userbean;
import com.Util.Userutil;
public class Userdao {
public void add(Userbean claz) throws ClassNotFoundException, SQLException
{
//获得链接对象
Connection connection = Userutil.getConnection();
//准备sql语句
String sql = "insert into course(zhuti,mudi,leixing,time,didian,duixiang,neirong,richenganpai) values(?,?,?,?,?,?,?,?)";
PreparedStatement preparedStatement = null;
try {
//创建语句传输对象
preparedStatement = connection.prepareStatement(sql);
// preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, claz.getzhuti());
preparedStatement.setString(2, claz.getmudi());
preparedStatement.setString(3, claz.getleixing());
preparedStatement.setString(4, claz.gettime());
preparedStatement.setString(5, claz.getdidian());
preparedStatement.setString(6, claz.getduixiang());
preparedStatement.setString(7, claz.getneirong());
preparedStatement.setString(8, claz.getrichenganpai());
preparedStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
//关闭资源
//DBUtil.close(preparedStatement);
//DBUtil.close(connection);
}
}
}
package com.Util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Userutil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Connection connection = null;//连接数据库
Statement stmt = null;//Statement 对象用于将 SQL 语句发送到数据库中。
ResultSet rs = null;
//1. 导入驱动jar包
//2.注册驱动
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test123", "root", "yxs17717111701");
return connection;
}
public static void close(Connection connection ) {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(PreparedStatement preparedStatement ) {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(ResultSet resultSet ) {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
jsp文件代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>校园社团活动管理系统</title>
</head>
<body>
<h2 align="center">校园社团活动管理系统</h2>
<a href="jiemain.jsp">发布活动信息</a><br>
<a href="jiemain.jsp">修改活动信息</a><br>
<a href="shanchu.jsp">删除活动信息</a><br>
<a href="liulan.jsp">浏览活动信息</a><br>
</body>
</html>
<%@page import="com.Bean.Userbean"%>
<%@page import="com.Dao.Userdao"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<%
//接收客户端传递过来的参数
String zhuti = request.getParameter("zhuti");
String mudi = request.getParameter("mudi");
String leixing = request.getParameter("leixing");
String time = request.getParameter("time");
String didian = request.getParameter("didian");
String duixiang = request.getParameter("duixiang");
String neirong = request.getParameter("neirong");
String richenganpai = request.getParameter("richenganpai");
// try{
//if()
{
// throw new ClassException("信息填报错误");
}
// else if()
{
// throw new ClassException("信息填报错误");
}
// else
{
Userbean A = new Userbean();
A.setzhuti(zhuti);
A.setmudi(mudi);
A.setleixing(leixing);
A.settime(time);
A.setdidian(didian);
A.setduixiang(duixiang);
A.setneirong(neirong);
A.setrichenganpai(richenganpai);
Userdao Dao = new Userdao();
Dao.add(A);
}
%>
<a href="jiemain.jsp">发布活动信息</a><br>
<a href="jiemain.jsp">修改活动信息</a><br>
<a href="shanchu.jsp">删除活动信息</a><br>
<a href="liulan.jsp">浏览活动信息</a><br>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>石家庄铁道大学校园社团活动发布表</title>
</head>
<body>
<form action="add.jsp" method="get">
<table align="center" border="1" width="500">
<tr>
<td>活动主题:</td>
<td>
<input type="text" name="zhuti" />
</td>
</tr>
<tr>
<td>活动目的:</td>
<td>
<input type="text" name="mudi" />
</td>
</tr>
<tr>
<td>学生类型:</td>
<td>
<input type="radio" name="leixing" value="社团竞赛" >社团竞赛
<input type="radio" name="leixing" value="野外风采" >野外风采
<input type="radio" name="leixing" value="校内集会" >校内集会
<input type="radio" name="leixing" value="社团纳新" >社团纳新
</td>
</tr>
<tr>
<td>时间:</td>
<td>
<input type="text" name="time" />
</td>
</tr>
<tr>
<td>地点:</td>
<td>
<input type="text" name="didian" />
</td>
</tr>
<tr>
<td>活动内容:</td>
<td>
<input type="text" name="neirong" />
</td>
</tr>
<tr>
<td>活动日程安排:</td>
<td>
<input type="text" name="richenganpai"/>
</td>
</tr>
<tr>
<td>活动对象：</td>
<input type="checkbox" value="社团成员" name="duixiang">社团成员
<br>
<input type="checkbox" value="全体学生" name="duixiang">全体学生
<br>
</tr>
<tr align="center">
<td colspan="2">
<input type="submit" value="提交"/>
</td>
</tr>
</table>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>浏览</title>
</head>
<body>
<form action="add.jsp" method="get">
<table align="center" border="1" width="500">
<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>
</tr>
<tr align="center">
<button>浏览完成</button>
</tr>
</table>
</body>
</html>>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>信息删除页面</title>
</head>
<body>
<form method="post" action="add.jsp">
<table align="center">
<tr>
主题：<input name="zhuti" type="text">
</tr>
<tr align="center">
<button>查询活动主题信息</button>
</tr>
</table>
</form>
</table>
</body>
</html>
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· TypeScript + Deepseek 打造卜卦网站：技术与玄学的结合
· Manus的开源复刻OpenManus初探
· 三行代码完成国际化适配，妙~啊~
· .NET Core 中如何实现缓存的预热？
· 如何调用 DeepSeek 的自然语言处理 API 接口并集成到在线客服系统