一:概述
SSM框架在项目开发中经常使用到,所以这次实习首先学习的就是SSM框架的搭建和使用。
Spring作为一个轻量级的框架,有很多的拓展功能,最主要的我们一般项目使用的就是IOC和AOP。ioc 控制反转 即spring帮我们创建对象, aop提供了切面;springmvc负责控制,mybatis负责数据库操作。
介绍一下SSM框架里主要包含的文件结构:
Java包:
bean:实体类
dao:持久层 数据库增删改查
controller:控制层,页面跳转
service:业务层
resources包
mapper dao实现类
applicationContext.xml spring+mybatis
db.properties 数据库连接信息
log4j.properties 日志
springmvc.xml 配置springmvc
webapp
jsp页面
web-inf
web.xml 加载过滤器 拦截器
这里发一个基于SSM框架的增删改查项目帮助大家理解:
Userinfo.java
package com.zhongruan.bean;
public class Userinfo {
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 "Userinfo{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
UserController.java
package com.zhongruan.controller;
import com.sun.org.apache.bcel.internal.generic.RETURN;
import com.zhongruan.bean.Userinfo;
import com.zhongruan.service.IUserService;
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 org.springframework.web.servlet.ModelAndView;
import sun.misc.Request;
import javax.xml.registry.infomodel.User;
import java.util.List;
@Controller
@RequestMapping("user")
public class UserController {
@Autowired
private IUserService userService;
@RequestMapping("findAll.do")
public ModelAndView findAll(){
List<Userinfo> userinfos = userService.findAll();
ModelAndView mv = new ModelAndView();
mv.addObject("ui", userinfos);
mv.setViewName("allUser");
return mv;
}
@RequestMapping("toAddUser.do")
public String toAddUser(){
return "addUser";
}
@RequestMapping("save.do")
public String addUser(Userinfo userinfo){
userService.addUser(userinfo);
return "redirect:/user/findAll.do";
}
@RequestMapping("toUpdate.do")
public String toUpdate(Model model, int id){
model.addAttribute("userInfo", userService.findU(id));
return "updateUser";
}
@RequestMapping("update.do")
public String updateUser(Userinfo userinfo){
userService.updateUser(userinfo);
return "redirect:/user/findAll.do";
}
@RequestMapping("delete.do")
public String deleteUser(int id){
userService.deleteUser(id);
return "redirect:/user/findAll.do";
}
}
IUserDao.java
package com.zhongruan.dao;
import com.zhongruan.bean.Userinfo;
import java.util.List;
public interface IUserDao {
public List<Userinfo> findAll();
public boolean addUser(Userinfo userinfo);
public boolean deleteUser(int id);
public boolean updateUser(Userinfo userinfo);
public Userinfo findU(int id);
}
IUserServiceImpl.java
package com.zhongruan.service.impl;
import com.zhongruan.bean.Userinfo;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class IUserServiceImpl implements IUserService {
@Autowired
IUserDao userDao;
@Override
public List<Userinfo> findAll() {
return userDao.findAll();
}
@Override
public boolean addUser(Userinfo userinfo) {
return userDao.addUser(userinfo);
}
@Override
public boolean deleteUser(int id) {
return userDao.deleteUser(id);
}
@Override
public boolean updateUser(Userinfo userinfo) {
return userDao.updateUser(userinfo);
}
@Override
public Userinfo findU(int id) {
return userDao.findU(id);
}
}
IUserService.java
package com.zhongruan.service;
import com.zhongruan.bean.Userinfo;
import java.util.List;
public interface IUserService {
public List<Userinfo> findAll();
public boolean addUser(Userinfo userinfo);
public boolean deleteUser(int id);
public boolean updateUser(Userinfo userinfo);
public Userinfo findU(int id);
}
UserMapper.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.IUserDao" >
<select id="findAll" resultType="com.zhongruan.bean.Userinfo">
select * from userinfo
</select>
<insert id="addUser" parameterType="com.zhongruan.bean.Userinfo">
insert into userinfo(username,password) value (#{username},#{password})
</insert>
<update id="updateUser" parameterType="com.zhongruan.bean.Userinfo">
update userinfo set username= #{username} , password = #{password} where id= #{id}
</update>
<select id="findU" resultType="com.zhongruan.bean.Userinfo">
select * from userinfo where id=#{id}
</select>
<delete id="deleteUser" parameterType="java.lang.Integer">
delete from userinfo where id=#{id}
</delete>
</mapper>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<body>
<h2>Hello World!</h2>
<hr>
<a href="${pageContext.request.contextPath}/user/findAll.do">查询所有用户</a>
</body>
</html>
allUser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>user列表</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 Bootstrap -->
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
基于SSM框架的管理系统:简单实现增、删、改、查。
</h1>
</div>
</div>
</div>
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>用户列表 —— 显示所有用户</small>
</h1>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4 column">
<a class="btn btn-primary" href="${pageContext.request.contextPath}/user/toAddUser.do">新增</a>
</div>
</div>
<div class="row clearfix">
<div class="col-md-12 column">
<table class="table table-hover table-striped">
<thead>
<tr>
<th>id</th>
<th>用户名</th>
<th>密码</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<c:forEach items="${ui}" var="userInfo">
<tr>
<td>${userInfo.id}</td>
<td>${userInfo.username}</td>
<td>${userInfo.password}</td>
<td>
<a href="${pageContext.request.contextPath}/user/toUpdate.do?id=${userInfo.id}">更改</a> |
<a href="${pageContext.request.contextPath}/user/delete.do?id=${userInfo.id}">删除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</div>
</div>
addUser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>新增用户</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 Bootstrap -->
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
基于SSM框架的管理系统:简单实现增、删、改、查。
</h1>
</div>
</div>
</div>
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>新增用户</small>
</h1>
</div>
</div>
</div>
<form action="${pageContext.request.contextPath}/user/save.do"
method="post">
用户姓名:<input type="text" name="username"><br><br><br>
用户密码:<input type="text" name="password"><br><br><br>
<input type="submit" value="添加" >
</form>
</div>
updateUser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>修改用户</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 Bootstrap -->
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
基于SSM框架的管理系统:简单实现增、删、改、查。
</h1>
</div>
</div>
</div>
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>修改用户</small>
</h1>
</div>
</div>
</div>
<form action="${pageContext.request.contextPath}/user/update.do"
method="post">
<input type="hidden" name="id" value="${userInfo.id}"/>
用户姓名:<input type="text" name="username" value="${userInfo.username}"/>
用户密码:<input type="text" name="password" value="${userInfo.password}"/>
<input type="submit" value="提交" />
</form>
</div>
数据库配置文档如下:
db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/idea?useSSL=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456