WebRoot/paike/paikem2.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<jsp:useBean id="mm" scope="session" class="stu.paike"/>
<html>
<head>
<title>管理员页面</title>
</head>
<body>


 <%  
 String time=mm.gettime();%>
 <h3><%=time%>的空闲教室如下：</h3><hr>
 <div align=center >
 <table style="font-size:20px; border=1;text-align:center;width:500">
 <tr><th>教室编号</th><th>教室大小</th><th>地址</th><th>是否为多媒体</th></tr>
  <% 
    String user="root";
	String password="root";
	String url="jdbc:mysql://localhost:3306/JSFP";
	
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn=DriverManager.getConnection(url,user,password);
	
    Statement state=conn.createStatement();
	String sql="select * from emptyclassroom ";
	ResultSet rs=null;
	rs=state.executeQuery(sql);
	while(rs.next()){ 
	String id=rs.getString("id");
	 String size=rs.getString("size");
	 String location=rs.getString("location");
	 String have=rs.getString("have");
	%>
<tr><td><%=id %></td><td>&nbsp;&nbsp;<%=size %></td><td><%=location %></td><td><%=have %></td></tr>		
<%  
}

	
 conn.close();
 rs.close();
 state.close();
 %>
 </table>
  <h2> <a href=paikem22.jsp>完成</a></h2>
  </div>



</body>
</html>