数据库连接配置文件不变 同上次
Bean类修改如下：
增加insert，update，delete
程序执行结果如下：
package spring.test;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
//import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
public class pringBean {
@Autowired
private JdbcTemplate jdbcTemplate;
public void insert() {
IUser user = new IUser();
System.out.println(“追加します”);
user.setId(“0005”);
user.setName(“新規追加”);
jdbcTemplate.update(“insert into i_user(id, name) values(? , ?)”, user.getId(), user.getName());
user.setId(“0006”);
user.setName(“新規追加DEL”);
jdbcTemplate.update(“insert into i_user(id, name) values(? , ?)”, user.getId(), user.getName());
}
public void update() {
IUser user = new IUser();
System.out.println(“更新します 0005”);
user.setId(“0005”);
user.setName(“更新222”);
jdbcTemplate.update(“update i_user set name = ? where id = ?”, user.getName(), user.getId());
}
public void delete() {
System.out.println(“削除します 0006”);
IUser user = new IUser();
user.setId(“0006”);
jdbcTemplate.update(“delete from i_user where id = ?”, user.getId());
}
public void show(){
/* String sql1 = “select * from I_USER”;
List<Map<String, Object>> ret = jdbcTemplate.queryForList(sql1);
for (Map<String, Object> map : ret) {
System.out.println(map.get(“ID”).toString() + “—–” + map.get(“NAME”).toString());
}*/
List<IUser> list = jdbcTemplate.query(“select * from i_user”, new RowMapper<IUser>() {
public IUser mapRow(ResultSet rs, int rowNum) throws SQLException {
IUser user = new IUser();
user.setId(rs.getString(“id”));
user.setName(rs.getString(“name”));
return user;
}
});
for (IUser user : list) {
System.out.println(user.getId() + “-” + user.getName());
}
}
}
データクラス(IUser.java)
getter、setter
package spring.test;
public class IUser {
private String id;
private String name;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}