2024年7月3号学习过程记录

续7月2号的代码，继续完善。

首先完成的是查找功能。

在MybatisTests.java中添加代码：

@Test
    public void test9(){
        Pages pages=new Pages(null,1,10);
        List<Company> companys = companyMapper.findCompanyByPages_2(pages);
        System.out.println(companys);
    }

在CompanyMapper.java中添加代码：

 List<Company> findCompanys(Pages pages);

在CompanyMapper.xml中添加代码：

<!--<include refid="Base_Column_List"></include>表示引用一段其他的代码-->
    <select id="findCompanys" resultMap="BaseResultMap" parameterType="com.qq.demo1.po.Pages">
        select
            <include refid="Base_Column_List"></include>
            from company t
                <where>
                    com_del = 0
                    <if test="id!=null">and com_id > #{id}</if>
                </where>
        limit #{pageNum},#{pageSize}
    </select>

接下来写一个批量插入，

批量插入的SQL语句如下：

    
INSERT INTO table_name (column1, column2, column3, ...)  
VALUES  
	  (value1_1, value1_2, value1_3, ...),  

	  (value2_1, value2_2, value2_3, ...),  

	  (value3_1, value3_2, value3_3, ...);

在CompanyMapper.xml中添加代码，

<!--useGeneratedKeys 是否使用数据库生成KEY,true表示使用，keyProperty 表示哪个属性是key-->
    <!--prefix 参数用什么开头，suffix用什么参数结尾，suffixOverrides用什么做分割-->
    <insert id="insertCompany" parameterType="com.qq.demo1.model.Company" useGeneratedKeys="true" keyProperty="comId">
        INSERT INTO company
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="comNo!=null and comNo!=''">com_no,</if>
            <if test="comName!=null and comName!=''">com_name,</if>
            <if test="comEmail!=null and comEmail!=''">com_email,</if>
            <if test="comPhone!=null and comPhone!=''">com_phone,</if>
            <if test="comPwd!=null and comPwd!=''">com_pwd,</if>
            <if test="comTime!=null" >com_time,</if>
            <if test="comRemark !=null and comRemark!=''">com_remark,</if>
            <if test="comStatus!=null and comStatus!=''">com_status,</if>
            <if test="comDel!=null and comDel!=''">com_del,</if>
            <if test="comCard!=null and comCard!=''">com_card,</if>
        </trim>
            <trim prefix="value (" suffix=")" suffixOverrides=",">
                <if test="comNo!=null and comNo!=''">#{comNo},</if>
                <if test="comName!=null and comName!=''">#{comName},</if>
                <if test="comEmail!=null and comEmail!=''">#{comEmail},</if>
                <if test="comPhone!=null and comPhone!=''">#{comPhone},</if>
                <if test="comPwd!=null and comPwd!=''">#{comPwd},</if>
                <if test="comTime!=null ">#{comTime},</if>
                <if test="comRemark!=null and comRemark!=''">#{comRemark},</if>
                <if test="comStatus!=null and comStatus!=''">#{comStatus},</if>
                <if test="comDel!=null and comDel!=''">#{comDel},</if>
                <if test="comCard!=null and comCard!=''">#{comCard},</if>
            </trim>
    </insert>

在CompanyMapper.java中添加代码，

int insertCompany(Company company);

在MybatisTests.java中添加代码：

@Test
    public void test10(){
        Company company = new Company();
        company.setComNo("1234");
        company.setComName("普惠科技2");
        company.setComEmail("123@qq.com");
        company.setComPhone("13000000000");
        company.setComPwd("1234");
        company.setComTime(new Date());
        company.setComStatus("3");
        company.setComDel("0");

        // 从dao层插入
        int insert = companyMapper.insertCompany(company);
        System.out.println(insert);

    }

接下类写一个更新：

在CompanyMapper.xml中添加代码：

<update id="updateCompanyById" parameterType="com.qq.demo1.model.Company" useGeneratedKeys="true" keyProperty="comId">
        UPDATE company
        <trim prefix="SET" suffix=" " suffixOverrides=",">
            <if test="comNo!=null and comNo!=''">com_no=#{comNo},</if>
            <if test="comName!=null and comName!=''">com_name=#{comName},</if>
            <if test="comEmail!=null and comEmail!=''">com_email=#{comEmail},</if>
            <if test="comPhone!=null and comPhone!=''">com_phone=#{comPhone},</if>
            <if test="comPwd!=null and comPwd!=''">com_pwd=#{comPwd},</if>
            <if test="comTime!=null" >com_time=#{comTime},</if>
            <if test="comRemark !=null and comRemark!=''">com_remark=#{comRemark},</if>
            <if test="comStatus!=null and comStatus!=''">com_status=#{comStatus},</if>
            <if test="comDel!=null and comDel!=''">com_del=#{comDel},</if>
            <if test="comCard!=null and comCard!=''">com_card=#{comCard},</if>
        </trim>
        WHERE com_id=#{comId}
    </update>

在CompanyMapper.java中添加代码：

int updateCompanyById(Company company);

在MybatisTests.java中添加代码：

 @Test
    public void test11() {
        Company company = new Company();
        company.setComNo("1234");
        company.setComName("普惠科技3333");
        company.setComEmail("123@qq.com");
        company.setComPhone("13000000000");
        company.setComPwd("1234");
        company.setComTime(new Date());
        company.setComStatus("3");
        company.setComDel("");
        company.setComId(103);
// 从dao层插入
        int updated = companyMapper.updateCompanyById(company);
        System.out.println(updated);

    }

 接下来写一个简单的删除：

在CompanyMapper.xml中添加代码：

<!--删除-->
    <delete id="delCompanyById">
        delete from company where com_id=#{id}
    </delete>

在CompanyMapper.java中添加代码：

 int delCompanyById(Integer id);

在MybatisTests.java中添加代码：

@Test
    public void test12() {
        //从dao层插入
        int deleteById =companyMapper.delCompanyById(103);
        System.out.println(deleteById);
    }

如果要改成通用的删除，要添加参数。

接下来写删除多个。

在CompanyMapper.xml中添加代码：

<!--删除多个-->
    <update id="delCompanyByIds">
        UPDATE company SET com_del =2 WHERE com_id IN
          <foreach collection="array" item="id" open="(" close=")" separator=",">
              #{id}
          </foreach>
    </update>

在CompanyMapper.java中添加代码：

int delCompanyByIds(Long[] ids);

在MybatisTests.java中添加代码：

 @Test
    public void test13() {
        Long[] ids=new Long[2];
        ids[0]=105L;
        ids[1]=104L;

        int deleteById=companyMapper.delCompanyByIds(ids);
        System.out.println(deleteById);
    }

下午所做工作：

将第一天所用的registry_center文件夹以及backend_puhui-master文件夹中的代码分别在IDEA中启动。

接着将D:\backend_puhui-master\backend_puhui-master\qst-ui路径下的代码全部在VScode中打开，并启动。

接着自动进入系统登录页面：

输入验证码，登录系统，

可看到系统首页页面如下：

今天主要的工作就是把环境搭建好。