2018年1月28日
【0】功能要求
用户修改与保存功能:(1)登陆成功后(login.jsp),sys.jsp 系统页面会有链接---“用户修改”,点击跳转到补全用户修改信息( userModifySave.jsp),若是添加成功则会保存至数据库,并跳转用户显示(userlist.jsp),否则继续返回系统页面(sys.jsp);(2)用户修改信息包括常用数据和文件上传;
【1】jar包/文件架构
jar包:
图1
文件结构:
图2
【2】View层
1.在sys.jsp添加以下代码:
<h4>------------------点击下面的链接进行用户信息修改:---------</h4>
<br>
<a href="${pageContext.request.contextPath}/user/userModify.html">跳转到用户信息修改.</a>
<br/>
图3
2.新建/jsp/userModifySave.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h5>这是userModifySave页面!</h5>
<form action="${pageContext.request.contextPath }/user/userModifySave.html" method="post" enctype="multipart/form-data">
需要修改信息的用户ID:<input type="text" name="id" value=""><br>
用户编码 :<input type="text" name="userCode" value=""/><br>
用户名称 :<input type="text" name="userName" value=""/><br>
用户密码 :<input type="text" name="userPassword" value=""/><br>
用户地址 :<input type="text" name="address" value=""/> <br>
用户电话 : <input type="text" name="phone" value=""/><br>
用户生日 :<input type="text" name="birthday" value=""/><br>
用户性别: <select name="gender" id="gender">
<option value="1">女</option>
<option value="2" selected="selected">男</option>
</select><br>
用户角色 :<select name="userRole" id="userRole">
<option value="100" selected="selected">tour</option>
<option value="101">OrdinaryUser</option>
<option value="110">Administrator</option>
<option value="111">Manager</option>
</select><br>
<div>
<input type="hidden" id="errorinfo" value="${uploadFileError}">
文件1:<input type="file" name="uploadModifyFiles"/><br/><br/>
</div>
<div>
<input type="hidden" id="errorinfo" value="${uploadFileError}">
文件2:<input type="file" name="uploadModifyFiles"/><br/><br/>
</div>
<input type="submit" value="上传"/>
<input type="reset" value="重置"/>
</form>
</body>
</html>
图4
【3】控制器方法:
1.UserController.java添加处理方法:
@RequestMapping(value="/userModify.html",method=RequestMethod.GET)
public String modifyUser(@ModelAttribute("userModify") User userModify,HttpSession session){
System.out.println("UserController-modifyUser");
return "userModifySave";
}
@RequestMapping(value="/userModifySave.html",method=RequestMethod.POST)
public String modifyUserSave(User userModify,HttpSession session,
HttpServletRequest request,
@RequestParam(value="uploadModifyFiles",required=false)MultipartFile[] uploadModifyFiles) throws SQLException{
System.out.println("UserController-modifyUserSave");
System.out.println("userModify: "+userModify.toString());
String errorInfo = null;
String idPicPath = null;
String workPicPath = null;
boolean flag = true;
//获取保存文件的绝对路径
String path = request.getSession().getServletContext().getRealPath("statics"+File.separator+"uploadfilesUser");
System.out.println("2.1 uploadFile path ===>"+path);
for(int i=0;i<uploadModifyFiles.length;i++){
MultipartFile uploadFile = uploadModifyFiles[i];
System.out.println("开始-flag: "+flag);
if(!uploadFile.isEmpty()){
if(i==0){
errorInfo = "uploadFileError!";
}else if(i==1){
errorInfo = "uploadWpError!";
}
System.out.println("文件数量-flag: "+flag);
String oldFileName = uploadFile.getOriginalFilename();
String prefix = FilenameUtils.getExtension(oldFileName);
int filesize = 500000;
if(uploadFile.getSize() > filesize){
request.setAttribute("uploadFileError", "* 上传大小不得超过5000KB");
System.out.println("* 上传大小不得超过5000KB");
flag = false;
System.out.println("文件大小-flag: "+flag);
return "useradd";
}else if(prefix.equalsIgnoreCase("jpg")
|| prefix.equalsIgnoreCase("png")
|| prefix.equalsIgnoreCase("jpeg")
|| prefix.equalsIgnoreCase("pneg")){
//上传格式正确,重命名文件
String fileName = System.currentTimeMillis()+RandomUtils.nextInt(1000000)+"_Personal.jpg";
System.out.println("2.2 new fileName===>"+uploadFile.getName());
//新建这么一个文件,FILE API
File targetFile = new File(path,fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
System.out.println("格式-flag: "+flag);
//保存
try{
//上传
uploadFile.transferTo(targetFile);
}catch (Exception e){
e.printStackTrace();
request.setAttribute("uploadFileError", "* 上传失败! ");
System.out.println("* 上传失败! ");
flag = false;
System.out.println("上传-flag: "+flag);
return "useradd";
}
if(i==0){
idPicPath = path+File.separator+fileName;
log.info("2.3 idPicPath==>"+idPicPath);
}else if(i==1){
workPicPath = path+File.separator+fileName;
log.info("2.4 workPicPath==>"+workPicPath);
}
}else{
request.setAttribute("uploadFileError", "* 上传格式错误!");
System.out.println("* 上传格式错误!");
flag = false;
return "useradd";
}
}
}
System.out.println("flag:"+flag);
if(flag){
userModify.setIdPicPath(idPicPath);
userModify.setWorkPicPath(workPicPath);
System.out.println(" userModify.idPicPath: "+ userModify.getIdPicPath());
System.out.println(" userModify.workPicPath: "+ userModify.getWorkPicPath());
userModify.setCreatedBy(((User)session.getAttribute("currentUser")).getId());
System.out.println("userModify is: "+userModify.toString());
if(userService.modify(userModify)){
System.out.println("2.5 modify user success..");
return "redirect:/user/userlist";
}
}
return "sys";
}
解释:1、添加了“userModify”进Model,用于保存需要修改的信息;
【4】Service层
1. /Service/UserService.java 接口添加modify()方法:
public interface UserService {
public boolean modify(User userModify) throws SQLException;
}
2. UserServiceImpl.java实现类:
package com.User.Service;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.User.Dao.UserDao;
import com.User.entities.User;
@Service("userService")
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao ;
@Override
public boolean modify(User userModify) throws SQLException {
System.out.println("UserServiceImpl-modify");
boolean result = false;
if(userDao.modify(userModify) == 1){
result = true;
}
return result;
}
}
【5】Dao层
1. /Dao/UserDao.java接口添加modify()方法:
package com.User.Dao;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.List;
import com.User.entities.User;
public interface UserDao {
public int modify(User userModify) throws SQLException;
}
2. UserDaoImpl.java:
package com.User.Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.log4j.Logger;
import org.springframework.stereotype.Component;
import com.User.Controller.UserController;
import com.User.entities.User;
import com.mysql.jdbc.PreparedStatement;
@Component("userDao")
public class UserDaoImpl implements UserDao {
private Connection conn = null;
private Statement stmt = null;
private PreparedStatement p_stmt = null;
private ResultSet rs = null;
private String sql;
@Override
public int modify(User userModify) throws SQLException {
System.out.println("UserDaoImpl-add");
Logger log = Logger.getLogger(UserController.class.getName());
SimpleDateFormat birthdayFormat = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat createDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String birthday = birthdayFormat.format(userModify.getBirthday());
userModify.setModifyDate(new Date());
String modifyDate = createDateFormat.format(userModify.getModifyDate());
int count = 0;
//第二种方法
sql = "update smbms_user SET "
+"userCode='"+userModify.getUserCode()+"',"
+"userName='"+userModify.getUserName()+"',"
+"userRole="+userModify.getUserRole()+","
+"userPassword='"+userModify.getUserPassword()+"',"
+"gender="+userModify.getGender()+","
+"birthday='"+birthday+"',"
+"phone='"+userModify.getPhone()+"',"
+"address='"+userModify.getAddress()+"',"
+"modifyBy="+userModify.getModifyBy()+","
+"modifyDate='"+modifyDate+"',"
+"idPicPath='"+userModify.getIdPicPath()+"',"
+"workPicPath='"+userModify.getWorkPicPath()+"' "
+"where id="+ userModify.getId()+";";
String sql2 = " SELECT ROW_COUNT();";
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String username = "root";
String password = "";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,username,password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
stmt = conn.createStatement();
System.out.println("add - sql1: "+sql);
stmt.execute(sql);
System.out.println("add_result_row - sql: "+sql2);
rs = stmt.executeQuery(sql2);
rs.next();
count = rs.getInt(1);
System.out.println("count: "+count);
if(stmt!=null){
stmt.close();
}
if(rs!=null){
rs.close();
}
return count;
}
}
【6】配置文件:
1. spring配置文件 -- applicationContext-jdbc.xml:
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
">
<context:component-scan base-package="com.User.Dao"></context:component-scan>
<context:component-scan base-package="com.User.Service"></context:component-scan>
<context:component-scan base-package="com.Role.Dao"></context:component-scan>
<context:component-scan base-package="com.Role.Service"></context:component-scan>
<context:component-scan base-package="com.Provider.Dao"></context:component-scan>
<context:component-scan base-package="com.Provider.Service"></context:component-scan>
</beans>
2. springmvc配置文件 -- /springmvc-servlet.xml:
<?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:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!--mvc静态资源访问 -->
<mvc:resources mapping="/statics/**" location="/statics/"/>
<!-- 一键式配置 -->
<context:component-scan base-package="com.User.Controller"></context:component-scan>
<context:component-scan base-package="com.Provider.Controller"></context:component-scan>
<context:component-scan base-package="com.User"></context:component-scan>
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 配置视图解析器: 如何把 handler 方法返回值解析为实际的物理视图 -->
<!--prefix 前缀+suffix 后缀 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 全局异常处理 -->
<!-- -->
<bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
<property name="exceptionMappings">
<props>
<prop key="java.lang.RuntimeException">login</prop>
</props>
</property>
</bean>
<!-- 配置MultipartResolver -->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="5000000"></property>
<property name="defaultEncoding" value="UTF-8"></property>
</bean>
</beans>
3. web.xml配置文件:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
id="WebApp_ID" version="2.5">
<!-- 这个指定了log4j.xml放置的目录 -->
<context-param>
<param-name>log4jConfigLocation</param-name>
<param-value>classpath:log4j.properties</param-value>
</context-param>
<!-- 一定要加上这个listener -->
<listener>
<listener-class>
org.springframework.web.util.Log4jConfigListener
</listener-class>
</listener>
<!-- 配置 DispatcherServlet -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-servlet.xml</param-value>
</init-param>
<!--容器启动时就被加载了 -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<filter>
<filter-name>springUtf8Encoding</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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>springUtf8Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>/WEB-INF/jsp/login.jsp</welcome-file>
</welcome-file-list>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext-*.xml</param-value>
</context-param>
<!-- 配置Spring的ContextLoaderListener监听器,初始化spring容器 -->
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
</web-app>
【7】测试结果:
测试输入:
图5
日志打印:
UserServiceImpl-login
18/02/04 16:05:10 INFO Controller.UserController: UserDaoImpl.loginMatch
sql: select * from smbms_user where userName='mmb0889' and userPassword='scua';
8888
4
18/02/04 16:05:10 INFO Controller.UserController: 后台找一下有没有这个username和password: User [id=4, userCode=test01, userName=mmb0889, userPassword=scua, gender=2, birthdayString=null, birthday=1991-12-29, phone=0000, address=maoming, userRole=110, createdBy=1, creationDate=2017-12-17, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=null]
18/02/04 16:05:10 INFO Controller.UserController: user.toString(): User [id=4, userCode=test01, userName=mmb0889, userPassword=scua, gender=2, birthdayString=null, birthday=1991-12-29, phone=0000, address=maoming, userRole=110, createdBy=1, creationDate=2017-12-17, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=null]
18/02/04 16:05:10 INFO Controller.UserController: 刚刚存入了一个session对象:User [id=4, userCode=test01, userName=mmb0889, userPassword=scua, gender=2, birthdayString=null, birthday=1991-12-29, phone=0000, address=maoming, userRole=110, createdBy=1, creationDate=2017-12-17, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=null]
UserController-modifyUser
UserController-modifyUserSave
userModify: User [id=2, userCode=test07, userName=ffff, userPassword=43211234, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=jiangsu, userRole=100, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=null]
2.1 uploadFile path ===>D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser
开始-flag: true
文件数量-flag: true
2.2 new fileName===>uploadModifyFiles
格式-flag: true
18/02/04 16:06:17 INFO Controller.UserController: 2.3 idPicPath==>D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731912464_Personal.jpg
开始-flag: true
文件数量-flag: true
2.2 new fileName===>uploadModifyFiles
格式-flag: true
18/02/04 16:06:17 INFO Controller.UserController: 2.4 workPicPath==>D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731675343_Personal.jpg
flag:true
userModify.idPicPath: D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731912464_Personal.jpg
userModify.workPicPath: D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731675343_Personal.jpg
userModify is: User [id=2, userCode=test07, userName=ffff, userPassword=43211234, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=jiangsu, userRole=100, createdBy=4, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731912464_Personal.jpg, workPicPath=D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731675343_Personal.jpg, roleName=null]
UserServiceImpl-modify
UserDaoImpl-add
add - sql1: update smbms_user SET userCode='test07',userName='ffff',userRole=100,userPassword='43211234',gender=2,birthday='1994-07-01',phone='18819467607',address='jiangsu',modifyBy=null,modifyDate='2018-02-04 16:06:17',idPicPath='D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731912464_Personal.jpg',workPicPath='D:\java_ee_eclipse\mmb_workplace\.metadata\.plugins\org.eclipse.wst.server.core\tmp4\wtpwebapps\springmvc5\statics\uploadfilesUser\1517731675343_Personal.jpg' where id=2;
add_result_row - sql: SELECT ROW_COUNT();
count: 1
2.5 modify user success..
18/02/04 16:06:17 INFO Controller.UserController: getUserList ====> queryUserName: null
18/02/04 16:06:17 INFO Controller.UserController: getUserList ====> queryUserRole: null
18/02/04 16:06:17 INFO Controller.UserController: getUserList ====> pageIndex: null
sql: select COUNT('id') from smbms_user
userdao执行的sql: select u.userCode,u.userName,u.gender,u.birthday,u.phone,r.roleName from smbms_user u,smbms_role r where u.userRole=r.id;
18/02/04 16:06:17 INFO Controller.UserController: outside--result:[User [id=null, userCode=test01, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Dec 29 00:00:00 CST 1991, phone=0000, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test07, userName=ffff, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=tour], User [id=null, userCode=test01, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Dec 29 00:00:00 CST 1991, phone=0000, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test01, userName=mmb0889, userPassword=null, gender=2, birthdayString=null, birthday=Sun Dec 29 00:00:00 CST 1991, phone=0000, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test02, userName=mmb088, userPassword=null, gender=1, birthdayString=null, birthday=Tue Jan 09 00:00:00 CST 2018, phone=1212, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=tour], User [id=null, userCode=test03, userName=mmb088, userPassword=null, gender=1, birthdayString=null, birthday=Tue Jan 16 00:00:00 CST 2018, phone=21312, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Manager], User [id=null, userCode=test05, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Tue Jan 16 00:00:00 CST 2018, phone=5534, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=OrdinaryUser], User [id=null, userCode=test09, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Tue Dec 12 00:00:00 CST 2017, phone=1881645231, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=tour], User [id=null, userCode=ffff, userName=mmb0889, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=123456, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg3, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Jun 09 00:00:00 CST 2013, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=OrdinaryUser], User [id=null, userCode=szgg4, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg44, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sat Jul 09 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=ffffaaaa, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Jun 09 00:00:00 CST 2013, phone=123456, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg444, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg4444, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Jun 09 00:00:00 CST 2013, phone=123456, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg45, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg452, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test188, userName=mmb363, userPassword=null, gender=1, birthdayString=null, birthday=Sat Oct 01 00:00:00 CST 1994, phone=18819888888, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=szgg555, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Sun Jun 09 00:00:00 CST 2013, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=jjkk, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819967666, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test07, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=789456, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Manager], User [id=null, userCode=test10, userName=mmb088, userPassword=null, gender=2, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=Administrator], User [id=null, userCode=test10, userName=mmb088, userPassword=null, gender=1, birthdayString=null, birthday=Fri Jul 01 00:00:00 CST 1994, phone=18819467607, address=null, userRole=null, createdBy=null, creationDate=null, creationDateString=null, modifyBy=null, modifyDate=null, modifyDateString=null, idPicPath=null, workPicPath=null, roleName=OrdinaryUser]]
roledao执行的sql: select id,roleCode,roleName from smbms_role;
sql: select id,roleCode,roleName from smbms_role;
页面显示修改的结果:
图6
文件上传成功:
图7