ider ssm增删改查
时间: 2023-07-07 09:19:36 浏览: 38
SSM是指Spring+SpringMVC+MyBatis的框架组合,用于开发Java Web应用程序。下面是SSM框架下的增删改查操作示例:
1. 实体类定义:
```java
public class User {
private int id;
private String name;
private int age;
// getter和setter方法省略
}
```
2. Dao层操作接口:
```java
public interface UserDao {
// 添加用户
int addUser(User user);
// 根据id删除用户
int deleteUserById(int id);
// 更新用户信息
int updateUser(User user);
// 根据id查询用户
User getUserById(int id);
// 查询所有用户
List<User> getAllUsers();
}
```
3. Dao层操作实现:
```java
@Repository
public class UserDaoImpl implements UserDao {
@Autowired
private SqlSessionTemplate sqlSessionTemplate;
@Override
public int addUser(User user) {
return sqlSessionTemplate.insert("addUser", user);
}
@Override
public int deleteUserById(int id) {
return sqlSessionTemplate.delete("deleteUserById", id);
}
@Override
public int updateUser(User user) {
return sqlSessionTemplate.update("updateUser", user);
}
@Override
public User getUserById(int id) {
return sqlSessionTemplate.selectOne("getUserById", id);
}
@Override
public List<User> getAllUsers() {
return sqlSessionTemplate.selectList("getAllUsers");
}
}
```
4. Service层操作接口:
```java
public interface UserService {
// 添加用户
boolean addUser(User user);
// 根据id删除用户
boolean deleteUserById(int id);
// 更新用户信息
boolean updateUser(User user);
// 根据id查询用户
User getUserById(int id);
// 查询所有用户
List<User> getAllUsers();
}
```
5. Service层操作实现:
```java
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public boolean addUser(User user) {
int result = userDao.addUser(user);
return result > 0;
}
@Override
public boolean deleteUserById(int id) {
int result = userDao.deleteUserById(id);
return result > 0;
}
@Override
public boolean updateUser(User user) {
int result = userDao.updateUser(user);
return result > 0;
}
@Override
public User getUserById(int id) {
return userDao.getUserById(id);
}
@Override
public List<User> getAllUsers() {
return userDao.getAllUsers();
}
}
```
6. Controller层操作:
```java
@Controller
public class UserController {
@Autowired
private UserService userService;
// 添加用户
@RequestMapping(value = "/user", method = RequestMethod.POST)
public String addUser(User user) {
boolean result = userService.addUser(user);
if (result) {
return "success";
} else {
return "error";
}
}
// 删除用户
@RequestMapping(value = "/user/{id}", method = RequestMethod.DELETE)
public String deleteUserById(@PathVariable int id) {
boolean result = userService.deleteUserById(id);
if (result) {
return "success";
} else {
return "error";
}
}
// 更新用户信息
@RequestMapping(value = "/user", method = RequestMethod.PUT)
public String updateUser(User user) {
boolean result = userService.updateUser(user);
if (result) {
return "success";
} else {
return "error";
}
}
// 根据id查询用户
@RequestMapping(value = "/user/{id}", method = RequestMethod.GET)
public String getUserById(@PathVariable int id, Model model) {
User user = userService.getUserById(id);
model.addAttribute("user", user);
return "user";
}
// 查询所有用户
@RequestMapping(value = "/users", method = RequestMethod.GET)
public String getAllUsers(Model model) {
List<User> users = userService.getAllUsers();
model.addAttribute("users", users);
return "users";
}
}
```
以上就是一个简单的SSM框架下的增删改查操作示例。