81,122
社区成员




<%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page language="java" import="com.teacher"%>
<%@ page contentType="text/html;charset=utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type="text/css">
table {
border: 2px #CCCCCC solid;
width: 360px;
}
td, th {
height: 30px;
border: #CCCCCC 1px solid;
}
</stle>
</head>
<body>
<%
String driveName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
Class.forName(driveName);
String url = "jdbc:sqlserver://localhost:1433;databaseName=datalearn";
Connection con = DriverManager.getConnection(url, "sa",
"8260147");
Statement statement = con.createStatement();
List<teacher> list = new ArrayList<teacher>();
ResultSet rs = statement.executeQuery("select * from teacher");
while (rs.next()) {
teacher te = new teacher();
te.setID(rs.getString("教师号"));
te.setName(rs.getString("姓名"));
list.add(te);
}
request.getSession().setAttribute("list", list);
%>
<br>
<br>
<table align="center">
<tr>
<th>
学号
</th>
<th>
姓名
</th>
<th>
<c:out value="专业"/>
</th>
<th>
<c:out value="班级"/>
</th>
<th>
操作
</th>
</tr>
<c:forEach items="${list}" var="teacher" >
<tr>
<td>
${teacher.ID}
</td>
<td>
${teacher.ID}
</td>
<td>
${teacher.ID}
</td>
<td>
${teacher.ID}
</td>
<td>
${teacher.ID}
</td>
</tr>
</c:forEach>
</table>
<div align="center">
</div>
<%
rs.close();
statement.close();
con.close();
%>
</body>
</html>