- 创建bean,映射文件,
- 创建dao包,action包,jsp页面
- 配置web,hibernate,Spring,struts2
看一下效果先
首先是登录页面
点击注册
注册过后登录进入用户列表
点击删除,直接删除数据
点击修改进入修改页面
修改成功进入详情
在写代码前需要整合SSH
1. 创建bean文件,映射文件,
映射文件将ID改为自增长
package org.xian.bean;
public class Users {
private Integer uid;
private String name;
private String pwd;
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "Users [uid=" + uid + ", name=" + name + ", pwd=" + pwd + "]";
}
}
<hibernate-mapping>
<class name="org.xian.bean.Users" table="USERS">
<id name="uid" type="java.lang.Integer">
<column name="UID" />
<generator class="increment" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="pwd" type="java.lang.String">
<column name="PWD" />
</property>
</class>
</hibernate-mapping>
2 创建dao包,action包,jsp页面
创建dao包是编写对数据库数据的增删改查
注入hibernateTemplate
package org.xian.dao;
import java.util.List;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.xian.bean.Users;
public class UserDao {
private HibernateTemplate hibernateTemplate;
public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
this.hibernateTemplate = hibernateTemplate;
}
public Users findById(int id) {
return hibernateTemplate.get(Users.class, id) ;
}
public void update(Users users ) {
hibernateTemplate.update(users);
}
public List<Users> findAll() {
List list= hibernateTemplate.find("from Users");
return list;
}
public void add(Users users) {
hibernateTemplate.save(users);
}
public void delete(Users users) {
hibernateTemplate.delete(users);
}
public boolean login (String name,String pwd) {
List users= hibernateTemplate.find("from Users where name=? and pwd =?" ,name,pwd);
if (users.size()>0) {
return true;
}
return false;
}
public List checkName (String name) {
List list= hibernateTemplate.find("from Users where name=?" ,name);
return list;
}
}
action包是用来调用dao的增删改查方法
注入dao
package org.xian.action;
import java.util.HashMap;
import java.util.List;
import org.xian.bean.Users;
import org.xian.dao.UserDao;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
public class HelloAction extends ActionSupport implements ModelDriven<Users> {
private UserDao dao;
private Users users =new Users();
private List<Users> list;
private List<Users> user;
public String findById() {
users= dao.findById(users.getUid());
return SUCCESS;
}
public String login() {
if (dao.login(users.getName(), users.getPwd())) {
return SUCCESS;
}
return ERROR;
}
public String getAll() {
list=dao.findAll();
return SUCCESS;
}
public Stri