package?model;

import?java.sql.ResultSet;
import?java.sql.SQLException;

import?sql.*;
?
public?class?UserModel?{
	SQLHelper?sh=null;
	String?password=null;
	public?String?checkUser（String?id）{
		try?{
			String?sql=“select?密碼?from?UserInfo?where?UserInfo.賬號=?“;
			String?paras[]={id};
			sh=new?SQLHelper（）;
			ResultSet?rs=sh.query（sql?paras）;
			if（rs.next（））{
				id=rs.getString（1）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			//?TODO:?handle?exception
		}finally{
				sh.close（）;
		}
		return?id;
	}
	
	public?String?checkPower（String?id）{
		try?{
			String?sql=“select?權(quán)限?from?UserInfo?where?UserInfo.賬號=?“;
			String?paras[]={id};
			sh=new?SQLHelper（）;
			ResultSet?rs=sh.query（sql?paras）;
			if（rs.next（））{
				id=rs.getString（1）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			//?TODO:?handle?exception
		}finally{
				sh.close（）;
		}
		return?id;
	}
	public?void?register（String?[]paras）{
		
		String?sql=“insert?into?UserInfo?values（???????）“;
		sh=new?SQLHelper（）;
		sh.update（sql?paras）;
	}
}

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

?????文件????????364??2014-12-09?19:53??TicketSystem\.classpath

?????文件????????388??2014-12-09?19:53??TicketSystem\.project

?????文件????????598??2014-12-09?19:53??TicketSystem\.settings\org.eclipse.jdt.core.prefs

?????文件???????1812??2014-12-29?23:20??TicketSystem\bin\model\UserModel.class

?????文件???????9546??2014-12-30?00:55??TicketSystem\bin\resulttickets\BuyTickets.class

?????文件???????5246??2014-12-30?00:14??TicketSystem\bin\resulttickets\CheckTickets.class

?????文件???????5124??2014-12-30?00:14??TicketSystem\bin\resulttickets\CheckUserInfo.class

?????文件???????4296??2014-12-30?10:16??TicketSystem\bin\resulttickets\CheckUserTickets.class

?????文件???????6722??2014-12-30?10:28??TicketSystem\bin\resulttickets\DelTickets.class

?????文件???????2056??2014-12-22?16:19??TicketSystem\bin\resulttickets\TicModel.class

?????文件???????2324??2014-12-29?20:17??TicketSystem\bin\sql\SQLHelper.class

?????文件???????1086??2014-12-12?22:12??TicketSystem\bin\tools\BackImage.class

?????文件???????2196??2014-12-12?23:30??TicketSystem\bin\tools\TextSet.class

?????文件???????1633??2014-12-30?10:16??TicketSystem\bin\tools\Tools.class

?????文件???????5418??2014-12-30?00:40??TicketSystem\bin\view\Login.class

?????文件???????4353??2014-12-30?00:31??TicketSystem\bin\view\MangerAddDialog.class

?????文件???????5045??2014-12-30?00:32??TicketSystem\bin\view\MangerUpdateDialog.class

?????文件???????2968??2014-12-30?11:02??TicketSystem\bin\view\MangerWindow.class

?????文件???????5190??2014-12-30?00:13??TicketSystem\bin\view\Register.class

?????文件???????5600??2014-12-30?00:54??TicketSystem\bin\view\SelTicks.class

?????文件???????3587??2014-12-30?00:49??TicketSystem\bin\view\UserWindow.class

?????文件??????13674??2014-12-11?23:00??TicketSystem\image\000.gif

?????文件???????2479??2014-12-11?23:20??TicketSystem\image\1.jpg

?????文件??????10114??2014-12-13?01:13??TicketSystem\image\123.gif

?????文件?????142820??2014-12-13?01:02??TicketSystem\image\182.jpg

?????文件??????10205??2014-12-11?23:20??TicketSystem\image\2.jpg

?????文件???????2504??2014-12-11?23:20??TicketSystem\image\3.jpg

?????文件??????65933??2014-12-14?00:14??TicketSystem\image\33.jpg

?????文件???????2116??2014-12-11?23:21??TicketSystem\image\4.jpg

?????文件???????1755??2014-12-11?23:26??TicketSystem\image\5.jpg

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