package?org.dao;??
import?java.sql.*;??
import?org.model.*;??
import?org.db.*;??
import?java.util.ArrayList;??
public?class?LoginDao?{??
????Connection?conn=DBconn.getConn（）;??????????????????//數據庫連接對象??
????PreparedStatement?pstmt;??
????public?Login?checkLogin（String?nameString?password）{?//驗證用戶名密碼??
????????try{??
????????????pstmt=conn.prepareStatement（“select*from?loginss?where?name=??“?+?“?and?password=?“）;??
????????????pstmt.setString（1?name）;?????????????????????//設置SQL語句參數??
????????????pstmt.setString（2?password）;?????????????????//設置SQL語句參數??
????????????ResultSet?rs=pstmt.executeQuery（）;????????????//執行查詢，返回結果集??
????????????if（rs.next（））{????????????????????????????????//通過JavaBean保存值??
????????????????Login?login=new?Login（）;??
????????????????login.setId（rs.getInt（1））;??
????????????????login.setName（rs.getString（2））;??
????????????????login.setPassword（rs.getString（3））;??
????????????????login.setRole（rs.getInt（4））;??
????????????????return?login;?????????????????????????????//返回JavaBean對象??
????????????}??
????????????return?null;??????????????????????????????????//驗證失敗返回null??
????????}catch（Exception?e）{??
????????????e.printStackTrace（）;??
????????????return?null;??
????????}??
????}??
????public??ArrayList?findMbInfo（）{??
????????try{??
????????????ArrayList?al=new?ArrayList（）;??
????????????pstmt=conn.prepareStatement（“select?*?from?messagess“）;??
????????????ResultSet?rs=pstmt.executeQuery（）;??
????????????while（rs.next（））{??
????????????????MessBoar?mb=new?MessBoar（）;??
????????????????mb.setId（rs.getInt（1））;??
????????????????mb.setName（rs.getString（2））;??
????????????????mb.setTime（rs.getDate（3））;??
????????????????mb.settitle（rs.getString（4））;??
????????????????mb.setMessage（rs.getString（5））;??
????????????????al.add（mb）;??
????????????}??
????????????return?al;??
????????}catch（Exception?e）{??
????????????e.printStackTrace（）;??
????????????return?null;??
????????}??
????}??
????????public?String?getName（int?id）{??
????????????String?name=null;??
????????????try{??
????????????????pstmt=conn.prepareStatement（“select?name?from?loginss?where?id=?“）;??
????????????????pstmt.setInt（1?id）;??
????????????????ResultSet?rs=pstmt.executeQuery（）;??
????????????????while（rs.next（））{??
?????????????????????name=rs.getString（1）;??
????????????????}??
????????????????return?name;??
????????????}catch（Exception?e）{??
????????????????e.printStackTrace（）;??
????????????????return?null;??
????????????}??
????????}??
??
????????public?boolean?addInfo（MessBoar?mb）{??
????????????try{??
????????????????pstmt=conn.prepareStatement（“insert?into?messagess?values（?????）“）;??
????????????????pstmt.setInt（1?mb.getId（））;??
????????????????pstmt.setString（2?mb.getName（））;??
????????????????pstmt.setDate（3?mb.getTime（））;??
????????????????pstmt.setString（4?mb.gettitle（））;??
????????????????pstmt.setString（5?mb.getMessage（））;??
????????

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

?????文件?????625358??2018-05-05?11:03??-javaweb期末大作業\期末大作業.docx

?????文件????????953??2017-12-25?17:13??-javaweb期末大作業\demo2\.classpath

?????文件????????905??2017-12-25?16:18??-javaweb期末大作業\demo2\.project

?????文件????????567??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\.jsdtscope

?????文件????????364??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\org.eclipse.jdt.core.prefs

?????文件????????467??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-12-25?16:18??-javaweb期末大作業\demo2\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3744??2018-01-01?19:36??-javaweb期末大作業\demo2\build\classes\org\dao\LoginDao.class

?????文件???????1052??2018-01-01?19:38??-javaweb期末大作業\demo2\build\classes\org\db\DBconn.class

?????文件???????1150??2018-01-01?13:09??-javaweb期末大作業\demo2\build\classes\org\model\Login.class

?????文件???????1329??2018-01-01?13:09??-javaweb期末大作業\demo2\build\classes\org\model\MessBoar.class

?????文件???????2161??2018-01-01?13:09??-javaweb期末大作業\demo2\build\classes\org\servlet\LeaveMessageServlet.class

?????文件???????1916??2018-01-01?15:03??-javaweb期末大作業\demo2\build\classes\org\servlet\LoginServlet.class

?????文件???????1491??2018-01-01?15:04??-javaweb期末大作業\demo2\build\classes\org\servlet\RegisterServlet.class

?????文件???????3847??2018-01-01?19:36??-javaweb期末大作業\demo2\src\org\dao\LoginDao.java

?????文件????????822??2018-01-01?19:38??-javaweb期末大作業\demo2\src\org\db\DBconn.java

?????文件????????756??2017-12-25?17:01??-javaweb期末大作業\demo2\src\org\model\Login.java

?????文件????????932??2017-12-25?17:01??-javaweb期末大作業\demo2\src\org\model\MessBoar.java

?????文件???????1818??2017-12-25?18:05??-javaweb期末大作業\demo2\src\org\servlet\LeaveMessageServlet.java

?????文件???????1679??2018-01-01?15:03??-javaweb期末大作業\demo2\src\org\servlet\LoginServlet.java

?????文件???????1029??2018-01-01?15:04??-javaweb期末大作業\demo2\src\org\servlet\RegisterServlet.java

?????文件????????467??2017-12-25?16:41??-javaweb期末大作業\demo2\WebContent\error.jsp

?????文件???????1053??2017-12-25?17:07??-javaweb期末大作業\demo2\WebContent\leavemessage.jsp

?????文件???????1010??2017-12-25?17:10??-javaweb期末大作業\demo2\WebContent\login.jsp

?????文件???????1411??2017-12-25?17:07??-javaweb期末大作業\demo2\WebContent\main.jsp

?????文件?????????39??2017-12-25?16:18??-javaweb期末大作業\demo2\WebContent\meta-INF\MANIFEST.MF

?????文件???????1152??2017-12-25?16:40??-javaweb期末大作業\demo2\WebContent\register.jsp

?????文件????????329??2017-12-25?16:42??-javaweb期末大作業\demo2\WebContent\success.jsp

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