JdbcTemplate里的常用方法

query

public List<Map<String, Object>> findInceptionPlanList(Long pageStart, Long maxResult, HttpServletRequest request) {

        List<Object> params = new ArrayList<Object>();

           String dynamicParam = dynamicJDBCDaoParamUtil.dynamicFindInceptionPlanList(request, params);

           String sql =  "SELECT t.id, t.planname, t.planType, t.planCycle, t.deviceType_Id, t.device_Id from ( SELECT a1.*, ROWNUM rn FROM ("+

                " select * from T_INSPECTION_PLAN  "+

                   " where 1=1 "+ dynamicParam + " ) a1 WHERE rownum  <= ? ) t WHERE rn > ?   order by id";

           params.add(maxResult);

           params.add(pageStart);

           logger.info("sql:"+ sql);

           logger.info("param:"+ params.toString());

        List<Map<String, Object>> list = jdbcTemplate.query(sql, params.toArray(), new InceptionConfigInfoRowMapper());

        return list;

 }

       

        private class InceptionConfigInfoRowMapper implements RowMapper<Map<String,Object>> {

 

           public Map<String,Object> mapRow(ResultSet rowSet, int rowNum)

                   throws SQLException {

               Map<String,Object> map = new HashMap<String, Object>();

               map.put("id", rowSet.getInt("id"));

               map.put("planname", rowSet.getString("planname"));

               map.put("planType", rowSet.getInt("planType"));

               map.put("planCycle", rowSet.getInt("planCycle"));

               map.put("deviceTypeId", rowSet.getInt("deviceType_Id"));

               map.put("deviceId", rowSet.getInt("device_Id"));

               return map;

           }      

        }

queryForList

public List getXXXList() {

        String sql = "select  * from t_item  ";

        return this.jdbcTemplate.queryForList(sql, errorsheetId);

    }

queryForObject

public Long isRepeatInspection(TInspectionPlan tInspectionPlan) {

            List<Object> params = new ArrayList<Object>();

           String dynamicParam = dynamicJDBCDaoParamUtil.dynamicIsRepeatInspection(tInspectionPlan, params);

            String sql =  " select count(*) FROM T_INSPECTION_PLAN "+ dynamicParam;

            logger.info("sql:"+ sql);

            logger.info("param:"+ params.toString());

           return  jdbcTemplate.queryForObject(sql , params.toArray(),Long.class);

}

 

Execute

调用存储过程

public void XXX() {

            String sql =  " DECLARE BEGIN P_CREATE_CONCLUSION();END; ";

            jdbcTemplate.execute(sql);

}

Update

public void addItem(TItem Item) {

            jdbcTemplate.update("INSERT INTO t_item (id, name, itemId, type) VALUES(?, ?, ?, ?)",

                new Object[] {Item.getId(), Item.getName(), Item.getItemId(), Item.getType()}); 

}

public void deleteItemByName(String name) {

            Object[] obj = new Object[] { name};

            String sql = "DELETE FROM t_item WHERE name = ? ";

            jdbcTemplate.update(sql, obj);

}