📄 dprog.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();
		ResultSet rs=st.executeQuery("select * from plist");
		%>
		<html>
		<head>
		<title>
		Programs List
		</title>
		</head>
		<body bgcolor="#CCFFFF">
		<h1><center><u>Program Details<u></center></h1>
		<table align="center" width="100%" border="6">
		<tr>
		<td align="center">Program  Number</td>
<td align="center">Program Name</td>
<td align="center">Trainer Name</td>
<td align="center">Prog Starting Date</td>
<td align="center">Prog  Ending Date</td>
<td align="center">Prog  Venue</td>
</tr>
<% while(rs.next())
{
	%>
	<tr>
	<td align="center"><%=rs.getInt(1)%></td>
		<td align="center"><%=rs.getString(2)%></td>
				<td align="center"><%=rs.getString(3)%></td>
						<td align="center"><%=rs.getString(4)%></td>
								<td align="center"><%=rs.getString(5)%></td>
										<td align="center"><%=rs.getString(6)%></td>
										</tr>
										<%
}
	%>
	</table>
	</body>
	</html>
	<%conn.close();%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -