1、前提条件(创建失败原因):
Spring版本:4.3.3
Mysql版本:5.7
IDE版本:eclipse-2019-6 (安装有spring插件)
额外资源:commons-logging-1.2.jar(用maven从仓库中下载)
mysql-connector-java-8.0.11\mysql-connector-java-8.0.11.jar
2、创建文件
UserBean.java
package bean;
public class admin {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
//将数据保存到字符串中
public String toString() {
return "Admin[id=" + id + "," + "username=" + username + "," + "password=" + password + "]";
}
}
接口
import java.util.List;
import bean.admin;
public interface Springdao {
// 更新数据
public boolean updateadmin(admin admin);
// 删除数据
public boolean deleteadmin(int id);
// 添加数据
public boolean addadmin(admin admin);
// 查看指定数据
public admin lookadmin(int id);
// 查看所有数据
public List<admin> looAdmins();
}
接口实现
import java.util.List;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import bean.admin;
import dao.interfac.Springdao;
public