stu.mer位于MyStuMan文件夹下<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
<Connection session="conn_mysql_stu" database="stu" />
<Drawing gridVisible="false" snapOn="false" fastRouting="false" />
<Tables>
<Table name="admin">
<Drawing expanded="true" location="241,146" dimensions="167,87" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="int" size="16" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="classes">
<Drawing expanded="true" location="343,307" dimensions="173,125" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="tea_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="cour_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="room_id" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="cour_time" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="course">
<Drawing expanded="true" location="465,576" dimensions="161,127" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int" size="11" />
</Column>
<Column name="prepare" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="dep" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="enrol">
<Drawing expanded="true" location="468,43" dimensions="167,106" />
<Columns>
<Column name="class_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="stu_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="accept" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="score" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="student">
<Drawing expanded="true" location="583,306" dimensions="179,227" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="jiguan" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="department" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="sex" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int" size="11" />
</Column>
<Column name="tel" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="phone" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="email" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="teacher">
<Drawing expanded="true" location="241,579" dimensions="167,107" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="title" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
</Tables>
<Relationships>
<Relationship name="FK_Reference_4">
<Details primary_table="teacher" foreign_table="classes">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="tea_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="classes_ibfk_1">
<Details primary_table="course" foreign_table="classes">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="cour_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="enrol_ibfk_1">
<Details primary_table="classes" foreign_table="enrol">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="class_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="enrol_ibfk_2">
<Details primary_table="student" foreign_table="enrol">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="stu_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
</Relationships>
</ERDiagram>
<ERDiagram version="1.1">
<Connection session="conn_mysql_stu" database="stu" />
<Drawing gridVisible="false" snapOn="false" fastRouting="false" />
<Tables>
<Table name="admin">
<Drawing expanded="true" location="241,146" dimensions="167,87" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="int" size="16" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="classes">
<Drawing expanded="true" location="343,307" dimensions="173,125" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="tea_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="cour_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="room_id" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="cour_time" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="course">
<Drawing expanded="true" location="465,576" dimensions="161,127" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int" size="11" />
</Column>
<Column name="prepare" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="dep" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="enrol">
<Drawing expanded="true" location="468,43" dimensions="167,106" />
<Columns>
<Column name="class_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="stu_id" primary_key="false" foreign_key="true" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="accept" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="score" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="student">
<Drawing expanded="true" location="583,306" dimensions="179,227" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="jiguan" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="department" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="sex" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int" size="11" />
</Column>
<Column name="tel" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="phone" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="email" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
<Table name="teacher">
<Drawing expanded="true" location="241,579" dimensions="167,107" />
<Columns>
<Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="varchar" size="32" />
</Column>
<Column name="name" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="password" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
<Column name="title" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="32" />
</Column>
</Columns>
</Table>
</Tables>
<Relationships>
<Relationship name="FK_Reference_4">
<Details primary_table="teacher" foreign_table="classes">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="tea_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="classes_ibfk_1">
<Details primary_table="course" foreign_table="classes">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="cour_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="enrol_ibfk_1">
<Details primary_table="classes" foreign_table="enrol">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="class_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
<Relationship name="enrol_ibfk_2">
<Details primary_table="student" foreign_table="enrol">
<PrimaryKeys>
<ColumnName name="id" />
</PrimaryKeys>
<ForeignKeys>
<ColumnName name="stu_id" />
</ForeignKeys>
</Details>
<Drawing routingType="0" />
</Relationship>
</Relationships>
</ERDiagram>
<html>
<head>
<title>添加班级</title>
<style type="text/css"></style>
</head>
<bod>
<p>
<%
//String admin_id = (String) session.getAttribute("id");
// if (admin_id == null) {
// response.sendRedirect("login.jsp");
// }
// String name = "";
// String id = "";
%>
</p>
<p align="center">
新增班级
</p>
<form method="post" action="/MyStuMan/addClasses.do">
<input type="hidden" name="action" value="new">
<table width="38%" border="1" align="center" class="Edit">
<tr>
<td width="29%">
班级号
</td>
<td width="71%">
<input name="id" type="text" id="id2">
</td>
</tr>
<tr>
<td>
教师
</td>
<td>
<select name="tea_id" size="1" id="tea_id">
<option value="张三">张三 </option>
<option value="李四">李四</option>
<option value="王五">王五</option>
</select>
</td>
</tr>
<tr>
<td>
课程
</td>
<td>
<select name="cour_id" id="cour_id">
<option value="1">大学语文</option>
<option value="1">C</option>
<option value="1">C++</option>
</select>
</td>
</tr>
<tr>
<td>
教室ID
</td>
<td>
<select name="room_id" size="1" id="room_id">
<option>
10-1
</option>
<option>
10-2
</option>
<option>
10-3
</option>
<option>
10-4
</option>
<option>
10-5
</option>
<option>
20-1
</option>
<option>
20-2
</option>
<option>
20-3
</option>
<option>
20-4
</option>
<option>
20-5
</option>
<option>
30-1
</option>
<option>
30-2
</option>
<option>
30-3
</option>
<option>
30-4
</option>
<option>
30-5
</option>
<option>
30-6
</option>
</select>
</td>
</tr>
<tr>
<td>
上课时间
</td>
<td>
<select name="cour_time" size="1" id="cour_time">
<option value="Mon_1">
星期一/一节
</option>
<option value="Mon_2">
星期一/二节
</option>
<option value="Mon_3">
星期一/三节
</option>
<option value="Tues_1">
星期二/一节
</option>
<option value="Tues_2">
星期二/二节
</option>
<option value="Tues_3">
星期二/三节
</option>
<option value="Wed_1">
星期三/一节
</option>
<option value="Wed_2">
星期三/二节
</option>
<option value="Wed_3">
星期三/三节
</option>
<option value="Thurs_1">
星期四/一节
</option>
<option value="Thurs_2">
星期四/二节
</option>
<option value="Thurs_3">
星期四/三节
</option>
<option value="Fri_1">
星期五/一节
</option>
<option value="Fri_2">
星期五/二节
</option>
<option value="Fri_3">
星期五/三节
</option>
</select>
</td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit" value="提交">
</p>
<p>
</p>
</form>
<a href="getClass.jsp"><<Back </a>
</body>
</html>
<%@ page import="java.sql.*,com.stuman.service.*"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles"%><html>
<head>
<title>增加课程</title> </head>
<body>
<p>
<%// String admin_id = (String) session.getAttribute("id");
// if (admin_id == null) {
// response.sendRedirect("login.jsp");
// }
// String cour_name = "", cour_id = ""; %>
</p>
<p align="center">
新增课程
</p>
<form method="post" action="/MyStuMan/addCourse.do">
<div align="center"></div>
<table width="37%" border="1" align="center">
<tr>
<td>
课程号
</td>
<td>
<html:text property="id" value="" />
</td>
</tr>
<tr>
<td width="37%">
课程名
</td>
<td width="63%">
<html:text property="name" value="" />
</td>
</tr>
<tr>
<td>
学分
</td>
<td>
<html:select property="" size="3" value="1">
<html:option key="a" value="1">1</html:option>
<html:option key="b" value="2">2</html:option>
<html:option key="c" value="3">3</html:option>
<html:option key="d" value="4">4</html:option>
</html:select>
</td>
</tr>
<tr>
<td>
系别
</td>
<td>
<html:select property="department" size="3" value="计算机">
<html:option key="a" value="计算机">计算机</html:option>
<html:option key="b" value="机械系">机械系</html:option>
<html:option key="c" value="电子系">电子系</html:option>
<html:option key="d" value="数学系">数学系</html:option>
</html:select>
</td>
</tr>
<tr>
<td>
预修课
</td>
<td> <%ListCourseIdAndName courlist = new ListCourseIdAndName();
courlist.list(request, out);
%> </td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit2" value="确定">
</p>
<p>
</p>
</form>
<p>
<a href="getcourse.jsp"><<Back </a>
</p>
</body>
</html>