資源簡介
用Jsp頁面連接MySql數據庫,實現對數據的增刪改查。包含jsp源文件,java源文件,sql源文件,以及配置文件。可以直接導入myeclipse。

代碼片段和文件信息
package?com.zl.controller;
import?java.io.IOException;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?com.zl.model.*;
import?java.util.*;
public?class?LoginCLServlet?extends?HttpServlet?{
private?static?final?long?serialVersionUID?=?1L;
public?void?doGet(HttpServletRequest?request?HttpServletResponse?response)
throws?ServletException?IOException?{
//這是一個控制器接受用戶密碼
String?u=request.getParameter(“username“);
String?p=request.getParameter(“password“);
//使用模型UserBean,完成用戶和密碼
//創建一個UserBean處理對象調用方法
System.out.println(u);
System.out.println(p);
UserBeanCL?ubc=new?UserBeanCL();
if(ubc.checkUser(u?p)){
ArrayList?al=ubc.getUserPage(“1“);
int?pageCount=ubc.getPageCount();
//將alpageCount放入forward中
request.getSession().setAttribute(“myName“?u);
request.setAttribute(“result“?al);
request.setAttribute(“pageCount“?pageCount);
request.setAttribute(“x“?“1“);
request.setAttribute(“y“?“1“);
request.setAttribute(“pageNow“?“1“);
request.getRequestDispatcher(“main.jsp“).forward(request?response);
}else{
request.getRequestDispatcher(“login.jsp“).forward(requestresponse);
}
}
public?void?doPost(HttpServletRequest?request?HttpServletResponse?response)
throws?ServletException?IOException?{
this.doGet(request?response);
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????487??2010-09-04?09:55??test\.classpath
?????文件????????288??2010-09-03?12:39??test\.myme
?????文件???????1223??2010-04-29?11:06??test\.project
?????文件???????2599??2010-09-10?08:22??test\users.sql
?????文件???????1868??2010-09-03?14:21??test\WebRoot\add.jsp
?????文件????????948??2010-09-03?22:49??test\WebRoot\error.jsp
?????文件???????2435??2010-09-04?15:43??test\WebRoot\find.jsp
?????文件???????1732??2010-09-03?22:59??test\WebRoot\findresult.jsp
?????文件???????1653??2010-09-04?13:57??test\WebRoot\login.jsp
?????文件???????1520??2010-09-04?13:48??test\WebRoot\loginCL.jsp
?????文件???????1242??2010-09-04?14:34??test\WebRoot\main.jsp
?????文件????????950??2010-09-03?22:49??test\WebRoot\succes.jsp
?????文件???????2230??2010-09-04?00:46??test\WebRoot\update.jsp
?????文件???????1248??2010-05-07?10:26??test\WebRoot\WEB-INF\add.jsp
?????文件????????988??2010-09-04?09:55??test\WebRoot\WEB-INF\classes\com\zl\model\ConnDB.class
?????文件???????2255??2010-09-04?09:55??test\WebRoot\WEB-INF\classes\com\zl\model\UserBean.class
?????文件???????8009??2010-09-04?16:38??test\WebRoot\WEB-INF\classes\com\zl\model\UserBeanCL.class
?????文件???????2349??2010-09-04?09:55??test\WebRoot\WEB-INF\classes\com\zl\controller\LoginCLServlet.class
?????文件???????5273??2010-09-04?16:19??test\WebRoot\WEB-INF\classes\com\zl\controller\UsersCLServlet.class
?????文件????????535??2010-09-04?14:50??test\WebRoot\st
?????文件????????150??2010-09-02?10:19??test\WebRoot\st
?????文件?????????39??2010-04-29?11:06??test\WebRoot\me
?????文件??????20669??2010-09-03?15:52??test\WebRoot\img\shu.gif
????..A.SH.??????5632??2012-03-22?01:04??test\WebRoot\img\Thumbs.db
?????文件????????431??2010-09-02?09:37??test\src\com\zl\model\ConnDB.java
?????文件???????1560??2010-09-03?12:44??test\src\com\zl\model\UserBean.java
?????文件???????8587??2010-09-04?16:38??test\src\com\zl\model\UserBeanCL.java
?????文件???????1551??2010-05-06?10:04??test\src\com\zl\controller\LoginCLServlet.java
?????文件???????6336??2010-09-04?16:19??test\src\com\zl\controller\UsersCLServlet.java
?????目錄??????????0??2012-03-22?14:56??test\WebRoot\WEB-INF\classes\com\zl\model
............此處省略19個文件信息
評論
共有 條評論