SSH+Mysql实现单表增删改

最新推荐文章于 2024-08-16 11:00:59 发布

Cccc柠檬

最新推荐文章于 2024-08-16 11:00:59 发布

阅读量807

点赞数 1

文章标签： SSH MySql 增删改查

本文链接：https://blog.csdn.net/Ccccyxji/article/details/83443911

版权

本文介绍如何使用SSH框架结合MySQL数据库进行增删改查操作。首先需建立web项目并配置相关JAR包，然后分别创建实体类、映射文件、DAO接口、实现类、Service接口、实现类及Controller。详细步骤和代码示例已提供。

摘要由CSDN通过智能技术生成

哈喽~我来啦。这篇blog给大家分享一下SSH+MySQL实现增删改查
准备工作：创建一个web项目，加入所需要的JAR包。分包分模块，配置所需要的核心配置文件。如果不会的小伙伴去看我https://blog.csdn.net/Ccccyxji/article/details/83388503 这篇文章哦！

Ok~贴代码
1、 User.java

   public class User {
   
private Integer id;
private String  name;

public Integer getId() {
	return id;
}
public void setId(Integer id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
@Override
public String toString() {
	return "User [id=" + id + ", name=" + name + "]";
}
public User(Integer id, String name) {
	super();
	this.id = id;
	this.name = name;
}
public User() {
	super();
	// TODO Auto-generated constructor stub
}

}

2、user.hbm.xml

<hibernate-mapping>
	<class name="com.baidu.pojo.User" table="user">
	
		<id name="id" column="id" type="int">
			<generator class="native"></generator>
		</id> 
		
		<property name="name"></property>

	</class>
	
</hibernate-mapping>

3、UserdaoI.java

public interface UserDaoI {

List<User> findList();

void delete(User user);

void add(User user);

User toUpdate(Integer id);

void update(User user);

}

4、UserDaoImpl.java

@Repository
public class UserdaoImpl implements UserDaoI{

@Autowired
private HibernateTemplate hibernateTemplate;

public List<User> findList() {

	List list = hibernateTemplate.find("from User");
	
	return list;
}

public void delete(User user) {

	hibernateTemplate.delete(user);
}

public void add(User user) {

	hibernateTemplate.save(user);
}

public void update(User user) {
	
	hibernateTemplate.update(user);
}

public User toUpdate(Integer id) {

	User user = hibernateTemplate.get(User.class, id);
	
	return user;
}

}

5、UserServiceI.java

public interface UserServiceI {

List<User> findList();

void delete(User user);

void add(User user);

void update(User user);

User toUpdate(Integer id);

}

6、UserServiceImpl.java

@Service
public class UserServiceImpl implements UserServiceI{

@Autowired
private UserDaoI userDao;
public List<User> findList() {
	return userDao.findList();
}
public void delete(User user) {
	userDao.delete(user);
}
public void add(User user) {
	userDao.add(user);
}
public void update(User user) {
	userDao.update(user);
}
public User toUpdate(Integer id) {
	return userDao.toUpdate(id);
}

}

7、UserController.java

@Controller
@Scope(value=“prototype”)
public class UserController extends ActionSupport implements ModelDriven{

@Autowired
private UserServiceI userService;
HttpServletRequest request = ServletActionContext.getRequest();
private User user=new User();

public String list(){
	List<User> list = userService.findList();
	request.setAttribute("list", list);
	return "list";
}

public String delete(){
	int id= user.getId();
	userService.delete(user);	
	return "delete";
}

public String add(){
	userService.add(user);
	return "add";
}

public String toUpdate(){
    User user1 = userService.toUpdate(user.getId());
    request.setAttribute("user", user1);
	return "toUpdate";
}

public String update(){
    userService.update(user);	
	return "update";
}

public User getModel() {
	// TODO Auto-generated method stub
	return user;
}

}

附jsp界面截图
list.jsp