小项目second-任务一

朱雀 2022-03-17 10:29 171阅读 0赞

![在这里插入图片描述][20190223203947821.png]

## 任务6：创建后台项目 ##

创建一个项目sxt\_tysc\_system，将资料中的已编译的后台项目sxt\_admin\_static目录下的静态资源文件拷贝到我们的项目中，如下图:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]

接下来将jsp文件夹拖到WEB-INF目录下，**WEB-INF在web开发中是受保护的目录,**  
该目录下的资源不能通过客户端请求直接访问(不能用超链接，网址来直接访问)，只能通过服务器内部跳转即请求转发的方式来访问。最终我们的后台项目结构：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]

如果直接访问WEB-INF下的资源，会报错  
![在这里插入图片描述][20190223203904266.png]

## 任务7：管理员登录 ##

**1.在登录页面上显示验证码  
将资料中的验证码文件夹下的AuthCodeServlet添加到项目的servlet包里，AuthCodeUtil添加到util包里面**  
![在这里插入图片描述][201902232024099.png]  
**然后在web.xml中配置AuthCodeServlet**

<servlet>
 		<servlet-name>authCodeServlet</servlet-name>
 		<servlet-class>com.sxt.servlet.AuthCodeServlet</servlet-class>
 	</servlet>
 	<servlet-mapping>
 		<servlet-name>authCodeServlet</servlet-name>
 		<url-pattern>/authCode.action</url-pattern>
 	</servlet-mapping>

**2）.创建AdminDao，添加根据用户名和密码查询的方法**

public class AdminDaoImpl extends BaseDao<Admin> implements AdminDao {
 
 
 	@Override
 	public Admin queryByNameAndPwd(String username, String userpwd) {
 
 		// TODO Auto-generated method stub
 		String sql="select * from t_admin where username=? and userpwd=?";
 		Admin admin = this.getBean(Admin.class, sql,username,userpwd );
 		return admin;
 	}
 }

**3）在AdminService中添加登录的方法**

public class AdminServiceImpl  implements  AdminService{
        
    	private AdminDao  adminDao=new AdminDaoImpl();
    
    	@Override
    	public Admin login(String username, String userpwd) {
        
    		// TODO Auto-generated method stub
    		Admin admin = adminDao.queryByNameAndPwd(username, userpwd);
    		return admin;
    	}
    }

**4）在LoginServlet中处理登录请求**

## 任务8：分页显示所有会员 ##

**1)修改后台主页jsp/main/index.jsp上会员管理菜单的超链接请求路径**

**2)在UserDao中添加查询数据集合的方法queryData和查询总记录数的方法queryCount**

@Override
 	public List<User> queryData(PageBean<User> pb) {
 
 		// TODO Auto-generated method stub
 		String sql="select * from t_user limit ?,?";
 		List<User> list = this.getList(User.class, sql, (pb.getCurrentPage()-1)*pb.getPageSize(),pb.getPageSize());
 		return list;
 	}
 
 	@Override
 	public int queryCount() {
 
 		// TODO Auto-generated method stub
 		String sql="select count(*) from t_user";
 		int total = this.getTotal(sql);
 		return total;
 	}

**3)在userService中添加分页查询用户的方法**

public class UserServiceImpl implements UserService {
 
 
 	private UserDao dao = new UserDaoImpl();
 
 	@Override
 	public void getPageBean(PageBean<User> pb) {
 
 		// TODO Auto-generated method stub
 		List<User> list = dao.queryData(pb);
 		int totalCount = dao.queryCount();
 		// 设置pageBean的其它2个属性
 		pb.setData(list);
 		pb.setTotalCount(totalCount);
 	}
 }

**4）在Userservlet中处理分页查询用户的请求**

// 处理分页查询前台用户的请求
 	public void doPost(HttpServletRequest request, HttpServletResponse response)
 			throws ServletException, IOException {
 
 		// 获取请求的页号，即要查询第几页数据，假设请求参数名currentPage
 		String pageStr = request.getParameter("currentPage");
 		// 保存请求的页号
 		int currentPage = 1;
 		if (pageStr != null) {
 
 			currentPage = Integer.parseInt(pageStr);
 		}
 		// 每页条数
 		int pageSize = 2;
 		// 封装成PageBean，它只有2个数据currentPage和pageSize
 		PageBean<User> pb = new PageBean<>();
 		pb.setCurrentPage(currentPage);
 		pb.setPageSize(pageSize);
 		// 调用UserService,传入PageBean
 		UserService service = new UserServiceImpl();
 		service.getPageBean(pb);
 		// 把PageBean存到request域中
 		request.setAttribute("pb", pb);
 		// 转发到WEB-INF/jsp/user/list.jsp
 		request.getRequestDispatcher("WEB-INF/jsp/user/list.jsp").forward(
 				request, response);
 
 	}

**5）在用户列表页面上分页显示用户，做分页超链接的排版**

<c:choose>
 							<c:when test="${pb.currentPage eq 1}">
 								<a class="nocls">首页</a>
 								<a class="nocls">上一页</a>
 							</c:when>
 							<c:otherwise>
 								<a href="javascript:void(0)" onclick="changePageNum(1)">首页</a>
 								<a href="javascript:void(0)"
 									onclick="changePageNum(${pb.currentPage-1})">上一页</a>
 							</c:otherwise>
 						</c:choose>
 						
 						
 						<c:forEach var="sn" begin="1" end="${pb.totalPage }">
 							<c:choose>
 								<c:when test="${pb.currentPage eq sn}">
 									${sn }
 								</c:when>
 								<c:otherwise>
 									<a href="javascript:void(0)" onclick="changePageNum(${sn})">${sn }</a>
 								</c:otherwise>
 							</c:choose>
 						</c:forEach>
 
 						
 						
 
 						<c:choose>
 							<c:when test="${pb.currentPage eq pb.totalPage}">
 								<a class="nocls">下一页</a>
 								<a class="nocls">尾页</a>
 							</c:when>
 
 					 <c:otherwise>
 								<a href="javascript:void(0)" onclick="changePageNum(${pb.currentPage+1})">下一页</a>
 								<a href="javascript:void(0)"
 									onclick="changePageNum(${pb.totalPage})">尾页</a>
 							</c:otherwise>
 						</c:choose>

## 任务9：显示商品类别(无分页) ##

**1)修改main/index.jsp页面上的商品类别管理超链接**

<a href="${pageContext.request.contextPath}/catelog.action?method=queryAll"
 target="right">商品类别管理</a>

**2）创建CatelogDao接口，添加查询所有商品类别的方法**

@Override
 	public List<Catelog> queryAll() {
 
 		// TODO Auto-generated method stub
 		String sql="select * from t_catelog";
 		List<Catelog> list = this.getList(Catelog.class, sql);
 		return list;
 	}

**3)创建CatelogService接口，加入获取所有类别的方法**

private CatelogDao dao=new CatelogDaoImpl();
 	@Override
 	public List<Catelog> getAllCatelogs() {
 
 		// TODO Auto-generated method stub
 		List<Catelog> list = dao.queryAll();
 		return list;
 	}

**4)创建CatelogServlet,处理获取所有商品类别的请求**

//获取所有商品类别
 	public void queryAll(HttpServletRequest request, HttpServletResponse 
 	response)
 			
 			throws ServletException, IOException {
 
 		//直接调用Service的方法，返回商品类别的集合
 		CatelogService service=new CatelogServiceImpl();
 		List<Catelog> list = service.getAllCatelogs();
 		//把商品类别的集合存到request域中
 		request.setAttribute("list", list);
 		//转发到catelog/list.jsp
 		request.getRequestDispatcher("WEB-
 		INF/jsp/catelog/list.jsp").forward(
 				request, response);
 	}

[20190223203947821.png]: /images/20220317/3d903bc8556e467085f6b66e207a4f3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]: /images/20220317/27e4bd7cea5e48eeaf76c003f4f3ff05.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]: /images/20220317/52d60bb926f64ec3be3ec172623f51e6.png
[20190223203904266.png]: /images/20220317/1e9d67227d204826b19aade7105f18b2.png
[201902232024099.png]: /images/20220317/44555fa135694bb6beaf1da65cf46a0b.png