modifyfinancialrecord.jsp

Java项目开发实用案例之公司办公信息管理系统 本系统为公司办公信息管理系统EIMS

<%@ page contentType="text/html; charset=gb2312" language="java"  %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.text.*"%>
<%@ page import="cn.edu.buaa.nlsde.db.*"%>

<%request.setCharacterEncoding("GB2312");
String TheMessage = "";
String sql1 = "";
String sql2 = "";
String sql3 = "";
String sql4 = "";
String TheAddDate = "";
int QueryLabel = 0;
String TheName = "";
String TheDepartment = "";
String TheProjectName = "";
int TheFundTypeA = 0;
int TheFundTypeB = 0;
int TheFundTypeC = 0;
int TheFundTypeD = 0;
String TheSummary = "";
String TheRemark = "";
String TheModifyDate = "";
int TheSum = 0;
String temp = "";
String SqlString = "";
Calendar cal = Calendar.getInstance();
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
String Date = format.format(cal.getTime());
format = new SimpleDateFormat("yyyy");
String Year = format.format(cal.getTime());
format = new SimpleDateFormat("MM");
String Month = format.format(cal.getTime());
format = new SimpleDateFormat("dd");
String Day = format.format(cal.getTime());
ResultSet RSRecordResult = null;
ResultSet RSThisRecord = null;
Hashtable HTThisRecord = new Hashtable();
//判断用户是否登录
if (session.getAttribute("ID") == null) {
	response.sendRedirect("../login.jsp");
}
//判断用户是否具有财务管理员身份
if (session.getAttribute("IsFinancialManager").equals("False")) {
	response.sendRedirect("finance.jsp");
}
//连接系统数据库
//Connection conn = (new DBConnect()).getODBCConn("EIMS");
Connection conn = (new DBConnect()).getConnPoolConn("eims");
Statement stmt = conn.createStatement();
boolean Warning = false;
//查询某个财务记录
if (request.getParameter("Query") != null) {
	//获得用户的查询条件
	if (request.getParameter("QueryCheck1") != null
		&& (request.getParameter("FinancialRecordID") != null)) {
		sql1 = "and ID=" + request.getParameter("FinancialRecordID");
	}
	else {
		sql1 = " ";
	}
	if (request.getParameter("QueryCheck2") != null
		&& (request.getParameter("FinancialProjectName") != null)) {
		sql2 =
			" and ProjectName='"
				+ request.getParameter("FinancialProjectName")
				+ "'";
	}
	else {
		sql2 = " ";
	}
	if (request.getParameter("QueryCheck3") != null) {
		sql3 =
			" and Name='" + request.getParameter("SelectName") + "'";
	}
	else {
		sql3 = " ";
	}
	if (request.getParameter("QueryCheck4") != null) {
		TheAddDate =
			request.getParameter("AddYear")
				+ "-"
				+ request.getParameter("AddMonth")
				+ "-"
				+ request.getParameter("AddDay");
		sql4 = " and AddDate='" + TheAddDate + "' ";
	}
	else {
		sql4 = " ";
	}
	SqlString =
		"select * from FinancialRecord where AccountName='"
			+ session.getAttribute("Name")
			+ "' "
			+ sql1
			+ sql2
			+ sql3
			+ sql4
			+ " order by Name";
	System.out.println(SqlString);
	RSRecordResult = stmt.executeQuery(SqlString);
	TheMessage = "您查询的财务记录如下";
	QueryLabel = 2;
}
//用户选定了查询出来的某个财务记录
else if (request.getParameter("SelectRecord") != null) {
	TheMessage = "请在下面修改此条财务记录";
	RSThisRecord =
		stmt.executeQuery(
			"select * from FinancialRecord where ID="
				+ request.getParameter("RadioFinancialRecord"));
	QueryLabel = 3;
	while (RSThisRecord.next()) {
		HTThisRecord.put("ID", new Integer(RSThisRecord.getInt(1)));
		HTThisRecord.put("Name", RSThisRecord.getString(2));
		HTThisRecord.put("ProjectName", RSThisRecord.getString(4));
		HTThisRecord.put(
			"FundTypeA",
			new Integer(RSThisRecord.getInt(5)));
		HTThisRecord.put(
			"FundTypeB",
			new Integer(RSThisRecord.getInt(6)));
		HTThisRecord.put(
			"FundTypeC",
			new Integer(RSThisRecord.getInt(7)));
		HTThisRecord.put(
			"FundTypeD",
			new Integer(RSThisRecord.getInt(8)));
		HTThisRecord.put("Summary", RSThisRecord.getString(10));
		HTThisRecord.put("Remark", RSThisRecord.getString(11));
		HTThisRecord.put(
			"AddDate",
			RSThisRecord.getString(13).substring(0, 10));
	}
}
//用户对选定的财务记录进行了更新
else if (request.getParameter("UpdateRecord") != null) {
	//校验用户的输入
	try {
		NumberFormat numberformat = NumberFormat.getInstance();
		numberformat.parse(request.getParameter("UpdateFundTypeA"));
		numberformat.parse(request.getParameter("UpdateFundTypeB"));
		numberformat.parse(request.getParameter("UpdateFundTypeC"));
		numberformat.parse(request.getParameter("UpdateFundTypeD"));
		ResultSet RSLinkedDepartment =
			stmt.executeQuery(
				"select Department from PSLogins where Name='"
					+ request.getParameter("UpdateName")
					+ "'");
		TheName = request.getParameter("UpdateName");
		while (RSLinkedDepartment.next()) {
			TheDepartment =
				RSLinkedDepartment.getString("Department");
		}
		TheProjectName = request.getParameter("UpdateProjectName");
		TheFundTypeA =
			new Integer(request.getParameter("UpdateFundTypeA"))
				.intValue();
		TheFundTypeB =
			new Integer(request.getParameter("UpdateFundTypeB"))
				.intValue();
		TheFundTypeC =
			new Integer(request.getParameter("UpdateFundTypeC"))
				.intValue();
		TheFundTypeD =
			new Integer(request.getParameter("UpdateFundTypeD"))
				.intValue();
		TheSummary = request.getParameter("UpdateSummary");
		TheRemark = request.getParameter("UpdateRemark");
		TheModifyDate = Date;
		TheSum =
			TheFundTypeA + TheFundTypeB + TheFundTypeC + TheFundTypeD;
		//修改此条财务记录
		stmt.executeUpdate(
			"update FinancialRecord set Name='"
				+ TheName
				+ "',Department='"
				+ TheDepartment
				+ "',FundTypeA="
				+ TheFundTypeA
				+ ",FundTypeB="
				+ TheFundTypeB
				+ ",FundTypeC="
				+ TheFundTypeC
				+ ",FundTypeD="
				+ TheFundTypeD
				+ ",Sum="
				+ TheSum
				+ ",Summary='"
				+ TheSummary
				+ "',Remark='"
				+ TheRemark
				+ "',ModifyDate='"
				+ TheModifyDate
				+ "',ProjectName='"
				+ TheProjectName
				+ "' Where ID="
				+ request.getParameter("UpdateID"));
		QueryLabel = 3;
		TheMessage = "记录已经修改成功";
	}
	catch (Exception ex) {
		TheMessage = "记录中的款项字段中出现了非数字内容，无法修改此记录，请重填记录";
		Warning = true;
		QueryLabel = 3;
	}
	RSThisRecord =
		stmt.executeQuery(
			"select * from FinancialRecord where ID="
				+ request.getParameter("UpdateID"));
	while (RSThisRecord.next()) {
		HTThisRecord.put("ID", new Integer(RSThisRecord.getInt(1)));
		HTThisRecord.put("Name", RSThisRecord.getString(2));
		HTThisRecord.put("ProjectName", RSThisRecord.getString(4));
		HTThisRecord.put(
			"FundTypeA",
			new Integer(RSThisRecord.getInt(5)));
		HTThisRecord.put(
			"FundTypeB",
			new Integer(RSThisRecord.getInt(6)));
		HTThisRecord.put(
			"FundTypeC",
			new Integer(RSThisRecord.getInt(7)));
		HTThisRecord.put(
			"FundTypeD",
			new Integer(RSThisRecord.getInt(8)));
		HTThisRecord.put("Summary", RSThisRecord.getString(10));
		HTThisRecord.put("Remark", RSThisRecord.getString(11));
		HTThisRecord.put(
			"AddDate",
			RSThisRecord.getString(13).substring(0, 10));
	}
}
else {
	TheMessage = "请在下面填写您要修改的财务记录的查询条件";
	QueryLabel = 1;
}
%>



<HTML>
<HEAD>
<TITLE>公司财务信息管理系统</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>

<BODY BGCOLOR="">

<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
	align=center>
	<tr bgcolor=white>
		<td valign=middle><img src="../image/jsplogo.jpg" width=796 height=100></td>