当前位置：Gxlcms > 数据库问题 > spring4-4-jdbc-02

spring4-4-jdbc-02

时间：2021-07-01 10:21:17 帮助过：4人阅读

com.l1.spring.jdbc; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; @Repository public class EmployeeDao { @Autowired private JdbcTemplate jdbcTemplate; public Employee get(int id){ String sql = "select id,name,email from employees where id=?"; RowMapper<Employee> rowMapper = new BeanPropertyRowMapper<>(Employee.class); Employee employee = jdbcTemplate.queryForObject(sql, rowMapper,id); return employee; } }

第四条使用:

<span style="color: #008000;">/**</span><span style="color: #008000;">
 * 不推荐使用 JdbcDaoSupport, 而推荐直接使用 JdbcTempate 作为 Dao 类的成员变量
 </span><span style="color: #008000;">*/</span><span style="color: #000000;">
@Repository
</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span> DepartmentDao <span style="color: #0000ff;">extends</span><span style="color: #000000;"> JdbcDaoSupport{
    @Autowired
    </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> setDataSource2(DataSource dataSource){
        setDataSource(dataSource);
    }
    </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> Department get(Integer id){
        String sql </span>= "SELECT id, dept_name name FROM departments WHERE id = ?"<span style="color: #000000;">;
        RowMapper</span><Department> rowMapper = <span style="color: #0000ff;">new</span> BeanPropertyRowMapper<>(Department.<span style="color: #0000ff;">class</span><span style="color: #000000;">);
        </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> getJdbcTemplate().queryForObject(sql, rowMapper, id);
    }
    
}</span>

spring4-4-jdbc-02

标签：

spring4-4-jdbc-02

人气教程排行