制作一个简陋的课程信息管理系统

1，首先给这个系统进行基本布局

（1）用frameset给系统界面画一个大致的框架

代码:

</head>


<frameset rows="10%,*" frameborder="yes">

       <frame src="top.jsp" >
       
       <frameset cols="30%,*">
               <frame src="main_lift.jsp">
               <frame src="main_right.jsp" name="main_right">
       </frameset>
</frameset>

在main_lift.jsp中设置链接并将链接对应的内容映射到main_right.jsp中

代码：

<body>

<a href="inputclassinfo.jsp" target="main_right">录入课程信息</a><br/><br/>
<a href="chax.jsp" target="main_right">查询课程信息</a><br/><br/>
<a href="modifyclassinfo.jsp" target="main_right">修改课程信息</a><br/><br/>
<a href="deleteclassinfo.jsp" target="main_right">删除课程信息</a><br/><br/>
<a href="exit.jsp" target="_top">退出系统</a><br/>
</body>

并在top.jsp中设置头部界面

代码:

<body>
<h1> 欢迎来到铁道大学课程查询系统 </h1>
</body>

截图

2，给每个链接写入相应的代码即给其书写功能

录入功能

代码:

(页面显示)

<title>Insert title here</title>
<style type="text/css">

.sub{

width: 100px;

height: 25px;

margin-top: 25px;

background: #1E90FF;

border-radius: 10px;

border:none;

font-size: 14px;

font-weight: 700;

color: #fff;

}

.sub:hover {

background: #79A84B;

outline: 0;

}

.mytxt {
    color:#333;
    line-height:normal;
    font-family:"Microsoft YaHei",Tahoma,Verdana,SimSun;
    font-style:normal;
    font-variant:normal;
    font-size-adjust:none;
    font-stretch:normal;
    font-weight:normal;
    margin-top:0px;
    margin-bottom:0px;
    margin-left:0px;
    padding-top:4px;
    padding-right:4px;
    padding-bottom:4px;
    padding-left:4px;
    font-size:10px;
    outline-width:medium;
    outline-style:none;
    outline-color:invert;
    border-top-left-radius:3px;
    border-top-right-radius:3px;
    border-bottom-left-radius:3px;
    border-bottom-right-radius:3px;
    text-shadow:0px 1px 2px #fff;
    background-attachment:scroll;
    background-repeat:repeat-x;
    background-position-x:left;
    background-position-y:top;
    background-size:auto;
    background-origin:padding-box;
    background-clip:border-box;
    background-color:rgb(255,255,255);
    margin-right:8px;
    border-top-color:#ccc;
    border-right-color:#ccc;
    border-bottom-color:#ccc;
    border-left-color:#ccc;
    border-top-width:1px;
    border-right-width:1px;
    border-bottom-width:1px;
    border-left-width:1px;
    border-top-style:solid;
    border-right-style:solid;
    border-bottom-style:solid;
    border-left-style:solid;
    width: 150px;

}
.mytxt:focus {
     border: 1px solid #fafafa;
    -webkit-box-shadow: 0px 0px 6px #007eff;
     -moz-box-shadow: 0px 0px 5px #007eff;
     box-shadow: 0px 0px 5px #007eff;

}
</style>

</head>
<body>

<form action="inputclassinfo_result.jsp" method="post">
<table bgcolor="white" align="center">
<tr><td align="center" bgcolor="white" colspan="2">录入课程信息</td></tr>
<tr>
<td>课程名称</td> <td><input type="text" size=20 name="course" class="mytxt"/></td>
</tr>
<tr></tr>
<tr>
<td>任课教师</td> <td><input type="text" size=20 name="teacher" class="mytxt"/></td>
</tr>
<tr></tr>
<tr>
<td>上课地点</td> <td><input type="text" size=20 name="place" class="mytxt"/></td>
</tr>
<tr></tr>
<tr> <td></td><td>    <input type="submit" size="15" value="保存" class="sub"/> </td> </tr>

</table>
</form>

</body>

（后台处理）

</head>
<body>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="classInfo" class="stu_class.classinfo"> </jsp:useBean>
<jsp:setProperty property="*" name="classInfo"/>
<jsp:useBean id="classServer" class="service.classinfo_service"></jsp:useBean>
<%

boolean ps=false,tc=false;
if(classInfo.getPlace().equals("一教")||
  classInfo.getPlace().equals("二教")||
  classInfo.getPlace().equals("三教")||
  classInfo.getPlace().equals("基教"))
{
ps=true;
}
else
out.println("您设置的地点有误！请您重新设置");

if(classInfo.getTeacher().equals("王建民")||classInfo.getTeacher().equals("刘立嘉")||classInfo.getTeacher().equals("刘丹")||classInfo.getTeacher().equals("王辉")||classInfo.getTeacher().equals("杨子光")){
    tc=true;
}
else
out.println("您设置的教师有误！请您重新设置");

if(ps&&tc)
if(!classServer.checkClassName(classInfo))
{
out.print("本课程已存在!");
}
else
if(classServer.addclass(classInfo))
out.print("课程导入成功！");
else
out.print("课程导入失败！");
%>
</body>
</html>

截图

（2，查询信息）

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="classInfo" class="stu_class.classinfo"> </jsp:useBean>
<jsp:setProperty property="*" name="classInfo"/>
<jsp:useBean id="classServer" class="service.classinfo_service"></jsp:useBean>
<%
ArrayList clas=classServer.queryClass(classInfo);
//out.print(stus.size());
Iterator iter=clas.iterator();
%>
<table >
<tr><td></td> <td> 课程名称 </td><td> 任课老师 </td><td> 上课地点 </td></tr>
<%
int i=0;
while(iter.hasNext())
{
classinfo classe=(classinfo)iter.next();
%>
<tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
<td> <%=i+1 %> </td>
<td> <%=classe.getCourse() %></td>
<td> <%=classe.getTeacher() %></td>
<td> <%=classe.getPlace() %></td>
</tr>
<%
i++;
}
%>

</table>

</body>
</html>

.sub{

width: 100px;

height: 25px;

margin-top: 25px;

background: #1E90FF;

border-radius: 10px;

border:none;

font-size: 14px;

font-weight: 700;

color: #fff;

}

.sub:hover {

background: #79A84B;

outline: 0;

}

}
.mytxt:focus {
     border: 1px solid #fafafa;
    -webkit-box-shadow: 0px 0px 6px #007eff;
     -moz-box-shadow: 0px 0px 5px #007eff;
     box-shadow: 0px 0px 5px #007eff;

}
</style>

</head>
<body>

<form action="displayclassinfo.jsp" method="post">
<table bgcolor="white" align="center">
<tr><td align="center" bgcolor="white" colspan="2">录入课程信息</td></tr>
<tr>
<td>课程名称</td> <td><input type="text" size=20 name="course" class="mytxt"/></td>
</tr>
<tr></tr>
<tr>
<td>任课教师</td> <td><input type="text" size=20 name="teacher" class="mytxt"/></td>
</tr>
<tr></tr>
<tr>
<td>上课地点</td> <td><input type="text" size=20 name="place" class="mytxt"/></td>
</tr>
<tr></tr>
<tr> <td></td><td>    <input type="submit" size="15" value="查询" class="sub"/> </td> </tr>

</table>
</form>

</body>
</html>

截图

（3）修改

代码

<%@page import="stu_class.*"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.ArrayList"%>
<%@ 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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="ClassSer" class="service.classinfo_service"></jsp:useBean>
<%
ArrayList clas=ClassSer.queryAllClass();
//out.print(stus.size());
Iterator iter=clas.iterator();
%>
<table >
<tr><td> 课程名称 </td><td> 任课老师 </td><td> 上课地点 </td></tr>
<%
int i=0;
while(iter.hasNext())
{
classinfo classe=(classinfo)iter.next();
%>
<tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
<td> <%=classe.getCourse() %></td>
<td> <%=classe.getTeacher() %></td>
<td> <%=classe.getPlace() %></td>
<td> <a href="modifyOneclass.jsp?id=<%=classe.getId() %>">修改</a></td>
</tr>
<%
i++;
}
%>

</table>
</body>
</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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>

<body>

<%request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="clas" class="stu_class.classinfo"></jsp:useBean>
<jsp:setProperty property="*" name="clas" />
<jsp:useBean id="clasSer" class="service.classinfo_service"></jsp:useBean>

<%
boolean ps=false,tc=false;
if(clas.getPlace().equals("一教")||
  clas.getPlace().equals("二教")||
  clas.getPlace().equals("三教")||
  clas.getPlace().equals("基教"))
{
ps=true;
}
else
out.println("您设置的地点有误！请您重新设置");

if(clas.getTeacher().equals("王建民")||clas.getTeacher().equals("刘立嘉")||clas.getTeacher().equals("刘丹")||clas.getTeacher().equals("王辉")||clas.getTeacher().equals("杨子光")){
    tc=true;
}
else
out.println("您设置的教师有误！请您重新设置");

if(ps&&tc){

if(clasSer.updateClass(clas))
out.print("课程修改成功！");
else
out.print("课程修改失败！");
}
%>

</body>
</html>

截图

（4）删除信息

代码:

<%@page import="stu_class.classinfo"%>
<%@ 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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="classSer" class="service.classinfo_service"></jsp:useBean>
<%
int id=Integer.parseInt(request.getParameter("id"));
classinfo stu=classSer.queryClassByID(id);
if(classSer.deleteClass(id))
out.print("success!!");
else
out.print("false");
%>
</body>
</html>

<%@page import="stu_class.*"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.ArrayList"%>
<%@ 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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="ClassSer" class="service.classinfo_service"></jsp:useBean>
<%
ArrayList clas=ClassSer.queryAllClass();
//out.print(stus.size());
Iterator iter=clas.iterator();
%>
<table >
<tr><td></td> <td> 课程名称 </td><td> 任课老师 </td><td> 上课地点 </td></tr>
<%
int i=0;
while(iter.hasNext())
{
classinfo classe=(classinfo)iter.next();
%>
<tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
<td> <%=i+1 %> </td>
<td> <%=classe.getCourse() %></td>
<td> <%=classe.getTeacher() %></td>
<td> <%=classe.getPlace() %></td>
<td> <a href="deleteOneclass.jsp?id=<%=classe.getId() %>">删除</a></td>
</tr>
<%
i++;
}
%>

</table>

</body>
</html>

posted @ 2018-12-09 20:53 余鱼瑜渔阅读(163) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

余鱼瑜渔

制作一个简陋的课程信息管理系统

公告