spring中使用jdbcTemplate进行配置

整合的上次项目，具体在这里
这次项目整合所用的项目为上个项目，只在spring中做了修改，运用了jdbcTemplate

spring配置文件

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="username" value="root"></property>
        <property name="password" value="密码"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/newtest"></property>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    </bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

接下来进行测试
jdbcTemplate 的 query方法
RowMapper<T>() 和 ResultSetExtractor<T>()两种方法回调

//用JdbcTemplate进行查询 回调的方法是RowMapper<UserBean>()
    public static void test2() {
        ApplicationContext context = 
                new ClassPathXmlApplicationContext("test.xml");
        JdbcTemplate jdbcTemplate  =  (JdbcTemplate) context.getBean("jdbcTemplate");
        String sql = "select * from userbean where uid=1";
        UserBean user = new UserBean();
        //需要进行强转
        UserBean o = (UserBean) jdbcTemplate.query(sql,new RowMapper<UserBean>() {
            @Override
            public UserBean mapRow(ResultSet rs, int index) throws SQLException {
                // TODO Auto-generated method stub
                user.setUid(rs.getInt("uid"));
                user.setName(rs.getString("name"));
                user.setPwd(rs.getString("pwd"));
                return user;
            }
            //因为返回的是数组所以需要获取一条数据
        }).get(0);

        System.out.println("test2"+o);
    }
    //用JdbcTemplate进行查询 回调的方法是ResultSetExtractor<UserBean>()
    public static void test3() {
        ApplicationContext context = 
                new ClassPathXmlApplicationContext("test.xml");
        JdbcTemplate jdbcTemplate  =  (JdbcTemplate) context.getBean("jdbcTemplate");
        String sql = "select * from userbean where uid=2";
        UserBean user = new UserBean();
        //用Object时 实体类中需要有toString方法
        Object o = jdbcTemplate.query(sql,new ResultSetExtractor<UserBean>() {

            @Override
            public UserBean extractData(ResultSet rs) throws SQLException, DataAccessException {
                while(rs.next()) {
                    user.setUid(rs.getInt("uid"));
                    user.setName(rs.getString("name"));
                    user.setPwd(rs.getString("pwd"));
                }
                return user;
            }

        });

        System.out.println("test3"+o);
    }
    //用JdbcTemplate进行查询 回调的方法是ResultSetExtractor<UserBean>() 返回的值是Object
    public static void test4() {
        ApplicationContext context = 
                new ClassPathXmlApplicationContext("test.xml");
        JdbcTemplate jdbcTemplate  =  (JdbcTemplate) context.getBean("jdbcTemplate");
        String sql = "select * from userbean where uid=2";
        UserBean user = new UserBean();
        Object o = jdbcTemplate.query(sql,new RowMapper<UserBean>() {

            @Override
            public UserBean mapRow(ResultSet rs, int index) throws SQLException {
                // TODO Auto-generated method stub
                user.setUid(rs.getInt("uid"));
                user.setName(rs.getString("name"));
                user.setPwd(rs.getString("pwd"));
                return user;
            }
        });

        System.out.println("test4"+o);
    }