WebRoot/admin/crouse-add.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@page import="java.util.HashMap"%>
<%@page import="java.util.Map"%>
<%@page import="java.util.List"%>
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
<title>管理员页面</title>
<link type="text/css" rel=stylesheet href=../css/main.css >
</head>

<body>
<br><br><br>
<% 
String user="root";
String password="root";
String url="jdbc:mysql://localhost:3306/JSFP";

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url,user,password);
Statement state=conn.createStatement();
String sqlClass="select * from class";
ResultSet rs=null;
rs=state.executeQuery(sqlClass);
Map<String,String> classMap = new HashMap<String,String>();
while(rs.next()){

		String classid=rs.getString("clid");
		String classname=rs.getString("classname");
		classMap.put(classid,classname);
}	
String sqlTeacher="select * from teacher";
rs=state.executeQuery(sqlTeacher);
Map<String,String> teacherMap = new HashMap<String,String>();
while(rs.next()){

		String id=rs.getString("id");
		String name=rs.getString("name");
		teacherMap.put(id,name);
}
state.close();
conn.close();
%>
 
<div align=center>
  <form action="crouse-add2.jsp" method="post">
<h2>输入新增课程信息</h2><hr>

<table >
<tr><td>课程编号：</td><td><input name="id" type="text"></td></tr>
 <tr><td>课程名称：</td><td><input name=name type=text></td></tr>
 <tr><td>班级编号：</td><td>
 	<select name="classid" id="classid" onchange="getClassName()">
 		<option>请选择</option>
 		<c:forEach items="<%=classMap %>" var="obj">
			<option value="${obj.key}" class="${obj.value }">${obj.key}</option>	
 		</c:forEach>
 	</select>
 </td></tr>
 <tr><td>班级名称：</td><td><input name=classname type=text id=classname readonly="readonly"></td></tr>