JDBCTemplate操作

爱被打了一巴掌 2023-07-08 14:28 13阅读 0赞

@Repository
    public class MemberDao {
    	
    	private JdbcTemplate template;
    	
    	@Resource(name="dataSource")
    	public void setDataSource(DataSource dataSource){
    		template = new JdbcTemplate(dataSource);
    	}
    	
    	
    	public List<Member> select(){
    		
    		return template.query("select * from t_member", new RowMapper(){
    
    			@Override
    			public Member mapRow(ResultSet rs, int rowNum) throws SQLException {
    				Member m = new Member();
    				m.setId(rs.getLong("id"));
    				m.setName(rs.getString("name"));
    				return m;
    			}
    			
    		});
    		
    	}
    	
    	
    	public int insert(String name) throws Exception{
    		return template.update("insert into t_member(name) values(?)",name);
    	}
    	
    	
    	public int delete(long id) throws Exception{
    		return template.update("delete from t_member where id = ?",id);
    	}
    	
    	
    	public int update(long id,String name) throws Exception{
    		return template.update("update t_member set name = ? where id = ?",name,id);
    	}
    	
    }

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource"/>
    	</bean>
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>