前言
前面已经写了很多篇,其实每一篇都比较简单,因为我希望自己以后看自己的博客也可以一目了然,所以就分开来写,这一篇就做个结尾吧,把选课界面和管理员的界面一起给出。选课系统(5)的运行结果有一个选课按钮,点击它进入选课界面,也是直接给出选课界面代码:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="h2.*" %>
<!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>
<%
if(session.getAttribute("userName")==null)
response.sendRedirect("iindex.jsp");
String userName=(String)session.getAttribute("userName");
if(userName.equals("10"))
response.sendRedirect("index5.jsp");
%>
<%
String realname="";
if(session.getAttribute("realname")!=null)
realname=(String)session.getAttribute("realname");
String str="1";
boolean flag=false;
String a;
int number=0;
String Number=request.getParameter("number");
String Name;
if(Number!=null)
{number=Integer.valueOf(Number);
}
for(int i=0;i<=number;i++){
Name="choose"+i;
if(request.getParameter(Name)!=null)
{str=new String(request.getParameter("choose"+i).getBytes("ISO-8859-1"),"UTF-8").trim();
flag=selected.choosen( userName, str);
if(flag==false) out.print("选课失败");
}
}
%>
可以选的课:
<%
//boolean flag;
int n=0;
String classes[]=allcourse.allclasses();
String teachers[]=allcourse.allteachers();
int numbers[]=allcourse.allnumbers();
out.print(classes.length);
//flag=allcourse.allclasses();
for(int i=0;i<classes.length&&classes[i]!=null;i++){
%>
<form action="" method="post" name="game1" >
<input type="checkbox" name="choose<%=i %>" value="<%=classes[i] %> ">
课程名称:<input type="text" value="<%=classes[i] %>" style="width:100px">
任课老师<input type="text" value="<%=teachers[i] %>" style="width:100px">
选课人数<input type="text" value="<%=numbers[i] %>" style="width:100px"><br/>
<% n=i;} %>
<%//if(i==classes.length-1||classes[i+1]==null){ %>
<input type="hidden" name="number" value="<%=n%>">
<input type="submit" value="宣科">
</form>
<br><br><br><br><br><br>
<%if(!realname.equals("")){ %>
<%=realname %>已选的科目为:<br>
<% }
for(int i=0;i<=4;i++){
Name="cancel"+i;
if(request.getParameter(Name)!=null)
{
//out.print(i);
str=new String(request.getParameter("cancel"+i).getBytes("ISO-8859-1"),"UTF-8").trim();
flag=cancel.cancelCourse(userName, str);
}
}
%>
<%
int n1=0;
String[] course=new String[5];
course=selected.selecedtResult(userName);
for(int i=0;i<5;i++){
if(course[i]==null)
out.print("");
else{
%>
<form action="" method="post" name="game">
<input type="checkbox" value="<%=course[i]%>" name="cancel<%=i %>" /><%=course[i]%><br>
<%
n1=i;}}
%>
<input type="hidden" name="number1" value="<%=n1%>">
<input type="submit" value="取消" name="cancel">
</form>
</body>
</html>
该界面调用了allcourse方法和selected方法,这里也直接给出代码:
package h2;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
public class allcourse {
public static String[] allclasses() {
String classes[]=new String[10];
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
//String course
int i=0;
try{
String sql="SELECT COURSENAME FROM LIXIAOLI.COURSE WHERE NUMBER<5";
con=connection.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery(s