JdbcTemplate防注入的几种方式

今天药忘吃喽~ 2021-12-04 07:55 943阅读 0赞

使用数组

public void deleteItemByName(String name) {
    
                Object[] obj = new Object[] { name};
    
                String sql = "DELETE FROM t_item WHERE name = ? ";
    
                jdbcTemplate.update(sql, obj);
    
     }

使用List最后转成Array

public void updateCompanyInfo(TCompany tCompany) {
    
                List<Object> params = new ArrayList<Object>();
    
                params.add(tCompany.getMobile());
    
                params.add(tCompany.getAddress());
    
                params.add(tCompany.getEmail());
    
                params.add(tCompany.getId() );
    
                String sql = " update T_COMPANY set mobile = ? , address = ? , email = ? where id = ? ";
    
                logger.info("sql:"+ sql);
    
                logger.info("param:"+ params.toString());
    
                jdbcTemplate.update(sql, params.toArray());  
    
            }

使用map

public List<Map<String, Object>> hasCompanyItemSize(String companyName, String deviceTypeIds, String stationPoliceIds) {
    
                Map<String,Object> params = new HashMap<String,Object>();
    
                params.put("companyName", companyName);
    
                String dynamicParam = dynamicJDBCDaoParamUtil.dynamicHasCompanyItem(deviceTypeIds, stationPoliceIds, params);
    
                String sql = " select * from t_company_item tci where 1=1   and tci.COMPANY_NAME != :companyName " + dynamicParam;
    
                logger.info("sql:"+ sql);
    
                logger.info("_param:"+ params.toString());
    
               return namedTemplate.queryForList(sql , params);
    
            }

使用javaBean

public List<Child> beanParam(){
    
            String sql = "select c.child_id childId,c.child_name,c.child_age childAge,c.parent_id parentId from child c";
    
            sql += " where c.child_age=:childAge and c.parent_id =:parentId ";
    
            sql += " and c.child_name in(:names)";
    
            ParamBean bean = new ParamBean();
    
            bean.setChildAge(childAge);
    
            bean.setParentId(parentId);
    
            bean.setNames(names);
    
            SqlParameterSource param = new BeanPropertySqlParameterSource(bean);
    
            return namedTemplate.query(sql,param,new BeanPropertyRowMapper<Child>(Child.class));
    
        }

其他  
public List<Map<String, Object>> queryCompany(String companyName) \{

String sql = " select \* from t\_company tc where 1=1   and tc.COMPANY\_NAME like  '%'|| ? ||'%'  ";

return namedTemplate.queryForList(sql , companyName == null ? "");

\}  
\---------------------   
作者：C\_JK   
来源：CSDN   
原文：https://blog.csdn.net/sinat\_33704704/article/details/86525505   
版权声明：本文为博主原创文章，转载请附上博文链接！