📄 addfinancialrecord.jsp

📁 JSP网络办公自动化系统开发完整的很好好的
💻 JSP
字号:
<%@ 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 TheName = "";
String TheDepartment = "";
String TheProjectName = "";
int TheFundTypeA = 0;
int TheFundTypeB = 0;
int TheFundTypeC = 0;
int TheFundTypeD = 0;
String TheSummary = "";
String TheRemark = "";
String TheAccountName = "";
String TheDate = "";
int TheSum = 0;
boolean warning = false;//判断Themessage字体颜色
String temp = "";
//NumberFormat 属于格式数值格式的抽象基类
NumberFormat numberformat = NumberFormat.getInstance();
//判断用户是否登录
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("AddFinancialProject") != null) {
	response.sendRedirect("addfinancialproject.jsp");
}
//添加财务记录信息不能为空
if (request.getParameter("AddRecord") != null) {
	//从列表里选择财务记录经手人
	TheName = request.getParameter("SelectFinancialRecordName");
	//从列表里选择财务记录所属项目
	TheProjectName = request.getParameter("SelectFinancialProject");
	//对用户输入的财务记录信息进行校验
	try {
		numberformat.parse(request.getParameter("FundTypeA"));
		numberformat.parse(request.getParameter("FundTypeB"));
		numberformat.parse(request.getParameter("FundTypeC"));
		numberformat.parse(request.getParameter("FundTypeD"));
		TheFundTypeA =
			new Integer(request.getParameter("FundTypeA")).intValue();
		TheFundTypeB =
			new Integer(request.getParameter("FundTypeB")).intValue();
		TheFundTypeC =
			new Integer(request.getParameter("FundTypeC")).intValue();
		TheFundTypeD =
			new Integer(request.getParameter("FundTypeD")).intValue();
		TheSummary = request.getParameter("Summary");
		//备注
		TheRemark = request.getParameter("Remark");
		TheAccountName = (String)session.getAttribute("Name");
		Calendar cal = Calendar.getInstance();
		SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
		//获取当前时间
		TheDate = format.format(cal.getTime());
		TheSum =
			TheFundTypeA + TheFundTypeB + TheFundTypeC + TheFundTypeD;
		ResultSet RSDoExistName =
			stmt.executeQuery(
				"select * from PSLogins where Name='"
					+ TheName
					+ "'");
		while (RSDoExistName.next()) {
			TheDepartment = RSDoExistName.getString("Department");
		}
		//添加新财务记录到数据库
		stmt.executeUpdate(
			" insert into FinancialRecord (Name, Department, "
				+ "ProjectName,FundTypeA, FundTypeB,FundTypeC, "
				+ "FundTypeD, Sum, Summary, Remark, AddDate, AccountName)"
				+ " values ('"
				+ TheName
				+ "','"
				+ TheDepartment
				+ "','"
				+ TheProjectName
				+ "','"
				+ TheFundTypeA
				+ "','"
				+ TheFundTypeB
				+ "','"
				+ TheFundTypeC
				+ "','"
				+ TheFundTypeD
				+ "','"
				+ TheSum
				+ "','"
				+ TheSummary
				+ "','"
				+ TheRemark
				+ "','"
				+ TheDate
				+ "','"
				+ TheAccountName
				+ "')");
		TheMessage = "记录已提交成功，请填写新记录";
		Warning = false;
	}
	catch (ParseException ex) {
		TheMessage = "记录中的款项字段中出现了非数字内容，无法添加此记录，请重填";
		Warning = true;
	}
}
else {
	TheMessage = "请在下面填写新的财务记录";
	Warning = false;
}
%>

<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>
	</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
	cellpadding="0" cellspacing="0">
	<tr>
		<td height="13"><img src=".././image/banner2.jpg" width="800"
			height="12"></td>
	</tr>
</table>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
	align=center>
	<tr>
		<td colspan=3>
		<div align="center"><font color=white>
		公司办公信息管理系统->公司财务信息管理系统->添加财务记录&nbsp[当前用户- <%=session.getAttribute("Name")%>
		] </font></div>
		</td>
	</tr>
	<tr bgcolor=white>
		<td><a href="../html/home.jsp"><font color="#104DAD">返回系统主页</font></a></td>
		<td align=center>

		<%if (Warning == false) 
		{%> <font color="#104DAD"><%=TheMessage%></FONT>
		<%}
else {%>
 <font color=Red><%=TheMessage%></font> <%}%></td>
		<td align=right><a href="finance.jsp"><font color="#104DAD">返回上一级网页</font></a></td>
	</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
	cellpadding="0" cellspacing="0">
	<tr>
		<td height="10" colspan="4" valign="top" bgcolor="#FFFFFF">
		<table width="100%" border="0" height="13" cellspacing="0"
			cellpadding="0" mm_noconvert="TRUE">
			<tr>
				<td height="13"><img src=".././image/banner2.jpg" width="800"
					height="12"></td>
			</tr>
		</table>
		</td>
	</tr>
</table>

<table width="800" border="0" bordercolor="#164DA8" align="center"
	cellpadding="3" cellspacing="0">
	<tr>
		<td>

		<FORM ACTION="addfinancialrecord.jsp" METHOD=POST><br>

		<TABLE CELLPADDING=1 CELLSPACING=2 BORDER=1 bordercolor="#164DA8"
			WIDTH=800 align=center>
			<TR VALIGN="middle" ALIGN="center">
				
            <TD WIDTH=20% height="241" bgcolor=#B5C7EF><img src="../image/finance1.jpg"></td>
				<td>

				<table CELLPADDING=1 CELLSPACING=1 BORDER=1 align=center width=100%>
					<tr>
						<td width=25％><font color="#164DA8">此财务记录经手人姓名</font></td>
						<td><SELECT NAME="SelectFinancialRecordName">
							<%ResultSet RSPersons =
	stmt.executeQuery("select Name from PSLogins order by Name");
while (RSPersons.next()) {
	temp = RSPersons.getString("Name");%>
							<OPTION VALUE="<%=temp%>"><%=temp%></OPTION>
							<%}%>
						</SELECT></td>
					</tr>

					<tr>
						
                  <td height="26"><font color="#164DA8">项目名称</font></td>
						<td><SELECT NAME="SelectFinancialProject">
							<%ResultSet RSFinancialProject =
	stmt.executeQuery(
		"select FinancialProjectName from FinancialProject order by FinancialProjectName");
while (RSFinancialProject.next()) {
	//获取下拉菜单名称
	temp = RSFinancialProject.getString("FinancialProjectName");%>
							<OPTION VALUE="<%=temp%>"><%=temp%></OPTION>
							<%}%>
						</SELECT></td>
					</tr>


					<tr>
						<td><font color="#164DA8">款项名称</font></td>
						<td>

						<table width=100% border=1>
							<tr>
								<td width=18%><font color="#164DA8">款项A</font></td>
								<td width="82%"><INPUT TYPE="text" NAME="FundTypeA" VALUE="0"> 元</td>
							</tr>
							<tr>
								<td><font color="#164DA8">款项B</font></td>
								<td><INPUT TYPE="text" NAME="FundTypeB" VALUE="0"> 元</td>
							</tr>
							<tr>
								<td><font color="#164DA8">款项C</font></td>
								<td><INPUT TYPE="text" NAME="FundTypeC" VALUE="0"> 元</td>
							</tr>
							<tr>
								<td><font color="#164DA8">款项D</font></td>
								<td><INPUT TYPE="text" NAME="FundTypeD" VALUE="0"> 元</td>
							</tr>
						</table>

						</td>
					</tr>
					<tr>
						<td><font color="#164DA8">摘要</font></td>
						<td><INPUT TYPE="text" NAME="Summary" VALUE="" size=50></td>
					</tr>
					<tr>
						<td><font color="#164DA8">备注</font></td>
						<td><INPUT TYPE="text" NAME="Remark" VALUE="" size=50></td>
					</tr>


					<tr>
						<td><font color="#164DA8">会计经手人</font></td>
						<td><%=session.getAttribute("Name")%>&nbsp</td>
					</tr>
				</table>
				</td>
			</TR>
		</table>

		<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=1 WIDTH=800 align=center>
			<TR VALIGN="top" ALIGN="center">
				<TD WIDTH=100% align=center><INPUT TYPE="submit" NAME="AddRecord"
					VALUE="添加此记录"
					style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
				<INPUT TYPE="reset" NAME="Reset" VALUE="重设此记录"
					style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
				<INPUT TYPE="submit" NAME="AddFinancialProject" VALUE="添加删除财务项目"
					style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">

				</TD>
			</TR>
		</table>

		<br>
		</FORM>
		</td>
	</tr>
</table>


</BODY>
</HTML>
<%DBConnectionManager.getInstance().freeConnection("eims", conn);%>
<IFRAME  WIDTH=0 HEIGHT=0></IFRAME>
💿 文件大小 6958 K
👤 上传用户 flp123456
📂 所属分类 Java编程
🏷️ 相关标签

#JSP #网络 #办公自动化 #系统开发
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -