package?DBJavaBean;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpSession;
import?javax.swing.JOptionPane;

import?org.apache.struts2.interceptor.ServletRequestAware;

import?JavaBean.MyDayBean;
import?JavaBean.MyFileBean;
import?JavaBean.MyFriBean;
import?JavaBean.MyMessBean;
import?JavaBean.UserNameBean;

public?class?DB?implements?ServletRequestAware{
	private?String?driverName?=?“com.mysql.jdbc.Driver“;
	private?String?url?=?“jdbc:mysql://127.0.0.1:3306/imsystem?characterEncoding=utf-8“;
	private?String?user?=?“root“;
	private?String?password?=?“root“;
	private?Connection?con?=?null;
	private?Statement?st?=?null;
	private?ResultSet?rs?=?null;
	private?HttpServletRequest?request;
	
	public?DB（）{
		
	}
	
	public?String?getDriverName（）?{
		return?driverName;
	}

	public?void?setDriverName（String?driverName）?{
		this.driverName?=?driverName;
	}

	public?String?getUrl（）?{
		return?url;
	}

	public?void?setUrl（String?url）?{
		this.url?=?url;
	}

	public?String?getUser（）?{
		return?user;
	}

	public?void?setUser（String?user）?{
		this.user?=?user;
	}

	public?String?getPassword（）?{
		return?password;
	}

	public?void?setPassword（String?password）?{
		this.password?=?password;
	}
	@Override
	public?void?setServletRequest（HttpServletRequest?hsr）?{
		request=hsr;
		
	}
	//完成連接數據庫操作>生成容器并返回
	public?Statement?getStatement（）{
		try?{
			Class.forName（this.getDriverName（））;
			con?=?DriverManager.getConnection（this.getUrl（）this.getUser（）this.getPassword（））;
			return?con.createStatement（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}
	
	//查詢個人信息，并返回結果集rs
	public?ResultSet?selectMess（HttpServletRequest?request?String?userName）?{
		try?{
			String?sql?=?“select*?from?user?where?userName=‘“+userName+“‘“;
			st?=?getStatement（）;
			return?st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}
	//查詢登錄名和密碼是否存在
	public?ResultSet?selectLogin（HttpServletRequest?request?String?userName?String?password）?{
		try?{
			String?sql?=?“select*?from?user?where?userName=‘“+userName+“‘and?password=‘“+password+“‘“;
			st?=?getStatement（）;
			return?st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}
	//調用myLogin（）、myMessage（）方法、myFriends（）、myDayTime（）、myFile（）方法，把所有和用戶有關的信息全部保存到session對象中，該方法成功登錄后調用
	public?String?addList（HttpServletRequest?request?String?userName）?{
		//TODO
		String?sure?=?null;
		String?login?=?myLogin（requestuserName）;
		String?mess?=?myMessage（requestuserName）;
		String?fri?=?myFriends（requestuserName）;
		String?day?=?myDayTime（requestuserName）;
		String?file?=?myFile（requestuserName）;
		if（mess.equals（“ok“）&&login.equa

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1271??2018-03-27?12:18??PIMSystem\.classpath

?????文件???????1218??2018-03-27?12:17??PIMSystem\.project

?????文件????????567??2018-03-27?12:17??PIMSystem\.settings\.jsdtscope

?????文件????????119??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.core.resources.prefs

?????文件????????736??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.jdt.core.prefs

?????文件?????????90??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.m2e.core.prefs

?????文件????????559??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.wst.common.component

?????文件????????252??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-03-27?12:17??PIMSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????????81??2018-03-27?12:17??PIMSystem\.settings\org.hibernate.eclipse.console.prefs

?????文件???????2064??2018-03-30?14:24??PIMSystem\imsystem.sql

?????文件???????1771??2018-03-24?16:39??PIMSystem\pom.xml

?????文件??????22600??2018-03-30?12:39??PIMSystem\src\main\java\DBJavaBean\DB.java

?????文件???????3837??2018-03-29?15:55??PIMSystem\src\main\java\edu\dateTimeManager\action\AddDayAction.java

?????文件????????815??2018-03-29?16:18??PIMSystem\src\main\java\edu\dateTimeManager\action\DeleteDayAction.java

?????文件???????3516??2018-03-29?16:05??PIMSystem\src\main\java\edu\dateTimeManager\action\FindDayAction.java

?????文件???????3447??2018-03-29?16:15??PIMSystem\src\main\java\edu\dateTimeManager\action\UpdateDayAction.java

?????文件???????4159??2018-03-30?00:09??PIMSystem\src\main\java\edu\fileManager\action\AddFileAction.java

?????文件???????1260??2018-03-29?20:44??PIMSystem\src\main\java\edu\fileManager\action\DeleteFileAction.java

?????文件???????1873??2018-03-30?12:31??PIMSystem\src\main\java\edu\fileManager\action\DownFileAction.java

?????文件???????1754??2018-03-29?20:37??PIMSystem\src\main\java\edu\fileManager\action\FindFileAction.java

?????文件???????2889??2018-03-29?12:02??PIMSystem\src\main\java\edu\friendManager\action\AddFriAction.java

?????文件????????842??2018-03-29?12:02??PIMSystem\src\main\java\edu\friendManager\action\DeleteFriAction.java

?????文件???????1814??2018-03-29?14:37??PIMSystem\src\main\java\edu\friendManager\action\FindFriAction.java

?????文件???????2597??2018-03-29?12:02??PIMSystem\src\main\java\edu\friendManager\action\UpdateFriAction.java

?????文件???????2492??2018-03-27?17:50??PIMSystem\src\main\java\edu\login\action\LoginAction.java

?????文件???????4813??2018-03-28?23:49??PIMSystem\src\main\java\edu\login\action\RegisterAction.java

?????文件???????3787??2018-03-28?16:03??PIMSystem\src\main\java\edu\personManager\action\UpdateMessAction.java

?????文件???????1611??2018-03-28?16:03??PIMSystem\src\main\java\edu\personManager\action\UpdatePassAction.java

............此處省略121個文件信息