📄 remove_student.jsp
字号:
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*" errorPage="" %>
<html >
<head>
<title>无标题文档</title>
</head>
<body>
<%
String course_i = request.getParameter("course_id");
String student_i = request.getParameter("student_id");
String term = request.getParameter("term1");
String ccourse = request.getParameter("ccourse");
Connection con;
Statement sql;
ResultSet rs;
try{
con=DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
sql=con.createStatement();
// out.print(course_i+"pppp");//
// sql.executeUpdate("delete from course where course_id ='" + course_i +"'");
sql.executeUpdate("delete from choice_course where course_id ='" + course_i +"' and student_id='" +student_i+"'");
///out.println(term);
//out.println(ccourse);
//String ss="xuanke_manage.jsp?gread=";
//ss = ss+ term;
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
<jsp:forward page ="xuanke_manage.jsp">
<jsp:param name="gread" value="<%=term%>"/>
<jsp:param name="ccourse" value="<%=ccourse%>"/>
</jsp:forward>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -