資源簡介
flight-system.zip
代碼片段和文件信息
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\.myme
?????文件????????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.xm
?????文件??????????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個文件信息
評論
共有 條評論