Spring jdbcTemplat插入，查询

来源：互联网发布：网络培训计划编辑：程序博客网时间：2024/06/04 19:53
import java.sql.ResultSet;import java.sql.SQLException;import java.util.HashMap;import java.util.Map;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowMapper;import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;public class StudentDao {private JdbcTemplate jdbcTemplate;private NamedParameterJdbcTemplate namedJdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate){this.jdbcTemplate = jdbcTemplate;}public void setNamedJdbcTemplate(NamedParameterJdbcTemplate namedJdbcTemplate){this.namedJdbcTemplate = namedJdbcTemplate;}//使用索引参数public void addStudent(Student student){String sql = "INSERT INTO student values(?,?,?)";jdbcTemplate.update(sql,student.getId(), student.getAge(),student.getName());}//使用命名参数public void addStudent2(Student student){Map<String, Object> params = new HashMap<String, Object>();params.put("id", student.getId());params.put("age", student.getAge());params.put("name", student.getName());//使用命名参数，不是传统的索引参数，命名参数通过map进行绑定String sql = "insert into student values(:id, :age,:name)";namedJdbcTemplate.update(sql, params);}public Student getStudent(int id){String sql = "select id,age,name from student where id = ?";return jdbcTemplate.queryForObject(sql, new RowMapper<Student>(){@Overridepublic Student mapRow(ResultSet rs, int rowNum) throws SQLException {Student s = new Student();s.setId(rs.getInt("id"));s.setAge(rs.getInt("age"));        s.setName(rs.getString("name"));return s;}},id);//参数绑定}}
0 0