[大数据]SMM不破不立

controller:UerController.java
mapper:UserMapper.java(接口) UserMapper.xml
po:User.java
service:UserService.java(接口) UserServiceimpl.java
applicationContext.xml
db.properties
springMvc.xml

WEB-INF:jsp(addUser.jsp, erro.jsp, user.jsp, userinfo.jsp ) lib web.xml

applicationContext.xml:**********************************************

<context:property-placeholder
location= “classpath:db.properties” />

<tx:annotation-driven
transaction-manager= “transactionManager” />

db.properties:*******************************************************************
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/userdb
jdbc.user=root
jdbc.password=12345**********************************************************

springMvc.xml******************************************************************

<context:component-scan
base-package=“cn.test.controller” />

mvc:annotation-driven/

mvc:default-servlet-handler/
********************************************************************************************************************

UserController.java**********************************************************************************************************
package cn.test.controller;
import java.util.List;

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.RequestParam;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import cn.test.po.User;
import cn.test.service.UserService;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
UserService userService;
@RequestMapping("/getUserByid")
public String getUserByid(int uid, Model model) {
User u = userService.getUserByid(uid);
model.addAttribute(“u2”,u);
return “userinfo”;
}

@RequestMapping( “/queryUserByUid”)
public String queryUser(int uid, Model model) {//根据用户编号查询用户信息
User u = userService.queryUserByUid(uid);
model.addAttribute( “user”,u);
return “userinfo”;
}
@RequestMapping("/queryUserByUname")
public String queryUser(String uname, Model model) {
PageHelper.startPage(1,3);
List u = userService.queryByUname(uname);
PageInfo p = new PageInfo(u);// 包含了分页信息的类
model.addAttribute(“ulist”,u);
model.addAttribute(“pageinfo”, p);
return"userinfo";
}
@RequestMapping("/getAllUser")
public String getAllUser(Model model,@RequestParam(defaultValue = “1”)int pageNum,@RequestParam(defaultValue = “2”)int pageSize) {
PageHelper.startPage(pageNum,pageSize);
List u = userService.getAllUser();
PageInfo p=new PageInfo(u);
model.addAttribute(“pageinfo”,p);
model.addAttribute(“ulist”,u);
return “userinfo”;
}
@RequestMapping("/toAddUser")
public String toAddUser() {// 跳转到添加用户页面
return “addUser”;
}
@RequestMapping("/addUser")
public String addUser(User user) {// 执行添加用户的功能
int t = userService.addUser(user);
if(t>0)
return “forward:getAllUser”;
else
return"erro" ;
}
@RequestMapping("/deleteUser")
public String deleteUser(int uid) { //删除用户
int t=userService . deleteUser(uid);
if(t>0)
return “forward:getA1lUser”;
else
return “erro” ;
}
@RequestMapping("/toUpdateUser")
public String toUpdateUser(Integer uid ,Model model) {// 跳转到修改用户页面
User u=userService.queryUserByUid(uid);
model.addAttribute(“user”, u);
return “updateUser”;
}
@RequestMapping("/xiugaiUser")
public String xiugaiUser(User user) {
int t=userService . updateUser(user);
if(t>0)
return " forward:getAllUser";
else
return"erro" ;
}
}*********************************************************************************************************

UserMapper.java****************************************************************************************
package cn.test.mapper;

import java.util.List;

import cn.test.po.User;

public interface UserMapper {
public User getUserByid(int uid);

public User queryUserByUid(int uid);
public List<User> getAllUser();
public List<User> queryByUname(String uname);
public int addUser(User user);
public int deleteUser(int uid);
public int updateUser(User user);

}*****************************************************************************************************************

UserMapper.xml************************************************************************************************

*********************************************************************************************

User.java**************************************************************************************************
package cn.test.po;

public class User {
private int uid;
private String uname;
private int age;
public User(int uid, String uname, int age) {
super();
this.uid = uid;
this.uname = uname;
this.age = age;
}
public User() {
super();
}
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname ;
}
public void setUname (String uname) {
this. uname = uname;
}
}**********************************************************************************************************

UserService.java*******************************************************************************************************
package cn.test.service;

import java.util.List;

import cn.test.po.User;

public interface UserService {
public User getUserByid(int uid);

public User queryUserByUid(int uid);
public List<User> getAllUser();//获取所有用户信息
public List<User> queryByUname (String uname);
public int addUser(User user);
public int deleteUser(int uid);
public int updateUser(User user);

}

UserServiceimpl.java******************************************************************************************************
package cn.test.service;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service ;
import cn.test.mapper.UserMapper;
import cn.test.po.User;
@Service
public class UserServiceimpl implements UserService {
@Autowired
UserMapper userMapper;
@Override
public User getUserByid(int uid) {
return userMapper.getUserByid(uid);
}

@Override
public User queryUserByUid(int uid) {
return userMapper.queryUserByUid(uid);
}
@Override
public List getAllUser() {
return userMapper.getAllUser();
}
@Override
public List queryByUname(String uname) {
return userMapper.queryByUname(uname);
}
@Override
public int addUser(User user) {
return userMapper.addUser(user);
}
@Override
public int deleteUser(int uid) {
return userMapper.deleteUser(uid);
}
@Override
public int updateUser(User user) {
return userMapper.updateUser(user);
}

}******************************************************************************************************

web.xml**************************************************************************************************

addUser.jsp*****************************************************************************************************
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>

user.jsp******************************************************************************************************************
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>

userinfo.jsp*****************************************************************************************************************

<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>