crm第二天笔记

最新推荐文章于 2022-10-18 09:56:58 发布

伟大的程序猿csdn

最新推荐文章于 2022-10-18 09:56:58 发布

阅读量292

点赞数

分类专栏：项目笔记面试 ssh框架文章标签： crm 项目笔记

本文链接：https://blog.csdn.net/qq_36084681/article/details/79039670

版权

项目笔记同时被 3 个专栏收录

74 篇文章 2 订阅

订阅专栏

面试

27 篇文章 0 订阅

订阅专栏

ssh框架

7 篇文章 0 订阅

订阅专栏

一.客户列表分析

1.在客户列表做带有搜索功能的分页客户列表

二.pageBean封装

1.src下新建cn.itcast.utils包
包中新建PageBean
package cn.itcast.utils;

package cn.itcast.utils;

import java.util.List;

public class PageBean {
//当前页数
private Integer currentPage;
//总记录数
private Integer totalCount;
//每页显示条数
private Integer pageSize;
//总页数
private Integer totalPage;
//分页列表数据
private List list;
public PageBean(Integer currentPage, Integer totalCount, Integer pageSize) {
this.totalCount = totalCount;

this.pageSize = pageSize;

this.currentPage = currentPage;

if(this.currentPage == null){
//如页面没有指定显示那一页.显示第一页.
this.currentPage = 1;
}

if(this.pageSize == null){
//如果每页显示条数没有指定,默认每页显示3条
this.pageSize = 3;
}

//计算总页数
this.totalPage = (this.totalCount+this.pageSize-1)/this.pageSize;

//判断当前页数是否超出范围
//不能小于1
if(this.currentPage < 1){
this.currentPage = 1;
}
//不能大于总页数
if(this.currentPage > this.totalPage){
this.currentPage = this.totalPage;
}

}
//计算起始索引
public int getStart(){
return (this.currentPage-1)*this.pageSize;
}

public Integer getCurrentPage() {
return currentPage;
}
public void setCurrentPage(Integer currentPage) {
this.currentPage = currentPage;
}
public Integer getTotalCount() {
return totalCount;
}
public void setTotalCount(Integer totalCount) {
this.totalCount = totalCount;
}
public Integer getPageSize() {
return pageSize;
}
public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}
public Integer getTotalPage() {
return totalPage;
}
public void setTotalPage(Integer totalPage) {
this.totalPage = totalPage;
}
public List getList() {
return list;
}
public void setList(List list) {
this.list = list;
}

}

三:Action&Service开发

1.cn.itcast.web.action包中
package cn.itcast.web.action;

import org.apache.commons.lang3.StringUtils;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;

import cn.itcast.domain.Customer;
import cn.itcast.service.CustomerService;
import cn.itcast.utils.PageBean;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public class CustomerAction extends ActionSupport implements
ModelDriven<Customer> {
private Customer customer = new Customer();

private CustomerService cs;

private Integer currentPage;
private Integer pageSize;

public Integer getCurrentPage() {
return currentPage;
}

public void setCurrentPage(Integer currentPage) {
this.currentPage = currentPage;
}

public Integer getPageSize() {
return pageSize;
}

public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}

public void setCs(CustomerService cs) {
this.cs = cs;
}

public String list() throws Exception {
//封装离线查询对象
DetachedCriteria dc = DetachedCriteria.forClass(Customer.class);
//判断并封装参数
if(StringUtils.isNotBlank(customer.getCust_name())){
dc.add(Restrictions.like("cust_name","%"+customer.getCust_name()+"%"));
}
//1.调用Service查询分页数据(PageBean)
PageBean pb = cs.getPageBean(dc,currentPage,pageSize);
//2.将PageBean放入request域,转发到列表页面显示
ActionContext.getContext().put("pageBean",pb);
return "list";
}

public Customer getModel() {
// TODO Auto-generated method stub
return customer;
}
}

2.struts.xml中
<action name="CustomerAction_*" class="customerAction" method="{1}">
<result name="list" >jsp/customer/list.jsp</result>
</action>
3.cn.itcast.service中
新建接口CustomerService
public interface CustomerService{
//分页业务方法
PageBean getPageBean(DetachedCriteria dc,Integer currentPage,Integer pageSize);
}
4.cn.itcast.service.impl中
新建CustomerServiceImpl
public class CustomerServiceImpl implements CustomerService{
private CustomerDao cd;
public void setCd(CustomerDao cd){
this.cd = cd;
}
public PageBean getePageBean(DetachedCriteria dc,Integer currentPage,Integer pageSize){
//1.调用dao查询总记录数
Integer totalCount = cd.getTotalCount(dc);
//2.创建pageBean对象
PageBean pd = new PageBean(currentPage,totalCount,pageSize);
//3.调用dao查询分页列表数据
List<Customer> list = cd.getPageList(dc,pb.getStart(),pb.getPageSize());
//4.列表数据放入到pageBean中,并返回
pb.setList(list);
return pb;
}
}
5.cn.itcast.dao中
新建接口CustomerDao
public interface CustomerDao{
Integer getTotalCount(DetachedCriteria dc);

List<Customer> getPageList(DetachedCriteria dc,int start,Integer pageSize);
}

四.Dao开发

1.cn.itcast.dao.impl中
package cn.itcast.dao.impl;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.springframework.orm.hibernate5.support.HibernateDaoSupport;

import cn.itcast.dao.CustomerDao;
import cn.itcast.domain.Customer;

public class CustomerDaoImpl extends HibernateDaoSupport implements CustomerDao{
public Integer getTotalCount(DetachedCriteria dc){
//设置查询的聚合函数,总记录数
dc.setProjection(Projections.rowCount());
List<Long> list = (List<Long>) getHibernateTemplate().findByCriteria(dc);
//清空之前设置的聚合函数
dc.setProjection(null);

if(list!=null && list.size()>0){
Long count = list.get(0);
return count.intValue();
}else{
return null;
}
}
public List<Customer> getPageList(DetachedCriteria dc,int start,Integer pageSize){
List<Customer> list = (List<Customer>) getHibernateTemplate().findByCriteria(dc,start,pageSize);
return list;
}
}

2.applicationContext.xml中
<bean name="userDao" 复制一份
该成
customerDao cn.itcast.dao.impl.CustomerDaoImpl
<bean name="userService" 复制一份
改成
customerService cn.itcast.service.impl.CustomerServiceImpl
cd customerDao
userAction同理
改成customerAction cn.itcast.web.action.CustomerAction
cs customerService

五.前台list 页面开发

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<TITLE>客户列表</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<LINK href="${pageContext.request.contextPath }/css/Style.css" type=text/css rel=stylesheet>
<LINK href="${pageContext.request.contextPath }/css/Manage.css" type=text/css
rel=stylesheet>
<script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.4.4.min.js"></script>
<SCRIPT language=javascript>
function changePage(pageNum){
//1 将页码的值放入对应表单隐藏域中
$("#currentPageInput").val(pageNum);
//2 提交表单
$("#pageForm").submit();
};

function changePageSize(pageSize){
//1 将页码的值放入对应表单隐藏域中
$("#pageSizeInput").val(pageSize);
//2 提交表单
$("#pageForm").submit();
};
</SCRIPT>

<META content="MSHTML 6.00.2900.3492" name=GENERATOR>
</HEAD>
<BODY>

<TABLE cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<TR>
<TD width=15><IMG src="${pageContext.request.contextPath }/images/new_019.jpg"
border=0></TD>
<TD width="100%" background="${pageContext.request.contextPath }/images/new_020.jpg"
height=20></TD>
<TD width=15><IMG src="${pageContext.request.contextPath }/images/new_021.jpg"
border=0></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<TR>
<TD width=15 background=${pageContext.request.contextPath }/images/new_022.jpg><IMG
src="${pageContext.request.contextPath }/images/new_022.jpg" border=0></TD>
<TD vAlign=top width="100%" bgColor=#ffffff>
<TABLE cellSpacing=0 cellPadding=5 width="100%" border=0>
<TR>
<TD class=manageHead>当前位置：客户管理 > 客户列表</TD>
</TR>
<TR>
<TD height=2></TD>
</TR>
</TABLE>
<TABLE borderColor=#cccccc cellSpacing=0 cellPadding=0
width="100%" align=center border=0>
<TBODY>
<TR>
<TD height=25>
<FORM id="pageForm" name="customerForm"
action="${pageContext.request.contextPath }/CustomerAction_list"
method=post>

<input type="hidden" name="currentPage" id="currentPageInput" value="<s:property value="#pageBean.currentPage" />" />

<input type="hidden" name="pageSize" id="pageSizeInput" value="<s:property value="#pageBean.pageSize" />" />
<TABLE cellSpacing=0 cellPadding=2 border=0>
<TBODY>
<TR>
<TD>客户名称：</TD>
<TD><INPUT class=textbox id=sChannel2
style="WIDTH: 80px" maxLength=50 name="cust_name" value="${param.cust_name}"></TD>

<TD><INPUT class=button id=sButton2 type=submit
value=" 筛选 " name=sButton2></TD>
</TR>
</TBODY>
</TABLE>
</FORM>
</TD>
</TR>

<TR>
<TD>
<TABLE id=grid
style="BORDER-TOP-WIDTH: 0px; FONT-WEIGHT: normal; BORDER-LEFT-WIDTH: 0px; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM-WIDTH: 0px; BORDER-BOTTOM-COLOR: #cccccc; WIDTH: 100%; BORDER-TOP-COLOR: #cccccc; FONT-STYLE: normal; BACKGROUND-COLOR: #cccccc; BORDER-RIGHT-WIDTH: 0px; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #cccccc"
cellSpacing=1 cellPadding=2 rules=all border=0>
<TBODY>
<TR
style="FONT-WEIGHT: bold; FONT-STYLE: normal; BACKGROUND-COLOR: #eeeeee; TEXT-DECORATION: none">
<TD>客户名称</TD>
<TD>客户级别</TD>
<TD>客户来源</TD>
<TD>联系人</TD>
<TD>电话</TD>
<TD>手机</TD>
<TD>操作</TD>
</TR>
<s:iterator value="#pageBean.list" var="cust" >
<TR
style="FONT-WEIGHT: normal; FONT-STYLE: normal; BACKGROUND-COLOR: white; TEXT-DECORATION: none">
<TD>
<s:property value="#cust.cust_name" />
</TD>
<TD>
<s:property value="#cust.cust_level" />
</TD>
<TD>
<s:property value="#cust.cust_source" />
</TD>
<TD>
<s:property value="#cust.cust_linkman" />
</TD>
<TD>
<s:property value="#cust.cust_phone" />
</TD>
<TD>
<s:property value="#cust.cust_mobile" />
</TD>
<TD>
<a href="${pageContext.request.contextPath }/customerServlet?method=edit&custId=${customer.cust_id}">修改</a>
  
<a href="${pageContext.request.contextPath }/customerServlet?method=delete&custId=${customer.cust_id}">删除</a>
</TD>
</TR>
</s:iterator>

</TBODY>
</TABLE>
</TD>
</TR>

<TR>
<TD><SPAN id=pagelink>
<DIV
style="LINE-HEIGHT: 20px; HEIGHT: 20px; TEXT-ALIGN: right">
共[<B><s:property value="#pageBean.totalCount" /> </B>]条记录,[<B><s:property value="#pageBean.totalPage" /></B>]页
,每页显示 <%-- changePageSize($('#pageSizeSelect option').filter(':selected').val()) --%>
<select name="pageSize" οnchange="changePageSize($('#pageSizeSelect option:selected').val())" id="pageSizeSelect" >
<option value="3" <s:property value="#pageBean.pageSize==3?'selected':''" /> >3</option>
<option value="5" <s:property value="#pageBean.pageSize==5?'selected':''" /> >5</option>
</select>
条
[<A href="javaScript:void(0)" οnclick="changePage(<s:property value='#pageBean.currentPage-1' />)" >前一页</A>]
<B><s:property value="#pageBean.currentPage" /></B>
[<A href="javaScript:void(0)" οnclick="changePage(<s:property value='#pageBean.currentPage+1' />)" >后一页</A>]
到
<input type="text" size="3" id="page" name="page" value="<s:property value="#pageBean.currentPage" />" />
页

<input type="button" value="Go" οnclick="changePage($('#page').val())"/>
</DIV>
</SPAN></TD>
</TR>
</TBODY>
</TABLE>
</TD>
<TD width=15 background="${pageContext.request.contextPath }/images/new_023.jpg"><IMG
src="${pageContext.request.contextPath }/images/new_023.jpg" border=0></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<TR>
<TD width=15><IMG src="${pageContext.request.contextPath }/images/new_024.jpg"
border=0></TD>
<TD align=middle width="100%"
background="${pageContext.request.contextPath }/images/new_025.jpg" height=15></TD>
<TD width=15><IMG src="${pageContext.request.contextPath }/images/new_026.jpg"
border=0></TD>
</TR>
</TBODY>
</TABLE>

</BODY>
</HTML>

六.BaseDao设计

1.提交svn,完成客户列表功能
2.dao包中新建BaseDao
public interface BaseDao<T>{
//增
void save(T t);
//删
void delete(T t);
//删
void delete(Serializable id) ;
//改
void update(T t);
//查根据id查询
T getById(Serializable id);
//查符合条件的总记录数
Integer getTotalCount(DetachedCriteria dc);
//查查询分页列表数据
List<T> getPageList(DetachedCriteria dc,Integer start,Integer pageSize);

}
impl包中
BaseDaoImpl
public class BaseDaoImpl<T> extends HibernateDaoSupport implements BaseDao<T> {
private Class clazz;//用于接受运行期泛型类型
public BaseDaoImpl(){
//获得当前类型的带有泛型类型的父类
ParameterizedType ptClass = (ParameterizedType) this.getClass().getGenericSuperclass();
//获得运行期的泛型类型
clazz = (Class) ptClass.getActualTypeArguments()[0];
}
public void save(T t){
getHibernateTemplate().save(t);

}
public void delete(T t){
getHibernateTemplate().delete(t);

}
public void delete(Serializable id){
T t = this.getById(id);//先取出来,再删
getHibernateTemplate().delete(t);
}
public void update(T t){
getHibernateTemplate().update(t);
}
public T getById(Serializable id){
return (T)getHibernateTemplate().get(clazz,id);
}
public Integer getTotalCount(DetachedCriteria dc){
//设置查询的聚合函数,总记录数
dc.setProjection(Projections.rowCount());
List<Long> list = (List<Long>) getHibernateTemplate().findByCriteria(dc);

//清空之前设置的聚合函数
dc.setProjection(null);
if(list!=null && list.size()>0){
Long count = list.get(0);
return count.intValue();

}else{
return null;
}
}
public List<T> getPageList(DetachedCriteria dc,Integer start,Integer pageSize){
List<T> list = (List<T>) getHibernateTemplate().findByCriteria(dc,start,pageSize);
return list;
}

}

public interface CustomerDao extends BaseDao<Customer>{
//删除代码,为空
}
CustomerDaoImpl extends BaseDaoImpl<Customer> //下面的方法删掉

UserDao//删掉void save方法
UserDao extends BaseDao<User>
UserDaoImpl extends BaseDaoImpl<User> implements UserDao{
//删除save方法
}
新建LinkManDao
public interface LinkManDao extends BaseDao<LinkMan>{

}
新建LinkManDaoImpl
public class LinkManDaoImpl extends BaseDaoImpl<LinkMan> implements LinkManDao{

}

伟大的程序猿csdn

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
crm第二天笔记

一.客户列表分析1.在客户列表做带有搜索功能的分页客户列表二.pageBean封装1.src下新建cn.itcast.utils包包中新建PageBeanpackage cn.itcast.utils;package cn.itcast.utils;import java.util.List;public class PageBean {
复制链接

扫一扫

专栏目录