首页 > 代码库 > 小学期第二次作业

小学期第二次作业

这几天,我们做出了客户信息主界面以及客户信息存储、查询、修改、删除功能。

首先,建立一个applicationContext

<?xml version="1.0" encoding="UTF-8"?>

<beans

xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

<property name="driverClassName" value="http://www.mamicode.com/com.mysql.jdbc.Driver"></property>

<property name="url" value="http://www.mamicode.com/jdbc:mysql://localhost:3306/dbssh"></property>

<property name="username" value="http://www.mamicode.com/root"></property>

<property name="password" value="http://www.mamicode.com/123456"></property>

<property name="maxActive" value="http://www.mamicode.com/100"></property>

<property name="maxWait" value="http://www.mamicode.com/500"></property>

<property name="defaultAutoCommit" value="http://www.mamicode.com/true"></property>

</bean>

 

 

<bean id="sessionFactory"

class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="dataSource" ref="dataSource"></property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.dialect">

org.hibernate.dialect.MySQLDialect

</prop>

<prop key="hibernate.show_sql">true</prop>

</props>

</property>

<property name="mappingResources">

<list>

<value>com/crm/bean/Cust.hbm.xml</value>

</list>

</property>

</bean>

 

<bean id="custDao" class="com.crm.impl.CustDaoImpl">

<property name="sessionFactory">

<ref bean="sessionFactory"/>

</property>

</bean>

 

<bean id="custService" class="com.crm.service.impl.CustServiceImpl">

<property name="custDao" ref="custDao"></property>

</bean>

 

<!-- 配置action -->

<bean id="custSaveAction" class="com.crm.action.CustSaveAction">

<property name="service">

<ref bean="custService"/>

</property>

</bean>

 

<bean id="listCustAction" class="com.crm.action.ListCustAction">

<property name="service">

<ref bean="custService"/>

</property>

</bean>

 

<bean id="findCustByCdAction" class="com.crm.action.FindCustByCdAction">

<property name="findCdService">

<ref bean="custService"/>

</property>

</bean>

 

<!--配置-删除deleteAction  -->

<bean id="removeCustAction" class="com.crm.action.RemoveCustAction">

<property name="service">

<ref bean="custService"/>

</property>

</bean>

</beans>

 

其次,在src目录下建立actionbeandaoimplservice等类,其作用是对客户信息的录入、查询、修改、删除等操作,为此,我们要先建立一个与之对应的数据库。

 技术分享

接下来,在action中建立与之对应的各项操作:

 技术分享

package com.crm.action;

 

import com.crm.bean.Cust;

import com.crm.service.CustService;

import com.opensymphony.xwork2.ActionSupport;

 

public class CustSaveAction  extends ActionSupport{

  

 

    private CustService service;

    private Cust cust;

    public Cust getCust() {

        return cust;

    }

 

    public void setCust(Cust cust) {

        this.cust = cust;

    }

 

    public CustService getService() {

        return service;

    }

 

    public void setService(CustService service) {

        this.service = service;

        

    }

    

    @Override

    public String execute() throws Exception {

        // TODO Auto-generated method stub

        this.service.saveCustomer(cust);

        return SUCCESS;

    }

    

 

}

 

package com.crm.action;

 

import java.util.Map;

 

import com.crm.bean.Cust;

import com.crm.service.CustService;

import com.opensymphony.xwork2.ActionContext;

import com.opensymphony.xwork2.ActionSupport;

 

public class FindCustByCdAction extends ActionSupport{

private Cust cust;

private CustService findCdService;

public Cust getCust() {

return cust;

}

public void setCust(Cust cust) {

this.cust = cust;

}

public CustService getFindCdService() {

return findCdService;

}

public void setFindCdService(CustService findCdService) {

this.findCdService = findCdService;

}

@SuppressWarnings({ "unchecked", "unchecked" })

@Override

public String execute() throws Exception {

// TODO Auto-generated method stub

Map map=(Map)ActionContext.getContext().get("request");

map.put("list",this.findCdService.findCustByCondition(cust));

 

return SUCCESS;

}

 

 

}

 

package com.crm.action;

 

import java.util.Map;

 

import com.crm.bean.Cust;

import com.crm.service.CustService;

import com.opensymphony.xwork2.ActionContext;

import com.opensymphony.xwork2.ActionSupport;

 

public class ListCustAction extends ActionSupport {

private Cust cust;

private CustService service;

 

public void setService(CustService service)

{

this.service=service;

}

@Override

public String execute() throws Exception {

// TODO Auto-generated method stub

Map map=(Map)ActionContext.getContext().get("request");

map.put("list", this.service.findAllCust());

 

return SUCCESS;

}

public Cust getCust() {

return cust;

}

public void setCust(Cust cust) {

this.cust = cust;

}

 

 

}

package com.crm.action;

 

import com.crm.bean.Cust;

import com.crm.service.CustService;

import com.opensymphony.xwork2.ActionSupport;

 

public class RemoveCustAction extends  ActionSupport{

private Cust cust;

private CustService service;

 

public void setService(CustService service) {

this.service = service;

}

 

public Cust getCust() {

return cust;

}

 

public void setCust(Cust cust) {

this.cust = cust;

}

 

@SuppressWarnings("unchecked")

@Override

public String execute() throws Exception {

this.service.removeCustomer(cust);

return SUCCESS;

}

 

}

接下来,要与之建立相应的映射关系:

package com.crm.impl;

 

import java.util.List;

 

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

 

import com.crm.bean.Cust;

import com.crm.dao.CustDao;

 

public class CustDaoImpl extends HibernateDaoSupport  implements CustDao {

 

public List<Cust> findAllCust() {

// TODO Auto-generated method stub

String hql="from Cust cust order by cust.id desc";

return (List<Cust>)this.getHibernateTemplate().find(hql);

}

 

public Cust findCustomerById(Integer id) {

// TODO Auto-generated method stub

Cust cust=(Cust)this.getHibernateTemplate().get(Cust.class,id);

return null;

}

 

public void removeCustomer(Cust cust) {

// TODO Auto-generated method stub

this.getHibernateTemplate().delete(cust);

 

}

 

public void saveCustomer(Cust cust) {

// TODO Auto-generated method stub

this.getHibernateTemplate().save(cust);

}

 

public List<Cust> findCustByCondition(Cust cust) {

// TODO Auto-generated method stub

StringBuffer strBuffer=new StringBuffer();

String hql="from Cust cust where 1=1 ";

strBuffer.append(hql);

 

if(cust==null){

throw new NullPointerException("查询条件不能为空");

}

if(!"".equals(cust.getCustname())){

 

String custname="and custname = ‘"+cust.getCustname()+"‘ ";

strBuffer.append(custname);

}

if(!"".equals(cust.getCustnumber())){

 

String custnumber="and custnumber = ‘"+cust.getCustnumber()+"‘ ";

strBuffer.append(custnumber);

}

if(!"".equals(cust.getCustphone())){

 

String custphone="and custphone = ‘"+cust.getCustphone()+"‘ ";

strBuffer.append(custphone);

}

String orderBy="order by cust.id desc";

 

strBuffer.append(orderBy);

List<Cust> custList=this.getHibernateTemplate().find(strBuffer.toString());

 

 

return custList;

}

}

 

成品如图所示:

 技术分享

技术分享

技术分享

 

小学期第二次作业