JdbcTemplate

1.导入依赖

<dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.15</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.8.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.0.8.RELEASE</version>
        </dependency>
    </dependencies>

2.配置数据库连接信息

jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/db
jdbc.username = root
jdbc.password = 123456

3.配置数据源和jdbcTemplate

  <context:component-scan base-package="com.yhx"></context:component-scan>
    <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
    <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <bean class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="druidDataSource"></property>
    </bean>

4.编写UserDao接口

public interface UserDao {
    public int insert(User user);
    public int update(User user);
    public int delete(User user);
    public int selectCount();
    public User selectOne(int id);
    public List<User> selectAll();
}

5.编写UserDaoImpl接口实现类

@Repository
public class UserDaoImpl implements UserDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    //插入操作
    public int insert(User user) {
        return jdbcTemplate.update("insert into tbl_user values(?, ?, ?)", user.getId(), user.getName(), user.getAge());
    }
    //修改操作
    public int update(User user) {
        return jdbcTemplate.update("update tbl_user set name = ?, age = ? where id = ?",user.getName(),user.getAge(),user.getId());
    }
    //删除操作
    public int delete(User user) {
        return jdbcTemplate.update("delete from tbl_user where id = ?",user.getId());
    }
    //查询值
    public int selectCount() {
        return jdbcTemplate.queryForObject("select count(*) from tbl_user",Integer.class);
    }
    //查询对象
    public User selectOne(int id) {
        return jdbcTemplate.queryForObject("select * from tbl_user where id = ?",new BeanPropertyRowMapper<User>(User.class),id);
    }
    //查询集合
    public List<User> selectAll() {
        return jdbcTemplate.query("select * from tbl_user",new BeanPropertyRowMapper<User>(User.class));
    }
}