基于ssm的考勤设备和打卡系统----------（一）

最新推荐文章于 2023-06-11 09:00:00 发布

白鹿依山近

最新推荐文章于 2023-06-11 09:00:00 发布

阅读量1.2k

点赞数

分类专栏： spring Mybatis

本文链接：https://blog.csdn.net/moshubai/article/details/102753426

版权

Mybatis 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

spring

16 篇文章 1 订阅

订阅专栏

1.创建一个maven的web项目。

2.准备各种配置

引入依赖

<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.timmy</groupId>
  <artifactId>FingerRealtimeMysqlDemo</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  
  <properties>
		<!-- spring版本号 -->
		<spring.version>4.0.2.RELEASE</spring.version>
		<!-- mybatis版本号 -->
		<mybatis.version>3.2.6</mybatis.version>
		<!-- log4j日志文件管理包版本 -->
		<slf4j.version>1.7.7</slf4j.version>
		<log4j.version>1.2.17</log4j.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>4.3.7.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
		</dependency>


		<!-- spring核心包 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>
		<!-- mybatis/spring包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- 导入java ee jar 包 -->
		<dependency>
			<groupId>javax</groupId>
			<artifactId>javaee-api</artifactId>
			<version>7.0</version>
		</dependency>

		<!-- 导入Mysql数据库链接jar包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.36</version>
		</dependency>
		<!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.2.2</version>
		</dependency>

		<!-- JSTL标签类 -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<!-- 日志文件管理包 -->
		<!-- log start -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>${log4j.version}</version>
		</dependency>


		<!-- 格式化对象，方便输出日志 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.1.41</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${slf4j.version}</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${slf4j.version}</version>
		</dependency>
		<!-- log end -->
		<!-- JSON -->
		<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->

		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-mapper-asl</artifactId>
			<version>1.9.13</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-annotations -->
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-annotations</artifactId>
			<version>2.9.8</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>2.9.8</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-core</artifactId>
			<version>2.9.8</version>
		</dependency>

		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper</artifactId>
			<version>5.1.4</version>
		</dependency>
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>3.0.1</version>
			<scope>provided</scope>
		</dependency>

		<!-- quartz定时任务 -->
		<dependency>
			<groupId>org.quartz-scheduler</groupId>
			<artifactId>quartz</artifactId>
			<version>2.3.0</version>
		</dependency>


	</dependencies>

	<build>
		<pluginManagement><!-- lock down plugins versions to avoid using Maven 
				defaults (may be moved to parent pom) -->
			<plugins>
				<!-- clean lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#clean_Lifecycle -->
				<plugin>
					<artifactId>maven-clean-plugin</artifactId>
					<version>3.1.0</version>
				</plugin>
				<!-- default lifecycle, jar packaging: see https://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_jar_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-jar-plugin</artifactId>
					<version>3.0.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>
				<!-- site lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#site_Lifecycle -->
				<plugin>
					<artifactId>maven-site-plugin</artifactId>
					<version>3.7.1</version>
				</plugin>
				<plugin>
					<artifactId>maven-project-info-reports-plugin</artifactId>
					<version>3.0.0</version>
				</plugin>

				<plugin>
					<groupId>org.apache.maven.plugins</groupId>
					<artifactId>maven-compiler-plugin</artifactId>
					<version>3.1</version>
					<configuration>
						<source>1.8</source>
						<target>1.8</target>
					</configuration>
				</plugin>

			</plugins>
		</pluginManagement>
	</build>
  
  
  
</project>

3.配置资源文件，创建jdbc.properties. spring-mvc.xml, spring-mybatis.xml,这几个主要的文件

这是jdbc,properties,数据库配置，这里使用的是mysql数据库，内容如下：

然后是spring-mvc.xml,主要配置一些试图解析器，还有controller的扫描包，文件上传器配置等

<?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"
	xmlns:task="http://www.springframework.org/schema/task"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
		http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd"> 

    <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 --> 

    <context:component-scan base-package="com.timmy.controller" /> 
   
    <!-- 扩充了注解驱动，可以将请求参数绑定到控制器参数 -->

    <mvc:annotation-driven/>

    <!-- 静态资源处理  css js imgs -->

    <mvc:resources location="/resources/**" mapping="/resources"/>

   
    
    <import resource="quartz.xml"/> 
    <!--避免IE执行AJAX时，返回JSON出现下载文件 --> 

    <bean id="mappingJacksonHttpMessageConverter" 

        class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter"> 

        <property name="supportedMediaTypes"> 

            <list> 

                <value>text/html;charset=UTF-8</value> 

            </list> 

        </property> 

    </bean> 

    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 --> 

    <bean 

        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 

        <property name="messageConverters"> 

            <list> 

                <ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 --> 

            </list> 

        </property> 

    </bean> 

     

    <!-- 配置文件上传，如果没有使用文件上传可以不用配置，当然如果不配，那么配置文件中也不必引入上传组件包 --> 

  

   

    <!-- 配置ViewResolver 。可用多个ViewResolver 。使用order属性排序。   InternalResourceViewResolver 放在最后-->

    <bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">

    <property name="order" value="1"></property>

        <property name="mediaTypes">

            <map>

                <!-- 告诉视图解析器，返回的类型为json格式 -->

                <entry key="json" value="application/json" />

                <entry key="xml" value="application/xml" />

                <entry key="htm" value="text/htm" />

            </map>

        </property>

        <property name="defaultViews">

            <list>

                <!-- ModelAndView里的数据变成JSON -->

                <bean class="org.springframework.web.servlet.view.json.MappingJacksonJsonView" />

            </list>

        </property>

        <property name="ignoreAcceptHeader" value="true"></property>

    </bean>

   

   <!-- 定义跳转的文件的前后缀 ，视图模式配置--> 

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 

        <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 --> 

        <property name="prefix" value="/" /> 

        <property name="suffix" value=".jsp" /> 

    </bean> 

</beans>

3.spring-mybatis.xml文件的配置，包括bean包，还有数据库，还有mybatis的配置

<?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"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:task="http://www.springframework.org/schema/task"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
		http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> 

    <!-- 自动扫描 --> 

     
    

   

    <!-- 引入配置文件 --> 

    <bean id="propertyConfigurer" 

        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 

        <property name="location" value="classpath:jdbc.properties" /> 

    </bean> 

 
   <!-- 数据库连接 --> 
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 

        destroy-method="close"> 

        <property name="driverClassName" value="${driver}" /> 

        <property name="url" value="${url}" /> 

        <property name="username" value="${username}" /> 

        <property name="password" value="${password}" /> 

        <!-- 初始化连接大小 --> 

        <property name="initialSize" value="${initialSize}"></property> 

        <!-- 连接池最大数量 --> 

        <property name="maxActive" value="${maxActive}"></property> 

        <!-- 连接池最大空闲 --> 

        <property name="maxIdle" value="${maxIdle}"></property> 

        <!-- 连接池最小空闲 --> 

        <property name="minIdle" value="${minIdle}"></property> 

        <!-- 获取连接最大等待时间 --> 

        <property name="maxWait" value="${maxWait}"></property> 

    </bean> 

 

    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 --> 

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 

        <property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:mybatis-config.xml" /> 
		<property name="typeAliasesPackage" value="com.timmy.entity"/>
      
        <property name="mapperLocations" value="classpath:com/timmy/mapper/*.xml"></property> 

    </bean> 

 

    <!-- DAO接口所在包名，Spring会自动查找其下的类 --> 

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 

        <property name="basePackage" value="com.timmy.mapper;com.timmy.*.mapper" /> 

        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> 

    </bean> 

 

    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --> 

    <bean id="transactionManager" 

        class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 

        <property name="dataSource" ref="dataSource" /> 

    </bean> 

    <bean id="webSocket" class="com.timmy.websocket.WSServer" >
		<constructor-arg name="port" value="7789"></constructor-arg>
	</bean>
	
	<bean id="webSocketPool" class="com.timmy.websocket.WebSocketPool" >
		
	</bean>
 <tx:annotation-driven transaction-manager="transactionManager" />  
	<task:annotation-driven/>
	<context:component-scan base-package="com.timmy.*"/> 
</beans>

4.生成web.xml,配置一些监听器，servlet，过滤器，还有编码格式

<?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" version="2.5">
  <display-name>FingerRealtimeMysqlDemo</display-name>
    <filter>
        <filter-name>startFilter</filter-name>
        <filter-class>com.timmy.websocket.StartFilter</filter-class>
    </filter>
   <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath*:spring-mybatis*.xml</param-value>
  </context-param>
  <session-config>
    <session-timeout>120</session-timeout>
  </session-config>
    <!--配置监听器，通过监听器的方式来Spring框架运行起来-->
    <listener>  
      <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>  
   </listener>  
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
    <!--解决中文乱码-->
  <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>

  	   
 
    <!--Spring MVC的配置信息
    通过Servlet标签配置dispatcher-->
  <servlet>
    <servlet-name>dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      <!--需要一个初始化参数，加载spring MVC配置文件-->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath*:spring-mvc.xml</param-value>
    </init-param>
      <!--容器启动加载servlet-->
    <load-on-startup>1</load-on-startup>
  </servlet>
    <!--/监听全局路径-->
 
  <servlet-mapping>
    <servlet-name>dispatcher</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  
  <servlet-mapping>
  <servlet-name>default</servlet-name>
  <url-pattern>*.js</url-pattern>
  <url-pattern>*.css</url-pattern>
  </servlet-mapping>
</web-app>

5.本项目有分页的功能，使用的是mybatis的分页插件，新建一个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>
	
	<!-- <typeAliases>
		<package name="ssm.bean"/>
	</typeAliases> -->
	<!-- 分页设置 -->
	<plugins>
	    <plugin interceptor="com.github.pagehelper.PageInterceptor">
	    	<property name="reasonable" value="true"></property>
		</plugin>
	</plugins>
</configuration>

然后在spring-mybatis.xml文件中引入如下配置，即可食用分页插件

至此，配置完毕。运行项目，无报错，即可开发实际功能，包括增删改查等。下一篇我们会讲详细的功能

白鹿依山近

关注

0
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
基于ssm的考勤设备和打卡系统----------（一）

1.创建一个maven的web项目。2.准备各种配置引入依赖<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 h...
复制链接

扫一扫