2023年6月21日发(作者：)

SpringNamedParameterJdbcTemplate完成数据的增删改查1、Spring配置⽂件

xmlns:p="/schema/p" xmlns:xsi="/2001/XMLSchema-instance" xmlns:aop="/schema/aop"

xmlns:context="/schema/context"

xmlns:jdbc="/schema/jdbc"

xmlns:tx="/schema/tx" xmlns:jpa="/schema/data/jpa" xsi:schemaLocation=" /schema/beans /schema/beans/ /schema/aop /schema/aop/ /schema/context /schema/context/ /schema/jdbc /schema/jdbc/ /schema/tx /schema/tx/ /schema/data/jpa /schema/data/jpa/"

default-lazy-init="true">

${} ${} ${me} ${rd}

2、持久类操作数据库代码package ;import p;import ;import ce;import per;import opertySqlParameterSource;import arameterJdbcTemplate;import ameterSource;import terizedBeanPropertyRowMapper;import tory;@Repositorypublic class JdbcSpitterDao {

@Resource private NamedParameterJdbcTemplate jdbcTemplate; //插⼊数据的sql private static final String ADD_SQL="insert into tbl_c3p0(name,address,age) values(:name,:address,:age)"; //根据id获取user对象 private static final String QUERY_SQL="select id,name,address,age from tbl_c3p0 where id=:id"; //修改user对象 private static final String UPDATE_SQL="update tbl_c3p0 set name=:name,address=:address,age=:age where id=:id"; //根据id删除user对象 private static final String DELETE_SQL="delete from tbl_c3p0 where id=:id"; /** * 插⼊数据 */ public void add(User user){ Map paramMap = new HashMap<>(); ("name", e()); ("address", ress()); ("age", ()); (ADD_SQL, paramMap); } /** * 获取User对象 */ public User queryById(int id){ Map paramMap = new HashMap<>(); ("id", id); RowMapper rm = tance(); return orObject(QUERY_SQL, paramMap, rm); } /** * 根据User对象进⾏查找 */ public User queryByUser(User user){ SqlParameterSource ps = new BeanPropertySqlParameterSource(user); RowMapper rm = tance(); return orObject(QUERY_SQL, ps, rm); } /** * 根据id修改user对象 */ public void update(User user){ SqlParameterSource ps=new BeanPropertySqlParameterSource(user); (UPDATE_SQL, ps); } /** * 根据id删除user对象 */ public void delete(int id){ Map paramMap = new HashMap<>(); ("id", id); (DELETE_SQL, paramMap); }}3、注意事项在queryById⽅法中如果这样写：public User queryById(int id){ Map paramMap = new HashMap<>(); ("id", id); return orObject(QUERY_SQL, paramMap, ); }就会报：这样的问题

2023年6月21日发(作者：)

SpringNamedParameterJdbcTemplate完成数据的增删改查1、Spring配置⽂件

xmlns:p="/schema/p" xmlns:xsi="/2001/XMLSchema-instance" xmlns:aop="/schema/aop"

xmlns:context="/schema/context"

xmlns:jdbc="/schema/jdbc"

xmlns:tx="/schema/tx" xmlns:jpa="/schema/data/jpa" xsi:schemaLocation=" /schema/beans /schema/beans/ /schema/aop /schema/aop/ /schema/context /schema/context/ /schema/jdbc /schema/jdbc/ /schema/tx /schema/tx/ /schema/data/jpa /schema/data/jpa/"

default-lazy-init="true">

${} ${} ${me} ${rd}

2、持久类操作数据库代码package ;import p;import ;import ce;import per;import opertySqlParameterSource;import arameterJdbcTemplate;import ameterSource;import terizedBeanPropertyRowMapper;import tory;@Repositorypublic class JdbcSpitterDao {

@Resource private NamedParameterJdbcTemplate jdbcTemplate; //插⼊数据的sql private static final String ADD_SQL="insert into tbl_c3p0(name,address,age) values(:name,:address,:age)"; //根据id获取user对象 private static final String QUERY_SQL="select id,name,address,age from tbl_c3p0 where id=:id"; //修改user对象 private static final String UPDATE_SQL="update tbl_c3p0 set name=:name,address=:address,age=:age where id=:id"; //根据id删除user对象 private static final String DELETE_SQL="delete from tbl_c3p0 where id=:id"; /** * 插⼊数据 */ public void add(User user){ Map paramMap = new HashMap<>(); ("name", e()); ("address", ress()); ("age", ()); (ADD_SQL, paramMap); } /** * 获取User对象 */ public User queryById(int id){ Map paramMap = new HashMap<>(); ("id", id); RowMapper rm = tance(); return orObject(QUERY_SQL, paramMap, rm); } /** * 根据User对象进⾏查找 */ public User queryByUser(User user){ SqlParameterSource ps = new BeanPropertySqlParameterSource(user); RowMapper rm = tance(); return orObject(QUERY_SQL, ps, rm); } /** * 根据id修改user对象 */ public void update(User user){ SqlParameterSource ps=new BeanPropertySqlParameterSource(user); (UPDATE_SQL, ps); } /** * 根据id删除user对象 */ public void delete(int id){ Map paramMap = new HashMap<>(); ("id", id); (DELETE_SQL, paramMap); }}3、注意事项在queryById⽅法中如果这样写：public User queryById(int id){ Map paramMap = new HashMap<>(); ("id", id); return orObject(QUERY_SQL, paramMap, ); }就会报：这样的问题