基于SSM框架的增删改查项目

基于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
package com.zhongruan.dao;

import com.zhongruan.bean.Userinfo;

import java.util.List;

public interface IUserDao {
public List findAll();
public boolean addUser(Userinfo userinfo);
public boolean deleteUser(int id);
public boolean updateUser(Userinfo userinfo);
public Userinfo findU(int id);
}
IUserServicelmpl.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
package com.zhongruan.service;

import com.zhongruan.bean.Userinfo;

import java.util.List;

public interface IUserService {
public List 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" ?>

<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>

其他jsp代码由讲师提供。

运行截图