📄 datt.jsp

📁 help desk for hospitals/health care systems

💻 JSP

字号:

<%@page import="java.sql.*;"%>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection conn =DriverManager.getConnection("jdbc:odbc:tis","tis","tis"); 
		Statement st=conn.createStatement();
		double ENo=Double.parseDouble(request.getParameter("ENo"));
		ResultSet rs=st.executeQuery("select * from alist where eno=ENo");
		
		%>
		<html>
		<head>
		<title>
		Attendance Details
		</title>
		</head>
		<body bgcolor="#CCFFFF">
		<h1><center><u>Attendance Details<u></center></h1>
		<table align="center" width="100%" border="6">
		<tr>
		<td align="center">Employee  Number</td>
<td align="center">Employee Name</td>
<td align="center">Program Number</td>
<td align="center">ADate</td>
<td align="center">Status</td>
</tr>
<% while(rs.next())
{
	%>
	<tr>
	<td align="center"><%=rs.getInt(1)%></td>
		<td align="center"><%=rs.getString(2)%></td>
		<td align="center"><%=rs.getInt(3)%></td>
		<td align="center"><%=rs.getString(4)%></td>
				<td align="center"><%=rs.getString(5)%></td>
										</tr>
										<%
}
	%>
	</table>
	</body>
	</html>
	<%conn.close();%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -