WebRoot/cost/list_cost.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=GBK"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path;
	String applicationPath = basePath + "/" + "application";
%>
<%@ page import="java.sql.*"%>
<%@ page language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="com.hospital.*"%>
<jsp:useBean id="a" scope="page" class="com.hospital.Dbcoon" />
<html>
	<head>
		<style type="TEXT/CSS">
A:LINK {
	COLOR: blue;
	FONT-SIZE: 12PT;
	TEXT-DECORATION: NONE
}

A:VISITED {
	COLOR: blue;
	FONT-SIZE: 12PT;
	TEXT-DECORATION: NONE
}

A:HOVER {
	COLOR: red;
	FONT-SIZE: 12PT;
	TEXT-DECORATION: UNDERLINE
}
</STYLE>

		<link rel="stylesheet" type="text/css" media="all"
			href="<%=path%>/images/css1/ioa.css" />

		<title>病人信息列表</title>
	</head>
	<body bgcolor="#ffffff">
		<br>

		<%
			int PageSize = 6;
			int Page = 1;
			int totalPage = 1;
			int totalrecord = 0;

			String sql = null;
			ResultSet rs = null;
			String brxm = DataFormat.convert(request.getParameter("brxm"));

			//算出总行数
			if(brxm != null) {
				sql = "SELECT count(*) as recordcount FROM cost where name like '%" + brxm.trim() + "%'";
			} else {
				sql = "SELECT count(*) as recordcount FROM cost";
			}

			rs = a.executeQuery(sql);