- 浏览: 54875 次
- 性别:
- 来自: 北京
文章分类
最新评论
01_搭建项目搭架SSM.和mybatis_generator自动生成mapper与model
1 创建一个maven工程:
2 在pom.xml文件中添加包
<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>cn.hd.zcbfwen</groupId>
<artifactId>acbfwen</artifactId>
<version>1.0</version>
<packaging>war</packaging>
<name>acbfwen</name>
<description/>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<!-- spring的版本是4.3.3.RELEASE -->
<spirng.version>4.3.3.RELEASE</spirng.version>
</properties>
<dependencies>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 数据库相关的包 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1</version>
</dependency>
<!-- 1、先添加spring相关的包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spirng.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spirng.version}</version>
</dependency>
<!--aspectjweaver包:面向切面要用到的包 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.5</version>
</dependency>
<!--4、单元测试相关的包 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!-- 2、mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 整合插件包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.3.2</version>
<configuration>
<source>1.7</source>
<target>1.7</target>
</configuration>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>2.2</version>
<configuration>
<version>3.0</version>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>
</plugins>
</build>
</project>
3 添加配置文件:
1 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_3_0.xsd"
id="WebApp_ID" version="3.0">
<display-name>acbfwen</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 配置DispatchcerServlet -->
<servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置Spring mvc下的配置文件的位置和名称 -->
<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>springDispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 防止资源文件被spring MVC拦截 -->
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.css</url-pattern>
</servlet-mapping>
</web-app>
2 加其他配置文件:
3 修改数据库配置文件:db.properties
#driver_class=oracle.jdbc.driver.OracleDriver
#jdbcUrl=jdbc:oracle:thin:@192.168.1.203:1521:xe
#user=test01
#password=123456
#hibernate.dialect=org.hibernate.dialect.MySQLDialect
driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://192.168.4.236:3306/zcbfwen?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=wjy
jdbc_password=wjy
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect
#driverClassName=net.sourceforge.jtds.jdbc.Driver
#validationQuery=SELECT 1
#jdbc_url=jdbc:jtds:sqlserver://127.0.0.1:1433/sshe
#jdbc_username=sa
#jdbc_password=123456
#jndiName=java:comp/env/dataSourceName
#hibernate.hbm2ddl.auto=update
#hibernate.show_sql=true
#hibernate.format_sql=true
4 配置application.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:p="http://www.springframework.org/schema/p"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 扫描 -->
<context:component-scan base-package="cn.hd.mapper,cn.hd.service.impl"></context:component-scan>
<!-- 导入db.properties -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 先配置数据源:c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driverClassName}"></property>
<property name="jdbcUrl" value="${jdbc_url}"></property>
<property name="user" value="${jdbc_username}"></property>
<property name="password" value="${jdbc_password}"></property>
</bean>
<bean id="sqlsessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- 加载mybatis.cfg.xml文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml" ></property>
<!-- 自动扫描需要定义类别名的包,将包内的JAVA类的类名作为类别名 -->
<property name="typeAliasesPackage" value="cn.hd.model"></property>
</bean>
<!-- 自动扫描所有的Mapper接口与文件 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.hd.mapper"></property>
</bean>
</beans>
5 mybatis-config.xml
<?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>
<settings>
<setting name="cacheEnabled" value="true"/>
</settings>
<typeAliases>
<!--
<typeAlias type="cn.hd.model.Userbean" alias="userbean"/>
-->
<!-- 批量设置别名:别名就是类名(把第一个字母改小写) -->
<package name="cn.hd.model"/>
</typeAliases>
</configuration>
6 log4j.properties
log4j.rootCategory=debug, stdout , R
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[QC] %p [%t] %C.%M(%L) | %m%n
log4j.appender.R=org.apache.log4j.DailyRollingFileAppender
log4j.appender.R.File=D\:\\Tomcat 5.5\\logs\\qc.log
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%d-[TS] %p %t %c - %m%n
7 springmvc.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:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">
<context:component-scan base-package="cn.hd.controller"></context:component-scan>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
</beans>
4mybatis_generator
4.1 oracle mybatis-generator-oracle.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<classPathEntry location="C:\\driver\\ojdbc14.jar" />
<context id="OracleTables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:XE" userId="oa01"
password="oa01">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="cn.hd.model"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="cn.hd.mapper"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER"
targetPackage="cn.hd.mapper" targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="t_user" domainObjectName="Userbean"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>
4.2 mysql mybatis-generator-mysql.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<classPathEntry location="D:\\mysql-connector-java-5.1.38.jar" />
<context id="mysqlTables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://192.168.4.236:3306/zcbfwjy"
userId="wjy"
password="wjy">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="cn.hd.model"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="cn.hd.mapper"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER"
targetPackage="cn.hd.mapper" targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="t_user" domainObjectName="Userbean"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
<table tableName="t_role" domainObjectName="Role"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
<table tableName="t_security" domainObjectName="Security"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>
5 右击自动生成 model 和 mapper 并且拷贝到当前工程下面
6 注意容易出现的问题:
1 忘记写 @Controller @Service
2 jar错误:
a 删除.m2 的所有jar包
b clean compile
c clean
d update
7 编写代码,导入数据库(主要看t_user表)
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50547
Source Host : localhost:3306
Source Database : zcbfwjy
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2017-02-16 23:22:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_asset`
-- ----------------------------
DROP TABLE IF EXISTS `t_asset`;
CREATE TABLE `t_asset` (
`cardno` int(20) NOT NULL AUTO_INCREMENT,
`misno` varchar(20) NOT NULL,
`assetname` varchar(30) NOT NULL,
`assettype` varchar(30) NOT NULL,
`unit` varchar(10) NOT NULL,
`originalvalue` int(11) NOT NULL,
`usingstate` varchar(6) NOT NULL,
`supplier` varchar(30) NOT NULL,
`daiwei` varchar(30) NOT NULL,
`project` varchar(30) DEFAULT NULL,
`manufacturers` varchar(30) DEFAULT NULL,
`sam` varchar(30) DEFAULT NULL,
`accessories` varchar(30) DEFAULT NULL,
`configuration` varchar(50) DEFAULT NULL,
`maintenance` datetime DEFAULT NULL,
`userdept` varchar(30) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_asset
-- ----------------------------
INSERT INTO `t_asset` VALUES ('1', 'a', '电脑', '计算机', '2', '5000', '外借', '联想', '联想实体店', null, null, null, null, '一体机', null, '财务', null);
INSERT INTO `t_asset` VALUES ('2', 'b', '桌子', '桌子', '5', '2000', '报废', '撒旦', '诗圣杜甫', null, null, null, null, '担惊受恐', null, '水电费', null);
-- ----------------------------
-- Table structure for `t_assetbfrecord`
-- ----------------------------
DROP TABLE IF EXISTS `t_assetbfrecord`;
CREATE TABLE `t_assetbfrecord` (
`cardno` int(20) NOT NULL AUTO_INCREMENT,
`misno` varchar(20) NOT NULL,
`assetname` varchar(30) NOT NULL,
`assettype` varchar(30) NOT NULL,
`unit` varchar(10) NOT NULL,
`originalvalue` int(11) NOT NULL,
`usingstate` varchar(6) NOT NULL,
`supplier` varchar(30) NOT NULL,
`daiwei` varchar(30) NOT NULL,
`project` varchar(30) DEFAULT NULL,
`manufacturers` varchar(30) DEFAULT NULL,
`sam` varchar(30) DEFAULT NULL,
`accessories` varchar(30) DEFAULT NULL,
`configuration` varchar(50) DEFAULT NULL,
`maintenance` datetime DEFAULT NULL,
`userdept` varchar(30) DEFAULT NULL,
`reason` varchar(100) DEFAULT NULL,
`bftime` datetime DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_assetbfrecord
-- ----------------------------
INSERT INTO `t_assetbfrecord` VALUES ('1', 'f', 'f', 'f', '1', '5', '报废', 'df', 'df', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_assetbfrecord` VALUES ('2', 'sdf', 'sdf', 'sadf', '1', '1', '报废', 'ert', 'werf', null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for `t_borrow`
-- ----------------------------
DROP TABLE IF EXISTS `t_borrow`;
CREATE TABLE `t_borrow` (
`cardno` int(11) NOT NULL,
`t_u_userid` int(11) DEFAULT NULL,
`t_a_cardno` varchar(20) DEFAULT NULL,
`deptno` int(11) DEFAULT NULL,
`userid` int(11) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`endtime` datetime DEFAULT NULL,
`isback` tinyint(1) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_borrow
-- ----------------------------
-- ----------------------------
-- Table structure for `t_dept`
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept` (
`deptid` int(11) NOT NULL,
`deptname` varchar(30) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`deptid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_dept
-- ----------------------------
-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
`roleid` int(11) NOT NULL AUTO_INCREMENT,
`rolename` varchar(20) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '超级管理员', null);
INSERT INTO `t_role` VALUES ('2', '普通用户', null);
INSERT INTO `t_role` VALUES ('4', '普通管理员', null);
-- ----------------------------
-- Table structure for `t_role_security`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_security`;
CREATE TABLE `t_role_security` (
`roleid` int(11) NOT NULL,
`securityid` int(11) NOT NULL,
PRIMARY KEY (`roleid`,`securityid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_role_security
-- ----------------------------
-- ----------------------------
-- Table structure for `t_security`
-- ----------------------------
DROP TABLE IF EXISTS `t_security`;
CREATE TABLE `t_security` (
`securityid` int(11) NOT NULL AUTO_INCREMENT,
`securityname` varchar(30) DEFAULT NULL,
`security` varchar(20) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`securityid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='Ȩ';
-- ----------------------------
-- Records of t_security
-- ----------------------------
INSERT INTO `t_security` VALUES ('1', '系统管理', null, '0', null);
INSERT INTO `t_security` VALUES ('2', '用户管理', null, '1', null);
INSERT INTO `t_security` VALUES ('3', '角色管理', null, '1', null);
INSERT INTO `t_security` VALUES ('4', '菜单管理', null, '1', null);
INSERT INTO `t_security` VALUES ('5', '数据字典管理', null, '1', null);
INSERT INTO `t_security` VALUES ('6', '资产管理', null, '1', null);
INSERT INTO `t_security` VALUES ('7', '到增加用户界面', 'ROLE_USER_INIT', '2', null);
INSERT INTO `t_security` VALUES ('8', '到修改用户界面', 'ROLE_USER_UPDATE', '2', null);
INSERT INTO `t_security` VALUES ('9', '保存用户', 'ROLE_USER_SAVE', '2', null);
INSERT INTO `t_security` VALUES ('10', '查询用户列表', 'ROLE_USER_QUERY', '2', null);
INSERT INTO `t_security` VALUES ('11', '删除用户', 'ROLE_USER_DELETE', '2', null);
INSERT INTO `t_security` VALUES ('12', '到增加角色界面', 'ROLE_ROLE_INIT', '3', null);
INSERT INTO `t_security` VALUES ('13', '到修改角色界面', 'ROLE_ROLE_UPDATE', '3', null);
INSERT INTO `t_security` VALUES ('14', '报存角色', 'ROLE_ROLE_SAVE', '3', null);
INSERT INTO `t_security` VALUES ('15', '查询角色列表', 'ROLE_ROLE_QUERY', '3', null);
INSERT INTO `t_security` VALUES ('16', '删除角色', 'ROLE_ROLE_DELETE', '3', null);
INSERT INTO `t_security` VALUES ('17', '到增加菜单界面', 'ROLE_MENU_INIT', '4', null);
INSERT INTO `t_security` VALUES ('18', '到修改菜单界面', 'ROLE_MENU_UPDATE', '4', null);
INSERT INTO `t_security` VALUES ('19', '保存菜单', 'ROLE_MENU_SAVE', '4', null);
INSERT INTO `t_security` VALUES ('20', '查询菜单列表', 'ROLE_MENU_QUERY', '4', null);
INSERT INTO `t_security` VALUES ('21', '删除菜单', 'ROLE_MENU_DELETE', '4', null);
INSERT INTO `t_security` VALUES ('22', '到增加数据字典界面', 'ROLE_DATA_INIT', '5', null);
INSERT INTO `t_security` VALUES ('23', '到修改数据字典界面', 'ROLE_DATA_UPDATE', '5', null);
INSERT INTO `t_security` VALUES ('24', '查询数据字典列表', 'ROLE_DATA_QUERY', '5', null);
INSERT INTO `t_security` VALUES ('25', '保存数据字典', 'ROLE_DATA_SAVE', '5', null);
INSERT INTO `t_security` VALUES ('26', '到增加资产界面', 'ROLE_ZC_INIT', '6', null);
INSERT INTO `t_security` VALUES ('27', '到修改资产界面', 'ROLE_ZC_UPDATE', '6', null);
INSERT INTO `t_security` VALUES ('28', '查询资产列表', 'ROLE_ZC_QUERY', '6', null);
INSERT INTO `t_security` VALUES ('29', '保存资产', 'ROLE_ZC_SAVE', '6', null);
INSERT INTO `t_security` VALUES ('30', '删除资产', 'ROLE_ZC_DELETE', '6', null);
INSERT INTO `t_security` VALUES ('31', '删除数据字典', 'ROLE_DATA_DELETE', '5', null);
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`departmentid` int(11) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`realname` varchar(20) DEFAULT NULL,
`phonenumber` varchar(11) DEFAULT NULL,
`email` varchar(30) DEFAULT NULL,
`createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`lastlogin` datetime DEFAULT NULL,
`salt` varchar(10) DEFAULT 'salt',
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '1', 'a阿斯蒂芬', 'a', 'a阿斯蒂芬', '12345678901', 'qwer', '2017-02-14 14:45:19', '2017-02-14 14:45:24', 'salt', null);
INSERT INTO `t_user` VALUES ('2', '2', 'b', 'b', 'b', '123456789', 'asdf', '2017-02-14 15:27:25', '2017-02-14 15:27:28', 'salt', null);
INSERT INTO `t_user` VALUES ('5', null, '哈哈哈', 'hhh', '呵呵呵', '5289631', null, null, null, 'salt', null);
INSERT INTO `t_user` VALUES ('6', null, '俺大哥', 'fghj', '的防护套', '8783254', null, null, null, 'salt', null);
INSERT INTO `t_user` VALUES ('7', '12', 'dfa', 'ad', 'asd', '1', 'w', '2017-02-14 20:31:08', null, 'salt', null);
INSERT INTO `t_user` VALUES ('9', null, 'dfa', 'ad', 'asd', '1258', null, '2017-02-14 20:44:26', null, 'salt', null);
INSERT INTO `t_user` VALUES ('10', null, 'dfa阿斯蒂芬', 'ad', 'asd', '1258', null, '2017-02-14 20:44:51', null, 'salt', null);
INSERT INTO `t_user` VALUES ('11', null, '份额', 'afv', '爱玩', '9851', null, '2017-02-15 16:46:47', null, 'salt', null);
-- ----------------------------
-- Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
`userid` int(11) NOT NULL,
`roleid` int(11) NOT NULL,
PRIMARY KEY (`userid`,`roleid`),
KEY `FK_Relationship_1` (`roleid`) USING BTREE,
CONSTRAINT `t_user_role_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `t_role` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES ('1', '1');
8启动项目测试
http://localhost:8080/zcbfwen/user/query
搭建完成!!!
附件为搭建完成的代码包。
1 创建一个maven工程:
2 在pom.xml文件中添加包
<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>cn.hd.zcbfwen</groupId>
<artifactId>acbfwen</artifactId>
<version>1.0</version>
<packaging>war</packaging>
<name>acbfwen</name>
<description/>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<!-- spring的版本是4.3.3.RELEASE -->
<spirng.version>4.3.3.RELEASE</spirng.version>
</properties>
<dependencies>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 数据库相关的包 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1</version>
</dependency>
<!-- 1、先添加spring相关的包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spirng.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spirng.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spirng.version}</version>
</dependency>
<!--aspectjweaver包:面向切面要用到的包 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.5</version>
</dependency>
<!--4、单元测试相关的包 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!-- 2、mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 整合插件包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.3.2</version>
<configuration>
<source>1.7</source>
<target>1.7</target>
</configuration>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>2.2</version>
<configuration>
<version>3.0</version>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>
</plugins>
</build>
</project>
3 添加配置文件:
1 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_3_0.xsd"
id="WebApp_ID" version="3.0">
<display-name>acbfwen</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 配置DispatchcerServlet -->
<servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置Spring mvc下的配置文件的位置和名称 -->
<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>springDispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 防止资源文件被spring MVC拦截 -->
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.css</url-pattern>
</servlet-mapping>
</web-app>
2 加其他配置文件:
3 修改数据库配置文件:db.properties
#driver_class=oracle.jdbc.driver.OracleDriver
#jdbcUrl=jdbc:oracle:thin:@192.168.1.203:1521:xe
#user=test01
#password=123456
#hibernate.dialect=org.hibernate.dialect.MySQLDialect
driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://192.168.4.236:3306/zcbfwen?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=wjy
jdbc_password=wjy
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect
#driverClassName=net.sourceforge.jtds.jdbc.Driver
#validationQuery=SELECT 1
#jdbc_url=jdbc:jtds:sqlserver://127.0.0.1:1433/sshe
#jdbc_username=sa
#jdbc_password=123456
#jndiName=java:comp/env/dataSourceName
#hibernate.hbm2ddl.auto=update
#hibernate.show_sql=true
#hibernate.format_sql=true
4 配置application.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:p="http://www.springframework.org/schema/p"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 扫描 -->
<context:component-scan base-package="cn.hd.mapper,cn.hd.service.impl"></context:component-scan>
<!-- 导入db.properties -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 先配置数据源:c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driverClassName}"></property>
<property name="jdbcUrl" value="${jdbc_url}"></property>
<property name="user" value="${jdbc_username}"></property>
<property name="password" value="${jdbc_password}"></property>
</bean>
<bean id="sqlsessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- 加载mybatis.cfg.xml文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml" ></property>
<!-- 自动扫描需要定义类别名的包,将包内的JAVA类的类名作为类别名 -->
<property name="typeAliasesPackage" value="cn.hd.model"></property>
</bean>
<!-- 自动扫描所有的Mapper接口与文件 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.hd.mapper"></property>
</bean>
</beans>
5 mybatis-config.xml
<?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>
<settings>
<setting name="cacheEnabled" value="true"/>
</settings>
<typeAliases>
<!--
<typeAlias type="cn.hd.model.Userbean" alias="userbean"/>
-->
<!-- 批量设置别名:别名就是类名(把第一个字母改小写) -->
<package name="cn.hd.model"/>
</typeAliases>
</configuration>
6 log4j.properties
log4j.rootCategory=debug, stdout , R
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[QC] %p [%t] %C.%M(%L) | %m%n
log4j.appender.R=org.apache.log4j.DailyRollingFileAppender
log4j.appender.R.File=D\:\\Tomcat 5.5\\logs\\qc.log
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%d-[TS] %p %t %c - %m%n
7 springmvc.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:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">
<context:component-scan base-package="cn.hd.controller"></context:component-scan>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
</beans>
4mybatis_generator
4.1 oracle mybatis-generator-oracle.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<classPathEntry location="C:\\driver\\ojdbc14.jar" />
<context id="OracleTables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:XE" userId="oa01"
password="oa01">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="cn.hd.model"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="cn.hd.mapper"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER"
targetPackage="cn.hd.mapper" targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="t_user" domainObjectName="Userbean"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>
4.2 mysql mybatis-generator-mysql.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<classPathEntry location="D:\\mysql-connector-java-5.1.38.jar" />
<context id="mysqlTables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://192.168.4.236:3306/zcbfwjy"
userId="wjy"
password="wjy">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="cn.hd.model"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="cn.hd.mapper"
targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER"
targetPackage="cn.hd.mapper" targetProject="mybatis_generator\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="t_user" domainObjectName="Userbean"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
<table tableName="t_role" domainObjectName="Role"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
<table tableName="t_security" domainObjectName="Security"
enableCountByExample="false" enableUpdateByExample="false"
enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>
5 右击自动生成 model 和 mapper 并且拷贝到当前工程下面
6 注意容易出现的问题:
1 忘记写 @Controller @Service
2 jar错误:
a 删除.m2 的所有jar包
b clean compile
c clean
d update
7 编写代码,导入数据库(主要看t_user表)
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50547
Source Host : localhost:3306
Source Database : zcbfwjy
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2017-02-16 23:22:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_asset`
-- ----------------------------
DROP TABLE IF EXISTS `t_asset`;
CREATE TABLE `t_asset` (
`cardno` int(20) NOT NULL AUTO_INCREMENT,
`misno` varchar(20) NOT NULL,
`assetname` varchar(30) NOT NULL,
`assettype` varchar(30) NOT NULL,
`unit` varchar(10) NOT NULL,
`originalvalue` int(11) NOT NULL,
`usingstate` varchar(6) NOT NULL,
`supplier` varchar(30) NOT NULL,
`daiwei` varchar(30) NOT NULL,
`project` varchar(30) DEFAULT NULL,
`manufacturers` varchar(30) DEFAULT NULL,
`sam` varchar(30) DEFAULT NULL,
`accessories` varchar(30) DEFAULT NULL,
`configuration` varchar(50) DEFAULT NULL,
`maintenance` datetime DEFAULT NULL,
`userdept` varchar(30) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_asset
-- ----------------------------
INSERT INTO `t_asset` VALUES ('1', 'a', '电脑', '计算机', '2', '5000', '外借', '联想', '联想实体店', null, null, null, null, '一体机', null, '财务', null);
INSERT INTO `t_asset` VALUES ('2', 'b', '桌子', '桌子', '5', '2000', '报废', '撒旦', '诗圣杜甫', null, null, null, null, '担惊受恐', null, '水电费', null);
-- ----------------------------
-- Table structure for `t_assetbfrecord`
-- ----------------------------
DROP TABLE IF EXISTS `t_assetbfrecord`;
CREATE TABLE `t_assetbfrecord` (
`cardno` int(20) NOT NULL AUTO_INCREMENT,
`misno` varchar(20) NOT NULL,
`assetname` varchar(30) NOT NULL,
`assettype` varchar(30) NOT NULL,
`unit` varchar(10) NOT NULL,
`originalvalue` int(11) NOT NULL,
`usingstate` varchar(6) NOT NULL,
`supplier` varchar(30) NOT NULL,
`daiwei` varchar(30) NOT NULL,
`project` varchar(30) DEFAULT NULL,
`manufacturers` varchar(30) DEFAULT NULL,
`sam` varchar(30) DEFAULT NULL,
`accessories` varchar(30) DEFAULT NULL,
`configuration` varchar(50) DEFAULT NULL,
`maintenance` datetime DEFAULT NULL,
`userdept` varchar(30) DEFAULT NULL,
`reason` varchar(100) DEFAULT NULL,
`bftime` datetime DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_assetbfrecord
-- ----------------------------
INSERT INTO `t_assetbfrecord` VALUES ('1', 'f', 'f', 'f', '1', '5', '报废', 'df', 'df', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_assetbfrecord` VALUES ('2', 'sdf', 'sdf', 'sadf', '1', '1', '报废', 'ert', 'werf', null, null, null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for `t_borrow`
-- ----------------------------
DROP TABLE IF EXISTS `t_borrow`;
CREATE TABLE `t_borrow` (
`cardno` int(11) NOT NULL,
`t_u_userid` int(11) DEFAULT NULL,
`t_a_cardno` varchar(20) DEFAULT NULL,
`deptno` int(11) DEFAULT NULL,
`userid` int(11) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`endtime` datetime DEFAULT NULL,
`isback` tinyint(1) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_borrow
-- ----------------------------
-- ----------------------------
-- Table structure for `t_dept`
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept` (
`deptid` int(11) NOT NULL,
`deptname` varchar(30) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`deptid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_dept
-- ----------------------------
-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
`roleid` int(11) NOT NULL AUTO_INCREMENT,
`rolename` varchar(20) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '超级管理员', null);
INSERT INTO `t_role` VALUES ('2', '普通用户', null);
INSERT INTO `t_role` VALUES ('4', '普通管理员', null);
-- ----------------------------
-- Table structure for `t_role_security`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_security`;
CREATE TABLE `t_role_security` (
`roleid` int(11) NOT NULL,
`securityid` int(11) NOT NULL,
PRIMARY KEY (`roleid`,`securityid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_role_security
-- ----------------------------
-- ----------------------------
-- Table structure for `t_security`
-- ----------------------------
DROP TABLE IF EXISTS `t_security`;
CREATE TABLE `t_security` (
`securityid` int(11) NOT NULL AUTO_INCREMENT,
`securityname` varchar(30) DEFAULT NULL,
`security` varchar(20) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`securityid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='Ȩ';
-- ----------------------------
-- Records of t_security
-- ----------------------------
INSERT INTO `t_security` VALUES ('1', '系统管理', null, '0', null);
INSERT INTO `t_security` VALUES ('2', '用户管理', null, '1', null);
INSERT INTO `t_security` VALUES ('3', '角色管理', null, '1', null);
INSERT INTO `t_security` VALUES ('4', '菜单管理', null, '1', null);
INSERT INTO `t_security` VALUES ('5', '数据字典管理', null, '1', null);
INSERT INTO `t_security` VALUES ('6', '资产管理', null, '1', null);
INSERT INTO `t_security` VALUES ('7', '到增加用户界面', 'ROLE_USER_INIT', '2', null);
INSERT INTO `t_security` VALUES ('8', '到修改用户界面', 'ROLE_USER_UPDATE', '2', null);
INSERT INTO `t_security` VALUES ('9', '保存用户', 'ROLE_USER_SAVE', '2', null);
INSERT INTO `t_security` VALUES ('10', '查询用户列表', 'ROLE_USER_QUERY', '2', null);
INSERT INTO `t_security` VALUES ('11', '删除用户', 'ROLE_USER_DELETE', '2', null);
INSERT INTO `t_security` VALUES ('12', '到增加角色界面', 'ROLE_ROLE_INIT', '3', null);
INSERT INTO `t_security` VALUES ('13', '到修改角色界面', 'ROLE_ROLE_UPDATE', '3', null);
INSERT INTO `t_security` VALUES ('14', '报存角色', 'ROLE_ROLE_SAVE', '3', null);
INSERT INTO `t_security` VALUES ('15', '查询角色列表', 'ROLE_ROLE_QUERY', '3', null);
INSERT INTO `t_security` VALUES ('16', '删除角色', 'ROLE_ROLE_DELETE', '3', null);
INSERT INTO `t_security` VALUES ('17', '到增加菜单界面', 'ROLE_MENU_INIT', '4', null);
INSERT INTO `t_security` VALUES ('18', '到修改菜单界面', 'ROLE_MENU_UPDATE', '4', null);
INSERT INTO `t_security` VALUES ('19', '保存菜单', 'ROLE_MENU_SAVE', '4', null);
INSERT INTO `t_security` VALUES ('20', '查询菜单列表', 'ROLE_MENU_QUERY', '4', null);
INSERT INTO `t_security` VALUES ('21', '删除菜单', 'ROLE_MENU_DELETE', '4', null);
INSERT INTO `t_security` VALUES ('22', '到增加数据字典界面', 'ROLE_DATA_INIT', '5', null);
INSERT INTO `t_security` VALUES ('23', '到修改数据字典界面', 'ROLE_DATA_UPDATE', '5', null);
INSERT INTO `t_security` VALUES ('24', '查询数据字典列表', 'ROLE_DATA_QUERY', '5', null);
INSERT INTO `t_security` VALUES ('25', '保存数据字典', 'ROLE_DATA_SAVE', '5', null);
INSERT INTO `t_security` VALUES ('26', '到增加资产界面', 'ROLE_ZC_INIT', '6', null);
INSERT INTO `t_security` VALUES ('27', '到修改资产界面', 'ROLE_ZC_UPDATE', '6', null);
INSERT INTO `t_security` VALUES ('28', '查询资产列表', 'ROLE_ZC_QUERY', '6', null);
INSERT INTO `t_security` VALUES ('29', '保存资产', 'ROLE_ZC_SAVE', '6', null);
INSERT INTO `t_security` VALUES ('30', '删除资产', 'ROLE_ZC_DELETE', '6', null);
INSERT INTO `t_security` VALUES ('31', '删除数据字典', 'ROLE_DATA_DELETE', '5', null);
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`departmentid` int(11) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`realname` varchar(20) DEFAULT NULL,
`phonenumber` varchar(11) DEFAULT NULL,
`email` varchar(30) DEFAULT NULL,
`createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`lastlogin` datetime DEFAULT NULL,
`salt` varchar(10) DEFAULT 'salt',
`remark` varchar(100) DEFAULT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '1', 'a阿斯蒂芬', 'a', 'a阿斯蒂芬', '12345678901', 'qwer', '2017-02-14 14:45:19', '2017-02-14 14:45:24', 'salt', null);
INSERT INTO `t_user` VALUES ('2', '2', 'b', 'b', 'b', '123456789', 'asdf', '2017-02-14 15:27:25', '2017-02-14 15:27:28', 'salt', null);
INSERT INTO `t_user` VALUES ('5', null, '哈哈哈', 'hhh', '呵呵呵', '5289631', null, null, null, 'salt', null);
INSERT INTO `t_user` VALUES ('6', null, '俺大哥', 'fghj', '的防护套', '8783254', null, null, null, 'salt', null);
INSERT INTO `t_user` VALUES ('7', '12', 'dfa', 'ad', 'asd', '1', 'w', '2017-02-14 20:31:08', null, 'salt', null);
INSERT INTO `t_user` VALUES ('9', null, 'dfa', 'ad', 'asd', '1258', null, '2017-02-14 20:44:26', null, 'salt', null);
INSERT INTO `t_user` VALUES ('10', null, 'dfa阿斯蒂芬', 'ad', 'asd', '1258', null, '2017-02-14 20:44:51', null, 'salt', null);
INSERT INTO `t_user` VALUES ('11', null, '份额', 'afv', '爱玩', '9851', null, '2017-02-15 16:46:47', null, 'salt', null);
-- ----------------------------
-- Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
`userid` int(11) NOT NULL,
`roleid` int(11) NOT NULL,
PRIMARY KEY (`userid`,`roleid`),
KEY `FK_Relationship_1` (`roleid`) USING BTREE,
CONSTRAINT `t_user_role_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `t_role` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES ('1', '1');
8启动项目测试
http://localhost:8080/zcbfwen/user/query
搭建完成!!!
附件为搭建完成的代码包。
- 01maven搭建ssm项目(文建迎).rar (352.8 KB)
- 下载次数: 0
发表评论
-
09_短信发送
2017-02-23 10:53 3331 sms.webchinese.cn/default.sht ... -
08_shrio加密
2017-02-23 10:52 2821 准备数据库的数据:通过使用数据库的方式实现权限的管理。 ... -
07_shiro授权测试及与web项目集成
2017-02-23 10:54 425<!-- shiro相关的包 --> < ... -
06_shrio简单入门及加密
2017-02-21 09:19 427权限框架(做身份验证、授权的功能、会话管理、加密): 常见的有 ... -
05_用户模块及角色模块的单表和多表操作
2017-02-21 09:18 3481 Restful风格的参数接收 ... -
04_用户模块及角色模块的单表操作(通过一个vo实现条件查询并且带分页)pm
2017-02-21 09:18 341package cn.hd.model; /* * 条件查询 ... -
03_分页插件HelpPager(GitHub旗下产品,非常方便)
2017-02-21 09:12 520其它 0去掉JavaScript验证,解决红叉问题(这个与分页 ... -
02_用户模块和加入样式和spring对静态文件的放行
2017-02-21 09:09 46502_用户模块和加入样式 1 复制静态文件到当前工程 2 ...
相关推荐
百香果垂帘搭架技术.docx
2021最新幼儿园管理档案-为幼儿的学习 搭架.doc
此资源是搭架spring mvc4.0+mybatis的基础jar包,
华三无线调试专业文档,在帮助各位工程师,最快熟悉无线搭架,包含各种命令调试、AP上线注册原理。。。。。。。。。。。。。。。。
网络组织间关系治理的搭架:行动者网络理论的动态观点.docx
网络组织间关系治理的搭架:行动者网络理论的动态观点.pdf
阿里巴巴的矢量图标库Iconfont: 页面图标,个人项目中使用起来比较方便。 Node.js + Koa2: 后台服务器搭架,(Koa2需要node v7.6以上)。 ES6/ES7: 后台开发以ES6语法为主,并使用了ES7中的async/await。 Gulp: ...
自己编译的windows环境openjdk1.7 32位全源码 src.zip太大放在了另一个文件里
SSH架构的医院项目,仅供学习如何搭架ssh架构使用。
项目简介: 使用UE4对人机工程仿真软件的功能项进行预仿真演示,包括模型管理、场景搭建、人体活动人物仿真、人体姿态评估分析四个功能。 技术栈: UE4 、3DsMAX 搭架web页面对模型进行管理,开发出动态加载功能对...
前言 最近的项目用到了 vue.js + vuex + vue-router 全家桶,版本为 >2.0,在搞Store的时候发现,圈子里大部分关于...默认你已经搭架好了一个项目,而且需要建立或者已经是一个复杂的Store,但是还没有进行模块拆分
学习hadoop 的一些分享保护了 集群的搭架和使用,主要保护HDFS 和 MapReduce
而且采用分段搭架,需增加配合工序的工作量,也不利于抢工期。 经综合比较,决定采用落地架方案。主体阶段主要用于安全防护,主体结构完成之后拆除,在此防护架建筑物四周原开挖处回填夯实后,重新搭设正式装修用...
本文用于快速搭架docker tars java服务,springboot demo!教程文档、springBoot demo源码
记忆继续注解的ssh框架的搭架,适合初学者开发学习,一个基础的ssh框架搭建的demo。
vue快速搭架模板内含 vuex配置 axios配置 i18n多语言配置 新手可快速安装使用 内容全部由本人自己亲自完成
厦门汇成商业中心工程由两栋26层塔楼和4层裙楼组成,塔楼为全现浇钢筋混凝土框剪结构,裙楼为框架结构,建筑面积55926m2,总高85.9m。 第1章外脚手架搭设 在塔楼施工中外脚手架采用悬挑钢管脚手架分段分层搭设,每隔...
在包含中国鹅掌楸Liriodendron chinense和北美鹅掌楸L.tulipifera17个种源的试验林内,选取6个搭架的个体,连续2a定点观察了鹅掌楸的开花习性和传粉媒介。结果表明,鹅掌楸不同种源始花期有差异,但同一种源不同个体...
用于faceswap源码所需要的全套安装包,包含已经配置好的python,设置环境变量既可以用