This is an automated email from the ASF dual-hosted git repository.
sunzesong pushed a commit to branch rel/0.9
in repository https://gitbox.apache.org/repos/asf/incubator-iotdb.git
The following commit(s) were added to refs/heads/rel/0.9 by this push:
new ae45ed2 Add Chinese documents for chapter 4.2 in rel/0.9
ae45ed2 is described below
commit ae45ed2970b341e5c0df4e1b3e1567b5c859cef6
Author: samperson1997 <[email protected]>
AuthorDate: Tue Feb 18 18:05:04 2020 +0800
Add Chinese documents for chapter 4.2 in rel/0.9
---
.../UserGuide/4-Client/2-Programming - JDBC.md | 187 ++++++++++++++++++++-
1 file changed, 185 insertions(+), 2 deletions(-)
diff --git a/docs/Documentation-CHN/UserGuide/4-Client/2-Programming - JDBC.md
b/docs/Documentation-CHN/UserGuide/4-Client/2-Programming - JDBC.md
index 38b18b5..923d00b 100644
--- a/docs/Documentation-CHN/UserGuide/4-Client/2-Programming - JDBC.md
+++ b/docs/Documentation-CHN/UserGuide/4-Client/2-Programming - JDBC.md
@@ -22,10 +22,193 @@
# 第4章: 客户端
## 编程 - JDBC
-Coming soon.
+## 使用
+### 依赖项
-## Status Code
+* JDK >= 1.8
+* Maven >= 3.1
+
+### 只打包 JDBC 工程
+
+在根目录下执行下面的命令:
+```
+mvn clean package -pl jdbc -am -Dmaven.test.skip=true
+```
+
+### 如何到本地 MAVEN 仓库
+
+在根目录下执行下面的命令:
+```
+mvn clean install -pl jdbc -am -Dmaven.test.skip=true
+```
+
+### 如何在 MAVEN 中使用 IoTDB JDBC
+
+```
+<dependencies>
+ <dependency>
+ <groupId>org.apache.iotdb</groupId>
+ <artifactId>iotdb-jdbc</artifactId>
+ <version>0.8.0</version>
+ </dependency>
+</dependencies>
+```
+
+### 示例
+
+本章提供了如何建立数据库连接、执行 SQL 和显示查询结果的示例。
+
+要求您已经在工程中包含了数据库编程所需引入的包和 JDBC class.
+
+**注意:为了更快地插入，建议使用 insertBatch()**
+
+```Java
+import java.sql.*;
+import org.apache.iotdb.jdbc.IoTDBSQLException;
+
+public class JDBCExample {
+ /**
+ * Before executing a SQL statement with a Statement object, you need to
create a Statement object using the createStatement() method of the Connection
object.
+ * After creating a Statement object, you can use its execute() method to
execute a SQL statement
+ * Finally, remember to close the 'statement' and 'connection' objects by
using their close() method
+ * For statements with query results, we can use the getResultSet() method
of the Statement object to get the result set.
+ */
+ public static void main(String[] args) throws SQLException {
+ Connection connection = getConnection();
+ if (connection == null) {
+ System.out.println("get connection defeat");
+ return;
+ }
+ Statement statement = connection.createStatement();
+ //Create storage group
+ try {
+ statement.execute("SET STORAGE GROUP TO root.demo");
+ }catch (IoTDBSQLException e){
+ System.out.println(e.getMessage());
+ }
+
+
+ //Show storage group
+ statement.execute("SHOW STORAGE GROUP");
+ outputResult(statement.getResultSet());
+
+ //Create time series
+ //Different data type has different encoding methods. Here use INT32 as an
example
+ try {
+ statement.execute("CREATE TIMESERIES root.demo.s0 WITH
DATATYPE=INT32,ENCODING=RLE;");
+ }catch (IoTDBSQLException e){
+ System.out.println(e.getMessage());
+ }
+ //Show time series
+ statement.execute("SHOW TIMESERIES root.demo");
+ outputResult(statement.getResultSet());
+ //Show devices
+ statement.execute("SHOW DEVICES");
+ outputResult(statement.getResultSet());
+ //Count time series
+ statement.execute("COUNT TIMESERIES root");
+ outputResult(statement.getResultSet());
+ //Count nodes at the given level
+ statement.execute("COUNT NODES root LEVEL=3");
+ outputResult(statement.getResultSet());
+ //Count timeseries group by each node at the given level
+ statement.execute("COUNT TIMESERIES root GROUP BY LEVEL=3");
+ outputResult(statement.getResultSet());
+
+
+ //Execute insert statements in batch
+ statement.addBatch("insert into root.demo(timestamp,s0) values(1,1);");
+ statement.addBatch("insert into root.demo(timestamp,s0) values(1,1);");
+ statement.addBatch("insert into root.demo(timestamp,s0) values(2,15);");
+ statement.addBatch("insert into root.demo(timestamp,s0) values(2,17);");
+ statement.addBatch("insert into root.demo(timestamp,s0) values(4,12);");
+ statement.executeBatch();
+ statement.clearBatch();
+
+ //Full query statement
+ String sql = "select * from root.demo";
+ ResultSet resultSet = statement.executeQuery(sql);
+ System.out.println("sql: " + sql);
+ outputResult(resultSet);
+
+ //Exact query statement
+ sql = "select s0 from root.demo where time = 4;";
+ resultSet= statement.executeQuery(sql);
+ System.out.println("sql: " + sql);
+ outputResult(resultSet);
+
+ //Time range query
+ sql = "select s0 from root.demo where time >= 2 and time < 5;";
+ resultSet = statement.executeQuery(sql);
+ System.out.println("sql: " + sql);
+ outputResult(resultSet);
+
+ //Aggregate query
+ sql = "select count(s0) from root.demo;";
+ resultSet = statement.executeQuery(sql);
+ System.out.println("sql: " + sql);
+ outputResult(resultSet);
+
+ //Delete time series
+ statement.execute("delete timeseries root.demo.s0");
+
+ //close connection
+ statement.close();
+ connection.close();
+ }
+
+ public static Connection getConnection() {
+ // JDBC driver name and database URL
+ String driver = "org.apache.iotdb.jdbc.IoTDBDriver";
+ String url = "jdbc:iotdb://127.0.0.1:6667/";
+
+ // Database credentials
+ String username = "root";
+ String password = "root";
+
+ Connection connection = null;
+ try {
+ Class.forName(driver);
+ connection = DriverManager.getConnection(url, username, password);
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return connection;
+ }
+
+ /**
+ * This is an example of outputting the results in the ResultSet
+ */
+ private static void outputResult(ResultSet resultSet) throws SQLException {
+ if (resultSet != null) {
+ System.out.println("--------------------------");
+ final ResultSetMetaData metaData = resultSet.getMetaData();
+ final int columnCount = metaData.getColumnCount();
+ for (int i = 0; i < columnCount; i++) {
+ System.out.print(metaData.getColumnLabel(i + 1) + " ");
+ }
+ System.out.println();
+ while (resultSet.next()) {
+ for (int i = 1; ; i++) {
+ System.out.print(resultSet.getString(i));
+ if (i < columnCount) {
+ System.out.print(", ");
+ } else {
+ System.out.println();
+ break;
+ }
+ }
+ }
+ System.out.println("--------------------------\n");
+ }
+ }
+}
+```
+
+## 状态码
在最新版本中引入了**状态码**这一概念。例如，因为IoTDB需要在写入数据之前首先注册时间序列，一种可能的解决方案是：
