package?com.action;

import?java.io.IOException;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?javax.servlet.RequestDispatcher;
import?javax.servlet.ServletConfig;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.dao.DB;
import?com.orm.TJingying;

public?class?jingying_servlet?extends?HttpServlet
{
	public?void?service（HttpServletRequest?reqHttpServletResponse?res）throws?ServletException?IOException?
	{
????????String?type=req.getParameter（“type“）;
		
????????if（type.endsWith（“jingyingMana“））
????????{
????????	jingyingMana（req?res）;
????????}
????????if（type.endsWith（“jingyingList“））
????????{
????????	jingyingList（req?res）;
????????}
		if（type.endsWith（“jingyingAdd“））
		{
			jingyingAdd（req?res）;
		}
	}
	
	
	public?void?jingyingAdd（HttpServletRequest?reqHttpServletResponse?res）
	{
		String?mingcheng=req.getParameter（“mingcheng“）;
		String?riqi=req.getParameter（“riqi“）;
		String?touru=req.getParameter（“touru“）;
		String?shouyi=req.getParameter（“shouyi“）;
		String?lirun=req.getParameter（“l(fā)irun“）;
		String?sql=“insert?into?t_jingying?（mingchengriqitourushouyilirun）?values（?????）“;
		object[]?params={mingchengriqitourushouyilirun};
		DB?mydb=new?DB（）;
		mydb.doPstm（sql?params）;
		mydb.closed（）;
		
		req.setAttribute（“message“?“操作成功“）;
		req.setAttribute（“path“?“jingying?type=jingyingMana“）;
		
		String?targetURL?=?“/common/success.jsp“;
		dispatch（targetURL?req?res）;
	}
	
	
	public?void?jingyingMana（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		String?sql=“select?*?from?t_jingying“;
		
		req.setAttribute（“jingyingList“?getjingyingList（sql））;
		req.getRequestDispatcher（“admin/jingying/jingyingMana.jsp“）.forward（req?res）;
	}
	
	public?void?jingyingList（HttpServletRequest?reqHttpServletResponse?res）?throws?ServletException?IOException
	{
		String?sql=“select?*?from?t_jingying“;
		
		req.setAttribute（“jingyingList“?getjingyingList（sql））;
		req.getRequestDispatcher（“admin/jingying/jingyingList.jsp“）.forward（req?res）;
	}

	
	private?List?getjingyingList（String?sql）
	{
		List?jingyingList=new?ArrayList（）;
		object[]?params={};
		DB?mydb=new?DB（）;
		try
		{
			mydb.doPstm（sql?params）;
			ResultSet?rs=mydb.getRs（）;
			while（rs.next（））
			{
				TJingying?jingying=new?TJingying（）;
				jingying.setId（rs.getInt（“id“））;
				jingying.setMingcheng（rs.getString（“mingcheng“））;
				jingying.setRiqi（rs.getString（“riqi“））;
				jingying.setTouru（rs.getDouble（“touru“））;
				jingying.setShouyi（rs.getDouble（“shouyi“））;
				jingying.setLirun（rs.getDouble（“l(fā)irun“））;
				jingyingList.add（jingying）;
		????}
			rs.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		mydb.closed（）;	
		return?jingyingList;
	}
	public?v

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1147??2013-04-23?16:14??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\.classpath

?????文件????????291??2013-04-27?21:08??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\.mymetadata

?????文件???????1224??2013-04-03?09:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\.project

?????文件????????330??2013-04-03?08:37??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\.settings\org.eclipse.jdt.core.prefs

?????文件???????3557??2013-04-04?14:54??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\action\jingying_servlet.java

?????文件???????2937??2013-04-18?21:25??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\dao\DB.java

?????文件???????1166??2013-04-27?21:14??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\orm\TGongzi.java

?????文件????????890??2013-04-03?20:18??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\orm\TJingying.java

?????文件???????2941??2013-04-09?18:23??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\service\loginService.java

?????文件???????1216??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\com\util\EncodingFilter.java

?????文件?????????70??2013-04-18?20:57??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\src\dbInfo.properties

?????文件?????????61??2014-02-27?17:03??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\admin\index.jsp

?????文件?????????88??2013-03-29?12:10??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\admin\login.jsp

?????文件???????8928??2013-04-06?17:06??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\admin\menu.jsp

?????文件???????3071??2013-04-03?09:38??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\admin\top.jsp

?????文件???????4218??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\admin\userinfo\userPw.jsp

?????文件????????797??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\common\success.jsp

?????文件???????5008??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\base.css

?????文件????????795??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\dtree.css

?????文件???????1669??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\front1.css

?????文件???????6520??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\layout.css

?????文件???????1168??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\main.css

?????文件????????638??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\whole.css

?????文件???????2684??2012-04-01?23:34??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\css\woncore.css

?????文件????????153??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\arr4.gif

?????文件????????908??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\arrow.gif

?????文件???????8331??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\banner.jpg

?????文件???????1040??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\base.gif

?????文件??????29151??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\bhj.jpg

?????文件????????239??2012-04-17?18:09??354JSP財(cái)務(wù)管理系統(tǒng)\cwglxt\WebRoot\img\cd.gif

............此處省略160個(gè)文件信息