📄 showemployeename.jsp
字号:
<%@ page language="java" import="java.util.*,com.buat.hr.share.DBConnection,java.sql.*" pageEncoding="GBK"%>
<%
Connection con=new DBConnection().getConnection();
PreparedStatement pst=con.prepareStatement("select * from employee");
ResultSet rs=pst.executeQuery();
rs.beforeFirst();
%>
<html>
<head>
</head>
<body background="../bg.jpg">
<table border="0" width=90% align="center">
<tr>
<td colspan="8" align="center"><font color="red">员工姓名</font></td>
</tr>
<% int i = 0;
int j = 1;
while(rs.next()){
i++;
if(i == j*8){
%>
<tr>
<%
j++;
}
%>
<th>
<a href="Add.jsp?name=<%=rs.getString("name")%>&employeeid=<%=rs.getString("employeeid") %>"><%=rs.getString("name") %></a>
</th>
<%
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -