📄 hoice.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 course_id1 = request.getParameter("course_id1");
%>
<br>
<form method="post" action="hoice.jsp">
<a> 请输入课程号：</a>
<input type ="text" name = "course_id1">
<input type = "submit" value = "确定">
</form>
<%
Connection con;
Statement sql;
ResultSet rs;
if(course_id1!=null)
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
sql=con.createStatement();
rs=sql.executeQuery("select a.student_id,a.student_name,c.course_name,c.course_id,result from student a, choice_course b, course c where a.student_id = b.student_id and c.course_id = b.course_id and c.course_id ='" +course_id1+"'");
// rs = sql.executeQuery("select * from student");
out.print("<form align =center method=\"post\" action=\"chengji.jsp?course_id2=" + course_id1+"\" >");
out.print("<Table Border align=center>");
out.print("<tr>");
out.print("<td>学生学号");
out.print("<td>学生姓名");
out.print("<td>课程名字");
out.print("<td>成绩");
out.print("</tr>");
int i=1;
while(rs.next()){
out.print("<TR name=\"1\" values =\"3\">");
out.print("<TD>"+rs.getString(1)+"</TD>");
//out.print("<TD name="+i+" value = "+rs.getString(1)+">"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD><input type = \"text\" name = "+rs.getString(1)+" value ="+rs.getString(5)+"></TD>");
// out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("</TR>");
i++;
}
out.print("</Table>");
out.print("<br> <input align=center type=submit value=确定>");
out.print("</form>");
}
else
{
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("</tr>");
}
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -