📄 may.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-image: url(images/0866.jpg);
}
-->
</style></head>
<%
if(request.getParameter("Submit")!=null)
{
String name=request.getParameter("Submit");
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
String semester="2007年秋";
if(name.equals("添加"))
{
byte []b;
String C_ID=request.getParameter("C_ID");
String C_Name=request.getParameter("C_Name");
b=C_Name.getBytes("ISO-8859-1");
C_Name=new String(b);
String score=request.getParameter("score");
String period=request.getParameter("period");
String teacher=request.getParameter("teacher");
b=teacher.getBytes("ISO-8859-1");
teacher=new String(b);
String specialty=request.getParameter("specialty");
b=specialty.getBytes("ISO-8859-1");
specialty=new String(b);
String Maxpeople=request.getParameter("Maxpeople");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:system");
Statement smt = con.createStatement();
String sql="select * from Course where C_ID="+C_ID+" and C_Name='"+C_Name+"' and semester='2007年秋' and teacher='"+teacher+"'";
ResultSet se=smt.executeQuery(sql);
if(!se.next())
{
sql="insert into Course values("+C_ID+",'"+C_Name+"',"+score+","+period+",'"+teacher+"','"+semester+"','"+specialty+"',"+Maxpeople+")";
smt.executeUpdate(sql);
int i=smt.getUpdateCount();
if(i>0)
out.println("<script>alert('添加成功');</script>");
else
out.println("<script>alert('添加失败');</script>");
}
else
out.println("<script>alert('不能添加课程');</script>");
con.close();
}
}
%>
<body>
<form action="may.jsp" method="post">
<table width="766" border="1">
<tr>
<td width="142">课程号</td>
<td width="143">课程名</td>
<td width="96">学分</td>
<td width="47">学时</td>
<td width="79">任课老师</td>
<td width="144">适合专业</td>
<td width="69">最多选课人数</td>
</tr>
<tr>
<td><input name="C_ID" type="text" size="15" /></td>
<td><input name="C_Name" type="text" size="15" /></td>
<td><input name="score" type="text" size="10" /></td>
<td><input name="period" type="text" size="10" /></td>
<td><input name="teacher" type="text" size="15" /></td>
<td><input name="specialty" type="text" size="20" /></td>
<td><input name="Maxpeople" type="text" size="20" /></td>
</tr>
<tr>
<td colspan="8" align="center"><input type="submit" name="Submit" value="添加" /></td>
</tr>
</table>
</form>
<form action="modify.jsp" method="post">
<p> </p>
<p> </p>
<table>
<tr>
<td></td>
<td width="142">课程号</td>
<td width="143">课程名</td>
<td width="96">学分</td>
<td width="47">学时</td>
<td width="79">任课老师</td>
<td width="144">适合专业</td>
<td width="69">最多选课人数</td>
</tr>
<jsp:useBean id="showcourse" class="student.ReadCourse" scope="request"/>
<jsp:setProperty name="showcourse" property="semester" value="2007年秋" />
<%
ResultSet result=showcourse.getResult();
int CID;
while(result.next())
{
CID=result.getInt(1);
out.println("<tr><td><input name=\"CID\" type=\"radio\" value=\""+CID+"\" /></td><td>"+CID+"</td><td>"+result.getString(2)+"</td><td>"+result.getFloat(3)+"</td><td>"+result.getInt(4)+"</td><td>"+result.getString(5)+"</td><td>"+result.getString(7)+"</td><td>"+result.getString(8)+"</td></tr>");
}
showcourse.Close();
out.println("<tr><td></td><td></td><td></td><td><input type=\"submit\" name=\"Submit\" value=\"删除\" /></td><td></td><td><input type=\"submit\" name=\"Submit\" value=\"修改\" /></td><td></td><td></td></tr>");
%>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -