WebRoot/query/list_costinfo.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" />

		<script type="text/javascript" src="<%=path%>/calendar/WdatePicker.js">
</script>

		<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 doctor = DataFormat.convert(request.getParameter("doctor"));
			String startdate = request.getParameter("sksjs") == null ? "" : request.getParameter("sksjs");
			String enddate = request.getParameter("sksje") == null ? "" : request.getParameter("sksje");

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