搭建SSM
选择环境
https://www.cnblogs.com/aishangJava/p/10361481.html
1 选择语言
2 选择编译器
3 选择框架
搭建环境
11 版本说明
2 环境初始化
21 安装tomcat
22 配置tomcat
创建项目
31 新建MAVEN项目
https://www.baidu.com/link?url=57aywD0Q6WTnl7XKbIHuE7lcWGXh50Vy3z1lItKlmd4OJre3dLQnWbn8s4nBPmV16nhmYWl5yIJbrdDso3yxfkmyZmbFynVfbHuRh2r9Cea&wd=&eqid=cb60ae640002a3da000000065d9730da
32 为项目添加运行环境
33 同步版本信息
搭建框架
41 添加依赖
42 做必要配置
43 添加Spring配置文件
44 创建数据库属性文件
45 创建SpringMVC配置文件
Tomcat配置
测试环境
1 测试Sring MVC
11 创建bean
12 创建controller
13 运行项目
21 构建MBG逆向工程
211 准备数据库环境
212 创建MBG配置文件
213 实现逆向工程
22 进行单元测试
模型-视图-控制器模式,也称为MVC模式。是软件工程中的一种软件架构模式,把软件系统分为三个基本部分:
模型(Model):负责存储系统的中心数据。
视图(View):将信息显示给用户(可以定义多个视图)。
控制器(Controller):处理用户输入的信息。负责从视图读取数据,控制用户输入,并向模型发送数据,是应用程序中处理用户交互的部分。负责管理与用户交互交互控制。
管理系统的创建
项目结构
bean 实体类 和数据库对应
dao 持久层 数据库的增删改查
service 业务层
controller 控制层
实体类:UserInfo.java
package com.zhongruan.bean;
public class UserInfo {
private int id;
private String username;
private String password;
public UserInfo() {
} //必须有!!
public UserInfo(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = 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 "UserInfo{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
控制层 UserInfoController.java
package com.zhongruan.controller;
import com.zhongruan.bean.UserInfo;
import com.zhongruan.service.IUserInfoService;
import com.zhongruan.service.impl.IUserInfoServiceImpl;
import org.omg.CORBA.PUBLIC_MEMBER;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import javax.xml.registry.infomodel.User;
import java.util.List;
@Controller
@RequestMapping("user")
public class UserInfoController {
@Autowired
IUserInfoService userInfoService;
@RequestMapping("findAll.do")
public ModelAndView findAll() {
List<UserInfo> users =userInfoService.findAll();
ModelAndView mv=new ModelAndView();
mv.addObject("users",users);
mv.setViewName("allUser");//jsp路径
return mv;
}
//跳转页面
@RequestMapping("toAddUser.do")
public ModelAndView toAddUser(){
ModelAndView mv = new ModelAndView();
mv.setViewName("addUser");//jsp路径跳转至addUser.jsp页面
return mv;
}
@RequestMapping("save.do")
public ModelAndView save(@RequestParam("id") int id, @RequestParam("username") String username, @RequestParam("password")String password) {
//接收来自jsp的输入
//创建一个UserInfo对象
UserInfo userInfo=new UserInfo();
userInfo.setId(id);
userInfo.setPassword(password);
userInfo.setUsername(username);
// System.out.println(userInfo);
//调用userInfoservice服务
userInfoService.add(userInfo);
//重新获取数据库所有数据
List<UserInfo> users =userInfoService.findAll();
//重新填充模型
// 返回所有用户视图
ModelAndView mv=new ModelAndView();
mv.addObject("users",users);
mv.setViewName("allUser");//jsp路径
return mv;
}
@RequestMapping("toUpdate.do")
public ModelAndView toUpdate(@RequestParam("id") int id){
UserInfo userInfo=userInfoService.search(id);
ModelAndView mv =new ModelAndView();
mv.addObject("userInfo",userInfo); //把此页面的数据送给页面容器
mv.setViewName("updateUser");
return mv;
}
@RequestMapping("update.do")
public ModelAndView update(@RequestParam("id") int id,
@RequestParam("username")String username,@RequestParam("password")String password) {
UserInfo userInfo = new UserInfo();
userInfo.setId(id);
userInfo.setUsername(username);
userInfo.setPassword(password);
// System.out.println(userInfo);//测试
userInfoService.update(userInfo);
List<UserInfo> users = userInfoService.findAll();
ModelAndView mv = new ModelAndView();
mv.addObject("users", users);
mv.setViewName("allUser");//jsp路径
return mv;
}
@RequestMapping("delete.do")
public ModelAndView delete(@RequestParam("id")int id){
userInfoService.delete(id);//找到user
List<UserInfo> users =userInfoService.findAll();
ModelAndView mv=new ModelAndView();
mv.addObject("users", users);
mv.setViewName("allUser");//jsp路径
return mv;
}
}
dao层(持久层)IUserInfoDao.java
package com.zhongruan.dao;
import com.zhongruan.bean.UserInfo;
import javax.jws.soap.SOAPBinding;
import java.util.List;
//dao层与MyBatis中的xml对应,SQL
public interface IUserInfoDao {
List<UserInfo> findAll();
void add(UserInfo userInfo);
void update(UserInfo userInfo);
UserInfo search(int id);
void delete (int id);
}
服务层(service) IUserInfoService.java
package com.zhongruan.service;
import com.zhongruan.bean.UserInfo;
import java.util.List;
public interface IUserInfoService {
List<UserInfo> findAll();
void add(UserInfo userInfo);
void update(UserInfo userInfo);
UserInfo search(int id);
void delete (int id);
}
service层:IUserInfoServiceImpl.java
package com.zhongruan.service.impl;
import com.zhongruan.bean.UserInfo;
import com.zhongruan.dao.IUserInfoDao;
import com.zhongruan.service.IUserInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.xml.registry.infomodel.User;
import java.util.List;
@Service
public class IUserInfoServiceImpl implements IUserInfoService{
@Autowired
IUserInfoDao userInfoDao;
@Override
public List<UserInfo>findAll(){
return userInfoDao.findAll();
}
public void add(UserInfo userInfo) {
userInfoDao.add(userInfo);
}
public void update(UserInfo userInfo){
userInfoDao.update(userInfo);
}
public UserInfo search(int id){
return userInfoDao.search(id);
}
public void delete(int id){
userInfoDao.delete(id);
}
}
myBatis
UserInfoMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zhongruan.dao.IUserInfoDao" >
<select id="findAll" resultType="com.zhongruan.bean.UserInfo">
select * from userinfo
</select>
<select id="add" parameterType="com.zhongruan.bean.UserInfo">
insert into userinfo (id, username, password) values(#{id}, #{username}, #{password})
</select>
<select id="update" parameterType="com.zhongruan.bean.UserInfo">
update userinfo set username=#{username}, password=#{password} where id=#{id}
</select>
<select id="search" resultType="com.zhongruan.bean.UserInfo">
select * from userinfo where id=#{id}
</select>
<select id="delete" parameterType="_int">
delete from userinfo where id=#{id}
</select>
</mapper>
applicationContext.xml 、 db.properties 、 log4j.properties 、spring-mvc.xml 略
项目结果
初始页面
显示所有用户,进入功能页面
新增用户
结果:
删除用户 id=4
更改用户信息
修改生效: