Elasticsearch插件：elasticsearch-sql安装和使用

article/2025/10/24 12:38:32

使用此插件，您可以使用熟悉的SQL语法查询elasticsearch。您还可以在SQL中使用ES函数。

有两种方法可以使用此插件：

  1. 使用其余的api 
http://localhost:9200/_sql?sql=select * from indexName limit 10

2. 或者通过浏览器访问 http://localhost:9200/_plugin/sql 


Web前端概述

 

安装

安装为插件：版本（sql插件与Elasticsearch的版本对应关系）

elasticsearch versionlatest versionremarksbranch
1.x1.7.6tested against elastic 1.7.6elastic1.x
2.0.02.0.4delete commands not supportedelastic2.0
2.1.02.1.0.2delete commands not supportedelastic2.1
2.1.12.1.1.1delete commands not supportedelastic2.1.1
2.1.22.1.2.0delete commands not supportedelastic2.1.2
2.2.02.2.0.1delete commands not supportedelastic2.2.0
2.2.12.2.1.0delete commands not supportedelastic2.2.1
2.3.02.3.0.0delete commands not supportedelastic2.3.0
2.3.12.3.1.1delete commands not supportedelastic2.3.1
2.3.22.3.2.0delete commands not supportedelastic2.3.2
2.3.32.3.3.0delete commands not supportedelastic2.3.3
2.3.42.3.4.0delete commands not supportedelastic2.3.4
2.3.52.3.5.0delete commands not supportedelastic2.3.5
2.4.02.4.0.1delete commands not supportedelastic2.4.0
2.4.12.4.1.0delete commands not supportedelastic2.4.1
2.4.22.4.2.1delete commands not supportedelastic2.4.2
2.4.32.4.3.0delete commands not supportedelastic2.4.3
2.4.42.4.4.0delete commands not supportedelastic2.4.4
2.4.52.4.5.0delete commands not supportedelastic2.4.5
2.4.62.4.6.0delete commands not supportedelastic2.4.6
5.0.15.0.1.0delete commands not supportedelastic5.0.1
5.1.15.1.1.0delete commands not supportedelastic5.1.1
5.1.25.1.2.0delete commands not supportedelastic5.1.2
5.2.05.2.0.0delete commands not supportedelastic5.2.0
5.2.15.2.1.0delete commands not supportedelastic5.2.1
5.2.25.2.2.0delete commands not supportedelastic5.2.2
5.3.05.3.0.0delete commands not supportedelastic5.3.0
5.3.15.3.1.0delete commands not supportedelastic5.3.1
5.3.25.3.2.0delete commands not supportedelastic5.3.2
5.3.35.3.3.0delete commands not supportedelastic5.3.3
5.4.05.4.0.0delete commands not supportedelastic5.4.0
5.4.15.4.1.0delete commands not supportedelastic5.4.1
5.4.25.4.2.0delete commands not supportedelastic5.4.2
5.4.35.4.3.0delete commands not supportedelastic5.4.3
5.5.05.5.0.1delete commands not supportedelastic5.5.0
5.5.15.5.1.0delete commands not supportedelastic5.5.1
5.5.25.5.2.0delete commands not supportedelastic5.5.2
5.5.35.5.3.0delete commands not supportedelastic5.5.3
5.6.05.6.0.0delete commands not supportedelastic5.6.0
5.6.15.6.1.0delete commands not supportedelastic5.6.1
5.6.25.6.2.0delete commands not supportedelastic5.6.2
5.6.35.6.3.0delete commands not supportedelastic5.6.3
5.6.45.6.4.0delete commands not supportedelastic5.6.4
5.6.55.6.5.0delete commands not supportedelastic5.6.5
5.6.65.6.6.0 elastic5.6.6
5.6.75.6.7.0 elastic5.6.7
5.6.85.6.8.0 elastic5.6.8
5.6.95.6.9.0 elastic5.6.9
5.6.105.6.10.0 elastic5.6.10
6.0.06.0.0.0 elastic6.0.0
6.0.16.0.1.0 elastic6.0.1
6.1.06.1.0.0 elastic6.1.0
6.1.16.1.1.0 elastic6.1.1
6.1.26.1.2.0 elastic6.1.2
6.1.36.1.3.0 elastic6.1.3
6.1.46.1.4.0 elastic6.1.4
6.2.06.2.0.0 elastic6.2.0
6.2.16.2.1.0 elastic6.2.1
6.2.26.2.2.0 elastic6.2.2
6.2.36.2.3.0 elastic6.2.3
6.2.46.2.4.0 elastic6.2.4
6.3.06.3.0.0 elastic6.3.0
6.3.16.3.1.0 elastic6.3.1

不同Elasticsearch版本的安装命令

Elasticsearch 1.x

./bin/plugin -u https://github.com/NLPchina/elasticsearch-sql/releases/download/1.7.6/elasticsearch-sql-1.7.6.zip --install sql

Elasticsearch 2.0.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.0.4/elasticsearch-sql-2.0.4.zip

Elasticsearch 2.1.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.0.2/elasticsearch-sql-2.1.0.2.zip

Elasticsearch 2.1.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.1.1/elasticsearch-sql-2.1.1.1.zip

Elasticsearch 2.1.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.2.0/elasticsearch-sql-2.1.2.0.zip

Elasticsearch 2.2.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.0.1/elasticsearch-sql-2.2.0.1.zip

Elasticsearch 2.2.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.1.0/elasticsearch-sql-2.2.1.0.zip

Elasticsearch 2.3.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip

Elasticsearch 2.3.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.1.1/elasticsearch-sql-2.3.1.1.zip

Elasticsearch 2.3.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.2.0/elasticsearch-sql-2.3.2.0.zip

Elasticsearch 2.3.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.3.0/elasticsearch-sql-2.3.3.0.zip

Elasticsearch 2.3.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.4.0/elasticsearch-sql-2.3.4.0.zip

Elasticsearch 2.3.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.5.0/elasticsearch-sql-2.3.5.0.zip

Elasticsearch 2.4.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.0.1/elasticsearch-sql-2.4.0.1.zip

Elasticsearch 2.4.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.1.0/elasticsearch-sql-2.4.1.0.zip

Elasticsearch 2.4.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.2.1/elasticsearch-sql-2.4.2.1.zip

Elasticsearch 2.4.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.3.0/elasticsearch-sql-2.4.3.0.zip

Elasticsearch 2.4.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.4.0/elasticsearch-sql-2.4.4.0.zip

Elasticsearch 2.4.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.5.0/elasticsearch-sql-2.4.5.0.zip

Elasticsearch 2.4.6

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.6.0/elasticsearch-sql-2.4.6.0.zip

Elasticsearch 5.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.0.1/elasticsearch-sql-5.0.1.0.zip

Elasticsearch 5.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.1.0/elasticsearch-sql-5.1.1.0.zip

Elasticsearch 5.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.2.0/elasticsearch-sql-5.1.2.0.zip

Elasticsearch 5.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.0.0/elasticsearch-sql-5.2.0.0.zip

Elasticsearch 5.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.1.0/elasticsearch-sql-5.2.1.0.zip

Elasticsearch 5.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.2.0/elasticsearch-sql-5.2.2.0.zip

Elasticsearch 5.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.0.0/elasticsearch-sql-5.3.0.0.zip

Elasticsearch 5.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.1.0/elasticsearch-sql-5.3.1.0.zip

Elasticsearch 5.3.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.2.0/elasticsearch-sql-5.3.2.0.zip

Elasticsearch 5.3.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.3.0/elasticsearch-sql-5.3.3.0.zip

Elasticsearch 5.4.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/elasticsearch-sql-5.4.0.0.zip

Elasticsearch 5.4.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/elasticsearch-sql-5.4.1.0.zip

Elasticsearch 5.4.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.2.0/elasticsearch-sql-5.4.2.0.zip

Elasticsearch 5.4.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.3.0/elasticsearch-sql-5.4.3.0.zip

Elasticsearch 5.5.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.0.0/elasticsearch-sql-5.5.0.1.zip

Elasticsearch 5.5.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.1.0/elasticsearch-sql-5.5.1.0.zip

Elasticsearch 5.5.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.2.0/elasticsearch-sql-5.5.2.0.zip

Elasticsearch 5.5.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.3.0/elasticsearch-sql-5.5.3.0.zip

Elasticsearch 5.6.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.0.0/elasticsearch-sql-5.6.0.0.zip

Elasticsearch 5.6.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.1.0/elasticsearch-sql-5.6.1.0.zip

Elasticsearch 5.6.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.2.0/elasticsearch-sql-5.6.2.0.zip

Elasticsearch 5.6.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.3.0/elasticsearch-sql-5.6.3.0.zip

Elasticsearch 5.6.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.4.0/elasticsearch-sql-5.6.4.0.zip

Elasticsearch 5.6.5

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.5.0/elasticsearch-sql-5.6.5.0.zip

Elasticsearch 5.6.6

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.6.0/elasticsearch-sql-5.6.6.0.zip

Elasticsearch 5.6.7

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.7.0/elasticsearch-sql-5.6.7.0.zip

Elasticsearch 5.6.8

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.8.0/elasticsearch-sql-5.6.8.0.zip

Elasticsearch 5.6.9

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.9.0/elasticsearch-sql-5.6.9.0.zip

Elasticsearch 5.6.10

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.10.0/elasticsearch-sql-5.6.10.0.zip

Elasticsearch 6.0.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.0.0/elasticsearch-sql-6.0.0.0.zip

Elasticsearch 6.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.1.0/elasticsearch-sql-6.0.1.0.zip

Elasticsearch 6.1.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.0.0/elasticsearch-sql-6.1.0.0.zip

Elasticsearch 6.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.1.0/elasticsearch-sql-6.1.1.0.zip

Elasticsearch 6.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.2.0/elasticsearch-sql-6.1.2.0.zip

Elasticsearch 6.1.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.3.0/elasticsearch-sql-6.1.3.0.zip

Elasticsearch 6.1.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.4.0/elasticsearch-sql-6.1.4.0.zip

Elasticsearch 6.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.0.0/elasticsearch-sql-6.2.0.0.zip

Elasticsearch 6.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.1.0/elasticsearch-sql-6.2.1.0.zip

Elasticsearch 6.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.2.0/elasticsearch-sql-6.2.2.0.zip

Elasticsearch 6.2.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip

Elasticsearch 6.2.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.4.0/elasticsearch-sql-6.2.4.0.zip

Elasticsearch 6.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.0.0/elasticsearch-sql-6.3.0.0.zip

Elasticsearch 6.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.1.0/elasticsearch-sql-6.3.1.1.zip

After doing this, you need to restart the Elasticsearch server. Otherwise you may get errors like Invalid index name [sql], must not start with '']; ","status":400}.

执行此操作后，您需要重新启动Elasticsearch服务器。否则你可能会收到错误

Invalid index name [sql], must not start with '']; ","status":400}。

重新启动Elasticsearch服务器

#停止Elasticsearch进程
kill `ps -ef | grep Elasticsearch | grep -v grep | awk '{print $2}'`
#启动Elasticsearch进程
/elasticsearch-5.4.3/bin/elasticsearch -d

基本用法

在elasticsearch 1.x / 2.x上，可以直接访问elasticsearch-sql web前端页面：

http://localhost:9200/_plugin/sql/

在elasticsearch 5.x / 6.x上,需要先下载个网站插件 download and extract site.

具体下载地址是：

https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/es-sql-site-standalone.zip

启动插件:

cd site-server
npm install express --save
node node-server.js
  • 简单的查询
http://localhost:9200/_sql?sql=select * from indexName limit 10
  • 解释SQL
http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10

SQL用法

  • 简单查询

      SELECT * FROM bank WHERE age >30 AND gender = 'm'

  • 聚合查询

      select COUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age)FROM bank GROUP BY gender ORDER BY SUM(age), m DESC

  • 删除

      DELETE FROM bank WHERE age >30 AND gender = 'm'

超越SQL

  • Search

      SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDER BY _score DESC LIMIT 3

  • 聚合

    • range age group 20-25,25-30,30-35,35-40

        SELECT COUNT(age) FROM bank GROUP BY range(age, 20,25,30,35,40)

    • range date group by day

        SELECT online FROM online GROUP BY date_histogram(field='insert_time','interval'='1d')

    • range date group by your config

        SELECT online FROM online GROUP BY date_range(field='insert_time','format'='yyyy-MM-dd' ,'2014-08-18','2014-08-17','now-8d','now-7d','now-6d','now')

  • ES Geographic（地理位置）

      SELECT * FROM locations WHERE GEO_BOUNDING_BOX(fieldname,100.0,1.0,101,0.0)

  • Select type

      SELECT * FROM indexName/type

SQL功能

  • SQL Select
  • SQL Delete
  • SQL Where
  • SQL Order By
  • SQL Group By
  • SQL AND & OR
  • SQL Like
  • SQL COUNT distinct
  • SQL In
  • SQL Between
  • SQL Aliases
  • SQL Not Null
  • SQL(ES) Date
  • SQL avg()
  • SQL count()
  • SQL last()
  • SQL max()
  • SQL min()
  • SQL sum()
  • SQL Nulls
  • SQL isnull()
  • SQL now()
  • SQL floor
  • SQL split
  • SQL trim
  • SQL log
  • SQL log10
  • SQL substring
  • SQL round
  • SQL sqrt
  • SQL concat_ws
  • SQL union and minus

支持JDBC (处于试验阶段的功能)

Check details : JDBC Support

public void testJDBC() throws Exception {Properties properties = new Properties();properties.put("url", "jdbc:elasticsearch://127.0.0.1:9300/" + TestsConstants.TEST_INDEX);DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory.createDataSource(properties);Connection connection = dds.getConnection();PreparedStatement ps = connection.prepareStatement("SELECT  gender,lastname,age from  " + TestsConstants.TEST_INDEX + " where lastname='Heath'");ResultSet resultSet = ps.executeQuery();List<String> result = new ArrayList<String>();while (resultSet.next()) {System.out.println(resultSet.getString("lastname") + "," + resultSet.getInt("age") + "," + resultSet.getString("gender"))}ps.close();connection.close();dds.close();}

 

Beyond sql features

  • ES TopHits
  • ES MISSING
  • ES STATS
  • ES GEO_INTERSECTS
  • ES GEO_BOUNDING_BOX
  • ES GEO_DISTANCE
  • ES GEOHASH_GRID aggregation

参考来源：https://github.com/NLPchina/elasticsearch-sql


http://chatgpt.dhexx.cn/article/TXKGb4OE.shtml

相关文章

sqlserver2012安装教程

sqlserver2012安装教程

前言&#xff1a; 我们实验室开发前端界面一般用.net&#xff0c;然后数据库用微软的Sqlserver,搭配起来做一些系统框架还是很方便的。记得本科的时候安装Sqlserver的时候好像出了点问题&#xff0c;不知道是不是因为先安装了VS&#xff0c;然后这一次我打算先安装Sqlserver&am…
阅读更多...
SQLServer2008安装教程

SQLServer2008安装教程

因为对接老系统的数据&#xff0c;上面使用的SQLServer2008&#xff0c;所以本机也需要SQLServer2008作对接。 首当其冲的就是SQLServer2008的安装。 1.下载sqlServer2008的安装包 2.在安装包中点击setup.exe 2.选择安装&#xff0c;再选择全新安装 3.安装规则检测&#xff…
阅读更多...
SQL server安装问题汇总

SQL server安装问题汇总

SQLTOC 欢迎使用Markdown编辑器 安装SQL Server遇到的几个问题 1.安装过程中最后出现“数据库引擎服务安装失败”&#xff0c;报错代码&#xff1a;1722&#xff0c;安装时选择“全新SQL server安装或向现有安装添加功能”&#xff0c;安装成功了。 2.安装过程出现“以前的某…
阅读更多...
MySQL可视化工具HeidiSQL安装与使用

MySQL可视化工具HeidiSQL安装与使用

之前mysql可视化工具一直使用navicat for mysql工具,后来想学一下其他的数据库,把navicat for MySQL卸载后,网上找教程下载安装了navicat premium,但是破解之后的一段时间内,激活码失效了,由于navicat for mysql工具安装也需要破解,便不想安装了,就找到这款免费的MySQL可视化工…
阅读更多...
SQL安装步骤及可能遇到的错误

SQL安装步骤及可能遇到的错误

SQL Server 2017下载内容分为两部分SQL Server 2017 Developer和SQLserver Mamngement Studio 第一部分&#xff1a; 1.官网下载SQL Server 2017 Developer https://www.microsoft.com/zh-cn/sql-server/sql-server-downloads 2.打开安装软件&#xff0c;选择自定义 3选择语…
阅读更多...
mysql安装步骤

mysql安装步骤

针对windows操作系统&#xff0c;使用mysql8免安装版本。 1、在官网下载对应的压缩文件&#xff0c;放到本地文件夹下&#xff0c;解压缩。 2、配置Path环境变量&#xff1a;指向mysql的bin文件夹路径&#xff0c;C:\software\mysql-8.0.23-winx64\bin。 3、在mysql根目录下…
阅读更多...
我的老公是IT男

我的老公是IT男

我家老公是个资深IT男&#xff0c;结婚这么多年以来&#xff0c;工作日一起吃晚餐的次数屈指可数&#xff01;因为要加班&#xff5e; 对老公的工作谈不上支持&#xff0c;但至少不能扯后腿吧。 晚上自己吃饭自己遛弯&#xff0c;倒也还清净。 成家立业后&#xff0c;才觉出…
阅读更多...
IT人的事业情结

IT人的事业情结

IT人的事业情结 对事业的认知主要来自学生时代的那些影视作品&#xff0c;不管是白手起家、还是承袭祖业&#xff0c;有一家自己的小面店做得风生水起、门庭若市&#xff0c;便是年少轻狂的心中完美的事业愿景。 毕业之初进入一家当地小有名气民营企业&#xff0c;兢兢业业研发…
阅读更多...
IT男的神级吐槽 || 我们IT人的心声(_)

IT男的神级吐槽 || 我们IT人的心声(_)

小编说&#xff1a;黑程序员、吐槽程序员的段子多了去了&#xff0c;这篇文章可谓是歇斯底里的吐槽啊&#xff0c;吐露了我们广大IT人的心声&#xff0c;顿时心里有点酸(>_<)&#xff0c;不过&#xff0c;不过&#xff0c;依旧热爱着IT&#xff0c;just do IT!!文章也仅供…
阅读更多...
如果金融男和IT男同时追你，你选谁？

如果金融男和IT男同时追你，你选谁？

对于金融女心仪对象排行榜的前两名&#xff0c; 金融男和IT男的地位是不可动摇了&#xff0c; 要说两个行业的不同之处 &#xff0c; 最大的区别在于一个是经济领域&#xff0c; 一个是产业领域 而另一个区别呢&#xff1f; 当然是从事这两种行业的人群不同啦&#xff0c; 具…
阅读更多...
IT技术人员的特点

IT技术人员的特点

1、价值观 对生活的一般看法&#xff1a;追求简单&#xff0c;安定&#xff0c;可控制的生活&#xff0c;但对家庭生活的责任持消极态度 草根本性&#xff0c;反对政治和专制 希望得到平等和公正的对待 相信一分耕耘&#xff0c;一分收获 将技术视为立身之本&#xff0c;通…
阅读更多...
好IT男不能“淫”-谈IT人员目前普遍存在的“A情绪”

好IT男不能“淫”-谈IT人员目前普遍存在的“A情绪”

《如果当道德无法约束你的时候。。。那么就让对疾病的恐惧来制约你吧》 前言 在写这篇文章前我的心情无比的沉重。几次提笔欲写&#xff0c;几次又未能完成&#xff0c;可是最终让我“奋笔疾书”的原因在于前不久我有几个前好友包括前同事中有一人&#xff0c;被确诊为HIV&…
阅读更多...
谁决定了 IT 直男的价值

谁决定了 IT 直男的价值

作者 | Jeff.Star 责编 | 张文 来源 | 来自 CSDN 博客 头图 | CSDN 下载自视觉中国 怎样做一个有价值的程序员&#xff1f; 从一段代码说起 package com.jeff.study.jdk8.stream; import java.lang.reflect.Modifier;import java.util.Arrays; /** * Description 迭代常量类中…
阅读更多...
IT男的工作现状

IT男的工作现状

写在前面 干IT痴汉这一行也有些年头了&#xff0c;做过几年产品&#xff0c;也做过几年外包。总是想把自己的工作经历整理成文&#xff0c;为日后自己玩味&#xff0c;同时也为刚入行的后来者做一些参考。 近三年来都是做软件外包&#xff0c;就从这几天的工作说起吧。 外包…
阅读更多...
什么叫真正的IT男？

什么叫真正的IT男？

来源&#xff1a;极客头条 说起IT男&#xff0c;大家脑海里都会浮现一番这样的形象&#xff1a; 瘦的身材&#xff0c;带着粗黑的眼镜框&#xff0c;沉默寡言&#xff0c;一身休闲装的打扮&#xff0c;头发有时会凌乱&#xff0c;不用去面对客户&#xff0c;有点屌丝&#xff0…
阅读更多...
谁决定了IT直男的价值

谁决定了IT直男的价值

做一个有价值的程序员 从一段代码说起为什么没有价值&#xff1f;谁才是这场竞赛的裁判&#xff1f;开源时代&#xff0c;别让内卷耽误了你&#xff1f;如何搭建自己的知识体系&#xff1f; 从一段代码说起 package com.jeff.study.jdk8.stream;import java.lang.reflect.Modi…
阅读更多...
真正的IT技术男是什么样的？

真正的IT技术男是什么样的？

我们经常会听到很多对IT男士的调侃称呼&#xff0c;“屌丝”、“宅男”&#xff0c;会逗的大家捧腹大笑。但是&#xff0c;大家要不要以为称呼IT男是“屌丝”、“宅男”&#xff0c;就当真以为他们是这样了。今天&#xff0c;青鸟学姐就带大家一起来了解一下&#xff0c;真正的…
阅读更多...
RK3288的GTxx触摸屏驱动调试

RK3288的GTxx触摸屏驱动调试

电容屏是在LCD屏上覆盖一个透明的矩阵键盘&#xff0c;在调试goodix gt9xx系列触控屏的驱动时&#xff0c;会遇到各种问题&#xff01; 1、linux启动时&#xff0c;触控屏驱动偶尔不能加载固件信息。 2、在使用过程中偶尔不能触发或触发失灵现象。 3、触屏反应缓慢&#xff0c;…
阅读更多...
C/C++中最快、最简洁的read()快读(卡常数)方法

C/C++中最快、最简洁的read()快读(卡常数)方法

别人的方法 遇到数据较多的题目时&#xff0c;用scanf或者cin肯定是不够快的。由于getchar()有速度快的特性&#xff0c;有人手打了这样的快速读入函数&#xff1a; inline void read(int& a) {int s 0, w 1;char ch getchar();while (ch < 0 || ch>9){if (ch …
阅读更多...
I2C通信

I2C通信

I2C总线是PHLIPS公司推出的一种串行总线&#xff0c;它只有两根双向信号线。一根是数据线SDA&#xff08;serial data I/o&#xff09;&#xff0c;另一根是时钟总线SCL&#xff08;serial clock&#xff09;。 如下图所示&#xff0c;I2C总线上可以挂接多个器件&#xff0c;而…
阅读更多...
推荐文章

Copyright @ 2022~2023