sqa-example.zip

package com.sqa.sqaexample.dao; import com.google.common.collect.Lists; import com.sqa.sqaexample.model.User; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; import java.util.List; import java.util.Map; /** * 用户表数据操作JDBC */ @Repository public class UserDao { @Autowired private JdbcTemplate jdbcTemplate; //插入数据 public boolean insert(User user) { String sql = "insert into user (id,user_name,password,sex,age,address) values (?,?,?,?,?,?)"; Object[] objects = new Object[6]; objects[0] = user.getId(); objects[1] = user.getUserName(); objects[2] = user.getPassword(); objects[3] = user.getSex(); objects[4] = user.getAge(); objects[5] = user.getAddress(); int count = jdbcTemplate.update(sql, objects); return count == 1; } //根据用户名查询单个用户 public User getUserByName(String userName) { String sql = "select * from user where user_name=?"; Object[] objects = new Object[1]; objects[0] = userName; Map<String, Object> map = jdbcTemplate.queryForMap(sql, objects); User user = new User(); /** * Integer.valueOf(map.get("id").toString()) * String idStr= map.get("id").toString(); * int id = Integer.valueOf(idStr); */ user.setId(Integer.valueOf(map.get("id").toString())); user.setUserName(map.get("user_name").toString()); user.setPassword(map.get("password").toString()); user.setSex(Integer.valueOf(map.get("sex").toString())); user.setAge(Integer.valueOf(map.get("age").toString())); user.setAddress(map.get("address").toString()); return user; } //查询所有用户信息 public List<User> getAllUser() { String sql = "select * from user"; List<Map<String, Object>> queryList = jdbcTemplate.queryForList(sql); List<User> list = Lists.newArrayList(); User user = null; for (Map<String, Object> map : queryList) { user = new User(); user.setId(Integer.valueOf(map.get("id").toString())); user.setUserName(map.get("user_name").toString()); user.setPassword(map.get("password").toString()); user.setSex(Integer.valueOf(map.get("sex").toString())); user.setAge(Integer.valueOf(map.get("age").toString())); user.setAddress(map.get("address").toString()); list.add(user); } return list; } }