package?Bean;

import?java.sql.*;
import?java.util.ArrayList;
import?javax.servlet.ServletContext;
import?javax.servlet.http.HttpServletRequest;


public?class?DBProcess?{
	private?HttpServletRequest?request;
	private?Connection?con;
	private?Statement?stat;
	
	public?DBProcess（HttpServletRequest?request）
	{
		this.request=request;
		ServletContext?ctx?=request.getSession（）.getServletContext（）;
		con=（Connection）?ctx.getAttribute（“DBCon“）;
		
	}
	
	public?void?save（）?throws?Exception
	{
		String??insertSQL?=“insert?into?student（stuidstuNamesexclassname）value（????）“;
		String?updateSQL=“update?student?set?stuid=?stuName=?sex=?classname=?where?id=?“;
		ArrayList?params=new?ArrayList（）;
		params.add（request.getParameter（“stuid“））;
		params.add（request.getParameter（“stuName“））;
		params.add（request.getParameter（“sex“））;
		params.add（request.getParameter（“classname“））;
		String?id?=request.getParameter（“id“）;
		System.out.println（params.get（0））;
		if（““.equals（id））
		{
			exePrepare（insertSQLparams）;
			System.out.println（“...“）;
			
		}
		else
		{
			params.add（id）;
			exePrepare（updateSQLparams）;
		}
	}

	
	public?void?getStudentList（）?throws?SQLException
	{
		String?sql=“select?*from?student“;
		ResultSet?rs=getRS（sql）;
		ArrayListstuList=new?ArrayList（）;
		while（rs.next（））
		{
			stuList.add（toStudent（rs））;
			
		}
		System.out.println（stuList.size（））;
		request.setAttribute（“stuList“?stuList）;
		closeRS（rs）;
	}
	private?void?closeRS（ResultSet?rs）?{
		try
		{
			stat.close（）;
			rs.close（）;	
		}catch（SQLException?e）
		{
			e.printStackTrace（）;
		}
		
	}

	private?ResultSet?getRS（String?sql）?throws?SQLException{
		//?TODO?Auto-generated?method?stub
	stat=con.createStatement（）;
	ResultSet?res=stat.executeQuery（sql）;
	return?res;
	}
	
	
	
	public?void?getStuById（）?throws?SQLException
	{
		String?sql=“select?*?from?student?where?id=“;
		String?id=request.getParameter（“id“）;
		sql+=id;
		ResultSet?rs=getRS（sql）;
		
		while（rs.next（））
		{
			Student?stu=toStudent（rs）;
			request.setAttribute（“stu“stu）;
		}
		closeRS（rs）;
	}
	
	public?void?deleteStuById（）?throws?SQLException
	{
		String?sql=“delete?from?student?where?id=?“;
		String?id=request.getParameter（“id“）;
		PreparedStatement?pstat=con.prepareStatement（sql）;
		
		pstat.setString（1id）;	
		pstat.execute（）;
	}
	
	private?Student?toStudent（ResultSet?rs）throws?SQLException
	{
		Student?stu=new?Student（）;
		stu.setId（rs.getInt（“id“））;
		stu.setStuid（rs.getString（“stuid“））;
		stu.setStuName（rs.getString（“stuName“））;
		stu.setSex（rs.getString（“sex“））;
		stu.setClassname（rs.getString（“classname“））;
	System.out.println（stu.getClassname（））;
	
		return?stu;
		
	}
	
	private?void?exePrepare（String?sqlArrayList?params）throws?SQLException
	{
		PreparedStatement?pstat=con.prepareStatement（sql）;
		int?i=1;
		for（String?param:params）
		

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\
?????文件?????????630??2017-11-14?09:16??mvc\mvcAction\.classpath
?????目錄???????????0??2017-11-14?09:15??mvc\mvcAction\.myeclipse\
?????文件?????????300??2017-11-20?08:40??mvc\mvcAction\.mymetadata
?????文件?????????240??2017-11-14?09:16??mvc\mvcAction\.mystrutsdata
?????文件????????1835??2017-11-14?09:39??mvc\mvcAction\.project
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\src\
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\src\actions\
?????文件????????1517??2017-11-14?09:51??mvc\mvcAction\src\actions\StudentAction.java
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\src\beans\
?????文件?????????607??2017-11-14?09:16??mvc\mvcAction\src\beans\Student.java
?????文件?????????451??2017-11-14?09:26??mvc\mvcAction\src\struts.xml
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\src\util\
?????文件????????2980??2017-11-20?09:45??mvc\mvcAction\src\util\DBUtil.java
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\
?????文件?????????829??2017-11-14?09:15??mvc\mvcAction\WebRoot\index.jsp
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\meta-INF\
?????文件??????????36??2017-11-14?09:15??mvc\mvcAction\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\classes\actions\
?????文件????????2267??2017-11-20?08:41??mvc\mvcAction\WebRoot\WEB-INF\classes\actions\StudentAction.class
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\classes\beans\
?????文件????????1134??2017-11-20?08:41??mvc\mvcAction\WebRoot\WEB-INF\classes\beans\Student.class
?????文件?????????451??2017-11-14?09:26??mvc\mvcAction\WebRoot\WEB-INF\classes\struts.xml
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\classes\util\
?????文件????????4199??2017-11-20?09:45??mvc\mvcAction\WebRoot\WEB-INF\classes\util\DBUtil.class
?????文件????????1000??2017-11-14?09:47??mvc\mvcAction\WebRoot\WEB-INF\edit.jsp
?????目錄???????????0??2017-12-17?17:01??mvc\mvcAction\WebRoot\WEB-INF\lib\
?????文件??????767492??2017-09-24?17:35??mvc\mvcAction\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.13-bin.jar
?????文件?????????791??2017-11-20?09:36??mvc\mvcAction\WebRoot\WEB-INF\list.jsp
............此處省略49個文件信息