写在题前:如果是mybatis逆向工程生成的代码一定注意变量大小写!一定注意变量大小写!一定注意变量大小写!(重要的事情说三遍)
工程结构
出于方便,service层略去
pom文件配置
IDEA和eclipse有部分地方不同所以需要多导入一些依赖
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.openlab.web</groupId>
<artifactId>UserManagement</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>UserManagement Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp.jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet/servlet-api -->
<!-- https://mvnrepository.com/artifact/javax.servlet.jsp/jsp-api -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
</dependencies>
<build>
<finalName>UserManagement</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
前端页面
login.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'login.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<style type="text/css">
span{
color:red;
font-weight:bold;
}
</style>
<script type="text/javascript">
function changeVerifyCode(){
t = new Date().getTime();
document.getElementById("myImage").src="VerifyCodeServlet.vc?t="+t;
}
</script>
</head>
<body>
<form action="loginServlet.do?opt=login" method="post">
<label>用户名:</label>
<input type="text" name="username">
<span>
<%
String err = (String) (request.getAttribute("err"));
if(err!=null&&(!err.equals(""))){
out.println(err);
}
%>
</span><br>
<label>密码:</label>
<input type="password" name="password"><br/>
<input type="submit" value="提交" />
</form>
</body>
</html>
menu.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.openlab.pojo.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'menu.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<script type="text/javascript" src="js/dtree/dtree.js"></script>
<script type="text/javascript" src="js/java-like.util.js"></script>
<link rel="stylesheet" href="js/dtree/dtree.css" type="text/css">
</head>
<body>
<form action="" name="form1" method=POST>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="5" width="1" bgcolor="CCCCCC"></td>
<td bgcolor="CCCCCC" height="1"></td>
<td rowspan="4" bgcolor="CCCCCC" width="1"></td>
</tr>
<tr>
<td bgcolor="E3E7FF" align="center" height="5"></td>
</tr>
<tr>
<td bgcolor="CCCCCC" height="1"></td>
</tr>
<tr>
<td bgcolor="F9F9F9" align="center" valign="top">
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="F5F5F5">
<tr bgcolor="F3F9FF">
<td bgcolor="F5F5F5">
<script LANGUAGE="JavaScript">
d = new dTree('d');
d.config.target = "body";
d.config.imageDir = 'js/dtree/img';
d.reSetImagePath();
d.config.folderLinks = false;
d.config.closeSameLevel = true;
var isOpen ;
//根节点
<%
User user = (User)session.getAttribute("user");
List<Menu> list = user.getMenus();
for(int i = 0;i<list.size();i++){
Menu m = list.get(i);
%>
d.add(<%=m.getMenuid()%>, <%=m.getFatherid()%>, '<%=m.getMenuname()%>', '<%=m.getMenuurl()%>', '', 'body');
<%
}
%>
document.write(d);
</script>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td background="images/jao1.gif" colspan="2" align="right"><img
src="images/jao.gif" width="8" height="8"> <br></td>
</tr>
</table>
</form>
</body>
</html>
配置文件部分
<?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>
<properties resource="jdbc.properties"></properties>
<typeAliases>
<package name="com.openlab.pojo"></package>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com//openlab//mapper//UserMapper.xml"></mapper>
</mappers>
</configuration>
<?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.openlab.mapper.UserMapper">
<select id="queryForLogin" resultMap="userMapping">
SELECT
u.id,u.username,u.password,u.roleId,u.iconURL,
r.roleId,r.roleName,
m.menuId,m.menuName,m.menuURL,m.fatherId,
f.funId,f.funName,f.funURL,f.menuId
FROM
user u
LEFT JOIN role r
ON u.roleId=r.roleId
LEFT JOIN role_menu rm
ON r.roleId = rm.roleId
LEFT JOIN menu m
ON rm.menuId=m.menuId
LEFT JOIN funs f
ON m.menuId=f.menuId
WHERE
u.username=#{userName} AND u.password=#{password}
</select>
<select id="userNameIsExist" resultType="java.lang.Integer">
SELECT
COUNT(1)
FROM
user
WHERE
username=#{userName}
</select>
<!--定义user的映射-->
<resultMap id="userMapping" type="User">
<id column="id" property="id"></id>
<result column="username" property="username"></result>
<result column="password" property="password"></result>
<result column="roleId" property="roleid"></result>
<result column="iconURL" property="iconurl"></result>
<association property="role" javaType="Role" resultMap="roleMapping"></association>
</resultMap>
<!--定义role的映射-->
<resultMap id="roleMapping" type="Role">
<id column="roleId" property="roleid"></id>
<result column="roleName" property="rolename"></result>
<collection property="menus" ofType="Menu" resultMap="menuMapping"></collection>
</resultMap>
<!--定义menu的映射-->
<resultMap id="menuMapping" type="Menu">
<id column="menuId" property="menuid"></id>
<result column="menuName" property="menuname"></result>
<result column="menuURL" property="menuurl"></result>
<result column="fatherId" property="fatherid"></result>
<collection property="funs" ofType="funs" resultMap="funsMapping"></collection>
</resultMap>
<!--定义funs的映射-->
<resultMap id="funsMapping" type="Funs">
<id column="funId" property="funid"></id>
<result column="funName" property="funname"></result>
<result column="funURL" property="funurl"></result>
<result column="menuId" property="menuid"></result>
</resultMap>
</mapper>
实体类及工具类略~~
servlet
package com.openlab.servlet;
import com.openlab.mapper.UserMapper;
import com.openlab.pojo.User;
import com.openlab.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet(value = "/loginServlet.do")
public class LoginServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
SqlSession sqlSession = MybatisUtil.getSqlSession();
String username = request.getParameter("username");
String password = request.getParameter("password");
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.queryForLogin(username, password);
if(user == null){
request.setAttribute("err","用户名密码错误");
request.getRequestDispatcher("login.jsp").forward(request,response);
}else {
System.out.println(user.getUsername()+user.getRole().getMenus());
request.getSession().setAttribute("user",user);
response.sendRedirect(request.getContextPath()+"/home.jsp");
}
}
}
结果演示
管理员张三对应9个菜单
普通员工lisi对应六个菜单
普通用户王五对应三个菜单