基于Java企业管理系统中留言管理模块常用源码
时间: 2024-05-27 16:12:05 浏览: 14
以下是Java企业管理系统中留言管理模块常用源码:
1. 留言实体类代码:
public class Message {
private Long id;
private String title;
private String content;
private Date createTime;
private Date updateTime;
// 省略getter和setter方法
}
2. 留言DAO接口代码:
public interface MessageDao {
void save(Message message);
void delete(Long id);
void update(Message message);
Message findById(Long id);
List<Message> findAll();
}
3. 留言DAO实现类代码:
public class MessageDaoImpl implements MessageDao {
// 使用JdbcTemplate操作数据库
private JdbcTemplate jdbcTemplate;
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
@Override
public void save(Message message) {
String sql = "INSERT INTO message(title, content, create_time, update_time) VALUES (?, ?, ?, ?)";
jdbcTemplate.update(sql, message.getTitle(), message.getContent(), message.getCreateTime(), message.getUpdateTime());
}
@Override
public void delete(Long id) {
String sql = "DELETE FROM message WHERE id=?";
jdbcTemplate.update(sql, id);
}
@Override
public void update(Message message) {
String sql = "UPDATE message SET title=?, content=?, update_time=? WHERE id=?";
jdbcTemplate.update(sql, message.getTitle(), message.getContent(), message.getUpdateTime(), message.getId());
}
@Override
public Message findById(Long id) {
String sql = "SELECT * FROM message WHERE id=?";
return jdbcTemplate.queryForObject(sql, new RowMapper<Message>() {
@Override
public Message mapRow(ResultSet rs, int rowNum) throws SQLException {
Message message = new Message();
message.setId(rs.getLong("id"));
message.setTitle(rs.getString("title"));
message.setContent(rs.getString("content"));
message.setCreateTime(rs.getDate("create_time"));
message.setUpdateTime(rs.getDate("update_time"));
return message;
}
}, id);
}
@Override
public List<Message> findAll() {
String sql = "SELECT * FROM message";
return jdbcTemplate.query(sql, new RowMapper<Message>() {
@Override
public Message mapRow(ResultSet rs, int rowNum) throws SQLException {
Message message = new Message();
message.setId(rs.getLong("id"));
message.setTitle(rs.getString("title"));
message.setContent(rs.getString("content"));
message.setCreateTime(rs.getDate("create_time"));
message.setUpdateTime(rs.getDate("update_time"));
return message;
}
});
}
}
4. 留言服务类代码:
public class MessageService {
private MessageDao messageDao;
public void setMessageDao(MessageDao messageDao) {
this.messageDao = messageDao;
}
public void save(Message message) {
message.setCreateTime(new Date());
message.setUpdateTime(new Date());
messageDao.save(message);
}
public void delete(Long id) {
messageDao.delete(id);
}
public void update(Message message) {
message.setUpdateTime(new Date());
messageDao.update(message);
}
public Message findById(Long id) {
return messageDao.findById(id);
}
public List<Message> findAll() {
return messageDao.findAll();
}
}
5. 留言控制器代码:
@Controller
@RequestMapping("/message")
public class MessageController {
@Autowired
private MessageService messageService;
@RequestMapping(value = "/add", method = RequestMethod.POST)
public String add(Message message) {
messageService.save(message);
return "redirect:/message/list";
}
@RequestMapping(value = "/delete/{id}")
public String delete(@PathVariable("id") Long id) {
messageService.delete(id);
return "redirect:/message/list";
}
@RequestMapping(value = "/update", method = RequestMethod.POST)
public String update(Message message) {
messageService.update(message);
return "redirect:/message/list";
}
@RequestMapping(value = "/edit/{id}")
public String edit(@PathVariable("id") Long id, Model model) {
Message message = messageService.findById(id);
model.addAttribute("message", message);
return "/message/edit";
}
@RequestMapping(value = "/list")
public String list(Model model) {
List<Message> messages = messageService.findAll();
model.addAttribute("messages", messages);
return "/message/list";
}
}
以上是Java企业管理系统中留言管理模块常用源码。通过这些源码,我们可以实现留言的增删改查功能,并且可以在控制器中使用Spring MVC的注解来方便地处理请求。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)