java 监听复制面板

java 监听复制面板

通过读取文件和监听复制面板的内容,生成sql语句,执行sql

  • 监听复制面板
  • jdbc 连接
  • 业务处理
package com.czh.sand.xiamen.demo;

import cn.hutool.json.JSONUtil;
import com.czh.common.util.idgen.IdGenerateFactory;
import com.czh.sand.xiamen.demo.utils.DateUtils;
import java.awt.*;
import java.awt.datatransfer.*;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.List;
import java.util.Map;


/**
 * @author 
 * @date 1/30/2024
 */
public class SQLTool implements ClipboardOwner {

    public static void main(String[] args) throws Exception {
        // 监听复制
        SQLTool sqlTool = new SQLTool();
        while (true);
    }

    // 剪切板 begin ======================================>
    private Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();

    public SQLTool(){
        // 将剪切板的所有者设置为自己
        // 当所有者为自己时,才能监控下一次剪切板的变动
        // clipboard.getContents(null) 获取当前剪切板的内容
        clipboard.setContents(clipboard.getContents(null), this);
    }

    /**
     * 监听剪切板
     * @param clipboard the clipboard that is no longer owned
     * @param contents the contents which this owner had placed on the clipboard
     */
    @Override
    public void lostOwnership(Clipboard clipboard, Transferable contents) {
        // 延迟1s执行,如果立即执行会报错,系统还没使用完剪切板,直接操作会报错
        // IllegalStateException: cannot open system clipboard
        try {
            Thread.sleep(1000);
        } catch (InterruptedException e) {
            e.printStackTrace();
        }

        String text = null;
        if (clipboard.isDataFlavorAvailable(DataFlavor.stringFlavor)){
            try {
                // 获取文本数据
                text = (String)clipboard.getData(DataFlavor.stringFlavor);
            } catch (UnsupportedFlavorException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        System.out.println(text);

        try {
            getSQLByClick(text);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        // 不影响剪切板内容
        // 每次剪切板变动,剪切板的所有者会被剥夺,所以要重新设置自己为所有者,才能监听下一次剪切板变动
        clipboard.setContents(clipboard.getContents(null), this);
    }
    // 剪切板 end ======================================
    

    // jdbc 连接数据库 begin ==============================
    private static final String driver="com.mysql.jdbc.Driver";//数据库驱动
    private static final String url="jdbc:mysql://192.168.4.191:3316/bs?useUnicode=true&characterEncoding=utf-8&useSSL=false";
    private static final String username="root";//数据库名
    private static final String password="rootsand";//数据库密码

    private static Connection conn=null;
    //静态代码块负责加载驱动
    static{
        try{
            Class.forName(driver);
        }
        catch(Exception e){
            e.printStackTrace();
        }
    }

    //单例模式返回数据库对象
    public static Connection getConnection() throws Exception{
        if(conn==null){
            Class.forName(driver);
            conn= DriverManager.getConnection(url, username, password);
            return conn;

        }
        return conn;
    }
    
    // jdbc 连接数据库 end ==============================


    // 具体业务,根据剪贴板内容、文件内容生成sql,执行sql
    public static void getSQLByClick(String modelName) throws Exception {
        String path = "./bs-3d\\dist\\storage\\scenes\\xiamen\\park.json";
        byte[] bytes = Files.readAllBytes(Paths.get(path));
        String json = new String(bytes);
        Map<String, Object> jsonObject = JSONUtil.parseObj(json);

        Map<String, Object> map = (Map<String, Object>) jsonObject.get("scene");
        List<Object> eyeList = (List<Object>) map.get("eye");
        List<Object> centerList = (List<Object>) map.get("center");

        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.append("update bs_model_info set \n")
                        .append("eye_x=").append(eyeList.get(0)).append(",")
                        .append("eye_y=").append(eyeList.get(1)).append(",")
                        .append("eye_z=").append(eyeList.get(2)).append(",")
                        .append("center_x=").append(centerList.get(0)).append(",")
                        .append("center_y=").append(centerList.get(1)).append(",")
                        .append("center_z=").append(centerList.get(2)).append("\n")
                        .append("where model_name=").append("'").append(modelName).append("';");
        
        Connection connection = getConnection();
        PreparedStatement preparedStatement = connection.prepareStatement(stringBuilder.toString());
        preparedStatement.execute();
        preparedStatement.close();

        System.out.println("==============  " + DateUtils.todayDateTimeStr(null));
        System.out.println(stringBuilder.toString());

    }
}

  • 6
    点赞
  • 11
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值