分类： Java
2009-05-05 21:21:30
前段时间在网上查找spring的相关资料,结果发现一篇自己06年写的技术文章,^_^ 相当的意外
以下是相关的地址
http://biqimahairitai.blog.163.com/blog/static/2241075220084231083423/
spring开源项目的应用(1)- -
1.新建一个webapp项目，然后在webapp\WEB-INF\src下新建一个xml文件applicationContext.xml
class="com.zj.mtn.biz.CommisionSprHandler" singleton="false">
2.新建包com.zj.common
BaseDAO.java
package com.zj.common;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
// Referenced classes of package com.sinosoft.common:
// DAO
public class BaseDAO implements DAO {
public BaseDAO() {
}
public DataSource getDataSource() {
return dataSource;
}
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
public List queryWithJDBC(String sql) {
JdbcTemplate jTemplate = new JdbcTemplate(getDataSource());
return jTemplate.queryForList(sql);
}
public int queryForInt(String sql) {
JdbcTemplate jTemplate = new JdbcTemplate(getDataSource());
return jTemplate.queryForInt(sql);
}
public void excute(String sql) {
JdbcTemplate jTemplate = new JdbcTemplate(getDataSource());
jTemplate.execute(sql);
}
private DataSource dataSource;
}
DAO.java
package com.zj.common;
import java.util.List;
public interface DAO {
public abstract List queryWithJDBC(String s);
public abstract int queryForInt(String s);
public abstract void excute(String s);
}
BeanFactory.java
package com.zj.common;
import java.io.IOException;
import java.net.URL;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.InputStreamResource;
// Referenced classes of package com.sinosoft.common:
// Loader
public final class BeanFactory {
public BeanFactory() {
}
public static Object getBean(String beanName) {
return factory.getBean(beanName);
}
private static Logger logger;
static XmlBeanFactory factory = null;
static {
logger = Logger.getLogger(com.zj.common.BeanFactory.class);
URL url = Loader.getResource("applicationContext.xml");
try {
org.springframework.core.io.Resource is = new InputStreamResource(
url.openStream());
factory = new XmlBeanFactory(is);
} catch (IOException e) {
logger.error("create beanFactory error !");
throw new RuntimeException(e);
}
}
}
Loader.java
package com.zj.common;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.net.URL;
import org.apache.log4j.Logger;
public class Loader {
public Loader() {
}
public static URL getResource(String resource) {
ClassLoader classLoader = null;
URL url = null;
try {
classLoader = getTCL();
if (classLoader != null) {
url = classLoader.getResource(resource);
if (url != null)
return url;
}
classLoader = com.zj.common.Loader.class.getClassLoader();
if (classLoader != null) {
url = classLoader.getResource(resource);
if (url != null)
return url;
}
} catch (IllegalArgumentException e) {
log.warn("Error on load [" + resource + "]", e);
} catch (IllegalAccessException e) {
log.warn("Error on load [" + resource + "]", e);
} catch (InvocationTargetException e) {
log.warn("Error on load [" + resource + "]", e);
}
return ClassLoader.getSystemResource(resource);
}
private static ClassLoader getTCL() throws IllegalArgumentException,
IllegalAccessException, InvocationTargetException {
Method method = null;
try {
method = java.lang.Thread.class.getMethod("getContextClassLoader",
null);
} catch (NoSuchMethodException e) {
return null;
}
return (ClassLoader) method.invoke(Thread.currentThread(), null);
}
private static Logger log;
static {
log = Logger.getLogger(com.zj.common.Loader.class);
}
}
ICommisionSprHandler.java
package com.zj.mtn.implnts;
import java.sql.Date;
import java.util.List;
public interface ICommisionSprHandler {
public abstract List getClkCommisionList(Date beginDate,Date endDate,String strBranchNo);
}
CommisionSprHandler.java
/*
* 创建日期 2006-6-9
*
* TODO 要更改此生成的文件的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
package com.zj.mtn.biz;
import java.sql.SQLException;
import java.util.ArrayList;
import java.sql.Date;
import java.util.*;
import java.math.BigDecimal;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.log4j.Logger;
import com.zj.mtn.implnts.*;
import com.zj.mtn.domain.ClkCommisionSprHandlerModel;
import com.zj.mtn.VO.ClkCommisionSprHandlerVO;
import com.zj.mtn.form.MtnQueryForm;
import com.zj.common.*;
/**
* @author Administrator
*
* TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
public class CommisionSprHandler implements ICommisionSprHandler {
private static Logger logger = Logger.getLogger((CommisionSprHandler.class)
.getName());
private DAO dao;
/**
* @return Returns the dao.
*/
public DAO getDao() {
return dao;
}
/**
* @param dao
* The dao to set.
*/
public void setDao(DAO dao) {
this.dao = dao;
}
public CommisionSprHandler() {
}
public List getClkCommisionList(Date beginDate, Date endDate,
String strBranchNo) {
List result = new ArrayList();
List clkCommisionList = new ArrayList();
//ClkCommisionHandlerModel aClkCommisionHandler = new ClkCommisionHandlerModel();
ClkCommisionSprHandlerVO aClkCommisionSprHandler;
StringBuffer stringbuffer = new StringBuffer();
stringbuffer
.append("select t00salesno,t03businesstype as type, t03policyno as policyno,t03insuredname as insuredname, t03payterm as payterm,t03premium as premium, t03commision as commision,t00statdate as statdate from t03_policyperday ");
stringbuffer
.append(" where t03businesstype in ('01','04','06','19') and t00salesno like '"
+ strBranchNo + "%' and t03commision <> 0 ");
stringbuffer.append(" and t00statdate between '" + beginDate
+ "' and '" + endDate + "'");
String hsql = stringbuffer.toString();
result = getDao().queryWithJDBC(hsql);
Iterator iter = result.iterator();
for (; iter.hasNext(); clkCommisionList.add(aClkCommisionSprHandler)) {
aClkCommisionSprHandler= new ClkCommisionSprHandlerVO();
Map rs = (Map) iter.next();
aClkCommisionSprHandler.setT00salesno((String) rs.get("t00salesno"));
aClkCommisionSprHandler.setType((String) rs.get("type"));
aClkCommisionSprHandler.setPolicyno((String) rs.get("policyno"));
aClkCommisionSprHandler.setInsuredname((String)rs.get("insuredname"));
aClkCommisionSprHandler.setPayterm((String) rs.get("payterm"));
aClkCommisionSprHandler.setPremium((BigDecimal) rs.get("premium"));
aClkCommisionSprHandler.setCommision((BigDecimal) rs
.get("commision"));
aClkCommisionSprHandler.setStatdate((Date) rs.get("statdate"));
}
return result;
}
public String getGbk(String str) {
try {
return new String(str.getBytes("ISO8859-1"));
} catch (Exception e) {
return str;
}
}
}
BusinessDelegate.java
package com.zj.mtn.dbUtil;
import com.zj.mtn.implnts.*;
import java.sql.*;
import java.util.List;
import com.zj.common.*;
public class BusinessDelegate
{
public BusinessDelegate()
{
}
public List getClkCommisionList(Date beginDate,Date endDate,String strBranchNo)
{
ICommisionSprHandler commisionSprHandler = (ICommisionSprHandler )BeanFactory.getBean("commisionSprHandler");
return commisionSprHandler.getClkCommisionList(beginDate,endDate,strBranchNo);
}
}
CharsetConverter.java
package com.zj.mtn.dbUtil;
public class CharsetConverter
{
public CharsetConverter()
{
}
public static String ISO8859_1ToGBK(String strOriginal)
{
if(strOriginal != null)
{
try
{
return new String(strOriginal.getBytes("ISO8859_1"), "GB2312");
}
catch(Exception exception)
{
exception.printStackTrace();
}
return strOriginal;
} else
{
return null;
}
}
public static String GBKToISO8859_1(String strOriginal)
{
if(strOriginal != null)
{
try
{
return new String(strOriginal.getBytes("GB2312"), "ISO8859_1");
}
catch(Exception exception)
{
exception.printStackTrace();
}
return strOriginal;
} else
{
return null;
}
}
public static String GBKToUTF8(String strOriginal)
{
if(strOriginal != null)
{
try
{
return new String(strOriginal.getBytes("GB2312"), "UTF-8");
}
catch(Exception exception)
{
exception.printStackTrace();
}
return strOriginal;
} else
{
return null;
}
}
}
ClkCommisionSprHandlerModel.java
/*
* 创建日期 2006-6-9
*
* TODO 要更改此生成的文件的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
package com.zj.mtn.domain;
import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.Date;
/**
* @author Administrator
*
* TODO 要更改此生成的类型注释的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
public class ClkCommisionSprHandlerModel implements Serializable {
private String t00salesno;
private String type;
private String policyno;
private String insuredname;
private String payterm;
private BigDecimal premium;
private BigDecimal commision;
private Date statdate;
/**
* @return Returns the commision.
*/
public BigDecimal getCommision() {
return commision;
}
/**
* @param commision The commision to set.
*/
public void setCommision(BigDecimal commision) {
this.commision = commision;
}
/**
* @return Returns the insuredname.
*/
public String getInsuredname() {
return insuredname;
}
/**
* @param insuredname The insuredname to set.
*/
public void setInsuredname(String insuredname) {
this.insuredname = insuredname;
}
/**
* @return Returns the payterm.
*/
public String getPayterm() {
return payterm;
}
/**
* @param payterm The payterm to set.
*/
public void setPayterm(String payterm) {
this.payterm = payterm;
}
/**
* @return Returns the policyno.
*/
public String getPolicyno() {
return policyno;
}
/**
* @param policyno The policyno to set.
*/
public void setPolicyno(String policyno) {
this.policyno = policyno;
}
/**
* @return Returns the premium.
*/
public BigDecimal getPremium() {
return premium;
}
/**
* @param premium The premium to set.
*/
public void setPremium(BigDecimal premium) {
this.premium = premium;
}
/**
* @return Returns the statdate.
*/
public Date getStatdate() {
return statdate;
}
/**
* @param statdate The statdate to set.
*/
public void setStatdate(Date statdate) {
this.statdate = statdate;
}
/**
* @return Returns the t00salesno.
*/
public String getT00salesno() {
return t00salesno;
}
/**
* @param t00salesno The t00salesno to set.
*/
public void setT00salesno(String t00salesno) {
this.t00salesno = t00salesno;
}
/**
* @return Returns the type.
*/
public String getType() {
return type;
}
/**
* @param type The type to set.
*/
public void setType(String type) {
this.type = type;
}
public ClkCommisionSprHandlerModel(String t00salesno, String type, String policyno, String insuredname, String payterm, BigDecimal premium, BigDecimal commision, Date statdate) {
super();
// TODO Auto-generated constructor stub
this.t00salesno = t00salesno;
this.type = type;
this.policyno = policyno;
this.insuredname = insuredname;
this.payterm = payterm;
this.premium = premium;
this.commision = commision;
this.statdate = statdate;
}
public ClkCommisionSprHandlerModel() {
super();
// TODO Auto-generated constructor stub
}
}
ClkCommisionSprHandlerVO.java
/*
* 创建日期 2006-6-9
*
* TODO 要更改此生成的文件的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
package com.zj.mtn.VO;
import java.io.Serializable;
import java.sql.Date;
import java.math.BigDecimal;
import com.zj.indemqry.pub.StringUtil;
/**
* @author Administrator
*
* TODO 要更改此生成的类型注释的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
public class ClkCommisionSprHandlerVO {
private int colId;
private String urlLink;
private String trClassName;
private String t00salesno;
private String type;
private String policyno;
private String insuredname;
private String payterm;
private BigDecimal premium;
private BigDecimal commision;
private Date statdate;
/**
* @return Returns the colId.
*/
public int getColId() {
return colId;
}
/**
* @param colId The colId to set.
*/
public void setColId(int colId) {
this.colId = colId;
}
/**
* @return Returns the commision.
*/
public BigDecimal getCommision() {
return commision;
}
/**
* @param commision The commision to set.
*/
public void setCommision(BigDecimal commision) {
this.commision = commision;
}
/**
* @return Returns the insuredname.
*/
public String getInsuredname() {
return insuredname;
}
/**
* @param insuredname The insuredname to set.
*/
public void setInsuredname(String insuredname) {
this.insuredname = insuredname;
}
/**
* @return Returns the payterm.
*/
public String getPayterm() {
return payterm;
}
/**
* @param payterm The payterm to set.
*/
public void setPayterm(String payterm) {
this.payterm = payterm;
}
/**
* @return Returns the policyno.
*/
public String getPolicyno() {
return policyno;
}
/**
* @param policyno The policyno to set.
*/
public void setPolicyno(String policyno) {
this.policyno = policyno;
}
/**
* @return Returns the premium.
*/
public BigDecimal getPremium() {
return premium;
}
/**
* @param premium The premium to set.
*/
public void setPremium(BigDecimal premium) {
this.premium = premium;
}
/**
* @return Returns the statdate.
*/
public Date getStatdate() {
return statdate;
}
/**
* @param statdate The statdate to set.
*/
public void setStatdate(Date statdate) {
this.statdate = statdate;
}
/**
* @return Returns the t00salesno.
*/
public String getT00salesno() {
return t00salesno;
}
/**
* @param t00salesno The t00salesno to set.
*/
public void setT00salesno(String t00salesno) {
this.t00salesno = t00salesno;
}
/**
* @return Returns the trClassName.
*/
public String getTrClassName() {
return trClassName;
}
/**
* @param trClassName The trClassName to set.
*/
public void setTrClassName(String trClassName) {
this.trClassName = trClassName;
}
/**
* @return Returns the type.
*/
public String getType() {
return type;
}
/**
* @param type The type to set.
*/
public void setType(String type) {
this.type = type;
}
/**
* @return Returns the urlLink.
*/
public String getUrlLink() {
return urlLink;
}
/**
* @param urlLink The urlLink to set.
*/
public void setUrlLink(String urlLink) {
this.urlLink = urlLink;
}
}
/*
* 创建日期 2006-1-20
*程序员：zjnubridge
* TODO 要更改此生成的文件的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
package com.zj.mtn.action;
import java.sql.SQLException;
import java.util.TreeMap;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.zj.mtn.dbUtil.BusinessDelegate;
import com.zj.login.domain.UserAccount;
import com.zj.mtn.VO.*;
import com.zj.mtn.biz.*;
import com.zj.mtn.biz.MtnQueryLogic;
import com.zj.mtn.biz.MtnRevQueryLogic;
import com.zj.mtn.biz.Zj01ClkSumPremLogic;
import com.zj.mtn.domain.*;
import com.zj.mtn.domain.StaDataList;
import com.zj.mtn.domain.ZjStaDataList;
import com.zj.mtn.form.MtnQueryForm;
import com.zj.mtn.action.ZJLBB02;
import com.zj.mtn.domain.StaData;
import com.zj.util.*;
import java.sql.Date;
/**
* @author Administrator
*
* TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
public class MtnQueryAction extends Action {
// --------------------------------------------------------- Instance
// Variables
// --------------------------------------------------------- Methods
private static Log log = LogFactory.getLog(MtnQueryAction.class);
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest request,
HttpServletResponse httpServletResponse) throws SQLException {
MtnQueryForm mtnQueryForm = (MtnQueryForm) actionForm;
UserAccount aUserAccount=(UserAccount)request.getSession().getAttribute("USERACCOUNT");
/*
* 使用spring做数据库底层逻辑
*
**/
if (mtnQueryForm.getSelect().equals("mtn110-1")) {
BusinessDelegate bd = new BusinessDelegate();
Date beginDate=mtnQueryForm.getProcDateStart();
Date endDate=mtnQueryForm.getProcDateEnd();
String strBranchNo=mtnQueryForm.getAcceptBranchNo();
List resultList = bd.getClkCommisionList(beginDate,endDate,strBranchNo);
log.info("======================================");
log.info("userCode:" + aUserAccount.getUserCode());
log.info("userName:" + aUserAccount.getUserName());
log.info("userBranch:" + aUserAccount.getBranchName());
log.info("userDeptName:" + aUserAccount.getDeptName());
log.info("operate:查询xxxxxxxxxx");
log.info("current time:" + DateTimeUtil.getCurrentSysDate() + " "
+ DateTimeUtil.getCurrentSysTime());
log.info("beginDate:" + mtnQueryForm.getProcDateStart());
log.info("endDate:" + mtnQueryForm.getProcDateEnd());
log.info("branchNo:" + mtnQueryForm.getAcceptBranchNo());
log.info("sayWay:" + mtnQueryForm.getSaleWay());
log.info("back record amount :" + resultList.size());
log.info("======================================");
int i = 0;
for (int j = 0; j < resultList.size(); j++) {
System.out.println("111");
ClkCommisionHandlerVO std = (ClkCommisionHandlerVO) resultList
.get(j);
System.out.println("sdf");
std.setColId(j + 1);
if (i == 0) {
std.setTrClassName("odd");
i++;
} else {
std.setTrClassName("even");
i = 0;
}
}
request.getSession().setAttribute("clkCommisionHandlerList",
resultList);
request.getSession().setAttribute("acceptBranchNo",
mtnQueryForm.getAcceptBranchNo());
request.getSession().setAttribute("procDateStart",
mtnQueryForm.getProcDateStart());
request.getSession().setAttribute("procDateEnd",
mtnQueryForm.getProcDateEnd());
request.getSession().setAttribute("saleWay",
mtnQueryForm.getSaleWay());
System.out.println("fsdsfsdfhgfdshd");
return (actionMapping.findForward("mtn110"));
}
return (actionMapping.findForward("error"));
} //end doExecute()
}
