📄 course_info.jsp
字号:
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*" errorPage="" %>
<html >
<head>
<title>无标题文档</title>
</head>
<body>
<%
String id = request.getParameter("course_id");
//Srting course_i = (Srting)session.getAttribute("course_id");
//out.print(id);
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();
// String course_i = "1";
rs=sql.executeQuery("SELECT * FROM course where course_id =" + id);
//out.print("<form>");
out.print("<Table Border>");
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>");
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>");
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -