SSM配置并实现简单的数据库增删改查操作

2024-06-12 07:45| 来源: 网络整理| 查看: 265

一、程序结构图

二、jar包导入

　　链接：https://pan.baidu.com/s/1jJDMlyI 密码：i610

开始编写程序

　　数据库的创建我就不写了大家可以根据自己的喜好创建数据库

　　一、创建User实体类

package com.ssm.model; public class User { 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; } @Override public String toString() { return "User [id=" + id + ", username=" + username + ", password=" + password + "]"; } }

　　二、创建和实现mapper接口

　　　　UserMapper.xml

DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> INSERT INTO Demo4(id,username,password) VALUES(#{id},#{username},#{password}) UPDATE Demo4 SET username=#{username},password=#{password} where id=#{id} DELETE FROM Demo4 WHERE id=#{id} SELECT id,username,password FROM Demo4 WHERE id=#{id} SELECT id,username,password FROM Demo4 SELECT TOP 10 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ROWNUMBER,* FROM Demo4 ) AS A WHERE ROWNUMBER>10*(#{page}-1)

　　　　UserMapper.java

package com.ssm.mapper; import java.util.List; import com.ssm.model.User; public interface UserMapper { void save(User user); int update(User user); boolean delete(int id); User findById(int id); List findAll(); }

　　三、mybatis和spring的整合

　　　　spring-common.xml

　　四、mybatis的配置文件

　　　　mybatis-config.xml

DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

　　五、配置log4j.properties

log4j.rootLogger=DEBUG, stdout, R log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout # Pattern to output the caller's file name and line number. #log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n # Print the date in ISO 8601 format log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p %c - %m%n log4j.appender.R=org.apache.log4j.RollingFileAppender log4j.appender.R.File=example.log log4j.appender.R.MaxFileSize=100KB # Keep one backup file log4j.appender.R.MaxBackupIndex=1 log4j.appender.R.layout=org.apache.log4j.PatternLayout log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n # Print only messages of level WARN or above in the package com.foo. log4j.logger.com.foo=WARN

　　六、整合springmvc

　　　　spring-mvc.xml

　　七、web.xml的配置

ssm001 index.html index.htm index.jsp default.html default.htm default.jsp org.springframework.web.context.ContextLoaderListener contextConfigLocation classpath:spring-common.xml,classpath:spring-mvc.xml springMVC org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:spring-common.xml,classpath:spring-mvc.xml 1 springMVC / org.springframework.web.util.IntrospectorCleanupListener encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 forceEncoding true encodingFilter /* index.jsp

　　八、srevice的创建和实现

　　　　UserService.java

package com.ssm.service;

import java.util.List;

import com.ssm.model.User;

public interface UserService { void save(User user); int update(User user); boolean delete(int id); User findById(int id); List findAll();}

　　UserServiceImpl.java

package com.ssm.service.impl; import java.util.List; import javax.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.ssm.mapper.UserMapper; import com.ssm.model.User; import com.ssm.service.UserService; @Service @Transactional public class UserServiceImpl implements UserService{ @Resource private UserMapper usermapper; @Override public void save(User user) { // TODO Auto-generated method stub usermapper.save(user); } @Override public boolean update(User user) { // TODO Auto-generated method stub return usermapper.update(user); } @Override public boolean delete(int id) { // TODO Auto-generated method stub return usermapper.delete(id); } @Override public User findById(int id) { // TODO Auto-generated method stub User user=usermapper.findById(id); return user; } @Override public List findAll() { // TODO Auto-generated method stub List findAllList=usermapper.findAll(); return findAllList; } }

　　九、控制层Controller

　　　　UserController.java

package com.ssm.controller; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import com.ssm.model.User; import com.ssm.service.UserService; @Controller @RequestMapping("/user") public class UserController { @Autowired private UserService userService; /** * 获取所有用户列表 * @param request * @param model * @return */ @RequestMapping("/getAllUser") public String getAllUser(HttpServletRequest request,Model model){ List user=userService.findAll(); model.addAttribute("userList",user); request.setAttribute("userList",user); return "/allUser"; } /** * 跳转到添加用户界面 * @param request * @return */ @RequestMapping("/toAddUser") public String toAddUser() { return "/addUser"; } /** * 添加用户并重定向 * @param user * @param request * @return */ @RequestMapping("/addUser") public String addUser(User user,Model model){ userService.save(user); return "redirect:/user/getAllUser"; } /** *编辑用户 * @param user * @param request * @return */ @RequestMapping("/updateUser") public String updateUser(User user,HttpServletRequest request,Model model){ if(userService.update(user)!=0) { user=userService.findById(user.getId()); request.setAttribute("user",user); model.addAttribute("user",user); return "redirect:/user/getAllUser"; } else { return "/error"; } } /** * 根据id查询单个用户 * @param id * @param request * @return */ @RequestMapping("/getUser") public String getUser(int id,HttpServletRequest request,Model model){ request.setAttribute("user",userService.findById(id)); model.addAttribute("user",userService.findById(id)); return "/editUser"; } /** * 删除用户 * @param id * @param request * @param response */ @RequestMapping("/delUser") public void delUser(int id,HttpServletRequest request,HttpServletResponse response){ String result="{\"result\":\"error\"}"; if(userService.delete(id)) { result="{\"result\":\"success\"}"; }else { result="{\"result\":\"error\"}"; } response.setContentType("application/json"); try { PrintWriter out=response.getWriter(); out.write(result); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

　　十、jap页面

　　index.jsp

用户列表进入用户管理页

　　　　addUser.jsp

My JSP 'addUser.jsp' starting page function addUser(){ var form = document.forms[0]; form.action = "user/addUser"; form.method="post"; form.submit(); } 添加用户 ID：账号：密码：

　　　　allUser.jsp

My JSP 'allUser.jsp' starting page function del(id){ $.get("user/delUser?id="+id,function(data){ if("success"==data.result){ alert("删除成功"); window.location.reload(); }else{alert("删除失败");} }); } 添加用户 id 账号密码操作 ${user.id} ${user.username} ${user.password} 编辑删除

　　　　editUser.jsp

s My JSP 'editUser.jsp' starting page function updateUsers(){ var form=document.forms[0]; form.action="user/updateUser"; form.method="post"; form.submit() ; } 修改用户 ID：${user.id} 账号：密码：

　　　　error.jsp就是一个显示错误的 jsp我就不写了

【本文地址】

公司简介

联系我们