Spring -JDBC

package mysql;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created by Administrator on 2017/6/5.
 */
public class Conn {
    public void mysqlAction(){

//        设置数据库信息
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/test");
        dataSource.setPassword("123456");
        dataSource.setUsername("root");
//        设置JdbcTemplate对象
        JdbcTemplate jt = new JdbcTemplate(dataSource);
//        利用JdbcTemplate方法进行操作
//        String sql = "insert into user values (?,?)";
//       int row =  jt.update(sql,"张三","210");
//        System.out.println(row);
//        查询
        String sqlSelect = "select * from user where age = ?";
        person p = jt.queryForObject(sqlSelect, new Mymap(), "21");
        System.out.println(p);
    }
}

class Mymap implements RowMapper<person>{

    @Override
    public person mapRow(ResultSet rs, int i) throws SQLException {
//        从结果获取信息
        String name = rs.getString("name");
        String age = rs.getString("age");
//        将信息封装到对象中
        person p = new person();
        p.setName(name);
        p.setAge(age);
        return p;
    }
}

Spring查询！