package?dao;

import?java.util.List;

import?entity.Admin;
import?entity.Message;
import?entity.Problem;
import?entity.Reply;
import?entity.User;

public?interface?SqlDAO?{
	public?void?insertUser（User?u）?throws?Exception;
	public?User?findByusername（String?username）?throws?Exception;
	public?void?insertMsg（Message?m）?throws?Exception;
	public?List?findByusernameM（String?username）?throws?Exception;
	public?Reply?findByMsgId（long?id）?throws?Exception;
	public?void?updateUser（String?usernameString?nameString?sexString?emailString?phone）?throws?Exception;
	public?List?findAllKeys（String?key）?throws?Exception;
	public?String?findByKey（String?key）?throws?Exception;
	public?void?deleteMegById（long?id?）throws?Exception;
	public?List?findAllsUser（String?page?int?pageSize）throws?Exception;
	public?int?getTotalpage（int?pageSize）?throws?Exception;
	public?int?getTotalCount（）?throws?Exception;
	public?void?delUserById（long?id）?throws?Exception;
	public?List?findAllsMessage（String?page?int?pageSize）throws?Exception;
	public?int?getTotalpageMessage（int?pageSize）?throws?Exception;
	public?int?getTotalCountMessage（）?throws?Exception;
	public?Boolean?insertReply（Reply?r）?throws?Exception;
	public?void?updateIsReply（long?id）?throws?Exception;
	public?List?findAllsProblem（String?page?int?pageSize）throws?Exception;
	public?int?getTotalCountProblem（）?throws?Exception;
	public?int?getTotalpageProblem（int?pageSize）?throws?Exception;
	public?Problem?findByanswerId（long?id）?throws?Exception;
	public?void?insertProblem（Problem?p）?throws?Exception;
	public?void?updateProblem（Problem?p）?throws?Exception;
	public?Admin?findAdmById（String?username）?throws?Exception;
	public?void?deleteAnswerById（long?id）?throws?Exception;
	public?void?modifyPasswordbyuseranem（String?usernameString?password）?throws?Exception;
}

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

?????文件????????529??2013-10-02?11:55??Travel\.classpath

?????文件????????291??2013-10-02?11:55??Travel\.mymetadata

?????文件?????????66??2013-10-02?23:54??Travel\.myumldata

?????文件???????1749??2013-10-02?13:10??Travel\.project

?????文件????????500??2013-10-02?11:55??Travel\.settings\.jsdtscope

?????文件????????168??2013-10-09?19:23??Travel\.settings\com.genuitec.eclipse.core.prefs

?????文件?????????69??2013-10-02?13:01??Travel\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2013-10-09?19:23??Travel\.settings\org.eclipse.jdt.core.prefs

?????文件????????456??2013-10-02?11:55??Travel\.settings\org.eclipse.wst.common.component

?????文件????????252??2013-10-02?11:55??Travel\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-10-02?11:55??Travel\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-10-02?11:55??Travel\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????7446??2014-03-27?16:21??Travel\db_travel.sql

?????文件?????????27??2013-10-02?13:39??Travel\src\config.properties

?????文件??????18633??2013-10-21?21:32??Travel\src\dao\impl\SqlDAOImpl.java

?????文件???????1900??2013-10-21?21:37??Travel\src\dao\SqlDAO.java

?????文件???????1246??2013-10-07?19:01??Travel\src\entity\Admin.java

?????文件????????966??2013-10-02?21:26??Travel\src\entity\Message.java

?????文件????????598??2013-10-06?13:28??Travel\src\entity\Problem.java

?????文件????????796??2013-10-02?23:02??Travel\src\entity\Reply.java

?????文件???????1617??2013-10-02?16:05??Travel\src\entity\User.java

?????文件????????567??2013-10-02?13:40??Travel\src\util\ConfigUtil.java

?????文件???????1711??2013-10-19?18:54??Travel\src\util\CookieUtil.java

?????文件????????305??2013-10-02?13:40??Travel\src\util\DAOFactory.java

?????文件???????1671??2013-10-09?11:23??Travel\src\util\DateUtil.java

?????文件???????1024??2013-10-02?13:36??Travel\src\util\DBUtil.java

?????文件????????669??2013-09-27?19:55??Travel\src\util\Md5.java

?????文件??????24230??2013-10-28?20:05??Travel\src\web\ActionServlet.java

?????文件???????1694??2013-10-08?21:04??Travel\src\web\CheckCodeServlet.java

?????文件???????1851??2013-10-04?01:24??Travel\src\web\SearchSuggest.java

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