package?com.system;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?com.system.DBConn;

public?class?Common?{
	public?String?GetWebtitle（）
	{
		return?“航空訂票系統“;
	}
	?
	?

	//返回修改結果
	public??boolean?Update?（String?sql）
	{?
		DBConn?conn?=?null;?
		conn?=new?DBConn（）;
		return?conn.Update（sql）;
	}?
	
	//返回RS
	public?ResultSet?GetResultSet（String?sql）
	{
		DBConn?conn?=?null;?
		conn?=new?DBConn（）;
		return?conn.GetResultSet（sql）;
	}
	
	
	
	/**
	?*?檢測是管理員登錄?
	?*?@return	true?是管理員
	?*?			false?不是管理員
	?*/
	//驗證用戶登錄?
	public?int?CheckAdminLogin（String?usernameString?userpass）?{
		DBConn?conn?=?null;?
		try?{
			String?sql?=?“select?id?from?admininfo?where?adname=??and?adpass=?“;
			conn?=?new?DBConn（）;
			PreparedStatement?pStmt?=?conn.prepareStmt（sql）;
			pStmt.setString（1username）;
			pStmt.setString（2userpass）;
			ResultSet?rs?=?conn.executeQuery（）;
			if?（rs.next（））{
		????return?rs.getInt（“id“）;
			}
			return?0;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}?finally?{
			conn.close（）;?
		}
	}
	?
?
	
	
	/**
	?*?檢測是管理員登錄?
	?*?@return	true?是管理員
	?*?			false?不是管理員
	?*/
	//驗證用戶登錄?
	public?int?CheckUserLogin（String?usernameString?userpass）?{
		DBConn?conn?=?null;?
		try?{?
			String?sql?=?“select?*?from?userinfo?where?mName=??and?mPass=??“;
			
			conn?=?new?DBConn（）;
			PreparedStatement?pStmt?=?conn.prepareStmt（sql）;
			pStmt.setString（1username）;
			pStmt.setString（2userpass）;
			ResultSet?rs?=?conn.executeQuery（）;
			if?（rs.next（））{
		????return?rs.getInt（“id“）;
			}
			return?0;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}?finally?{
			conn.close（）;?
		}
	}
	?
	
	

	//驗證管理員舊密碼
	public?int?CheckOldPass（String?uidString?upass）
	{
		DBConn?conn=null?;
		try
		{		
			String?sql?=?“select?*?from?admininfo?where?ID=??and?ADPass=?“;
			conn?=?new?DBConn（）;
			PreparedStatement?pStmt?=?conn.prepareStmt（sql）;
			pStmt.setString（1uid）;
			pStmt.setString（2upass）;
			ResultSet?rs?=?conn.executeQuery（）;
		????rs.next（）;
		????return?rs.getInt（“ID“）;
		}catch（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}?finally?{
			conn.close（）;?
		}?
	}
?

	//保存管理員新密碼
	public?int?ChangeNewPass（String?uidString?newpass）
	{
		DBConn?conn=null?;
		try
		{		
			String?sql?=?“update?admininfo?set?ADPass=??where?ID=?“;
			conn?=?new?DBConn（）;
			PreparedStatement?pStmt?=?conn.prepareStmt（sql）;
			pStmt.setString（1newpass）;
			pStmt.setString（2uid）;
			?int?i?=?conn.executeUpdate（）;?
		????if?（?i?>0）
		????	return?1;
		????else?
		????	return?0;
		}catch（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}?finally?{
			conn.close（）;?
		}
		
	}
	

	
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-26?21:08??flight-system\
?????文件????????1342??2016-08-08?22:14??flight-system\.classpath
?????目錄???????????0??2018-07-13?01:43??flight-system\.myeclipse\
?????文件?????????319??2017-07-12?08:53??flight-system\.mymetadata
?????文件????????1760??2018-05-29?02:09??flight-system\.project
?????目錄???????????0??2018-07-13?01:41??flight-system\.settings\
?????文件?????????493??2016-05-09?08:43??flight-system\.settings\.jsdtscope
?????文件????????1009??2018-05-29?02:11??flight-system\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????247??2016-08-08?22:14??flight-system\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????395??2016-05-09?08:43??flight-system\.settings\org.eclipse.jdt.core.prefs
?????文件?????????567??2018-05-29?02:11??flight-system\.settings\org.eclipse.wst.common.component
?????文件?????????346??2016-08-08?22:14??flight-system\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-05-09?08:43??flight-system\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-05-09?08:43??flight-system\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-07-13?01:43??flight-system\src\
?????目錄???????????0??2018-07-13?01:41??flight-system\src\com\
?????目錄???????????0??2018-07-13?01:43??flight-system\src\common\
?????目錄???????????0??2018-07-13?01:43??flight-system\src\common\myUtils\
?????文件?????????201??2017-11-26?17:56??flight-system\src\common\myUtils\ConditionMap.java
?????文件?????????474??2017-10-23?21:47??flight-system\src\common\myUtils\ExcelError.java
?????文件????????3792??2017-12-05?17:12??flight-system\src\common\myUtils\ExcelUtil.java
?????文件?????????635??2017-11-26?17:57??flight-system\src\common\myUtils\HqlMaker.java
?????文件?????????224??2017-10-23?14:21??flight-system\src\common\myUtils\IdGendertor.java
?????文件?????????732??2017-11-27?16:46??flight-system\src\common\myUtils\IdGenerator.java
?????文件????????1186??2017-11-30?14:06??flight-system\src\common\myUtils\LoginInfoListener.java
?????文件????????1679??2017-12-01?20:27??flight-system\src\common\myUtils\MyDateUtil.java
?????文件?????????873??2017-12-01?19:45??flight-system\src\common\myUtils\MyStringUtil.java
?????文件????????1637??2017-11-26?17:56??flight-system\src\common\myUtils\PageBean.java
?????文件????????3809??2017-11-26?18:06??flight-system\src\common\myUtils\PageUtil.java
?????文件?????????980??2017-12-01?22:54??flight-system\src\common\myUtils\RandomUtil.java
?????文件????????4342??2017-12-05?18:17??flight-system\src\common\myUtils\SysConstants.java
............此處省略356個文件信息