1.Spring配置文件、Mybatis配置文件、SpringMVC配置文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">
<!-- 配置数据访问层和业务逻辑层包的扫描 -->
<context:component-scan base-package="com.leisong.service.impl"></context:component-scan>
<!--配置数据源-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/smbms?zeroDateTimeBehavior=convertToNull"/>
<property name="user" value="root"/>
<property name="password" value="123456"/>
</bean>
<!--配置SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<!--自动扫描-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.leisong.dao"></property>
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 给类起别名 -->
<typeAliases>
<package name="com.leisong.domain" />
</typeAliases>
</configuration>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
https://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd">
<!--开启注解扫描 -->
<context:component-scan base-package="com.leisong"></context:component-scan>
<!-- 视图解析器对象-->
<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--开启springmvc框架的注解支持-->
<mvc:annotation-driven/>
<!-- 全局异常 -->
<bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
<property name="exceptionMappings">
<props>
<prop key="java.lang.RuntimeException">
error
</prop>
</props>
</property>
</bean>
<!--访问静态资源-->
<mvc:resources mapping="/sta/**" location="/static/"></mvc:resources>
</beans>
2.web.xml
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!-- 加载Spring的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext-jdbc.xml</param-value>
</context-param>
<!-- 配置监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--配置springmvc的前端控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<!-- 配置启动的优先级 -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 配置解决中文乱码的过滤器-->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
3.数据访问层及其映射文件
package com.leisong.dao;
import com.leisong.domain.Role;
import java.util.List;
public interface RoleDao {
//查询所有的角色
public List<Role> getRoleList();
}
package com.leisong.dao;
import com.leisong.domain.User;
import java.util.Date;
import java.util.List;
public interface UserDao {
//查询指定用户
public User getLoginUser(String userCode, String password)throws Exception;
//查询所有的用户列表
public List<User> getUserList(String userName,int roleId);
//查看某个人的信息
public User getUserById(String id);
//修改某个人的信息
public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);
//添加用户
public int add(User user);
//删除
public int deleteById(String id);
}
``
```java
package com.leisong.dao;
import com.leisong.domain.User;
import java.util.Date;
import java.util.List;
public interface UserDao {
//查询指定用户
public User getLoginUser(String userCode, String password)throws Exception;
//查询所有的用户列表
public List<User> getUserList(String userName,int roleId);
//查看某个人的信息
public User getUserById(String id);
//修改某个人的信息
public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);
//添加用户
public int add(User user);
//删除
public int deleteById(String id);
}
<?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.leisong.dao.UserDao">
<select id="getLoginUser" resultType="user">
select * from smbms_user where userCode=#{arg0} and userPassword=#{arg1}
</select>
<select id="getUserList" resultType="user">
select u.*,r.roleName from smbms_user u,smbms_role r where u.userName like #{arg0} and u.userRole=#{arg1}
</select>
<select id="getUserById" resultType="user" parameterType="String">
select u.* from smbms_user u where u.id=#{id}
</select>
<update id="updateByUserId" >
update smbms_user u set userName=#{arg0},userPassword=#{arg1},gender=#{arg2},birthday=#{arg3},phone=#{arg4},address=#{arg5} where u.id=#{arg6}
</update>
</mapper>
4.业务逻辑层
package com.leisong.service;
import com.leisong.domain.Role;
import java.util.List;
public interface RoleService {
//查询所有的角色
public List<Role> findRoleList();
}
package com.leisong.service;
import com.leisong.domain.User;
import java.util.Date;
import java.util.List;
public interface UserService {
public User findUser(String userCode, String password);
//查询所有的用户列表
public List<User> findUserList(String userName,int roleId);
//查看某个人的信息
public User findUserById(String id);
//修改某个人的信息
public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);
//添加用户
public int save(User user);
//删除
public int deleteById(String id);
}
package com.leisong.service.impl;
import com.leisong.dao.RoleDao;
import com.leisong.domain.Role;
import com.leisong.service.RoleService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service("roleService")
public class RoleServiceImpl implements RoleService {
@Resource
private RoleDao roleDao;
public RoleDao getRoleDao() {
return roleDao;
}
public void setRoleDao(RoleDao roleDao) {
this.roleDao = roleDao;
}
@Override
public List<Role> findRoleList() {
return roleDao.getRoleList();
}
}
package com.leisong.service.impl;
import com.leisong.dao.UserDao;
import com.leisong.domain.User;
import com.leisong.service.UserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.Date;
import java.util.List;
@Service("userService")
public class UserServiceImpl implements UserService {
@Resource
private UserDao userdao;
public UserDao getUserdao() {
return userdao;
}
public void setUserdao(UserDao userdao) {
this.userdao = userdao;
}
@Override
public User findUser(String userCode, String password) {
User user = null;
try {
user = userdao.getLoginUser(userCode, password);
} catch (Exception e) {
e.printStackTrace();
}
return user;
}
@Override
public List<User> findUserList(String userName, int roleId) {
return userdao.getUserList(userName, roleId);
}
@Override
public User findUserById(String id) {
return userdao.getUserById(id);
}
@Override
public void updateByUserId( String userName, String userPassword,
int gender, Date birthday, String phone, String address,String id) {
userdao.updateByUserId(userName, userPassword, gender, birthday, phone, address,id);
}
@Override
public int save(User user) {
return userdao.add(user);
}
@Override
public int deleteById(String id) {
return userdao.deleteById(id);
}
}
6.控制器
package com.leisong.controller;
import com.leisong.domain.Role;
import com.leisong.domain.User;
import com.leisong.service.RoleService;
import com.leisong.service.UserService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.validation.Valid;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Controller
@RequestMapping("/user")
public class UserController {
@Resource
UserService us=null;
@Resource
RoleService rs=null;
//登录
@RequestMapping(value="/login.html")
public String dologin(String username,String password,HttpServletRequest request,HttpSession session){
//调用业务逻辑层
User user=us.findUser(username, password);
if(user==null){
/*request.setAttribute("errors", "用户名密码不正确");
return "login";*/
throw new RuntimeException("用户名密码不正确....");
}else{
System.out.println("控制器user用户的值:"+user.getUserName());
session.setAttribute("currentUser", user);
//return "main";
return "redirect:/user/main.html";
}
}
//定义跳转到主页面的处理器
@RequestMapping(value="/main.html")
public String doMain(){
return "main";
}
//定义局部异常处理
/* @ExceptionHandler(value=RuntimeException.class)
public String handlerException(RuntimeException e,HttpServletRequest request){
request.setAttribute("e", e);
return "login";
}*/
//查询所有的用户列表
@RequestMapping(value="/findUserList.html" )
public String findUserList(@RequestParam(value="userName",required=false)String userName,@RequestParam(value="roleId",required=false,defaultValue="0")int roleId,Model model){
List<User> list=us.findUserList(userName, roleId);
System.out.println("接受到的用户名:"+userName);
List<Role> roleList=rs.findRoleList();
model.addAttribute("userList",list);
model.addAttribute("queryUserName",userName);
model.addAttribute("queryroleId",roleId);
model.addAttribute("roleList",roleList);
return "userList";
}
@RequestMapping(value="/getUserById.html/{uid}")
public String findByUserId(@PathVariable(value="uid") String id,Model model){
User user=us.findUserById(id);
model.addAttribute("u",user);
return "userInfo";
}
//修改
@RequestMapping(value="/updateUserById.html/{id}")
public String updateUserById(@PathVariable(value="id") String id, Model model){
User user=us.findUserById(id);
model.addAttribute("u",user);
return "updateUser";
}
//真正完成修改操作
@RequestMapping(value="/update.html",method=RequestMethod.POST)
//public String updateUser(String id,String userCode,String userName,String userPassword,int gender,Date birthday,String phone,String address,Model model){
public String updateUser(User user,Model model){
System.out.println(user.getUserName());
us.updateByUserId(user.getUserName(), user.getUserPassword(), user.getGender(), user.getBirthday(), user.getPhone(), user.getAddress(),user.getId().toString());
return "redirect:/user/findUserList.html";
}
//定义跳转到添加用户页面的路由
@RequestMapping(value="userAdd.html")
public String add(User user){
return "userAdd";
}
@RequestMapping(value="userAdd1.html")
public String add1(User user){
return "userAdd1";
}