基于Java与MySQL及spring boot
链接: https://pan.baidu.com/s/1b_K5McV_gF_rRlgYbxx1Wg?pwd=59ig 提取码: 59ig
开发员工系统功能模块如何编写
模块1 显示员工列表。
模块2按员工号删除员工及用户信息（事务管理）。
模块3按性别统计员工人数。
模块4 基于员工数据库开发创意功能模块。
如何在控制台输出结果及日志
九月六号
基于控制台的简单Java员工管理系统（密码验证+mysql+jdbc）_杰杰杰.的博客-CSDN博客_基于java的员工管理系统
可以参考这篇文章
这是要干嘛啊，代练吗
需要加功能还是一点都没写。。。
网上很多可以参考的啊，增删改查都一样的。参考过程中，有遇到问题再问。
```java
<?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="nj.zb.kb15.dao.RoleDao">
<!--新增角色方法-->
<insert id="addRole">
INSERT INTO mrole(id,roleCode,roleName,createdBy,creationDate)
value (null,#{roleCode},#{roleName},#{createdBy},#{creationDate})
</insert>
<!--修改角色方法-->
<update id="updateRole">
update mrole
set roleCode=#{roleCode},
roleName=#{roleName},
modifyBy=#{modifyBy},
modifyDate=#{modifyDate}
where id=#{id}
</update>
<!--查询所有角色,需要添加resultType-->
<select id="getAll" resultType="Role">
select id,roleCode,roleName,createdBy,creationDate,modifyBy,modifyDate from mrole;
</select>
<delete id="deleteRole">
delete from mrole where id=#{roleId}
</delete>
<insert id="addRole2">
insert into mrole
<trim prefix="(" suffix=")" suffixOverrides=",">
-- suffixOverrides 是去除最后一个逗号
<if test="roleCode!=null and roleCode!=''">
roleCode,
</if>
<if test="roleName!=null and roleName!=''">
roleName,
</if>
<if test="createdBy!=null">
createdBy,
</if>
<if test="creationDate!=null">
creationDate,
</if>
</trim>
values
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="roleCode!=null and roleCode!=''">
#{roleCode},
</if>
<if test="roleName!=null and roleName!=''">
#{roleName},
</if>
<if test="createdBy!=null">
#{createdBy},
</if>
<if test="creationDate!=null">
#{creationDate},
</if>
</trim>
</insert>
<update id="updateRole2">
update mrole
<set>
<if test="roleCode!=null and roleCode!=''">
roleCode=#{roleCode},
</if>
<if test="roleName!=null and roleName!=''">
roleName=#{roleName},
</if>
<if test="modifyBy!=null">
modifyBy=#{modifyBy},
</if>
<if test="modifyDate!=null">
modifyDate=#{modifyDate},
</if>
</set>
where id=#{id};
</update>
<delete id="deleteRole2">
delete from mrole where id in
<foreach collection="ids" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>
<insert id="batchAddRole">
INSERT INTO mrole(roleCode,roleName,createdBy,creationDate)
values
<foreach collection="roles" item="role" separator=",">
(#{role.roleCode},#{role.roleName},#{role.createdBy},#{role.creationDate})
</foreach>
</insert>
<update id="batchUpdateRole">
<foreach collection="roles" item="role" >
update mrole
<set>
<if test="role.roleCode!=null and role.roleCode!=''">
roleCode=#{role.roleCode},
</if>
<if test="role.roleName!=null and role.roleName!=''">
roleName=#{role.roleName},
</if>
<if test="role.modifyBy!=null">
modifyBy=#{role.modifyBy},
</if>
<if test="role.modifyDate!=null">
modifyDate=#{role.modifyDate},
</if>
</set>
where id=#{role.id};
</foreach>
</update>
<select id="getAll2" resultMap="roleMap">
<include refid="complexSql"></include>
</select>
<resultMap id="roleMap" type="Role">
<id property="id" column="rid"></id>
<result property="roleCode" column="roleCode"></result>
<result property="roleName" column="roleName"></result>
<result property="createdBy" column="createdBy"></result>
<result property="creationDate" column="creationDate"></result>
<result property="modifyBy" column="modifyBy"></result>
<result property="modifyDate" column="modifyDate"></result>
<collection property="users" ofType="User">
<id property="id" column="id"></id>
<result property="userCode" column="userCode"></result>
<result property="userName" column="userName"></result>
<result property="userPwd" column="userPwd"></result>
<result property="gender" column="gender"></result>
<result property="birthday" column="birthday"></result>
</collection>
</resultMap>
<sql id="simpleSql">
select id,roleCode,roleName,createdBy,creationDate,modifyBy,modifyDate from mrole
</sql>
<sql id="complexSql">
select r.id rid,r.roleCode,r.roleName,r.createdBy,r.creationDate,
r.modifyBy,r.modifyDate,u.id,u.userCode,u.userName,u.userPwd,
u.gender,u.birthday from mrole r
left join muser u on r.id=u.userRole
</sql>
<select id="getRoleByRoleName" resultMap="roleMap">
<include refid="complexSql" ></include>
where r.roleName=#{roleName}
</select>
<select id="getRoleByCondition" resultType="Role">
<include refid="simpleSql" ></include>
<where>
<if test="roleName!=null and roleName!=''">
roleName like concat('%',#{roleName},'%')
</if>
<if test="createdBy!=null">
and createdBy=#{createdBy}
</if>
</where>
<choose>
<when test="order==1">
order by creationDate desc
</when>
<when test="order==2">
order by creationDate asc
</when>
<otherwise>
order by id asc
</otherwise>
</choose>
</select>
</mapper>
```
之前写过一个简单得
连接数据库 ，和数据库操作差不多
只是换种写法
这是想找人写个小系统吗
可以去参照一些网上的实战视频，既有项目，也有具体的实现过程