📄 choice.jsp
字号:
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*" errorPage="" %>
<html >
<head>
<title>无标题文档</title>
</head>
<body background="jpg/5.jpg">
<%
String name = (String)session.getAttribute("student_id");
//out.println(session.getAttribute("student_n"));
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
try{
con=DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM course");
out.print("<hr><br><form>");
out.print("<Table Border align=center>");
out.print("<tr>");
out.print("<TH width=100>"+"选课");
out.print("<TH width=100>"+"课程号");
out.print("<TH width=100>"+"课程名字");
out.print("<TH width=100>"+"学分");
out.print("<TH width=100>"+"学时");
out.print("<TH width=100>"+"教师");
out.print("<TH width=100>"+"开课学期");
out.print("<TH width=100>"+"使用专业");
out.print("<TH width=100>"+"最大选课人数");
out.print("</tr>");
while(rs.next()){
out.print("<TR>");
String temp = rs.getString(1);
// <td><a href = "course_info.jsp?id=1"> 22</a></td>
out.print("<td><a href = \"xuanke.jsp?course_id=" + temp +"\"> 选课</a></td>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("<TD>"+rs.getString(6)+"</TD>");
out.print("<TD>"+rs.getString(7)+"</TD>");
out.print("<TD>"+rs.getString(8)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
out.print("</form><br>");
out.print("<hr>");
out.print("<p><br>");
//out.print("已选");
rs=sql.executeQuery("SELECT * FROM course where course_id in(select course_id from choice_course where student_id =" +name + ")");
out.print("<Table Border>");
out.print("<tr><td colspan=9 align= 'center'> 已选 </td></tr>");
out.print("<tr>");
out.print("<TH width=100>"+"选课");
out.print("<TH width=100>"+"课程号");
out.print("<TH width=100>"+"课程名字");
out.print("<TH width=100>"+"学分");
out.print("<TH width=100>"+"学时");
out.print("<TH width=100>"+"教师");
out.print("<TH width=100>"+"开课学期");
out.print("<TH width=100>"+"使用专业");
out.print("<TH width=100>"+"最大选课人数");
out.print("</tr>");
while(rs.next()){
out.print("<TR>");
String temp = rs.getString(1);
out.print("<td><a href = \"tuixuan.jsp?course_id=" + temp +"\">退选</a></td>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("<TD>"+rs.getString(6)+"</TD>");
out.print("<TD>"+rs.getString(7)+"</TD>");
out.print("<TD>"+rs.getString(8)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -