📄 showitem.jsp

📁 机械工业出版社的《jsp2.0动态网站开发实例指南》的源代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="law.user" %>
<%@ page import="java.sql.*"%>
<html>
<head><title>showitem</title></head>
<body>
<center>
<jsp:useBean id="log" class="law.user" scope="session"/>
<%@ include file="head.txt"%>
<%
	if(log.getLogin().equals("true")){
		Connection con;
		Statement sql;
		ResultSet rs;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		      	con=DriverManager.getConnection("jdbc:odbc:law","","");
		     	sql=con.createStatement();
		      	String condition="SELECT * FROM data order by num";
		      	rs=sql.executeQuery(condition);
		      	%>
		      	<table border=1 width=800>
		      	<tr>
		      		<td width=100 align=center>档案序号</td>
		      		<td width=300 align=center>建立时间</td>
		      		<td width=200 align=center>建立用户</td>
		      		<td width=100 align=center>查阅</td>
		      		<td width=100 align=center>删除</td>	
		      	</tr>
		      	<%
      			while(rs.next()){
      				long num=rs.getLong("num");
      				%>
      				<tr>
		      		<td width=100 align=center><%=num%></td>
		      		<td width=300 align=center><%=rs.getString("time")%></td>
		      		<td width=200 align=center><%=rs.getString("id")%></td>
		      		<td width=100 align=center><a href="item.jsp?num=<%=num%>">查阅</a></td>
		      		<td width=100 align=center><a href="delete.jsp?num=<%=num%>">删除</a></td>	
		      		</tr>
      				<%
        		}
        		%>
        		</table>
        		<%
		      	con.close();
	    	}catch(SQLException e){
	    		out.println(e);
	    	}catch(ClassNotFoundException e){
	    		out.println(e);
		}
	}
	else{
		out.print("<font color=#FF0000>您还没有登录。<br><a href='index.htm'>首页 </a>");
	}

%>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -