From d72388c77063623237ab53cef5e2f170d4580c78 Mon Sep 17 00:00:00 2001 From: jiaojizu <jiaojizu@454eff88-639b-444f-9e54-f578c98de674> Date: 星期三, 08 三月 2017 13:25:51 +0800 Subject: [PATCH] --- VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitStat.java | 40 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PostMapper.xml | 60 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PlaceMapper.xml | 242 ++++ VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMapper.java | 17 VisitFace/faceDiscesn/src/main/resources/jdbc.properties | 5 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMatterMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/mapper/callingMapper.xml | 84 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PostMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitStatMapper.java | 9 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PlaceMapper.java | 20 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitingMapper.xml | 184 +++ VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PersonMapper.xml | 236 ++++ VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitStatMapper.xml | 76 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitorTypeMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visiting.java | 61 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/calling/entity/calling.java | 51 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/CheckingCompany.java | 30 VisitFace/faceDiscesn/src/main/resources/MyBaits-config.xml | 5 VisitFace/faceDiscesn/src/main/resources/log4j.properties | 21 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Department.java | 40 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitFace.java | 40 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visit.java | 111 ++ VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/ImageMapper.xml | 40 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Image.java | 40 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/component/user/cotroller/FacilityManager.java | 19 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/EmployeeFaceMapper.xml | 82 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Place.java | 50 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitFaceMapper.xml | 71 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMatterMapper.xml | 84 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitMatter.java | 50 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMapper.xml | 153 +++ VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Company.java | 37 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingCompanyMapper.xml | 31 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/EmployeeFaceMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/CompanyMapper.java | 17 VisitFace/faceDiscesn/src/main/resources/springmvc-context.xml | 11 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Person.java | 181 +++ VisitFace/faceDiscesn/src/main/resources/ehcache.xml | 13 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingCompanyMapper.java | 9 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Post.java | 30 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/DepartmentMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitorType.java | 50 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/EmployeeFace.java | 50 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/DepartmentMapper.xml | 73 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingMapper.xml | 93 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PersonMapper.java | 17 VisitFace/faceDiscesn/src/main/resources/spring-context.xml | 49 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/Checking.java | 61 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitorTypeMapper.xml | 84 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/callingMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/CompanyMapper.xml | 58 + VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitFaceMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitingMapper.java | 17 VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/ImageMapper.java | 9 55 files changed, 2,947 insertions(+), 0 deletions(-) diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/callingMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/callingMapper.java new file mode 100644 index 0000000..568c773 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/callingMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.calling; + +import cn.com.basic.face.discern.calling.entity.calling; + +public interface callingMapper { + int deleteByPrimaryKey(Integer id); + + int insert(calling record); + + int insertSelective(calling record); + + calling selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(calling record); + + int updateByPrimaryKey(calling record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/mapper/callingMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/mapper/callingMapper.xml new file mode 100644 index 0000000..c8043ad --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/calling/mapper/callingMapper.xml @@ -0,0 +1,84 @@ +<?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="cn.com.basic.face.discern.baseapi.calling.callingMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.calling.entity.calling" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="callDT" property="calldt" jdbcType="TIMESTAMP" /> + <result column="callerPersonID" property="callerpersonid" jdbcType="INTEGER" /> + <result column="calleePersonID" property="calleepersonid" jdbcType="INTEGER" /> + </resultMap> + <sql id="Base_Column_List" > + ID, callDT, callerPersonID, calleePersonID + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_calling + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_calling + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.calling.entity.calling" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_calling (ID, callDT, callerPersonID, + calleePersonID) + values (#{id,jdbcType=INTEGER}, #{calldt,jdbcType=TIMESTAMP}, #{callerpersonid,jdbcType=INTEGER}, + #{calleepersonid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.calling.entity.calling" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_calling + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="calldt != null" > + callDT, + </if> + <if test="callerpersonid != null" > + callerPersonID, + </if> + <if test="calleepersonid != null" > + calleePersonID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="calldt != null" > + #{calldt,jdbcType=TIMESTAMP}, + </if> + <if test="callerpersonid != null" > + #{callerpersonid,jdbcType=INTEGER}, + </if> + <if test="calleepersonid != null" > + #{calleepersonid,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.calling.entity.calling" > + update t_calling + <set > + <if test="calldt != null" > + callDT = #{calldt,jdbcType=TIMESTAMP}, + </if> + <if test="callerpersonid != null" > + callerPersonID = #{callerpersonid,jdbcType=INTEGER}, + </if> + <if test="calleepersonid != null" > + calleePersonID = #{calleepersonid,jdbcType=INTEGER}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.calling.entity.calling" > + update t_calling + set callDT = #{calldt,jdbcType=TIMESTAMP}, + callerPersonID = #{callerpersonid,jdbcType=INTEGER}, + calleePersonID = #{calleepersonid,jdbcType=INTEGER} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingCompanyMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingCompanyMapper.java new file mode 100644 index 0000000..ed7ecea --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingCompanyMapper.java @@ -0,0 +1,9 @@ +package cn.com.basic.face.discern.baseapi.checking; + +import cn.com.basic.face.discern.checking.entity.CheckingCompany; + +public interface CheckingCompanyMapper { + int insert(CheckingCompany record); + + int insertSelective(CheckingCompany record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingMapper.java new file mode 100644 index 0000000..caef6ab --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/CheckingMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.checking; + +import cn.com.basic.face.discern.checking.entity.Checking; + +public interface CheckingMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Checking record); + + int insertSelective(Checking record); + + Checking selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Checking record); + + int updateByPrimaryKey(Checking record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingCompanyMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingCompanyMapper.xml new file mode 100644 index 0000000..c052b2b --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingCompanyMapper.xml @@ -0,0 +1,31 @@ +<?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="cn.com.basic.face.discern.baseapi.checking.CheckingCompanyMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.checking.entity.CheckingCompany" > + <result column="personID" property="personid" jdbcType="INTEGER" /> + <result column="companyID" property="companyid" jdbcType="INTEGER" /> + </resultMap> + <insert id="insert" parameterType="cn.com.basic.face.discern.checking.entity.CheckingCompany" > + insert into t_checkingcompany (personID, companyID) + values (#{personid,jdbcType=INTEGER}, #{companyid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.checking.entity.CheckingCompany" > + insert into t_checkingcompany + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="personid != null" > + personID, + </if> + <if test="companyid != null" > + companyID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + <if test="companyid != null" > + #{companyid,jdbcType=INTEGER}, + </if> + </trim> + </insert> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingMapper.xml new file mode 100644 index 0000000..74bbda6 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/checking/mapper/CheckingMapper.xml @@ -0,0 +1,93 @@ +<?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="cn.com.basic.face.discern.baseapi.checking.CheckingMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.checking.entity.Checking" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="statusID" property="statusid" jdbcType="TINYINT" /> + <result column="statusDT" property="statusdt" jdbcType="TIMESTAMP" /> + <result column="personID" property="personid" jdbcType="INTEGER" /> + <result column="placeID" property="placeid" jdbcType="INTEGER" /> + </resultMap> + <sql id="Base_Column_List" > + ID, statusID, statusDT, personID, placeID + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_checking + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_checking + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.checking.entity.Checking" > + insert into t_checking (ID, statusID, statusDT, + personID, placeID) + values (#{id,jdbcType=INTEGER}, #{statusid,jdbcType=TINYINT}, #{statusdt,jdbcType=TIMESTAMP}, + #{personid,jdbcType=INTEGER}, #{placeid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.checking.entity.Checking" > + insert into t_checking + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="id != null" > + ID, + </if> + <if test="statusid != null" > + statusID, + </if> + <if test="statusdt != null" > + statusDT, + </if> + <if test="personid != null" > + personID, + </if> + <if test="placeid != null" > + placeID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="id != null" > + #{id,jdbcType=INTEGER}, + </if> + <if test="statusid != null" > + #{statusid,jdbcType=TINYINT}, + </if> + <if test="statusdt != null" > + #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + <if test="placeid != null" > + #{placeid,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.checking.entity.Checking" > + update t_checking + <set > + <if test="statusid != null" > + statusID = #{statusid,jdbcType=TINYINT}, + </if> + <if test="statusdt != null" > + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="personid != null" > + personID = #{personid,jdbcType=INTEGER}, + </if> + <if test="placeid != null" > + placeID = #{placeid,jdbcType=INTEGER}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.checking.entity.Checking" > + update t_checking + set statusID = #{statusid,jdbcType=TINYINT}, + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + personID = #{personid,jdbcType=INTEGER}, + placeID = #{placeid,jdbcType=INTEGER} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/CompanyMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/CompanyMapper.java new file mode 100644 index 0000000..8beee07 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/CompanyMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Company; + +public interface CompanyMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Company record); + + int insertSelective(Company record); + + Company selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Company record); + + int updateByPrimaryKey(Company record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/DepartmentMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/DepartmentMapper.java new file mode 100644 index 0000000..a012936 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/DepartmentMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Department; + +public interface DepartmentMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Department record); + + int insertSelective(Department record); + + Department selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Department record); + + int updateByPrimaryKey(Department record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/EmployeeFaceMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/EmployeeFaceMapper.java new file mode 100644 index 0000000..fab3a0e --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/EmployeeFaceMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.EmployeeFace; + +public interface EmployeeFaceMapper { + int deleteByPrimaryKey(Integer id); + + int insert(EmployeeFace record); + + int insertSelective(EmployeeFace record); + + EmployeeFace selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(EmployeeFace record); + + int updateByPrimaryKey(EmployeeFace record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/ImageMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/ImageMapper.java new file mode 100644 index 0000000..572237e --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/ImageMapper.java @@ -0,0 +1,9 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Image; + +public interface ImageMapper { + int insert(Image record); + + int insertSelective(Image record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PersonMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PersonMapper.java new file mode 100644 index 0000000..3730b8a --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PersonMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Person; + +public interface PersonMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Person record); + + int insertSelective(Person record); + + Person selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Person record); + + int updateByPrimaryKey(Person record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PlaceMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PlaceMapper.java new file mode 100644 index 0000000..4c3ebce --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PlaceMapper.java @@ -0,0 +1,20 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Place; + +public interface PlaceMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Place record); + + int insertSelective(Place record); + + Place selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Place record); + + int updateByPrimaryKey(Place record); + + Integer qureyCompanyIDByAuthorizationID(String authorizationid); + +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PostMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PostMapper.java new file mode 100644 index 0000000..3bd1724 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/PostMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.Post; + +public interface PostMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Post record); + + int insertSelective(Post record); + + Post selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Post record); + + int updateByPrimaryKey(Post record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitFaceMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitFaceMapper.java new file mode 100644 index 0000000..e135a2e --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitFaceMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.VisitFace; + +public interface VisitFaceMapper { + int deleteByPrimaryKey(Integer id); + + int insert(VisitFace record); + + int insertSelective(VisitFace record); + + VisitFace selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(VisitFace record); + + int updateByPrimaryKey(VisitFace record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitorTypeMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitorTypeMapper.java new file mode 100644 index 0000000..696061c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/VisitorTypeMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.user; + +import cn.com.basic.face.discern.user.entity.VisitorType; + +public interface VisitorTypeMapper { + int deleteByPrimaryKey(Integer id); + + int insert(VisitorType record); + + int insertSelective(VisitorType record); + + VisitorType selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(VisitorType record); + + int updateByPrimaryKey(VisitorType record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/CompanyMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/CompanyMapper.xml new file mode 100644 index 0000000..b59275f --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/CompanyMapper.xml @@ -0,0 +1,58 @@ +<?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="cn.com.basic.face.discern.baseapi.user.CompanyMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Company" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="NAME" property="name" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, NAME + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_company + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_company + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Company" > + insert into t_company (ID, NAME) + values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Company" > + insert into t_company + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="id != null" > + ID, + </if> + <if test="name != null" > + NAME, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="id != null" > + #{id,jdbcType=INTEGER}, + </if> + <if test="name != null" > + #{name,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Company" > + update t_company + <set > + <if test="name != null" > + NAME = #{name,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Company" > + update t_company + set NAME = #{name,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/DepartmentMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/DepartmentMapper.xml new file mode 100644 index 0000000..6dfb6ff --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/DepartmentMapper.xml @@ -0,0 +1,73 @@ +<?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="cn.com.basic.face.discern.baseapi.user.DepartmentMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Department" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="label" property="label" jdbcType="VARCHAR" /> + <result column="labelSpell" property="labelspell" jdbcType="CHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, label, labelSpell + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_department + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_department + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Department" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_department (ID, label, labelSpell + ) + values (#{id,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, #{labelspell,jdbcType=CHAR} + ) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Department" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_department + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="label != null" > + label, + </if> + <if test="labelspell != null" > + labelSpell, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="label != null" > + #{label,jdbcType=VARCHAR}, + </if> + <if test="labelspell != null" > + #{labelspell,jdbcType=CHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Department" > + update t_department + <set > + <if test="label != null" > + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="labelspell != null" > + labelSpell = #{labelspell,jdbcType=CHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Department" > + update t_department + set label = #{label,jdbcType=VARCHAR}, + labelSpell = #{labelspell,jdbcType=CHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/EmployeeFaceMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/EmployeeFaceMapper.xml new file mode 100644 index 0000000..9960c48 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/EmployeeFaceMapper.xml @@ -0,0 +1,82 @@ +<?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="cn.com.basic.face.discern.baseapi.user.EmployeeFaceMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.EmployeeFace" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="registerCompanyID" property="registercompanyid" jdbcType="INTEGER" /> + <result column="personID" property="personid" jdbcType="INTEGER" /> + <result column="imagePath" property="imagepath" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, registerCompanyID, personID, imagePath + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_employeeface + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_employeeface + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.EmployeeFace" > + insert into t_employeeface (ID, registerCompanyID, personID, + imagePath) + values (#{id,jdbcType=INTEGER}, #{registercompanyid,jdbcType=INTEGER}, #{personid,jdbcType=INTEGER}, + #{imagepath,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.EmployeeFace" > + insert into t_employeeface + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="id != null" > + ID, + </if> + <if test="registercompanyid != null" > + registerCompanyID, + </if> + <if test="personid != null" > + personID, + </if> + <if test="imagepath != null" > + imagePath, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="id != null" > + #{id,jdbcType=INTEGER}, + </if> + <if test="registercompanyid != null" > + #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + <if test="imagepath != null" > + #{imagepath,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.EmployeeFace" > + update t_employeeface + <set > + <if test="registercompanyid != null" > + registerCompanyID = #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="personid != null" > + personID = #{personid,jdbcType=INTEGER}, + </if> + <if test="imagepath != null" > + imagePath = #{imagepath,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.EmployeeFace" > + update t_employeeface + set registerCompanyID = #{registercompanyid,jdbcType=INTEGER}, + personID = #{personid,jdbcType=INTEGER}, + imagePath = #{imagepath,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/ImageMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/ImageMapper.xml new file mode 100644 index 0000000..208c0e7 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/ImageMapper.xml @@ -0,0 +1,40 @@ +<?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="cn.com.basic.face.discern.baseapi.user.ImageMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Image" > + <result column="personID" property="personid" jdbcType="INTEGER" /> + <result column="imageTye" property="imagetye" jdbcType="VARCHAR" /> + <result column="imagePath" property="imagepath" jdbcType="VARCHAR" /> + </resultMap> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Image" > + insert into t_image (personID, imageTye, imagePath + ) + values (#{personid,jdbcType=INTEGER}, #{imagetye,jdbcType=VARCHAR}, #{imagepath,jdbcType=VARCHAR} + ) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Image" > + insert into t_image + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="personid != null" > + personID, + </if> + <if test="imagetye != null" > + imageTye, + </if> + <if test="imagepath != null" > + imagePath, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + <if test="imagetye != null" > + #{imagetye,jdbcType=VARCHAR}, + </if> + <if test="imagepath != null" > + #{imagepath,jdbcType=VARCHAR}, + </if> + </trim> + </insert> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PersonMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PersonMapper.xml new file mode 100644 index 0000000..b8c3b43 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PersonMapper.xml @@ -0,0 +1,236 @@ +<?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="cn.com.basic.face.discern.baseapi.user.PersonMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Person" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="NAME" property="name" jdbcType="VARCHAR" /> + <result column="nameSpell" property="namespell" jdbcType="CHAR" /> + <result column="gender" property="gender" jdbcType="BIT" /> + <result column="country" property="country" jdbcType="CHAR" /> + <result column="province" property="province" jdbcType="CHAR" /> + <result column="city" property="city" jdbcType="CHAR" /> + <result column="birthday" property="birthday" jdbcType="DATE" /> + <result column="phone" property="phone" jdbcType="CHAR" /> + <result column="mobilePhone" property="mobilephone" jdbcType="CHAR" /> + <result column="identityType" property="identitytype" jdbcType="CHAR" /> + <result column="identify" property="identify" jdbcType="VARCHAR" /> + <result column="companyID" property="companyid" jdbcType="INTEGER" /> + <result column="departmentID" property="departmentid" jdbcType="INTEGER" /> + <result column="postID" property="postid" jdbcType="INTEGER" /> + <result column="remark" property="remark" jdbcType="VARCHAR" /> + <result column="warning" property="warning" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, NAME, nameSpell, gender, country, province, city, birthday, phone, mobilePhone, + identityType, identify, companyID, departmentID, postID, remark, warning + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_person + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_person + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Person" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_person (ID, NAME, nameSpell, + gender, country, province, city, + birthday, phone, mobilePhone, + identityType, identify, companyID, + departmentID, postID, remark, + warning) + values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{namespell,jdbcType=CHAR}, + #{gender,jdbcType=BIT}, #{country,jdbcType=CHAR}, #{province,jdbcType=CHAR}, #{city,jdbcType=CHAR}, + #{birthday,jdbcType=DATE}, #{phone,jdbcType=CHAR}, #{mobilephone,jdbcType=CHAR}, + #{identitytype,jdbcType=CHAR}, #{identify,jdbcType=VARCHAR}, #{companyid,jdbcType=INTEGER}, + #{departmentid,jdbcType=INTEGER}, #{postid,jdbcType=INTEGER}, #{remark,jdbcType=VARCHAR}, + #{warning,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Person" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_person + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="name != null" > + NAME, + </if> + <if test="namespell != null" > + nameSpell, + </if> + <if test="gender != null" > + gender, + </if> + <if test="country != null" > + country, + </if> + <if test="province != null" > + province, + </if> + <if test="city != null" > + city, + </if> + <if test="birthday != null" > + birthday, + </if> + <if test="phone != null" > + phone, + </if> + <if test="mobilephone != null" > + mobilePhone, + </if> + <if test="identitytype != null" > + identityType, + </if> + <if test="identify != null" > + identify, + </if> + <if test="companyid != null" > + companyID, + </if> + <if test="departmentid != null" > + departmentID, + </if> + <if test="postid != null" > + postID, + </if> + <if test="remark != null" > + remark, + </if> + <if test="warning != null" > + warning, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="name != null" > + #{name,jdbcType=VARCHAR}, + </if> + <if test="namespell != null" > + #{namespell,jdbcType=CHAR}, + </if> + <if test="gender != null" > + #{gender,jdbcType=BIT}, + </if> + <if test="country != null" > + #{country,jdbcType=CHAR}, + </if> + <if test="province != null" > + #{province,jdbcType=CHAR}, + </if> + <if test="city != null" > + #{city,jdbcType=CHAR}, + </if> + <if test="birthday != null" > + #{birthday,jdbcType=DATE}, + </if> + <if test="phone != null" > + #{phone,jdbcType=CHAR}, + </if> + <if test="mobilephone != null" > + #{mobilephone,jdbcType=CHAR}, + </if> + <if test="identitytype != null" > + #{identitytype,jdbcType=CHAR}, + </if> + <if test="identify != null" > + #{identify,jdbcType=VARCHAR}, + </if> + <if test="companyid != null" > + #{companyid,jdbcType=INTEGER}, + </if> + <if test="departmentid != null" > + #{departmentid,jdbcType=INTEGER}, + </if> + <if test="postid != null" > + #{postid,jdbcType=INTEGER}, + </if> + <if test="remark != null" > + #{remark,jdbcType=VARCHAR}, + </if> + <if test="warning != null" > + #{warning,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Person" > + update t_person + <set > + <if test="name != null" > + NAME = #{name,jdbcType=VARCHAR}, + </if> + <if test="namespell != null" > + nameSpell = #{namespell,jdbcType=CHAR}, + </if> + <if test="gender != null" > + gender = #{gender,jdbcType=BIT}, + </if> + <if test="country != null" > + country = #{country,jdbcType=CHAR}, + </if> + <if test="province != null" > + province = #{province,jdbcType=CHAR}, + </if> + <if test="city != null" > + city = #{city,jdbcType=CHAR}, + </if> + <if test="birthday != null" > + birthday = #{birthday,jdbcType=DATE}, + </if> + <if test="phone != null" > + phone = #{phone,jdbcType=CHAR}, + </if> + <if test="mobilephone != null" > + mobilePhone = #{mobilephone,jdbcType=CHAR}, + </if> + <if test="identitytype != null" > + identityType = #{identitytype,jdbcType=CHAR}, + </if> + <if test="identify != null" > + identify = #{identify,jdbcType=VARCHAR}, + </if> + <if test="companyid != null" > + companyID = #{companyid,jdbcType=INTEGER}, + </if> + <if test="departmentid != null" > + departmentID = #{departmentid,jdbcType=INTEGER}, + </if> + <if test="postid != null" > + postID = #{postid,jdbcType=INTEGER}, + </if> + <if test="remark != null" > + remark = #{remark,jdbcType=VARCHAR}, + </if> + <if test="warning != null" > + warning = #{warning,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Person" > + update t_person + set NAME = #{name,jdbcType=VARCHAR}, + nameSpell = #{namespell,jdbcType=CHAR}, + gender = #{gender,jdbcType=BIT}, + country = #{country,jdbcType=CHAR}, + province = #{province,jdbcType=CHAR}, + city = #{city,jdbcType=CHAR}, + birthday = #{birthday,jdbcType=DATE}, + phone = #{phone,jdbcType=CHAR}, + mobilePhone = #{mobilephone,jdbcType=CHAR}, + identityType = #{identitytype,jdbcType=CHAR}, + identify = #{identify,jdbcType=VARCHAR}, + companyID = #{companyid,jdbcType=INTEGER}, + departmentID = #{departmentid,jdbcType=INTEGER}, + postID = #{postid,jdbcType=INTEGER}, + remark = #{remark,jdbcType=VARCHAR}, + warning = #{warning,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PlaceMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PlaceMapper.xml new file mode 100644 index 0000000..9047829 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PlaceMapper.xml @@ -0,0 +1,242 @@ +<?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="cn.com.basic.face.discern.baseapi.user.PlaceMapper"> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Place"> + <id column="ID" jdbcType="INTEGER" property="id" /> + <result column="companyID" jdbcType="INTEGER" property="companyid" /> + <result column="label" jdbcType="VARCHAR" property="label" /> + <result column="authorizationID" jdbcType="VARCHAR" property="authorizationid" /> + </resultMap> + <sql id="Base_Column_List"> + ID, companyID, label, authorizationID + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> + select + <include refid="Base_Column_List" /> + from t_place + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> + delete from t_place + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Place"> + insert into t_place (ID, companyID, label, + authorizationID) + values (#{id,jdbcType=INTEGER}, #{companyid,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, + #{authorizationid,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + insert into t_place + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null"> + ID, + </if> + <if test="companyid != null"> + companyID, + </if> + <if test="label != null"> + label, + </if> + <if test="authorizationid != null"> + authorizationID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null"> + #{id,jdbcType=INTEGER}, + </if> + <if test="companyid != null"> + #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + #{authorizationid,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + <set> + <if test="companyid != null"> + companyID = #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + authorizationID = #{authorizationid,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + set companyID = #{companyid,jdbcType=INTEGER}, + label = #{label,jdbcType=VARCHAR}, + authorizationID = #{authorizationid,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Place"> + <id column="ID" jdbcType="INTEGER" property="id" /> + <result column="companyID" jdbcType="INTEGER" property="companyid" /> + <result column="label" jdbcType="VARCHAR" property="label" /> + <result column="authorizationID" jdbcType="VARCHAR" property="authorizationid" /> + </resultMap> + <sql id="Base_Column_List"> + ID, companyID, label, authorizationID + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> + select + <include refid="Base_Column_List" /> + from t_place + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> + delete from t_place + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Place"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_place (ID, companyID, label, + authorizationID) + values (#{id,jdbcType=INTEGER}, #{companyid,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, + #{authorizationid,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_place + <trim prefix="(" suffix=")" suffixOverrides=","> + ID, + <if test="companyid != null"> + companyID, + </if> + <if test="label != null"> + label, + </if> + <if test="authorizationid != null"> + authorizationID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + #{id,jdbcType=INTEGER}, + <if test="companyid != null"> + #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + #{authorizationid,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + <set> + <if test="companyid != null"> + companyID = #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + authorizationID = #{authorizationid,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + set companyID = #{companyid,jdbcType=INTEGER}, + label = #{label,jdbcType=VARCHAR}, + authorizationID = #{authorizationid,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Place"> + <id column="ID" jdbcType="INTEGER" property="id" /> + <result column="companyID" jdbcType="INTEGER" property="companyid" /> + <result column="label" jdbcType="VARCHAR" property="label" /> + <result column="authorizationID" jdbcType="VARCHAR" property="authorizationid" /> + </resultMap> + <sql id="Base_Column_List"> + ID, companyID, label, authorizationID + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> + select + <include refid="Base_Column_List" /> + from t_place + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> + delete from t_place + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Place"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_place (ID, companyID, label, + authorizationID) + values (#{id,jdbcType=INTEGER}, #{companyid,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, + #{authorizationid,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_place + <trim prefix="(" suffix=")" suffixOverrides=","> + ID, + <if test="companyid != null"> + companyID, + </if> + <if test="label != null"> + label, + </if> + <if test="authorizationid != null"> + authorizationID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + #{id,jdbcType=INTEGER}, + <if test="companyid != null"> + #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + #{authorizationid,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + <set> + <if test="companyid != null"> + companyID = #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null"> + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="authorizationid != null"> + authorizationID = #{authorizationid,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Place"> + update t_place + set companyID = #{companyid,jdbcType=INTEGER}, + label = #{label,jdbcType=VARCHAR}, + authorizationID = #{authorizationid,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PostMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PostMapper.xml new file mode 100644 index 0000000..c3fa11c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/PostMapper.xml @@ -0,0 +1,60 @@ +<?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="cn.com.basic.face.discern.baseapi.user.PostMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.Post" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="label" property="label" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, label + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_post + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_post + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.Post" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_post (ID, label) + values (#{id,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.Post" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_post + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="label != null" > + label, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="label != null" > + #{label,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.Post" > + update t_post + <set > + <if test="label != null" > + label = #{label,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.Post" > + update t_post + set label = #{label,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitFaceMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitFaceMapper.xml new file mode 100644 index 0000000..8e52d0e --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitFaceMapper.xml @@ -0,0 +1,71 @@ +<?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="cn.com.basic.face.discern.baseapi.user.VisitFaceMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.VisitFace" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="personID" property="personid" jdbcType="INTEGER" /> + <result column="imagePath" property="imagepath" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, personID, imagePath + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_visitface + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_visitface + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.VisitFace" > + insert into t_visitface (ID, personID, imagePath + ) + values (#{id,jdbcType=INTEGER}, #{personid,jdbcType=INTEGER}, #{imagepath,jdbcType=VARCHAR} + ) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.VisitFace" > + insert into t_visitface + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="id != null" > + ID, + </if> + <if test="personid != null" > + personID, + </if> + <if test="imagepath != null" > + imagePath, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="id != null" > + #{id,jdbcType=INTEGER}, + </if> + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + <if test="imagepath != null" > + #{imagepath,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.VisitFace" > + update t_visitface + <set > + <if test="personid != null" > + personID = #{personid,jdbcType=INTEGER}, + </if> + <if test="imagepath != null" > + imagePath = #{imagepath,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.VisitFace" > + update t_visitface + set personID = #{personid,jdbcType=INTEGER}, + imagePath = #{imagepath,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitorTypeMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitorTypeMapper.xml new file mode 100644 index 0000000..31bc187 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/user/mapper/VisitorTypeMapper.xml @@ -0,0 +1,84 @@ +<?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="cn.com.basic.face.discern.baseapi.user.VisitorTypeMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.user.entity.VisitorType" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="label" property="label" jdbcType="VARCHAR" /> + <result column="registerCompanyID" property="registercompanyid" jdbcType="INTEGER" /> + <result column="personID" property="personid" jdbcType="INTEGER" /> + </resultMap> + <sql id="Base_Column_List" > + ID, label, registerCompanyID, personID + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_visitortype + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_visitortype + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.user.entity.VisitorType" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visitortype (ID, label, registerCompanyID, + personID) + values (#{id,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, #{registercompanyid,jdbcType=INTEGER}, + #{personid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.user.entity.VisitorType" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visitortype + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="label != null" > + label, + </if> + <if test="registercompanyid != null" > + registerCompanyID, + </if> + <if test="personid != null" > + personID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="label != null" > + #{label,jdbcType=VARCHAR}, + </if> + <if test="registercompanyid != null" > + #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="personid != null" > + #{personid,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.user.entity.VisitorType" > + update t_visitortype + <set > + <if test="label != null" > + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="registercompanyid != null" > + registerCompanyID = #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="personid != null" > + personID = #{personid,jdbcType=INTEGER}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.user.entity.VisitorType" > + update t_visitortype + set label = #{label,jdbcType=VARCHAR}, + registerCompanyID = #{registercompanyid,jdbcType=INTEGER}, + personID = #{personid,jdbcType=INTEGER} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMapper.java new file mode 100644 index 0000000..b2f86a5 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.visit; + +import cn.com.basic.face.discern.visit.entity.Visit; + +public interface VisitMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Visit record); + + int insertSelective(Visit record); + + Visit selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Visit record); + + int updateByPrimaryKey(Visit record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMatterMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMatterMapper.java new file mode 100644 index 0000000..a19c795 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitMatterMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.visit; + +import cn.com.basic.face.discern.visit.entity.VisitMatter; + +public interface VisitMatterMapper { + int deleteByPrimaryKey(Integer id); + + int insert(VisitMatter record); + + int insertSelective(VisitMatter record); + + VisitMatter selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(VisitMatter record); + + int updateByPrimaryKey(VisitMatter record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitStatMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitStatMapper.java new file mode 100644 index 0000000..9a1cb3e --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitStatMapper.java @@ -0,0 +1,9 @@ +package cn.com.basic.face.discern.baseapi.visit; + +import cn.com.basic.face.discern.visit.entity.VisitStat; + +public interface VisitStatMapper { + int insert(VisitStat record); + + int insertSelective(VisitStat record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitingMapper.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitingMapper.java new file mode 100644 index 0000000..5c58d1c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/VisitingMapper.java @@ -0,0 +1,17 @@ +package cn.com.basic.face.discern.baseapi.visit; + +import cn.com.basic.face.discern.visit.entity.Visiting; + +public interface VisitingMapper { + int deleteByPrimaryKey(Integer id); + + int insert(Visiting record); + + int insertSelective(Visiting record); + + Visiting selectByPrimaryKey(Integer id); + + int updateByPrimaryKeySelective(Visiting record); + + int updateByPrimaryKey(Visiting record); +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMapper.xml new file mode 100644 index 0000000..66d1490 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMapper.xml @@ -0,0 +1,153 @@ +<?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="cn.com.basic.face.discern.baseapi.visit.VisitMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.Visit" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="visitorPersonID" property="visitorpersonid" jdbcType="INTEGER" /> + <result column="visiteePersonID" property="visiteepersonid" jdbcType="INTEGER" /> + <result column="matterID" property="matterid" jdbcType="INTEGER" /> + <result column="remark" property="remark" jdbcType="VARCHAR" /> + <result column="lastStatus" property="laststatus" jdbcType="INTEGER" /> + <result column="startTime" property="starttime" jdbcType="TIMESTAMP" /> + <result column="lastTime" property="lasttime" jdbcType="TIMESTAMP" /> + <result column="visitorTypeLabel" property="visitortypelabel" jdbcType="VARCHAR" /> + <result column="warning" property="warning" jdbcType="VARCHAR" /> + </resultMap> + <sql id="Base_Column_List" > + ID, visitorPersonID, visiteePersonID, matterID, remark, lastStatus, startTime, lastTime, + visitorTypeLabel, warning + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_visit + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_visit + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.Visit" > + insert into t_visit (ID, visitorPersonID, visiteePersonID, + matterID, remark, lastStatus, + startTime, lastTime, visitorTypeLabel, + warning) + values (#{id,jdbcType=INTEGER}, #{visitorpersonid,jdbcType=INTEGER}, #{visiteepersonid,jdbcType=INTEGER}, + #{matterid,jdbcType=INTEGER}, #{remark,jdbcType=VARCHAR}, #{laststatus,jdbcType=INTEGER}, + #{starttime,jdbcType=TIMESTAMP}, #{lasttime,jdbcType=TIMESTAMP}, #{visitortypelabel,jdbcType=VARCHAR}, + #{warning,jdbcType=VARCHAR}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.Visit" > + insert into t_visit + <trim prefix="(" suffix=")" suffixOverrides="," > + <if test="id != null" > + ID, + </if> + <if test="visitorpersonid != null" > + visitorPersonID, + </if> + <if test="visiteepersonid != null" > + visiteePersonID, + </if> + <if test="matterid != null" > + matterID, + </if> + <if test="remark != null" > + remark, + </if> + <if test="laststatus != null" > + lastStatus, + </if> + <if test="starttime != null" > + startTime, + </if> + <if test="lasttime != null" > + lastTime, + </if> + <if test="visitortypelabel != null" > + visitorTypeLabel, + </if> + <if test="warning != null" > + warning, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + <if test="id != null" > + #{id,jdbcType=INTEGER}, + </if> + <if test="visitorpersonid != null" > + #{visitorpersonid,jdbcType=INTEGER}, + </if> + <if test="visiteepersonid != null" > + #{visiteepersonid,jdbcType=INTEGER}, + </if> + <if test="matterid != null" > + #{matterid,jdbcType=INTEGER}, + </if> + <if test="remark != null" > + #{remark,jdbcType=VARCHAR}, + </if> + <if test="laststatus != null" > + #{laststatus,jdbcType=INTEGER}, + </if> + <if test="starttime != null" > + #{starttime,jdbcType=TIMESTAMP}, + </if> + <if test="lasttime != null" > + #{lasttime,jdbcType=TIMESTAMP}, + </if> + <if test="visitortypelabel != null" > + #{visitortypelabel,jdbcType=VARCHAR}, + </if> + <if test="warning != null" > + #{warning,jdbcType=VARCHAR}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.visit.entity.Visit" > + update t_visit + <set > + <if test="visitorpersonid != null" > + visitorPersonID = #{visitorpersonid,jdbcType=INTEGER}, + </if> + <if test="visiteepersonid != null" > + visiteePersonID = #{visiteepersonid,jdbcType=INTEGER}, + </if> + <if test="matterid != null" > + matterID = #{matterid,jdbcType=INTEGER}, + </if> + <if test="remark != null" > + remark = #{remark,jdbcType=VARCHAR}, + </if> + <if test="laststatus != null" > + lastStatus = #{laststatus,jdbcType=INTEGER}, + </if> + <if test="starttime != null" > + startTime = #{starttime,jdbcType=TIMESTAMP}, + </if> + <if test="lasttime != null" > + lastTime = #{lasttime,jdbcType=TIMESTAMP}, + </if> + <if test="visitortypelabel != null" > + visitorTypeLabel = #{visitortypelabel,jdbcType=VARCHAR}, + </if> + <if test="warning != null" > + warning = #{warning,jdbcType=VARCHAR}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.visit.entity.Visit" > + update t_visit + set visitorPersonID = #{visitorpersonid,jdbcType=INTEGER}, + visiteePersonID = #{visiteepersonid,jdbcType=INTEGER}, + matterID = #{matterid,jdbcType=INTEGER}, + remark = #{remark,jdbcType=VARCHAR}, + lastStatus = #{laststatus,jdbcType=INTEGER}, + startTime = #{starttime,jdbcType=TIMESTAMP}, + lastTime = #{lasttime,jdbcType=TIMESTAMP}, + visitorTypeLabel = #{visitortypelabel,jdbcType=VARCHAR}, + warning = #{warning,jdbcType=VARCHAR} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMatterMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMatterMapper.xml new file mode 100644 index 0000000..f6eca52 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitMatterMapper.xml @@ -0,0 +1,84 @@ +<?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="cn.com.basic.face.discern.baseapi.visit.VisitMatterMapper" > + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.VisitMatter" > + <id column="ID" property="id" jdbcType="INTEGER" /> + <result column="companyID" property="companyid" jdbcType="INTEGER" /> + <result column="label" property="label" jdbcType="VARCHAR" /> + <result column="available" property="available" jdbcType="BIT" /> + </resultMap> + <sql id="Base_Column_List" > + ID, companyID, label, available + </sql> + <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > + select + <include refid="Base_Column_List" /> + from t_visitmatter + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > + delete from t_visitmatter + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.VisitMatter" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visitmatter (ID, companyID, label, + available) + values (#{id,jdbcType=INTEGER}, #{companyid,jdbcType=INTEGER}, #{label,jdbcType=VARCHAR}, + #{available,jdbcType=BIT}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.VisitMatter" > + <selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" > + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visitmatter + <trim prefix="(" suffix=")" suffixOverrides="," > + ID, + <if test="companyid != null" > + companyID, + </if> + <if test="label != null" > + label, + </if> + <if test="available != null" > + available, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides="," > + #{id,jdbcType=INTEGER}, + <if test="companyid != null" > + #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null" > + #{label,jdbcType=VARCHAR}, + </if> + <if test="available != null" > + #{available,jdbcType=BIT}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.visit.entity.VisitMatter" > + update t_visitmatter + <set > + <if test="companyid != null" > + companyID = #{companyid,jdbcType=INTEGER}, + </if> + <if test="label != null" > + label = #{label,jdbcType=VARCHAR}, + </if> + <if test="available != null" > + available = #{available,jdbcType=BIT}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.visit.entity.VisitMatter" > + update t_visitmatter + set companyID = #{companyid,jdbcType=INTEGER}, + label = #{label,jdbcType=VARCHAR}, + available = #{available,jdbcType=BIT} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitStatMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitStatMapper.xml new file mode 100644 index 0000000..029a981 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitStatMapper.xml @@ -0,0 +1,76 @@ +<?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="cn.com.basic.face.discern.baseapi.visit.VisitStatMapper"> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.VisitStat"> + <result column="personID" jdbcType="INTEGER" property="personid" /> + <result column="registerCompanyID" jdbcType="INTEGER" property="registercompanyid" /> + <result column="totalCount" jdbcType="INTEGER" property="totalcount" /> + </resultMap> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.VisitStat"> + insert into t_visitstat (personID, registerCompanyID, totalCount + ) + values (#{personid,jdbcType=INTEGER}, #{registercompanyid,jdbcType=INTEGER}, #{totalcount,jdbcType=INTEGER} + ) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.VisitStat"> + insert into t_visitstat + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="personid != null"> + personID, + </if> + <if test="registercompanyid != null"> + registerCompanyID, + </if> + <if test="totalcount != null"> + totalCount, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="personid != null"> + #{personid,jdbcType=INTEGER}, + </if> + <if test="registercompanyid != null"> + #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="totalcount != null"> + #{totalcount,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.VisitStat"> + <result column="personID" jdbcType="INTEGER" property="personid" /> + <result column="registerCompanyID" jdbcType="INTEGER" property="registercompanyid" /> + <result column="totalCount" jdbcType="INTEGER" property="totalcount" /> + </resultMap> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.VisitStat"> + insert into t_visitstat (personID, registerCompanyID, totalCount + ) + values (#{personid,jdbcType=INTEGER}, #{registercompanyid,jdbcType=INTEGER}, #{totalcount,jdbcType=INTEGER} + ) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.VisitStat"> + insert into t_visitstat + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="personid != null"> + personID, + </if> + <if test="registercompanyid != null"> + registerCompanyID, + </if> + <if test="totalcount != null"> + totalCount, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="personid != null"> + #{personid,jdbcType=INTEGER}, + </if> + <if test="registercompanyid != null"> + #{registercompanyid,jdbcType=INTEGER}, + </if> + <if test="totalcount != null"> + #{totalcount,jdbcType=INTEGER}, + </if> + </trim> + </insert> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitingMapper.xml b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitingMapper.xml new file mode 100644 index 0000000..b2a080c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/baseapi/visit/mapper/VisitingMapper.xml @@ -0,0 +1,184 @@ +<?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="cn.com.basic.face.discern.baseapi.visit.VisitingMapper"> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.Visiting"> + <id column="ID" jdbcType="INTEGER" property="id" /> + <result column="visitID" jdbcType="INTEGER" property="visitid" /> + <result column="statusID" jdbcType="TIMESTAMP" property="statusid" /> + <result column="statusDT" jdbcType="TIMESTAMP" property="statusdt" /> + <result column="placeID" jdbcType="INTEGER" property="placeid" /> + </resultMap> + <sql id="Base_Column_List"> + ID, visitID, statusID, statusDT, placeID + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> + select + <include refid="Base_Column_List" /> + from t_visiting + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> + delete from t_visiting + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visiting (ID, visitID, statusID, + statusDT, placeID) + values (#{id,jdbcType=INTEGER}, #{visitid,jdbcType=INTEGER}, #{statusid,jdbcType=TIMESTAMP}, + #{statusdt,jdbcType=TIMESTAMP}, #{placeid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer"> + SELECT LAST_INSERT_ID() + </selectKey> + insert into t_visiting + <trim prefix="(" suffix=")" suffixOverrides=","> + ID, + <if test="visitid != null"> + visitID, + </if> + <if test="statusid != null"> + statusID, + </if> + <if test="statusdt != null"> + statusDT, + </if> + <if test="placeid != null"> + placeID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + #{id,jdbcType=INTEGER}, + <if test="visitid != null"> + #{visitid,jdbcType=INTEGER}, + </if> + <if test="statusid != null"> + #{statusid,jdbcType=TIMESTAMP}, + </if> + <if test="statusdt != null"> + #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="placeid != null"> + #{placeid,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + update t_visiting + <set> + <if test="visitid != null"> + visitID = #{visitid,jdbcType=INTEGER}, + </if> + <if test="statusid != null"> + statusID = #{statusid,jdbcType=TIMESTAMP}, + </if> + <if test="statusdt != null"> + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="placeid != null"> + placeID = #{placeid,jdbcType=INTEGER}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + update t_visiting + set visitID = #{visitid,jdbcType=INTEGER}, + statusID = #{statusid,jdbcType=TIMESTAMP}, + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + placeID = #{placeid,jdbcType=INTEGER} + where ID = #{id,jdbcType=INTEGER} + </update> + <resultMap id="BaseResultMap" type="cn.com.basic.face.discern.visit.entity.Visiting"> + <id column="ID" jdbcType="INTEGER" property="id" /> + <result column="visitID" jdbcType="INTEGER" property="visitid" /> + <result column="statusID" jdbcType="TIMESTAMP" property="statusid" /> + <result column="statusDT" jdbcType="TIMESTAMP" property="statusdt" /> + <result column="placeID" jdbcType="INTEGER" property="placeid" /> + </resultMap> + <sql id="Base_Column_List"> + ID, visitID, statusID, statusDT, placeID + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> + select + <include refid="Base_Column_List" /> + from t_visiting + where ID = #{id,jdbcType=INTEGER} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> + delete from t_visiting + where ID = #{id,jdbcType=INTEGER} + </delete> + <insert id="insert" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + insert into t_visiting (ID, visitID, statusID, + statusDT, placeID) + values (#{id,jdbcType=INTEGER}, #{visitid,jdbcType=INTEGER}, #{statusid,jdbcType=TIMESTAMP}, + #{statusdt,jdbcType=TIMESTAMP}, #{placeid,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + insert into t_visiting + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null"> + ID, + </if> + <if test="visitid != null"> + visitID, + </if> + <if test="statusid != null"> + statusID, + </if> + <if test="statusdt != null"> + statusDT, + </if> + <if test="placeid != null"> + placeID, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null"> + #{id,jdbcType=INTEGER}, + </if> + <if test="visitid != null"> + #{visitid,jdbcType=INTEGER}, + </if> + <if test="statusid != null"> + #{statusid,jdbcType=TIMESTAMP}, + </if> + <if test="statusdt != null"> + #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="placeid != null"> + #{placeid,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + update t_visiting + <set> + <if test="visitid != null"> + visitID = #{visitid,jdbcType=INTEGER}, + </if> + <if test="statusid != null"> + statusID = #{statusid,jdbcType=TIMESTAMP}, + </if> + <if test="statusdt != null"> + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + </if> + <if test="placeid != null"> + placeID = #{placeid,jdbcType=INTEGER}, + </if> + </set> + where ID = #{id,jdbcType=INTEGER} + </update> + <update id="updateByPrimaryKey" parameterType="cn.com.basic.face.discern.visit.entity.Visiting"> + update t_visiting + set visitID = #{visitid,jdbcType=INTEGER}, + statusID = #{statusid,jdbcType=TIMESTAMP}, + statusDT = #{statusdt,jdbcType=TIMESTAMP}, + placeID = #{placeid,jdbcType=INTEGER} + where ID = #{id,jdbcType=INTEGER} + </update> +</mapper> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/calling/entity/calling.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/calling/entity/calling.java new file mode 100644 index 0000000..342d750 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/calling/entity/calling.java @@ -0,0 +1,51 @@ +package cn.com.basic.face.discern.calling.entity; + +import java.io.Serializable; +import java.util.Date; + +public class calling implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Date calldt; + + private Integer callerpersonid; + + private Integer calleepersonid; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Date getCalldt() { + return calldt; + } + + public void setCalldt(Date calldt) { + this.calldt = calldt; + } + + public Integer getCallerpersonid() { + return callerpersonid; + } + + public void setCallerpersonid(Integer callerpersonid) { + this.callerpersonid = callerpersonid; + } + + public Integer getCalleepersonid() { + return calleepersonid; + } + + public void setCalleepersonid(Integer calleepersonid) { + this.calleepersonid = calleepersonid; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/Checking.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/Checking.java new file mode 100644 index 0000000..6fbf1dc --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/Checking.java @@ -0,0 +1,61 @@ +package cn.com.basic.face.discern.checking.entity; + +import java.io.Serializable; +import java.util.Date; + +public class Checking implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Byte statusid; + + private Date statusdt; + + private Integer personid; + + private Integer placeid; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Byte getStatusid() { + return statusid; + } + + public void setStatusid(Byte statusid) { + this.statusid = statusid; + } + + public Date getStatusdt() { + return statusdt; + } + + public void setStatusdt(Date statusdt) { + this.statusdt = statusdt; + } + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public Integer getPlaceid() { + return placeid; + } + + public void setPlaceid(Integer placeid) { + this.placeid = placeid; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/CheckingCompany.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/CheckingCompany.java new file mode 100644 index 0000000..5a069e3 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/checking/entity/CheckingCompany.java @@ -0,0 +1,30 @@ +package cn.com.basic.face.discern.checking.entity; + +import java.io.Serializable; + +public class CheckingCompany implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer personid; + + private Integer companyid; + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public Integer getCompanyid() { + return companyid; + } + + public void setCompanyid(Integer companyid) { + this.companyid = companyid; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/component/user/cotroller/FacilityManager.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/component/user/cotroller/FacilityManager.java new file mode 100644 index 0000000..7009760 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/component/user/cotroller/FacilityManager.java @@ -0,0 +1,19 @@ +package cn.com.basic.face.discern.component.user.cotroller; + +import org.springframework.web.bind.annotation.RequestMapping; + +/** + * + * + * @简介: + * @author dpy + * @内容说明: + * @版本:1.0 + * + */ +@RequestMapping(value="facility") +public class FacilityManager { + + + +} diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Company.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Company.java new file mode 100644 index 0000000..a986932 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Company.java @@ -0,0 +1,37 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +/** + * @简介: + * @author dpy + * @内容说明: + * @版本: + * + */ +public class Company implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private String name; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getName() { + return name; + } + + public void setName(String name) { + this.name = name == null ? null : name.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Department.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Department.java new file mode 100644 index 0000000..9464c95 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Department.java @@ -0,0 +1,40 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class Department implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private String label; + + private String labelspell; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getLabel() { + return label; + } + + public void setLabel(String label) { + this.label = label == null ? null : label.trim(); + } + + public String getLabelspell() { + return labelspell; + } + + public void setLabelspell(String labelspell) { + this.labelspell = labelspell == null ? null : labelspell.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/EmployeeFace.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/EmployeeFace.java new file mode 100644 index 0000000..7348612 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/EmployeeFace.java @@ -0,0 +1,50 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class EmployeeFace implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer registercompanyid; + + private Integer personid; + + private String imagepath; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getRegistercompanyid() { + return registercompanyid; + } + + public void setRegistercompanyid(Integer registercompanyid) { + this.registercompanyid = registercompanyid; + } + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public String getImagepath() { + return imagepath; + } + + public void setImagepath(String imagepath) { + this.imagepath = imagepath == null ? null : imagepath.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Image.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Image.java new file mode 100644 index 0000000..f399a5a --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Image.java @@ -0,0 +1,40 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class Image implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer personid; + + private String imagetye; + + private String imagepath; + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public String getImagetye() { + return imagetye; + } + + public void setImagetye(String imagetye) { + this.imagetye = imagetye == null ? null : imagetye.trim(); + } + + public String getImagepath() { + return imagepath; + } + + public void setImagepath(String imagepath) { + this.imagepath = imagepath == null ? null : imagepath.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Person.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Person.java new file mode 100644 index 0000000..59072c1 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Person.java @@ -0,0 +1,181 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; +import java.util.Date; + +public class Person implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private String name; + + private String namespell; + + private Boolean gender; + + private String country; + + private String province; + + private String city; + + private Date birthday; + + private String phone; + + private String mobilephone; + + private String identitytype; + + private String identify; + + private Integer companyid; + + private Integer departmentid; + + private Integer postid; + + private String remark; + + private String warning; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getName() { + return name; + } + + public void setName(String name) { + this.name = name == null ? null : name.trim(); + } + + public String getNamespell() { + return namespell; + } + + public void setNamespell(String namespell) { + this.namespell = namespell == null ? null : namespell.trim(); + } + + public Boolean getGender() { + return gender; + } + + public void setGender(Boolean gender) { + this.gender = gender; + } + + public String getCountry() { + return country; + } + + public void setCountry(String country) { + this.country = country == null ? null : country.trim(); + } + + public String getProvince() { + return province; + } + + public void setProvince(String province) { + this.province = province == null ? null : province.trim(); + } + + public String getCity() { + return city; + } + + public void setCity(String city) { + this.city = city == null ? null : city.trim(); + } + + public Date getBirthday() { + return birthday; + } + + public void setBirthday(Date birthday) { + this.birthday = birthday; + } + + public String getPhone() { + return phone; + } + + public void setPhone(String phone) { + this.phone = phone == null ? null : phone.trim(); + } + + public String getMobilephone() { + return mobilephone; + } + + public void setMobilephone(String mobilephone) { + this.mobilephone = mobilephone == null ? null : mobilephone.trim(); + } + + public String getIdentitytype() { + return identitytype; + } + + public void setIdentitytype(String identitytype) { + this.identitytype = identitytype == null ? null : identitytype.trim(); + } + + public String getIdentify() { + return identify; + } + + public void setIdentify(String identify) { + this.identify = identify == null ? null : identify.trim(); + } + + public Integer getCompanyid() { + return companyid; + } + + public void setCompanyid(Integer companyid) { + this.companyid = companyid; + } + + public Integer getDepartmentid() { + return departmentid; + } + + public void setDepartmentid(Integer departmentid) { + this.departmentid = departmentid; + } + + public Integer getPostid() { + return postid; + } + + public void setPostid(Integer postid) { + this.postid = postid; + } + + public String getRemark() { + return remark; + } + + public void setRemark(String remark) { + this.remark = remark == null ? null : remark.trim(); + } + + public String getWarning() { + return warning; + } + + public void setWarning(String warning) { + this.warning = warning == null ? null : warning.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Place.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Place.java new file mode 100644 index 0000000..ed5495d --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Place.java @@ -0,0 +1,50 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class Place implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer companyid; + + private String label; + + private String authorizationid; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getCompanyid() { + return companyid; + } + + public void setCompanyid(Integer companyid) { + this.companyid = companyid; + } + + public String getLabel() { + return label; + } + + public void setLabel(String label) { + this.label = label == null ? null : label.trim(); + } + + public String getAuthorizationid() { + return authorizationid; + } + + public void setAuthorizationid(String authorizationid) { + this.authorizationid = authorizationid == null ? null : authorizationid.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Post.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Post.java new file mode 100644 index 0000000..d4f30eb --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/Post.java @@ -0,0 +1,30 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class Post implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private String label; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getLabel() { + return label; + } + + public void setLabel(String label) { + this.label = label == null ? null : label.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitFace.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitFace.java new file mode 100644 index 0000000..4770bdb --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitFace.java @@ -0,0 +1,40 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class VisitFace implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer personid; + + private String imagepath; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public String getImagepath() { + return imagepath; + } + + public void setImagepath(String imagepath) { + this.imagepath = imagepath == null ? null : imagepath.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitorType.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitorType.java new file mode 100644 index 0000000..33f30fe --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/user/entity/VisitorType.java @@ -0,0 +1,50 @@ +package cn.com.basic.face.discern.user.entity; + +import java.io.Serializable; + +public class VisitorType implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private String label; + + private Integer registercompanyid; + + private Integer personid; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getLabel() { + return label; + } + + public void setLabel(String label) { + this.label = label == null ? null : label.trim(); + } + + public Integer getRegistercompanyid() { + return registercompanyid; + } + + public void setRegistercompanyid(Integer registercompanyid) { + this.registercompanyid = registercompanyid; + } + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visit.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visit.java new file mode 100644 index 0000000..b47435b --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visit.java @@ -0,0 +1,111 @@ +package cn.com.basic.face.discern.visit.entity; + +import java.io.Serializable; +import java.util.Date; + +public class Visit implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer visitorpersonid; + + private Integer visiteepersonid; + + private Integer matterid; + + private String remark; + + private Integer laststatus; + + private Date starttime; + + private Date lasttime; + + private String visitortypelabel; + + private String warning; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getVisitorpersonid() { + return visitorpersonid; + } + + public void setVisitorpersonid(Integer visitorpersonid) { + this.visitorpersonid = visitorpersonid; + } + + public Integer getVisiteepersonid() { + return visiteepersonid; + } + + public void setVisiteepersonid(Integer visiteepersonid) { + this.visiteepersonid = visiteepersonid; + } + + public Integer getMatterid() { + return matterid; + } + + public void setMatterid(Integer matterid) { + this.matterid = matterid; + } + + public String getRemark() { + return remark; + } + + public void setRemark(String remark) { + this.remark = remark == null ? null : remark.trim(); + } + + public Integer getLaststatus() { + return laststatus; + } + + public void setLaststatus(Integer laststatus) { + this.laststatus = laststatus; + } + + public Date getStarttime() { + return starttime; + } + + public void setStarttime(Date starttime) { + this.starttime = starttime; + } + + public Date getLasttime() { + return lasttime; + } + + public void setLasttime(Date lasttime) { + this.lasttime = lasttime; + } + + public String getVisitortypelabel() { + return visitortypelabel; + } + + public void setVisitortypelabel(String visitortypelabel) { + this.visitortypelabel = visitortypelabel == null ? null : visitortypelabel.trim(); + } + + public String getWarning() { + return warning; + } + + public void setWarning(String warning) { + this.warning = warning == null ? null : warning.trim(); + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitMatter.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitMatter.java new file mode 100644 index 0000000..3c950af --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitMatter.java @@ -0,0 +1,50 @@ +package cn.com.basic.face.discern.visit.entity; + +import java.io.Serializable; + +public class VisitMatter implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer companyid; + + private String label; + + private Boolean available; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getCompanyid() { + return companyid; + } + + public void setCompanyid(Integer companyid) { + this.companyid = companyid; + } + + public String getLabel() { + return label; + } + + public void setLabel(String label) { + this.label = label == null ? null : label.trim(); + } + + public Boolean getAvailable() { + return available; + } + + public void setAvailable(Boolean available) { + this.available = available; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitStat.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitStat.java new file mode 100644 index 0000000..b95ecd6 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/VisitStat.java @@ -0,0 +1,40 @@ +package cn.com.basic.face.discern.visit.entity; + +import java.io.Serializable; + +public class VisitStat implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer personid; + + private Integer registercompanyid; + + private Integer totalcount; + + public Integer getPersonid() { + return personid; + } + + public void setPersonid(Integer personid) { + this.personid = personid; + } + + public Integer getRegistercompanyid() { + return registercompanyid; + } + + public void setRegistercompanyid(Integer registercompanyid) { + this.registercompanyid = registercompanyid; + } + + public Integer getTotalcount() { + return totalcount; + } + + public void setTotalcount(Integer totalcount) { + this.totalcount = totalcount; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visiting.java b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visiting.java new file mode 100644 index 0000000..fe0fb8a --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/java/cn/com/basic/face/discern/visit/entity/Visiting.java @@ -0,0 +1,61 @@ +package cn.com.basic.face.discern.visit.entity; + +import java.io.Serializable; +import java.util.Date; + +public class Visiting implements Serializable{ + /** + * + */ + private static final long serialVersionUID = 1L; + + private Integer id; + + private Integer visitid; + + private Date statusid; + + private Date statusdt; + + private Integer placeid; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public Integer getVisitid() { + return visitid; + } + + public void setVisitid(Integer visitid) { + this.visitid = visitid; + } + + public Date getStatusid() { + return statusid; + } + + public void setStatusid(Date statusid) { + this.statusid = statusid; + } + + public Date getStatusdt() { + return statusdt; + } + + public void setStatusdt(Date statusdt) { + this.statusdt = statusdt; + } + + public Integer getPlaceid() { + return placeid; + } + + public void setPlaceid(Integer placeid) { + this.placeid = placeid; + } +} \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/resources/MyBaits-config.xml b/VisitFace/faceDiscesn/src/main/resources/MyBaits-config.xml new file mode 100644 index 0000000..de7272c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/MyBaits-config.xml @@ -0,0 +1,5 @@ +<?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> + +</configuration> \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/resources/ehcache.xml b/VisitFace/faceDiscesn/src/main/resources/ehcache.xml new file mode 100644 index 0000000..252ac5c --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/ehcache.xml @@ -0,0 +1,13 @@ +<ehcache> + + <diskStore path="java.io.tmpdir"/> + + <cache name="surveyCache" + maxElementsInMemory="10000" + eternal="false" + timeToIdleSeconds="300" + timeToLiveSeconds="600" + overflowToDisk="true" + /> + +</ehcache> diff --git a/VisitFace/faceDiscesn/src/main/resources/jdbc.properties b/VisitFace/faceDiscesn/src/main/resources/jdbc.properties new file mode 100644 index 0000000..f1de5e8 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/jdbc.properties @@ -0,0 +1,5 @@ +jdbc.user=root +jdbc.password=123456 +jdbc.url=jdbc:mysql://localhost:3306/face_discern?allowMultiQueries=true&useUnicode=true&characterEncoding=utf8 +jdbc.driver=com.mysql.jdbc.Driver + diff --git a/VisitFace/faceDiscesn/src/main/resources/log4j.properties b/VisitFace/faceDiscesn/src/main/resources/log4j.properties new file mode 100644 index 0000000..206dcfd --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/log4j.properties @@ -0,0 +1,21 @@ +log4j.rootLogger=DEBUG,stdout,R + +log4j.logger.com.trusdom=DEBUG +log4j.logger.java.sql=DEBUG + +#### First appender writes to console +log4j.appender.stdout=org.apache.log4j.ConsoleAppender +log4j.appender.stdout.layout=org.apache.log4j.PatternLayout + +# Pattern to output the caller's file name and line number. +log4j.appender.stdout.layout.ConversionPattern=[%d{yyyy-MM-dd HH:mm:ss}] %-5p [%t] %c (%M:%L) - %m%n + +#### Second appender writes to a file +log4j.appender.R=org.apache.log4j.RollingFileAppender +log4j.appender.R.File=/usr/local/tomcat/logs/cbip-company-co.log +# Control the maximum log file size +log4j.appender.R.MaxFileSize=1000KB +# Archive log files (one backup file here) +log4j.appender.R.MaxBackupIndex=20 +log4j.appender.R.layout=org.apache.log4j.PatternLayout +log4j.appender.R.layout.ConversionPattern=[%d{yyyy-MM-dd HH:mm:ss}] %-5p [%t] %c (%M:%L) - %m%n \ No newline at end of file diff --git a/VisitFace/faceDiscesn/src/main/resources/spring-context.xml b/VisitFace/faceDiscesn/src/main/resources/spring-context.xml new file mode 100644 index 0000000..3282a5a --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/spring-context.xml @@ -0,0 +1,49 @@ +锘�<?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:tx="http://www.springframework.org/schema/tx" + xmlns:aop="http://www.springframework.org/schema/aop" + xmlns:cache="http://www.springframework.org/schema/cache" + xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd + http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd + http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-4.0.xsd + http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd + http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd"> + + <!-- 鎵弿缁勪欢Bean瀵硅薄:鎺掗櫎handler缁勪欢锛屽墿浣欓兘杩涜绠$悊 --> + <context:component-scan base-package="cn.com.basic.face.discern"> + <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> + </context:component-scan> + + <!-- 鍔犺浇澶栭儴灞炴�ч厤缃枃浠� --> + <context:property-placeholder location="classpath:jdbc.properties"/> + + <!-- 閰嶇疆C3P0鏁版嵁婧� --> + <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="true"> + <property name="driverClass" value="${jdbc.driver}"/> + <property name="user" value="${jdbc.user}"/> + <property name="password" value="${jdbc.password}"/> + <property name="jdbcUrl" value="${jdbc.url}"/> + </bean> + + <!-- 閰嶇疆SQLSessionFactory --> + <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> + <!-- 鈶犺閰嶆暟鎹簮 --> + <property name="dataSource" ref="dataSource"/> + <!-- 鈶℃寚瀹歁yBatis鑷韩閰嶇疆鏂囦欢鐨勪綅缃� --> + <property name="configLocation" value="classpath:MyBaits-config.xml"/> + <!-- typeAliasesPackage灞炴�alue鍊硷細鍙互鎸囧畾鐖跺寘锛岃嚜鍔ㄦ壂鎻忓瓙鍖� --> + <!-- 鈶㈡寚瀹氬疄浣撶被鐨勪綅缃� --> + <property name="typeAliasesPackage" value="cn.com.basic.face.discern"/> + <!-- <property name="mapperLocations"></property> --> + </bean> + + <!-- 鎵弿Mapper鏄犲皠閰嶇疆 --> + <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"> + <property name="basePackage" value="cn.com.basic.face.discern.baseapi"/> + </bean> + + + +</beans> diff --git a/VisitFace/faceDiscesn/src/main/resources/springmvc-context.xml b/VisitFace/faceDiscesn/src/main/resources/springmvc-context.xml new file mode 100644 index 0000000..cd75452 --- /dev/null +++ b/VisitFace/faceDiscesn/src/main/resources/springmvc-context.xml @@ -0,0 +1,11 @@ +锘�<?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/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd + 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"> + + +</beans> -- Gitblit v1.8.0