JAVA中SSM框架的搭建实现CRUD的方法

  4.0.0com.lrssmwar0.0.1-SNAPSHOTssm Maven Webapphttp://maven.apache.org 4.0.2.RELEASE3.2.81.7.121.2.17  junitjunit4.11test javaxjavaee-api7.0 com.fasterxml.jackson.corejackson-databind2.8.8 org.springframeworkspring-test${srping.version} org.springframeworkspring-core${srping.version} org.springframeworkspring-oxm${srping.version} org.springframeworkspring-tx${srping.version} org.springframeworkspring-jdbc${srping.version} org.springframeworkspring-aop${srping.version} org.springframeworkspring-context${srping.version} org.springframeworkspring-context-support${srping.version} org.springframeworkspring-expression${srping.version} org.springframeworkspring-orm${srping.version} org.springframeworkspring-web${srping.version} org.springframeworkspring-webmvc${srping.version} org.springframeworkspring-aspects${srping.version} org.mybatismybatis${mybatis.version} org.mybatismybatis-spring1.2.2 mysqlmysql-connector-java5.1.35 commons-dbcpcommons-dbcp1.4 jstljstl1.2 taglibsstandard1.1.2 log4jlog4j${log4j.version} org.slf4jslf4j-api${slf4j.version} org.slf4jslf4j-log4j12${slf4j.version} com.alibabafastjson1.2.6 org.codehaus.jacksonjackson-mapper-asl1.9.13 commons-fileuploadcommons-fileupload1.3.1 commons-iocommons-io2.4 commons-codeccommons-codec1.10 net.sourceforge.jexcelapijxl2.6 org.apache.poipoi3.8 org.apache.poipoi-ooxml3.9 Maven_Project  org.apache.maven.pluginsmaven-compiler-plugin2.3.2 1.71.7

 driver=com.mysql.jdbc.Driver url=jdbc\:mysql\://locahost\:3306/db username=root password=root maxActive=20 maxIdle=20 minIdle=1 maxWait=60000

     id, name, password, age  insert into user(name,password,age) values(#{name},#{password},#{age})  select  from user where id = #{id}  delete from user where id = #{id}  update user set name=#{name},password=#{password},age=#{age} where id=#{id}  select * from user 

 package com.lr.dao; import java.util.List; import com.lr.dto.User; public interface IUserDao { //查询用户 public User queryByPrimaryKey(int id); //删除用户 public int deleteByPrimaryKey(int id); //更新用户 public int updateByPrimaryKey(User user); //添加用户 public int addUser(User user); //查询所有用户 public List findallUser(); }

 package com.lr.service; import java.util.List; import com.lr.dto.User; public interface IUserService { //查询用户 public User getUserById(int userId); //删除 public void deleteUser(int id); //更新用户 public void updateUser(User user); //添加用户 public void addUser(User user); //查看所有用户 public List findallUser(); }

 package com.lr.service.Impl; import java.util.List; import javax.annotation.Resource; import org.springframework.stereotype.Service; import com.lr.dao.IUserDao; import com.lr.dto.User; import com.lr.service.IUserService; @Service("userService") public class UserServiceImpl implements IUserService{ @Resource private IUserDao userdao; public IUserDao getUserdao() { return userdao; } public void setUserdao(IUserDao userdao) { this.userdao = userdao; } //查询用户 @Override public User getUserById(int userId) { return userdao.queryByPrimaryKey(userId); } //更新用户 @Override public void updateUser(User user) { userdao.updateByPrimaryKey(user); } //删除用户 @Override public void deleteUser(int id) { userdao.deleteByPrimaryKey(id); } //添加用户 @Override public void addUser(User user) { userdao.addUser(user); } //查询所有用户 @Override public List findallUser() { return userdao.findallUser(); } }

 package com.lr.controller; import java.util.List; import javax.servlet.http.HttpServletRequest; 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.bind.annotation.ResponseBody; import com.lr.dto.User; import com.lr.service.IUserService; @Controller public class UserController { @Autowired private IUserService userService; public IUserService getUserService() { return userService; } public void setUserService(IUserService userService) { this.userService = userService; } //主页面 @RequestMapping("/") public String userMgr() { return "showUser"; } //添加用户 @RequestMapping("/addUser") @ResponseBody public void userAdd(User user) { userService.addUser(user); } //删除用户 @RequestMapping("/deleteUser") @ResponseBody public void deleteUser(int id){ userService.deleteUser(id); } //修改用户 @RequestMapping("/updateUser") @ResponseBody public void upadteUser(User user){ userService.updateUser(user); } //根据id查找用户 @RequestMapping("/showUser") @ResponseBody public User showUser(int id,Model model){ return userService.getUserById(id); } //查询所有用户 @RequestMapping("/findallUser") @ResponseBody public List findallUser(){ return userService.findallUser(); } }

 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>   
 
姓名：
密码：
年龄：
添加
 
输入用户id:
删除
查询所有
 
 
 
 
id
姓名
密码
年龄
 
输入用户id:
查询
 
 
 
 
id
姓名
密码
年龄
 
输入用户id:
输入用户姓名:
输入密码：
输入用户年龄:
修改