JdbcDaoSupport操作

org.springframework.jdbc.core.support.JdbcDaoSupport

生产环境：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">        <property name="jndiName"><value>java:jdbc/msiupdate</value></property>        <property name="resourceRef"><value>true</value></property>    </bean></beans>

测试环境：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>    <bean id="dataSource"        class="org.apache.commons.dbcp.BasicDataSource">        <property name="driverClassName">            <value>oracle.jdbc.driver.OracleDriver</value>        </property>        <property name="url">            <value>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=xxx)))(CONNECT_DATA=(SERVICE_NAME=msi)(SERVER=DEDICATED)))            </value>        </property>        <property name="username">            <value>xx</value>        </property>        <property name="password">            <value>xxx</value>        </property>    </bean></beans>

spring配置文件

<bean id="updateToolDao" class="com.travelsky.msi.dao.impl.MsiUpdateToolDao">        <property name="dataSource">            <ref bean="dataSource"/>        </property>    </bean>

java类：

public class MsiUpdateToolDao extends JdbcDaoSupport implements        IMsiUpdateToolDao {    final Logger log = LogManager.getLogger(MsiUpdateToolDao.class);    public static  final SimpleDateFormat sdf=UpdateBaseBean.sdf;    class VersionRowMapper implements RowMapper{        public Object mapRow(ResultSet rs, int index) throws SQLException {            UpdateVersionBean bean=new UpdateVersionBean();            bean.setSeqID(rs.getString("id"));            bean.setClientType(rs.getString("VERSION_TYPE"));            bean.setVersionNum(rs.getString("VERSION_NUM"));            bean.setBaseVersionNum(rs.getString("BASE_VERSION_NUM"));            bean.setAppNameVerNum(rs.getString("APPS_NAME_VERNUM"));            bean.setVerComments(rs.getString("VER_COMMENT"));            bean.setVerTm(sdf.format(rs.getTimestamp("VER_TM")));            bean.setDownloadPath(rs.getString("DOWNLOAD_PATH"));            bean.setLocalDir(rs.getString("LOCAL_DIR"));            bean.setUpdTm(sdf.format(rs.getTimestamp("upd_tm")));            bean.setUpdBy(rs.getString("upd_by"));            return bean;        }    }    public int saveClientInfo(ClientInfoBean clientinfo) throws Exception {        int ret=0;        String strSql="insert into CLIENT_INFO values(seq_clientinfo_id.nextval,?,?,?,?,?,?,?,?)";        try {            ret = getJdbcTemplate().update(strSql,clientinfo.toParms());            if (ret==1) {                log.info("saveClientInfo  success ! ");            }        } catch (Exception e) {            log.error("saveClientInfo with a  Exception", e);            throw e;        }        return ret;    }    public List<UpdateVersionBean> getVersionID(String versionNum,            String clientType) throws Exception {        // TODO Auto-generated method stub        List<UpdateVersionBean> versionlist=null;        String sql="select av.id,av.version_type,av.version_num,av.base_version_num,av.apps_name_vernum,av.ver_comment,av.ver_tm,av.download_path,av.local_dir,av.upd_tm,av.upd_by  from MSI_SYS_AUTOUPDATE_VERISON av where  av.version_num=? and av.version_type=?";        versionlist= getJdbcTemplate().query(sql,new Object[]{versionNum,clientType},new VersionRowMapper());        return versionlist;    }    public int updateClientInfo(ClientInfoBean ci) throws Exception {        // TODO Auto-generated method stub        int ret=0;        StringBuilder sb=new StringBuilder("update CLIENT_INFO c set c.upd_tm=?,c.upd_by=?,c.client_ip=?,c.client_airline=?,c.client_airport=?");        List<Object> parms=new ArrayList<Object>();        parms.add(ci.getUpdTmTimestamp());        parms.add(ci.getUpdBy());        parms.add(ci.getClientIP());        parms.add(ci.getAirline());        parms.add(ci.getAirport());        if (ci.getClientGroup()!=null&&!"".equals(ci.getClientGroup())) {            sb.append(",c.client_group=?");            parms.add(ci.getClientGroup());        }        sb.append("  where c.client_id=? and c.client_type=?");        parms.add(ci.getClientID());        parms.add(ci.getClientType());        try {            ret = getJdbcTemplate().update(sb.toString(),parms.toArray());            if (ret==0) {                log.error("updateClientInfo failed ,0 rows update");            }        } catch (DataAccessException e) {            log.error("updateClientInfo with a DataAccessException", e);            throw e ;        } catch (Exception e) {            log.error("updateClientInfo with a unexpected Exception", e);            throw e ;        }        return ret;    }}