course_info.jsp

来自「选课系统能够实现选课功能」· JSP 代码 · 共 66 行

JSP
66
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?