package com.dwx.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor

public class Fragment {
    private String content;
    private String from;
    private String addByID;
    private String addByName;
}

@RequestMapping("/fragmentAdd")
  public String fragmentAdd(String fragmentContest, String fragmentFrom, String type, HttpServletRequest req, HttpServletResponse resp) {

      //添加一个过滤器
      UserUtil util = new UserUtil();
      boolean b1 = false;
      try {
          b1 = util.userExist(req, resp);
      } catch (IOException e) {
          throw new RuntimeException(e);
      }
      if (!b1) {
          return "/error/index";
      }
      //首先判断类型
      System.out.println("该操作的类型为: " + type);
      if (type.equals("保存")) {

          System.out.println("输入的金句内容是: " + fragmentContest);
          System.out.println("输入的金句节选自: " + fragmentFrom);
          //从session里得到用户ID
          HttpSession session = req.getSession();
          User user = (User) session.getAttribute("userSession");
          System.out.println("添加者ID: " + user.getId());

          if (!fragmentContest.equals("") && !fragmentFrom.equals("")) {
              //如果都不为空 则进行添加程序
              boolean b = fragmentService.addFragment(fragmentContest, fragmentFrom, user.getId());
              if (b) {
                  System.out.println("添加金句成功");
              } else {
                  System.out.println("添加金句失败");
              }
          }
          return "/houtai/jsp/billadd";
      } else {
          //执行一个查询程序
          getALlFragments(req, resp);
          return "/houtai/jsp/billlist";
      }

  }

//删除金句
    @RequestMapping("/fragmentDelete")
    public String fragmentDelete(String fragmentContent,HttpServletRequest req, HttpServletResponse resp){


        System.out.println("要删除金句的内容是:"+fragmentContent);

        //添加一个过滤器
        UserUtil util = new UserUtil();
        boolean b1 = false;
        try {
            b1 = util.userExist(req, resp);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        if (!b1) {
            return "/error/index";
        }
        //进行一个判断看能不能删除
        HttpSession session = req.getSession();
        User user = (User) session.getAttribute("userSession");
        String id = user.getId();
        System.out.println(id);
        boolean b = util.userRole(req, resp, id);
        if (b){
            System.out.println("有资格，可以删除");
            fragmentService.deleteFragment(fragmentContent);
        }
        else {
            System.out.println("没资格删除");
        }


        //再次更新一下fragmentList
        getALlFragments(req, resp);
        return "/houtai/jsp/billlist";

    }

@RequestMapping("/fragmentUpdateView")
//修改程序分为两个 第一个是一个查询程序
public String fragmentUpdateView(int id,HttpServletRequest req, HttpServletResponse resp){

    System.out.println("要修改的金句的id为: "+id);

    Fragment fragment = fragmentService.getFragmentByID(id);

    req.getSession().setAttribute("fragment",fragment);

    return "/houtai/jsp/billmodify";

}    @RequestMapping("/fragmentUpdateView")
//修改程序分为两个 第一个是一个查询程序
public String fragmentUpdateView(int id,HttpServletRequest req, HttpServletResponse resp){

    System.out.println("要修改的金句的id为: "+id);

    Fragment fragment = fragmentService.getFragmentByID(id);

    req.getSession().setAttribute("fragment",fragment);

    return "/houtai/jsp/billmodify";

}

//修改金句
    //修改程序
    @RequestMapping("/fragmentUpdate")
    public String fragmentUpdate(String content, String from, String type, HttpServletRequest req, HttpServletResponse resp) {

        //用session获得id
        Fragment fragmentOld = (Fragment) req.getSession().getAttribute("fragment");
        int id = fragmentOld.getId();


        System.out.println("要修改的金句: "+content);
        System.out.println("选自: "+from);
        System.out.println("操作内容: "+type);

        if (type.equals("保存")) {

            //修改程序
            fragmentService.updateFragment(content, from, id);

            //修改完更新一下程序
            Fragment fragment = fragmentService.getFragmentByID(id);
            req.getSession().setAttribute("fragment", fragment);
            return "/houtai/jsp/billmodify";

        } else {
            //没有修改 直接跳转回原页面
            return "/houtai/jsp/billlist";
        }


    }

SELECT j.`JNO`,j.`JNAME`,j.`CITY`
FROM j
WHERE j.`JNO` IN(
	SELECT j.`JNO`
	FROM spj
	WHERE spj.`PNO` IN(
		SELECT p.`PNO`
		FROM p
		WHERE p.`COLOR` = '蓝'
		
		)
	);

SELECT X.`SNO`,X.`SNAME`
FROM s X
WHERE X.`CITY` IN (
	SELECT Y.`city`
	FROM s Y
	WHERE Y.`SNO` = 'S1'
);

robot = new Robot();
         //用robot模拟 alt+win+w 直接调用微信
         robot.keyPress(KeyEvent.VK_CONTROL);
         robot.keyPress(KeyEvent.VK_ALT);
         robot.keyPress(KeyEvent.VK_W);

//释放Ctrl按键，像Ctrl，退格键，删除键这样的功能性按键，在按下后一定要释放
robot.keyRelease(KeyEvent.VK_CONTROL);
robot.keyRelease(KeyEvent.VK_ALT);
robot.keyRelease(KeyEvent.VK_W);

// Ctrl + F 搜索指定好友
robot.keyPress(KeyEvent.VK_CONTROL);
robot.keyPress(KeyEvent.VK_F);

//按下输入 enter
         robot.keyPress(KeyEvent.VK_ENTER);
         //释放
         robot.keyRelease(KeyEvent.VK_ENTER);
         robot.delay(1000);

String msg = "该信息为测试程序，不用回复";
tText = new StringSelection(msg);
clip.setContents(tText,null);

// 以下两行按下了ctrl+v，完成粘贴功能
robot.keyPress(KeyEvent.VK_CONTROL);
robot.keyPress(KeyEvent.VK_V);

//释放
robot.keyRelease(KeyEvent.VK_CONTROL);
robot.keyRelease(KeyEvent.VK_V);


robot.delay(1000);

//按下输入 enter
robot.keyPress(KeyEvent.VK_ENTER);
//释放
robot.keyRelease(KeyEvent.VK_ENTER);
robot.delay(1000);

import java.awt.*;
import java.awt.datatransfer.Clipboard;
import java.awt.datatransfer.StringSelection;
import java.awt.datatransfer.Transferable;
import java.awt.event.KeyEvent;

public class test {

    public static void main(String[] args) {
        System.out.println("程序开始执行");
        Robot robot = null;
        try {
            //创建robot对象
            robot = new Robot();
            //用robot模拟 alt+win+w 直接调用微信
            robot.keyPress(KeyEvent.VK_CONTROL);
            robot.keyPress(KeyEvent.VK_ALT);
            robot.keyPress(KeyEvent.VK_W);

            //释放Ctrl按键，像Ctrl，退格键，删除键这样的功能性按键，在按下后一定要释放
            robot.keyRelease(KeyEvent.VK_CONTROL);
            robot.keyRelease(KeyEvent.VK_ALT);
            robot.keyRelease(KeyEvent.VK_W);

            //执行一个延迟
            robot.delay(1000);

            // Ctrl + F 搜索指定好友
            robot.keyPress(KeyEvent.VK_CONTROL);
            robot.keyPress(KeyEvent.VK_F);
            //释放按键
            robot.keyRelease(KeyEvent.VK_CONTROL);
            robot.keyRelease(KeyEvent.VK_F);



            //将信息放到粘贴板上 并且发送
            Clipboard clip = Toolkit.getDefaultToolkit().getSystemClipboard();
            Transferable tText = new StringSelection("聂八一");
            clip.setContents(tText, null);

            // 以下两行按下了ctrl+v，完成粘贴功能
            robot.keyPress(KeyEvent.VK_CONTROL);
            robot.keyPress(KeyEvent.VK_V);

            //释放
            robot.keyRelease(KeyEvent.VK_CONTROL);
            robot.keyRelease(KeyEvent.VK_V);


            robot.delay(1000);

            //按下输入 enter
            robot.keyPress(KeyEvent.VK_ENTER);
            //释放
            robot.keyRelease(KeyEvent.VK_ENTER);
            robot.delay(1000);


            //可以输入信息了
            //按照先放到剪切板 后赋值 后enter实现输入

            String msg = "该信息为测试程序，不用回复";
            tText = new StringSelection(msg);
            clip.setContents(tText,null);

            // 以下两行按下了ctrl+v，完成粘贴功能
            robot.keyPress(KeyEvent.VK_CONTROL);
            robot.keyPress(KeyEvent.VK_V);

            //释放
            robot.keyRelease(KeyEvent.VK_CONTROL);
            robot.keyRelease(KeyEvent.VK_V);


            robot.delay(1000);

            //按下输入 enter
            robot.keyPress(KeyEvent.VK_ENTER);
            //释放
            robot.keyRelease(KeyEvent.VK_ENTER);
            robot.delay(1000);





        } catch (AWTException e) {
            throw new RuntimeException(e);
        }
        System.out.println("程序执行结束");
    }
}

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
String time = df.format(System.currentTimeMillis());
System.out.println("现在时间是:" + time);

//设置时间
      int year = 2022;
      int month = 11;
      String day = "06";
      int hour = 20;
      int min = 40;
      String today = year+"-"+month+"-"+day+" "+hour+":"+min;
      System.out.println("目标时间:"+today);
      while (true){
          time = df.format(System.currentTimeMillis());
          time2 = df1.format(System.currentTimeMillis());
          //沉睡疫苗
          try {
              sleep(1000);
          } catch (InterruptedException e) {
              throw new RuntimeException(e);
          }
          System.out.println(time2);
          if (time.equals(today)){
              System.out.println("到时候了");
              break;
          }
      }

package com.dwx.utils;

import java.text.SimpleDateFormat;

public class TimeUtil {

    //当前时间
    private String timeNow = null;
    //目标时间
    private String targetTime = null;

    //设置目标时间
    public String setTargetTime(String year, String month, String day, String hour, String min) {
        targetTime = year + "-" + month + "-" + day + " " + hour + ":" + min;
        System.out.println("目标时间为：" + targetTime);
        return targetTime;
    }

    //获得时钟 直到秒
    public String getClockToSecond() {
        long l = System.currentTimeMillis();
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String time = df.format(l);
        System.out.println(time);
        return time;
    }

    //获得时钟 直到分钟
    public String getClockToMin() {
        long l = System.currentTimeMillis();
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
        timeNow = df.format(l);
        System.out.println(timeNow);
        return timeNow;
    }
}

package com.dwx.main;

import com.dwx.utils.RobotUtil;
import com.dwx.utils.TimeUtil;

import static java.lang.Thread.sleep;

public class demo01 {
    public static void main(String[] args) {
        RobotUtil robotUtil = new RobotUtil();
        String  msg1 = robotUtil.getFriendWin("文件传输助手");
        System.out.println(msg1);
        String s = robotUtil.sendMsg("定时发送数据程序测试");
        System.out.println(s);

        //设置时间
        TimeUtil timeUtil = new TimeUtil();
        String t1 = timeUtil.setTargetTime("2022", "11", "06", "21", "13");
        while (true){
            //沉睡一秒
            try {
                sleep(1000);
            } catch (InterruptedException e) {
                System.out.println("sleep出错:"+e);
            }
            timeUtil.getClockToSecond();
            String t2 = timeUtil.getClockToMin();
            if (t1.equals(t2)){
                //时间正确 执行信息发送
                robotUtil.getFriendWin("文件传输助手");
                robotUtil.sendMsg("时间到 执行程序");
                break;
            }
        }


    }
}

String[] msg = new String[]{
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
        "信息一",
};

package com.dwx.main;

import com.dwx.utils.RobotUtil;
import com.dwx.utils.TimeUtil;

import static java.lang.Thread.sleep;

public class demo01 {
    public static void main(String[] args) {
        RobotUtil robotUtil = new RobotUtil();
        //设置时间
        TimeUtil timeUtil = new TimeUtil();
        String t1 = timeUtil.setTargetTime("2022", "11", "06", "21", "35");
        while (true){
            //沉睡一秒
            try {
                sleep(1000);
            } catch (InterruptedException e) {
                System.out.println("sleep出错:"+e);
            }
            timeUtil.getClockToSecond();
            String t2 = timeUtil.getClockToMin();
            if (t1.equals(t2)){
                //时间正确 执行信息发送
                break;
            }
        }

        //信息池
        String[] msg = new String[]{
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
                "信息一",
        };
        robotUtil.getFriendWin("文件传输助手");
        int i = 1;
        for (String s : msg) {
            robotUtil.sendMsg(s+i++);
        }



    }
}

public static void main(String[] args) {
       //文件读写
       String fileUrl = "E:\\java\\wechatTest\\src\\main\\resources\\msg.txt";
       File file = new File(fileUrl);
       BufferedReader bufferedReader = null;
       try {
           bufferedReader = new BufferedReader(new FileReader(file));

           String s = bufferedReader.readLine();
           while (null != s){
               System.out.println(s);
               s = bufferedReader.readLine();
           }

       } catch (FileNotFoundException e) {
           System.out.println(e);
       } catch (IOException e) {
           System.out.println(e);
       }

   }

package com.dwx.main;

import com.dwx.utils.FileUtil;
import com.dwx.utils.RobotUtil;
import com.dwx.utils.TimeUtil;

import java.util.List;

import static java.lang.Thread.sleep;

public class demo01 {
    public static void main(String[] args) {
        RobotUtil robotUtil = new RobotUtil();
        //设置时间
        TimeUtil timeUtil = new TimeUtil();
        String t1 = timeUtil.setTargetTime("2022", "11", "06", "21", "57");
        while (true){
            //沉睡一秒
            try {
                sleep(1000);
            } catch (InterruptedException e) {
                System.out.println("sleep出错:"+e);
            }
            timeUtil.getClockToSecond();
            String t2 = timeUtil.getClockToMin();
            if (t1.equals(t2)){
                //时间正确 执行信息发送
                break;
            }
        }

        //信息池
        FileUtil fileUtil = new FileUtil();
        List<String> msgByFile = fileUtil.getMsgByFile();

        robotUtil.getFriendWin("文件传输助手");

        for (String s : msgByFile) {
            robotUtil.sendMsg(s);
        }


    }
}

select * from union.interpretation where keyword like  concat('%',#{keyword},'%')

package com.dwx.until;

import java.io.UnsupportedEncodingException;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

public class MD5Util {

    public String getMD5(String password) {


        byte[] digest = null;
        try {
            MessageDigest md5 = MessageDigest.getInstance("md5");
            digest = md5.digest(password.getBytes());
        } catch (NoSuchAlgorithmException e) {
            e.printStackTrace();
        }
        //16是表示转换为16进制数
        String md5Str = new BigInteger(1, digest).toString(16);
        return md5Str;
    }

}

package com.dwx.until;

import org.springframework.web.multipart.MultipartFile;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.nio.file.Path;
import java.nio.file.Paths;

//这是一个文件操作
public class FileUtil {

    //一个文件读取操作
    public String fileUpLoad(MultipartFile myfile,String filename, String fileUrl){
        //此路径为 服务器要存储文件的文件夹的路径


        //创建新文件
        File file = new File(fileUrl+filename);
        InputStream inputStream = null;
        FileOutputStream fileOutputStream = null;
        String result = null;
        try {

            //获得input流
            inputStream = myfile.getInputStream();

            fileOutputStream = new FileOutputStream(file);



            //固定的文件写操作
            int read;
            byte[] bytes = new byte[1024];

            while ((read = inputStream.read(bytes)) != -1) {
                fileOutputStream.write(bytes, 0, read);
            }
            //如果一切成功
            result = "success";


        } catch (Exception e) {
            System.out.println("程序出错了");
            System.out.println(e);
            //如果产生了异常 返回false
            return "false";

        }finally {

            //关闭所有的流
            try {
                fileOutputStream.close();
                inputStream.close();
            } catch (IOException e) {
                throw new RuntimeException(e);
            }
        }
     return  result;
    }


    //一个文件删除操作
    public boolean fileDelete(String fileName){
        //直接删除
        String fileUrl  = "/img";

        System.out.println(fileUrl + fileName);
        File file = new File(fileUrl + fileName);
        System.out.println(file.isFile());
        boolean delete = file.delete();


        return delete;
    }



}

package com.dwx.controller;

import com.dwx.until.FileUtil;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

@Controller
public class areFaceController {

    @RequestMapping(value = "/areFace.do")
    @ResponseBody
    public String areFaceTest(HttpServletRequest request,HttpServletRequest response,HttpSession session) {
        MultipartHttpServletRequest multipartRequest=(MultipartHttpServletRequest) request;
        MultipartFile myfile = multipartRequest.getFile("file");


        //获得正规的
        String fileName = myfile.getOriginalFilename();
        System.out.println(fileName);
        int local = fileName.lastIndexOf(".");
        System.out.println(local);
        String fileType = fileName.substring(local);
        System.out.println("文件类型为:"+fileType);

        //获得路径
        String contextPath = request.getContextPath();
        FileUtil fileUtil = new FileUtil();
        String fileUrl = "E:\\java\\union\\src\\main\\java\\com\\dwx\\img\\";


        String filename = "test";
        //文件上传操作
        String s = fileUtil.fileUpLoad(myfile, filename+fileType,fileUrl);

        System.out.println("图片生成成功");
        //对数据库里的File进行一个增加

        return s;


    }

}