期中考试
本周进行了java课程的期中考试,考试的主要内容为javaweb的增删改查,本次期中考试完成还可以,一下是题目要求和代码
题目内容:
校园社团活动管理系统(20分)
1、项目需求:
校园社团作为高校课外活动的重要组成部分,发展十分迅速,也受到越来越多学生的欢迎,社团规模、数量等都在日益增长,社团活动也更为多样和丰富。然而,大多数高校还没有一个完整成熟的社团管理系统,仅仅是靠人力来管理,导致效率低下,而学生也只能通过线下或者公众号的方式了解社团,另外,社团活动的通知方式也很杂乱,并没有一个信息聚合、消息发布的平台。
因此,高校有必要建立一个校园社团管理系统,使得社团管理工作规范化、系统化、程序化、科学化,提高管理工作的效率。
2.系统要求与功能设计
2.1 页面功能要求
(1)能够在Tomcat服务器中正确部署,并通过浏览器查看;(1分)
(2)网站页面整体风格统一;
图1 活动普查系统功能结构图
(3)主页面:要求显示发布活动信息、修改活动信息、删除活动信息、查询活动信息,活动信息浏览五个子菜单。(1分)
(4)发布活动信息页面:(6分)
①完成添加活动信息发布,基本信息和填报限制如下表所示
活动主题 |
字符串(不超过20个汉字) |
活动目的 |
字符串(不超过50个汉字) |
活动类型 |
社团竞赛、野外采风、校内集会、社团纳新(单选框) |
活动时间 |
文本框 |
活动地点 |
文本框 |
活动对象 |
社团成员、全体学生(复选框实现) |
活动内容 |
(文本框,不超过500个汉字) |
活动日程安排 |
(文本框,不超过500个汉字) |
②点击“提交”按钮,保存成功则跳转到活动基本信息浏览界面,新录入的信息置顶显示。失败则提示错误信息,返回当前页面
评分标准:
① 完成活动信息发布页面(未完成0分,完成1分)
② 保存活动信息入库(未完成0分,完成1分)
③ 社团竞赛、野外采风、校内集会、社团纳新实现单选框录入1分。(未完成0分,全部完成1分)
④ 实现活动对象复选框录入1分。(未完成0分,完成1分)
⑤ 实现活动主题、活动目的、活动内容、活动日程安排的字数判断,实现三个以上得1分(未完成0分,完成1分)
⑥提交后页面跳转功能;(未完成0分,完成1分)
(5)修改活动信息页面:(3分)
输入活动主题,显示其余信息,可对活动目的、活动类型、活动时间、活动地点、活动对象、活动内容、活动日程安排进行修改。(活动目的、活动类型、活动时间、活动地点、活动对象、活动内容、活动日程安排必须符合录入要求);如果该活动主题数据库不存在,则提示“该活动不存在”。(3分)
评分标准:
① 完成修改活动信息页面(未完成0分,完成1分)
② 实现数据库中信息更新(未完成0分,完成1分)
③输入活动主题,显示其余信息,若该信息不存在,提示错误信息;(未完成0分,完成1分)
(6)删除活动信息页面:录入活动主题,显示详细信息后,点击“删除”按钮,弹出提示框,提示“是否确认删除该活动信息”,确认后删除该信息。(1分)
评分标准:
① 输入活动主题可显示其余信息。(未完成0分,完成0.5分)
②对应删除数据库中信息(未完成0分,完成0.5分)
(7)浏览活动信息页面:(2分)
以列表形式显示活动基本信息,结果列表中显示活动主题、活动时间,活动类型、活动对象基本信息,点击主题,可以跳转到活动详细信息,显示全部活动信息。
① 实现以列表形式显示活动基本信息,结果列表中显示活动主题、活动时间,活动类型、活动对象基本信息(未完成0分,完成1分)
②实现跳转活动详细信息页面,显示全部活动信息。(未完成0分,完成1分)
(8)查询活动信息页面:(3分)
要求根据活动主题、活动时间、活动类型、活动地点四种条件实现模糊查询,输出结果以列表形式显示,显示显示活动主题、活动时间,活动类型、活动对象基本信息,点击列表中的活动主题,跳转到活动详细信息页面。
评分标准:
①缺少一种查询条件扣除1分。(未完成0分,完成3分)
2.2 功能要求
(1)设计出合理的数据库和数据表,要求使用mysql、sqlserver、oracle三种数据库中一种(1分)
(2)使用Serverlet实现页面交互(1分)。
(3)使用Java Bean封装数据库连接操作(1分。)
代码内容:
java文件:
package com.DAO;
import java.sql.*;
public class dao {
private String zhuti;
private String mudi;
private String type;
private String time;
private String place;
private String duixiang;
private String neirong;
private String anpai;
@Override
public String toString() {
return "dao{" +
"zhuti='" + zhuti + '\'' +
", mudi='" + mudi + '\'' +
", type='" + type + '\'' +
", time='" + time + '\'' +
", place='" + place + '\'' +
", duixiang='" + duixiang + '\'' +
", neirong='" + neirong + '\'' +
", anpai='" + anpai + '\'' +
'}';
}
public dao(String zhuti, String mudi, String type, String time, String place, String duixiang, String neirong, String anpai) {
this.zhuti = zhuti;
this.mudi = mudi;
this.type = type;
this.time = time;
this.place = place;
this.duixiang = duixiang;
this.neirong = neirong;
this.anpai = anpai;
}
public dao() {
}
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 getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public String getPlace() {
return place;
}
public void setPlace(String place) {
this.place = place;
}
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 getAnpai() {
return anpai;
}
public void setAnpai(String anpai) {
this.anpai = anpai;
}
public Connection getConnection()
{
try{
Class.forName("com.mysql.cj.jdbc.Driver");
//System.out.println("加载驱动成功");
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
String user="root";
String password="123456";
String url = "jdbc:mysql://localhost:3306/judge1?useSSL=false&serverTimezone=GMT&characterEncoding=utf-8&autoReconnect=true";
java.sql.Connection con=null;
try{
con= DriverManager.getConnection(url,user,password);
//System.out.println("数据库连接成功");
}catch(SQLException e)
{
e.printStackTrace();
}
return con;
}
public void close (Connection con)
{
try{
if(con!=null)
{
con.close();
}
}catch(SQLException e)
{
e.printStackTrace();
}
}
public void close (PreparedStatement preparedStatement)
{
try{
if(preparedStatement!=null)
{
preparedStatement.close();
}
}catch(SQLException e)
{
e.printStackTrace();
}
}
public void close(ResultSet resultSet)
{
try{
if(resultSet!=null)
{
resultSet.close();
}
}catch(SQLException e)
{
e.printStackTrace();
}
}
public void adddata(String zhuti, String mudi, String type, String time, String place, String duixiang, String neirong, String anpai)
{
Connection connection = getConnection();
PreparedStatement preparedStatement=null;
try {
String sql = "insert into job (活动主题,活动目的,活动类型,活动时间,活动地点,活动对象,活动内容,活动日程安排) values (?,?,?,?,?,?,?,?)";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,zhuti);
preparedStatement.setString(2,mudi);
preparedStatement.setString(3,type);
preparedStatement.setString(4,time);
preparedStatement.setString(5,place);
preparedStatement.setString(6,duixiang);
preparedStatement.setString(7,neirong);
preparedStatement.setString(8,anpai);
preparedStatement.executeUpdate();
//System.out.println("添加成功");
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(preparedStatement);
close(connection);
}
}
public boolean isEmpty(String zhuti, String mudi, String type, String time, String place, String duixiang, String neirong, String anpai)
//判空语句
{
if(zhuti==""||mudi==""||type==""||time==""||place==""||duixiang==""||neirong==""||anpai=="")
return true;
else return false;
}
public boolean iszhuti(String str)
{
if(str.length() >= 20)
{
return false;
}
else
{
return true;
}
}
public boolean mudi(String str)
{
if(str.length() >= 50)
{
return false;
}
else
{
return true;
}
}
public boolean neirong(String str)
{
if(str.length() >= 500)
{
return false;
}
else
{
return true;
}
}
public boolean anpai(String str)
{
if(str.length() >= 500)
{
return false;
}
else
{
return true;
}
}
public boolean istimuRight(String timu)
{
Connection connection = getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from job";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if( timu.equals(rs.getObject(1)))
return true;
}
//preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(rs);
close(preparedStatement);
close(connection);
}
return false;
}
public void revisedata(String zhuti, String mudi, String type, String time, String place, String duixiang, String neirong, String anpai)
{
Connection connection = getConnection();
PreparedStatement preparedStatement=null;
try {
//身份证号码、性别、民族、受教育程度
String sql = "update job set 活动目的=?, 活动类型=?, 活动时间=?, 活动地点=?, 活动对象=?, 活动内容=?, 活动日程安排=? where 活动主题=?";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,mudi);
preparedStatement.setString(2,type);
preparedStatement.setString(3,time);
preparedStatement.setString(4,place);
preparedStatement.setString(5,duixiang);
preparedStatement.setString(6,neirong);
preparedStatement.setString(7,anpai);
preparedStatement.setString(8,zhuti);
preparedStatement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(preparedStatement);
close(connection);
}
}
public void deletedatazhuti(String zhuti)
{//删除
Connection connection = getConnection();
PreparedStatement preparedStatement=null;
try {
String sql = "delete from job where 活动主题 = ?";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,zhuti);
preparedStatement.executeUpdate();
//System.out.println("删除成功");
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(preparedStatement);
close(connection);
}
}
}
jsp文件:
menu.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 12:02
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>校园社团活动管理系统</title>
</head>
<body>
<br>发布活动信息<br>
<br><input type="button" value="发布活动信息" onclick="location.href='add.jsp'" /><br>
<br>修改活动信息<br>
<br><input type="button" value="修改活动信息" onclick="location.href='xiugai.jsp'" /><br>
<br>删除活动信息<br>
<br><input type="button" value="删除活动信息" onclick="location.href='delect.jsp'" /><br>
<br>查询活动信息<br>
<br><input type="button" value="查询活动信息" onclick="location.href='screach.jsp'" /><br>
<br>浏览活动信息<br>
<br><input type="button" value="浏览活动信息" onclick="location.href='liulan.jsp'" /><br>
</body>
</html>
add.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:07
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>发布活动信息</title>
</head>
<body>
<form action="add1.jsp" method="get">
<br>活动主题<br>
<br> <input type="text" name="zhuti" size="8" /><br>
<br>活动目的<br>
<br> <input type="text" name="mudi" size="8" /><br>
<br>活动类型<br>
<br><input type="radio" name="type" value="社团竞赛" />社团竞赛
<input type="radio" name="type" value="社团竞赛" />社团竞赛
<input type="radio" name="type" value="校内集会" />校内集会
<input type="radio" name="type" value="社团纳新" />社团纳新
<br>活动时间<br>
<br> <input type="text" name="time" size="8" /><br>
<br>活动地点<br>
<br> <input type="text" name="place" size="8" /><br>
<br>活动对象<br>
<br><input type="checkbox" name = "duixiang" value = "社团成员" checked>社团成员<br>
<br><input type="checkbox" name = "duixiang" value = "全体学生" checked>全体学生<br>
<br>活动内容<br>
<br> <input type="text" name="neirong" size="8" /><br>
<br>活动日程安排<br>
<br> <input type="text" name="anpai" size="8" /><br>
<br><input type="submit" value="提交" />
</form>
</body>
</html>
add1.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:14
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>增加信息</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti=(String)request.getParameter("zhuti");
String mudi=(String)request.getParameter("mudi");
String type=(String)request.getParameter("type");
String time=(String)request.getParameter("time");
String place=(String)request.getParameter("place");
String [] h = request.getParameterValues("duixiang");
String duixiang = Arrays.toString(h);
duixiang = duixiang.substring(1, duixiang.length()-1);
String neirong=(String)request.getParameter("neirong");
String anpai=(String)request.getParameter("anpai");
if(qizhong.isEmpty(zhuti,mudi,type,time,place,duixiang,neirong,anpai)){
out.print("<script language='javaScript'> alert('输入为空');window.history.back(-1);</script>");
}
else if(!qizhong.iszhuti(zhuti))
{
out.print("<script language='javaScript'> alert('主题数字不对');window.history.back(-1);</script>");
}
else if(!qizhong.mudi(zhuti))
{
out.print("<script language='javaScript'> alert('主题目的数字不对');window.history.back(-1);</script>");
}
else if(!qizhong.neirong(zhuti))
{
out.print("<script language='javaScript'> alert('主题内容数字不对');window.history.back(-1);</script>");
}
else if(!qizhong.anpai(zhuti))
{
out.print("<script language='javaScript'> alert('主题安排数字不对');window.history.back(-1);</script>");
}
else {
qizhong.adddata(zhuti,mudi,type,time,place,duixiang,neirong,anpai);
out.print("<script language='javaScript'> alert('添加成功');</script>");
response.setHeader("refresh", "0;url=liulan.jsp");
}
%>
</body>
</html>
delect.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:56
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>删除</title>
</head>
<body>
<form action="delect1.jsp" method="get">
<br>活动主题<br>
<br> <input type="text" name="zhuti" size="8" /><br>
<br><input type="submit" value="提交" />
</form>
</body>
</html>
delect1.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:56
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>删除</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti=(String)request.getParameter("zhuti");
if(zhuti==""){
out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else if(!qizhong.istimuRight(zhuti))
{
out.print("<script language='javaScript'> alert('该活动不存在'); window.history.back(-1); </script>");
}
else {
session.setAttribute("zhuti", zhuti);
Connection connection = qizhong.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from job";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if( zhuti.equals(rs.getObject(1)))
{
%>
<table border="1"style="text-align:center;">
<tr>
<td align="center" width=20>活动主题</td>
<td align="center" width=20>活动目的</td>
<td align="center" width=20>活动类型</td>
<td align="center" width=20>活动时间</td>
<td align="center" width=20>活动地点</td>
<td align="center" width=20>活动对象</td>
<td align="center" width=20>活动内容</td>
<td align="center" width=20>活动日程安排</td>
</tr>
<tr>
<td align="center"><%=rs.getObject(1) %></td>
<td align="center"><%=rs.getObject(2) %></td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(5) %></td>
<td align="center"><%=rs.getObject(6) %></td>
<td align="center"><%=rs.getObject(7) %></td>
<td align="center"><%=rs.getObject(8) %></td>
</tr>
<%
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
qizhong.close(rs);
qizhong.close(preparedStatement);
qizhong.close(connection);
}
}
%>
<br>确认删除信息<br>
<br><input type="button" value="确认删除信息" onclick="location.href='delect2.jsp'" /><br>
<br>取消删除信息<br>
<br><input type="button" value="取消删除信息" onclick="location.href='menu.jsp'" /><br>
</body>
</html>
delect2.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 15:01
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>删除</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti=(String)session.getAttribute("zhuti");
qizhong.deletedatazhuti(zhuti);
out.print("<script language='javaScript'> alert('删除成功');</script>");
response.setHeader("refresh", "0;url=menu.jsp");
%>
</body>
</html>
xiugai.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:36
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>修改页面</title>
</head>
<body>
<form action="xiugai1.jsp" method="get">
<br>活动主题<br>
<br> <input type="text" name="zhuti" size="8" /><br>
<br><input type="submit" value="提交" />
</form>
</body>
</html>
xiugai1.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:38
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>修改页面</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti=(String)request.getParameter("zhuti");
if(zhuti==""){
out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else if(!qizhong.istimuRight(zhuti))
{
out.print("<script language='javaScript'> alert('该活动不存在'); window.history.back(-1); </script>");
}
else {
session.setAttribute("zhuti", zhuti);
Connection connection = qizhong.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from job";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if( zhuti.equals(rs.getObject(1)))
{
%>
<table border="1"style="text-align:center;">
<tr>
<td align="center" width=20>活动主题</td>
<td align="center" width=20>活动目的</td>
<td align="center" width=20>活动类型</td>
<td align="center" width=20>活动时间</td>
<td align="center" width=20>活动地点</td>
<td align="center" width=20>活动对象</td>
<td align="center" width=20>活动内容</td>
<td align="center" width=20>活动日程安排</td>
</tr>
<tr>
<td align="center"><%=rs.getObject(1) %></td>
<td align="center"><%=rs.getObject(2) %></td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(5) %></td>
<td align="center"><%=rs.getObject(6) %></td>
<td align="center"><%=rs.getObject(7) %></td>
<td align="center"><%=rs.getObject(8) %></td>
</tr>
<%
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
qizhong.close(rs);
qizhong.close(preparedStatement);
qizhong.close(connection);
}
}
%>
<form action="xiugai2.jsp" method="get">
<table border = "1" style= "text-align:center ;">
<br>活动目的<br>
<br> <input type="text" name="mudi" size="8" /><br>
<br>活动类型<br>
<br><input type="radio" name="type" value="社团竞赛" />社团竞赛
<input type="radio" name="type" value="社团竞赛" />社团竞赛
<input type="radio" name="type" value="校内集会" />校内集会
<input type="radio" name="type" value="社团纳新" />社团纳新
<br>活动时间<br>
<br> <input type="text" name="time" size="8" /><br>
<br>活动地点<br>
<br> <input type="text" name="place" size="8" /><br>
<br>活动对象<br>
<br><input type="checkbox" name = "duixiang" value = "社团成员" checked>社团成员<br>
<br><input type="checkbox" name = "duixiang" value = "全体学生" checked>全体学生<br>
<br>活动内容<br>
<br> <input type="text" name="neirong" size="8" /><br>
<br>活动日程安排<br>
<br> <input type="text" name="anpai" size="8" /><br>
<br><input type="submit" value="提交" />
</table>
</form>
</body>
</html>
xiugai2.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 14:45
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>Title</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti=(String)session.getAttribute("zhuti");
String mudi=(String)request.getParameter("mudi");
String type=(String)request.getParameter("type");
String time=(String)request.getParameter("time");
String place=(String)request.getParameter("place");
String [] h = request.getParameterValues("duixiang");
String duixiang = Arrays.toString(h);
duixiang = duixiang.substring(1, duixiang.length()-1);
String neirong=(String)request.getParameter("neirong");
String anpai=(String)request.getParameter("anpai");
if(qizhong.isEmpty(zhuti,mudi,type,time,place,duixiang,neirong,anpai)){
out.print("<script language='javaScript'> alert('输入为空');window.history.back(-1);</script>");
}
else if(!qizhong.mudi(zhuti))
{
out.print("<script language='javaScript'> alert('主题目的数字不对');window.history.back(-1);</script>");
}
else if(!qizhong.neirong(zhuti))
{
out.print("<script language='javaScript'> alert('主题内容数字不对');window.history.back(-1);</script>");
}
else if(!qizhong.anpai(zhuti))
{
out.print("<script language='javaScript'> alert('主题安排数字不对');window.history.back(-1);</script>");
}
else {
qizhong.revisedata(zhuti,mudi,type,time,place,duixiang,neirong,anpai);
out.print("<script language='javaScript'> alert('修改成功');</script>");
response.setHeader("refresh", "0;url=menu.jsp");
}
%>
</body>
</html>
screach.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 15:21
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>查询</title>
</head>
<body>
<form action="screach1.jsp" method="get">
<br>数据<br>
<br> <input type="text" name="data" size="8" /><br>
<br><input type="submit" value="提交" />
</form>
</body>
</html>
screach1.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 15:21
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<head>
<title>查询</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String data=(String)request.getParameter("data");
if( data == "")
{
out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else {
%>
<table border="1"style="text-align:center;">
<tr>
<td align="center" width=20>活动主题</td>
<td align="center" width=20>活动类型</td>
<td align="center" width=20>活动时间</td>
<td align="center" width=20>活动对象</td>
</tr>
<%
int i=0;
Connection connection = qizhong.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql= " select * from job where 活动主题 like ? or 活动类型 like ? or 活动时间 like ? or 活动地点 like ? ";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,"%"+data+"%");
preparedStatement.setString(2,"%"+data+"%");
preparedStatement.setString(3,"%"+data+"%");
preparedStatement.setString(4,"%"+data+"%");
rs=preparedStatement.executeQuery();
while(rs.next())
{
i++;
%>
<tr>
<td align="center"><a style="color:blue" href='all.jsp?zhuti=<%=rs.getObject(1) %>'><%=rs.getObject(1) %></a> </td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(6) %></td>
</tr>
<%
}
if(i==0)
{
out.print("<script language='javaScript'> alert('没有查询到有关信息'); window.history.back(-1); </script>");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
qizhong.close(rs);
qizhong.close(preparedStatement);
qizhong.close(connection);
}
}
%>
</body>
</html>
all.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 15:13
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<html>
<head>
<title>所有信息</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
String zhuti = (String)request.getParameter("zhuti");
Connection connection = qizhong.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from job ";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if(zhuti.equals(rs.getObject(1)))
{
%>
<table border="1"style="text-align:center;">
<tr>
<td align="center" width=20>活动主题</td>
<td align="center" width=20>活动目的</td>
<td align="center" width=20>活动类型</td>
<td align="center" width=20>活动时间</td>
<td align="center" width=20>活动地点</td>
<td align="center" width=20>活动对象</td>
<td align="center" width=20>活动内容</td>
<td align="center" width=20>活动日程安排</td>
</tr>
<tr>
<td align="center"><%=rs.getObject(1) %></td>
<td align="center"><%=rs.getObject(2) %></td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(5) %></td>
<td align="center"><%=rs.getObject(6) %></td>
<td align="center"><%=rs.getObject(7) %></td>
<td align="center"><%=rs.getObject(8) %></td>
</tr>
<%
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
qizhong.close(rs);
qizhong.close(preparedStatement);
qizhong.close(connection);
}
%>
</table>
</body>
</html>
liulan.jsp
<%--
Created by IntelliJ IDEA.
User: lxy
Date: 2022/10/28
Time: 15:07
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<html>
<head>
<title>浏览信息</title>
</head>
<body>
<jsp:useBean id="qizhong" class="com.DAO.dao" scope="page" />
<%
Connection connection = qizhong.getConnection();
PreparedStatement preparedStatement = null;
ResultSet rs = null;
try {
String sql = "select * from job";
preparedStatement = connection.prepareStatement(sql);
rs = preparedStatement.executeQuery();
while (rs.next()) {
%>
<table border="1" style="text-align:center;">
<tr>
<td align="center" width=20>活动主题</td>
<td align="center" width=20>活动类型</td>
<td align="center" width=20>活动时间</td>
<td align="center" width=20>活动对象</td>
</tr>
<tr>
<td td align="center"><a style="color:blue" href='all.jsp?zhuti=<%=rs.getObject(1) %>'><%=rs.getObject(1) %></a> </td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(6) %></td>
</tr>
<%
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
qizhong.close(rs);
qizhong.close(preparedStatement);
qizhong.close(connection);
}
%>
</body>
</html>
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· 百万级群聊的设计实践
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
· 永远不要相信用户的输入:从 SQL 注入攻防看输入验证的重要性