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"%>
//添加用户
$(function(){
$("#add").on("click", addNewUser);
})
function addNewUser(){
var name = $.trim($("#txtName").val());
var password = $.trim($("#txtPassword").val());
var age = $.trim($("#txtAge").val());
$.post("/ssm/addUser", {"name": name, "password": password, "age": age}, function(){
alert("添加成功！")
});
}
//删除用户
$(function(){
$("#delete").on("click",deleteUser);
})
function deleteUser(){
var id=$.trim($("#deleteid").val());
$.get("/ssm/deleteUser",{"id":id},function(){
alert("删除成功！")
});
}
//查询所有用户
$(function(){
$("#findalluser").click(function(){
$.ajax({
type:"POST",
dataType:"json",
url:"/ssm/findallUser",
success:function(msg){
var str="";
for(i in msg){
str+="
