首页 > 编程开发 > Go语言

Go语言实现逐行读取和写入文件详解

来自：网络
时间：2024-03-30
阅读：

前言

前面一篇博客讲到nodejs使用readline逐行读取和写入文件今天使用go语言实现从输入文件中读取每行数据，然后将每行字段组合成SQL插入脚本，然后逐行写入另外一个空白文件中。

tb_param表的结构

tb_param表的结构如下：

Go语言实现逐行读取和写入文件详解

Go语言实现逐行读取和写入文件详解

创建表的SQL脚本如下，我使用的是Sqlite数据库

 DROP TABLE IF EXISTS "main"."tb_param";
CREATE TABLE tb_param(protocol INT NOT NULL,slave INT NOT NULL,number INT NOT NULL,ptype INT NOT NULL,pid INT NOT NULL,name TEXT NOT NULL,format TEXT,PRIMARY KEY(protocol,slave,number,ptype,pid));

前面使用nodejs实现从input.txt文件逐行读取数据，然后将每行数据拼接成如下的数据格式：

INSERT INTO tb_param (protocol, slave, number, ptype, pid, name, format) 
VALUES (2, 6, 0, 1, 1, 'a34004', .0);

输入文件 input.txt示例如下：

2    24    0    1    1    a04005    .3
2    24    0    1    2    a04006    .3
2    24    0    1    3    a04007    .3
2    16    0    1    1    a99501    .3
2    16    0    1    2    a99502    .3
2    16    0    1    3    a99500    .3
2    16    0    1    4    a99505    .3
2    16    0    1    5    a99504    .3
2    16    0    1    6    a99503    .3
2    22    0    1    23    a24901    .3
2    22    0    1    27    a24904    .3
2    22    0    1    28    a24905    .3
2    22    0    1    29    a24042    .3
2    22    0    1    36    a25002    .3
2    22    0    1    33    a24036    .3
2    22    0    1    32    a24908    .3
2    22    0    1    34    a24909    .3
2    22    0    1    35    a24910    .3
2    22    0    1    37    a24012    .3
2    22    0    1    38    a24043    .3
2    22    0    1    39    a24084    .3
2    22    0    1    40    a24911    .3
2    22    0    1    43    a25003    .3
2    22    0    1    41    a24912    .3
2    22    0    1    42    a24913    .3
2    22    0    1    44    a24070    .3
2    22    0    1    45    a25004    .3
2    22    0    1    47    a25008    .3
2    22    0    1    49    a25038    .3
2    22    0    1    48    a25006    .3
2    22    0    1    46    a24044    .3
2    22    0    1    50    a25034    .3
2    22    0    1    51    a25033    .3
2    22    0    1    52    a25902    .3
2    22    0    1    53    a25014    .3
2    22    0    1    55    a25021    .3
2    22    0    1    56    a25901    .3
2    22    0    1    57    a25019    .3
2    22    0    1    54    a24068    .3
2    22    0    1    58    a25020    .3
2    22    0    1    59    a25903    .3
2    22    0    1    60    a25904    .3
2    22    0    1    61    a24914    .3
2    22    0    1    62    a24915    .3
2    22    0    1    1    a24001    .3
2    22    0    1    2    a24045    .3
2    22    0    1    3    a24002    .3
2    22    0    1    4    a24053    .3
2    22    0    1    5    a24038    .3
2    22    0    1    6    a24037    .3
2    22    0    1    7    a24079    .3
2    22    0    1    8    a24064    .3
2    22    0    1    11    a24063    .3
2    22    0    1    12    a24902    .3
2    22    0    1    13    a24041    .3
2    22    0    1    14    a24039    .3
2    22    0    1    20    a24077    .3
2    22    0    1    18    a24074    .3
2    22    0    1    22    a24076    .3
2    22    0    1    31    a24907    .3
2    22    0    1    24    a24903    .3
2    22    0    1    25    a24011    .3
2    22    0    1    21    a24061    .3
2    22    0    1    30    a24906    .3
2    22    0    1    104    a31005    .3
2    22    0    1    206    a24072    .3
2    22    0    1    221    a05009    .3
2    22    0    1    65    a05014    .3
2    22    0    1    66    a24099    .3
2    22    0    1    67    a24046    .3
2    22    0    1    15    a24078    .3
2    22    0    1    68    a24008    .3
2    22    0    1    69    a24015    .3
2    22    0    1    70    a24916    .3
2    22    0    1    96    a31004    .3
2    22    0    1    97    a31003    .3
2    22    0    1    72    a24047    .3
2    22    0    1    71    a05013    .3
2    22    0    1    98    a31024    .3
2    22    0    1    73    a24100    .3
2    22    0    1    74    a24003    .3
2    22    0    1    101    a28006    .3
2    22    0    1    75    a24016    .3
2    22    0    1    76    a24111    .3
2    22    0    1    77    a24004    .3
2    22    0    1    78    a24018    .3
2    22    0    1    79    a24005    .3
2    22    0    1    80    a24017    .3
2    22    0    1    81    a24049    .3
2    22    0    1    82    a24027    .3
2    22    0    1    83    a24007    .3
2    22    0    1    85    a24112    .3
2    22    0    1    84    a24054    .3
2    22    0    1    86    a24019    .3
2    22    0    1    87    a24050    .3
2    22    0    1    88    a24034    .3
2    22    0    1    89    a25010    .3
2    22    0    1    90    a24009    .3
2    22    0    1    91    a24020    .3
2    22    0    1    92    a25012    .3
2    22    0    1    95    a25011    .3
2    22    0    1    215    a30008    .3
2    22    0    1    219    a99051    .3
2    22    0    1    201    a29026    .3
2    22    0    1    208    a29017    .3
2    22    0    1    106    a31025    .3
2    22    0    1    209    a24110    .3
2    22    0    1    203    a25072    .3
2    22    0    1    222    a29015    .3
2    22    0    1    202    a31030    .3
2    22    0    1    211    a31027    .3
2    22    0    1    207    a24006    .3
2    22    0    1    93    a25013    .3
2    22    0    1    94    a25068    .3
2    22    0    1    204    a25015    .3
2    22    0    1    223    a24113    .3
2    22    0    1    224    a25059    .3
2    22    0    1    9    a24919    .3
2    22    0    1    213    a30003    .3
2    17    0    1    1    a99070    .0
2    17    0    1    2    a99071    .0
2    17    0    1    3    a99072    .0
2    17    0    1    4    a99073    .0
2    17    0    1    5    a99074    .0
2    17    0    1    6    a99075    .0
2    17    0    1    7    a99076    .0
2    17    0    1    8    a99077    .0
2    17    0    1    9    a99078    .0
2    17    0    1    10    a99079    .0
2    17    0    1    11    a99080    .0
2    17    0    1    12    a99081    .0
2    17    0    1    13    a99082    .0
2    17    0    1    14    a99083    .0
2    17    0    1    15    a99084    .0
2    17    0    1    16    a99085    .0
2    17    0    1    17    a99086    .0
2    17    0    1    18    a99087    .0
2    17    0    1    19    a99088    .0
2    17    0    1    20    a99089    .0
2    17    0    1    21    a99090    .0
2    17    0    1    22    a99091    .0
2    17    0    1    23    a99092    .0
2    17    0    1    24    a99093    .0
2    17    0    1    25    a99094    .0
2    17    0    1    26    a99095    .0
2    17    0    1    27    a99096    .0
2    17    0    1    28    a99097    .0
2    17    0    1    29    a99098    .0
2    17    0    1    30    a99099    .0
2    17    0    1    31    a99100    .0
2    17    0    1    32    a99101    .0
2    17    0    1    35    a99102    .1
2    17    0    1    36    a99103    .1
2    17    0    1    37    a99104    .1

Go语言实现代码

readFile.go 代码如下：

package main

import (
	"fmt"
	"os"
	"bufio"
	"strconv"
	"strings"
)

func main() {
	// open the file filepath
	fRead, err := os.Open("./input.txt")
	if err != nil {
		fmt.Println("failed open the file input.txt")
		panic(err)
	}
	defer fRead.Close()

	// 创建输出文件 output.txt 用于存放输出结果
	strDestFileName := "./output.txt"
	fWrite, err2 := os.Create(strDestFileName)
	if err2 != nil {
		fmt.Println(err.Error())
		panic(err2)
	}
	defer fWrite.Close()

	// create a scanner
	fs := bufio.NewScanner(fRead)

	// scan file
	// https://golang.org/pkg/bufio/#Scanner.Scan
	for fs.Scan() {
		strLine := fs.Text()
		// do anything with strLine
		fmt.Println(strLine)
		strLineSplit := strings.Split(strLine, "\t")
		strProtocol := strLineSplit[0]
		strSlave := strLineSplit[1]
		strNumber := strLineSplit[2]
		strPtype := strLineSplit[3]
		strPid := strLineSplit[4]
		strName := strLineSplit[5]
		strFormat := strLineSplit[6]

		iProtocol, err3 := strconv.Atoi(strProtocol)
		if err3 != nil {
			fmt.Println("转换strProtocol从string到int失败")
			panic(err3)
		}

		iSlave, err4 := strconv.Atoi(strSlave)
		if err4 != nil {
			fmt.Println("转换strSlave从string到int失败")
			panic(err4)
		}

		iNumber, err5 := strconv.Atoi(strNumber)
		if err5 != nil {
			fmt.Println("转换strNumber从string到int失败")
			panic(err5)
		}

		iPtype, err6 := strconv.Atoi(strPtype)
		if err6 != nil {
			fmt.Println("转换strPtype从string到int失败")
			panic(err6)
		}

		iPid, err7 := strconv.Atoi(strPid)
		if err7 != nil {
			fmt.Println("转换strPid从string到int失败")
			panic(err7)
		}

		// 根据读取到的每行数据，按照指定格式拼接成SQL插入脚本，按\n换行符进行分割
		strResult := fmt.Sprintf("INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)\n " +
			" VALUES(%d, %d, %d, %d, %d, '%v', '%v')\n", iProtocol, iSlave, iNumber, iPtype, iPid, strName, strFormat)
		// 将格式化处理的每行数据写入到文件output.txt中
		fWrite.WriteString(strResult)
		// fmt.Fprintf(fWrite, strResult)
	}
}

运行上述代码并获得输出

go run readFile.go

得到输出文件output.txt如下所示：

INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 24, 0, 1, 1, 'a04005', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 24, 0, 1, 2, 'a04006', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 24, 0, 1, 3, 'a04007', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 1, 'a99501', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 2, 'a99502', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 3, 'a99500', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 4, 'a99505', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 5, 'a99504', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 16, 0, 1, 6, 'a99503', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 23, 'a24901', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 27, 'a24904', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 28, 'a24905', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 29, 'a24042', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 36, 'a25002', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 33, 'a24036', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 32, 'a24908', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 34, 'a24909', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 35, 'a24910', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 37, 'a24012', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 38, 'a24043', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 39, 'a24084', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 40, 'a24911', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 43, 'a25003', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 41, 'a24912', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 42, 'a24913', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 44, 'a24070', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 45, 'a25004', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 47, 'a25008', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 49, 'a25038', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 48, 'a25006', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 46, 'a24044', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 50, 'a25034', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 51, 'a25033', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 52, 'a25902', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 53, 'a25014', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 55, 'a25021', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 56, 'a25901', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 57, 'a25019', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 54, 'a24068', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 58, 'a25020', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 59, 'a25903', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 60, 'a25904', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 61, 'a24914', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 62, 'a24915', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 1, 'a24001', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 2, 'a24045', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 3, 'a24002', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 4, 'a24053', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 5, 'a24038', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 6, 'a24037', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 7, 'a24079', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 8, 'a24064', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 11, 'a24063', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 12, 'a24902', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 13, 'a24041', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 14, 'a24039', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 20, 'a24077', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 18, 'a24074', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 22, 'a24076', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 31, 'a24907', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 24, 'a24903', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 25, 'a24011', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 21, 'a24061', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 30, 'a24906', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 104, 'a31005', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 206, 'a24072', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 221, 'a05009', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 65, 'a05014', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 66, 'a24099', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 67, 'a24046', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 15, 'a24078', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 68, 'a24008', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 69, 'a24015', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 70, 'a24916', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 96, 'a31004', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 97, 'a31003', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 72, 'a24047', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 71, 'a05013', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 98, 'a31024', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 73, 'a24100', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 74, 'a24003', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 101, 'a28006', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 75, 'a24016', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 76, 'a24111', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 77, 'a24004', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 78, 'a24018', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 79, 'a24005', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 80, 'a24017', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 81, 'a24049', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 82, 'a24027', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 83, 'a24007', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 85, 'a24112', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 84, 'a24054', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 86, 'a24019', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 87, 'a24050', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 88, 'a24034', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 89, 'a25010', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 90, 'a24009', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 91, 'a24020', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 92, 'a25012', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 95, 'a25011', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 215, 'a30008', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 219, 'a99051', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 201, 'a29026', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 208, 'a29017', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 106, 'a31025', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 209, 'a24110', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 203, 'a25072', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 222, 'a29015', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 202, 'a31030', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 211, 'a31027', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 207, 'a24006', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 93, 'a25013', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 94, 'a25068', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 204, 'a25015', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 223, 'a24113', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 224, 'a25059', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 9, 'a24919', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 22, 0, 1, 213, 'a30003', '.3')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 1, 'a99070', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 2, 'a99071', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 3, 'a99072', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 4, 'a99073', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 5, 'a99074', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 6, 'a99075', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 7, 'a99076', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 8, 'a99077', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 9, 'a99078', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 10, 'a99079', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 11, 'a99080', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 12, 'a99081', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 13, 'a99082', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 14, 'a99083', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 15, 'a99084', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 16, 'a99085', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 17, 'a99086', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 18, 'a99087', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 19, 'a99088', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 20, 'a99089', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 21, 'a99090', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 22, 'a99091', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 23, 'a99092', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 24, 'a99093', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 25, 'a99094', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 26, 'a99095', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 27, 'a99096', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 28, 'a99097', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 29, 'a99098', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 30, 'a99099', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 31, 'a99100', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 32, 'a99101', '.0')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 35, 'a99102', '.1')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 36, 'a99103', '.1')
INSERT INTO tb_param(protocol, slave, number, ptype, pid, name, format)
  VALUES(2, 17, 0, 1, 37, 'a99104', '.1')

以上就是Go语言实现逐行读取和写入文件详解的详细内容，更多关于Go逐行读取写入文件的资料请关注其它相关文章！

最新文章 相关文章

从零封装Gin框架配置初始化全局变量

目录引言安装编写配置文件编写配置结构体全局变量使用 viper 载入配置初始化配置引言配置文件是每个项目必不可少的部分，用来保存应用基本数据、数据库配置等信息，避免要修改

2024-03-30 11:27:07

Go语言Gin框架获取请求参数的两种方式

目录引言传递参数的方式HeaderURLHTTP Body直接获取请求参数获取URL Path中的参数获取URL Query中的参数获取HTTP Body中的参数绑定请求参数绑定Header参数绑定URL Path参数

2024-03-30 11:27:05

go mod 依赖管理的具体使用

目录go mod 介绍mod 相关环境变量如何使用 go modgo.mod 文件go mod 命令go.mod 文件go get 升级go.sum不同模式的命令区别1. gopath模式2. go vendor模式2. go module模式

2024-03-30 11:27:03

Go语言实现对称加密和非对称加密的示例代码

目录1、对称加密1.1 AES1.2 DES1.3 3DES2、非对称加密算法RSA2.1 生成密钥对2.2 RSA加密解密过程2.3 数字签名验证对称加密和非对称加密的区别主要有以下几个方面：1、密钥的

2024-03-30 11:27:01

go grpc高级用法

目录错误处理常规用法进阶用法原理多路复用元数据负载均衡压缩数据错误处理gRPC 一般不在 message 中定义错误。毕竟每个 gRPC 服务本身就带一个 error 的返回值，这是用来传

2024-03-30 11:26:59

Go语言断言和类型查询的实现

目录1、类型断言2、类型查询1、类型断言类型断言(Type Assertion)是一个使用在接口值上的操作，用于检查接口类型变量所持有的值是否实现了期望的接口或者具体的类型。在Go语

2024-03-30 11:26:57

Go Gin框架优雅重启和停止实现方法示例

目录什么是优雅重启和停止Go gin的优雅重启和停止使用系统信号进行优雅重启使用HTTP请求进行优雅停止优雅地处理超时总结什么是优雅重启和停止优雅地重启或停止一个Web服务

2024-03-30 11:26:55

从零封装Gin框架及项目初始化教程

目录引言适用人群目录结构初始化项目启动应用 & 测试结语引言我是一名 phper，由于各方面因素，决定转战 Go，PHP 基本都是用来开发 Web 项目的，所以这次就使用 Go 中最流行的 Web

2024-03-30 11:26:53

Go分布式链路追踪实战探索

目录什么是链路追踪？Tracing&Logging&Metrics三者关系Go链路追踪的实践链路追踪的示例链路追踪的深入理解总结什么是链路追踪？在现代复杂的分布式系统环境中，对应用或系统进行

2024-03-30 11:26:50

go通过编码缩短字符串的长度实现方法步骤

目录如何在Go中实现进制转换步骤1：将十进制字符串转换为十六进制字符串步骤2：### 十六进制到十进制的转换分析与实践结论如何在Go中实现进制转换在开发中，我们经常遇到需要处理

2024-03-30 11:26:48

分布式架构在Go语言网站的应用

目录构建分布式架构负载均衡缓存技术数据分片并发编程结论分布式架构是目前应对高流量、高并发的重要解决方案。分布式架构的核心思想是分而治之，将单台服务器的资源划分为多

2024-03-30 11:26:46

使用go语言将单反斜杠改为双反斜杠的方法

问题最近开发的时候遇到这么个问题，就是在window上获取了文件目录的字段，然后将这个绝对路径保存到数据库，最后前端需要请求的时候，就需要读取数据库存的文件目录路径给前端，前端

2024-03-30 11:26:44

深入理解Golang中的dig包管理和解决依赖关系

目录1. 引言2. dig库的介绍2.1 结构体2.2 基本工作流程3. 如何使用dig包3.1 安装dig包3.2 创建容器3.3 注册依赖关系3.4 解析依赖关系4. 应用场景4.1 Web应用程序4.2 单元测

2024-03-30 11:26:43

Golang中errgroup的常见误用详解

目录多余的context嵌套Wait返回的时机SetLimit和死锁总结errgroup想必稍有经验的golang程序员都应该听说过，实际项目中用过的也应该不在少数。它和sync.WaitGroup类似，都可以

2024-03-30 11:26:41

Go语言实现逐行读取和写入文件详解

目录前言tb_param表的结构Go语言实现代码前言前面一篇博客讲到nodejs使用readline逐行读取和写入文件今天使用go语言实现从输入文件中读取每行数据，然后将每行字段组合成SQL

2024-03-30 11:26:38

Golang token的生成和解析详解

Golang token的生成和解析使用第三方库来实现go get github.com/dgrijalva/jwt-gogolang代码package mainimport ( "fmt" "time" "github.com/dgrijalva/jwt-go")func main(

2024-03-30 11:23:24

Go Build编译打包文件的完整步骤

目录1、简单打包2、打包时为程序中的变量设置值3、打包时指定名称总结1、简单打包程序 main1.go：package mainimport "fmt"func main() { fmt.Println("Hello World!")}打包：#

2024-03-30 11:23:22

Go高级特性之并发处理http详解

目录引言使用 Goroutines 的基本方法Goroutine 入门并发 HTTP 请求的方法WaitGroupChannelsWorker Pools使用信号量限制 Goroutines那么，最好的方法是什么错误处理集中误差通

2024-03-30 11:23:21

golang通过http访问外部网址的操作方法

目录 get方式访问外部的接口 Post方式请求外部接口不同项目之前,通过http访问,进行数据沟通先设定一个接口,确认外部能访问到PHP写一个接口public function ceshi_return(){

2024-03-30 11:23:19

go编译so库让python引用编译后没有.h文件的问题

有时python需要引用go的一些开源库，这时就需要go编译成python可调用的库go代码package main//包必须是mainimport( "C"//需要C库的支持，方便类型转换)func main(){}//非常重要

2024-03-30 11:23:16

深入解析Go语言中crypto/subtle加密库

目录引言crypto/subtle库概览ConstantTimeCompare函数深入解析ConstantTimeSelect函数应用详解ConstantTimeLessOrEq函数实践指南安全编程实践性能优化与最佳实践与其他加密

2024-03-30 11:23:15

go依赖注入库samber/do使用示例讲解

目录介绍代码结构结论介绍以简单和高效而闻名的Go语言在其1.18版本中引入了泛型，这可以显着减少大量代码生成的需要，使该语言更加强大和灵活。如果您有兴趣， Go 泛型教程 是很

2024-03-30 11:23:13

手把手教你如何在Goland中创建和运行项目

目录前言创建新项目编辑运行/调试配置编写并运行代码总结前言在Go语言的开发过程中，选择一个合适的集成开发环境（IDE）是提高效率和编写可维护代码的关键一步。JetBrains的Golan

2024-03-30 11:23:11

Go实现字符串与数字的高效转换

目录引言1. 基本的字符串转数字方法2. 生成非可逆的数字标识3. 性能优化技巧4. 应用场景分析结语引言在软件开发的世界里，数据类型转换是一项基础而重要的技能。尤其在Go语言

2024-03-30 11:23:08

Golang中crypto/cipher加密标准库全面指南

目录引言Golang 和加密简介crypto/cipher 库概览使用 crypto/cipher 实现加密高级功能和技巧最佳实践和性能优化总结引言在现代软件开发领域，安全性是一个不容忽视的重要议题

2024-03-30 11:23:07

Go 1.22对net/http包的路由增强功能详解

目录引言方法匹配（Method Matching）通配符（Wildcards）路径前缀匹配优先规则兼容性API 变更小结引言Go 1.22 版本对 net/http 包的路由功能进行了增强，引入了方法匹配（method match

2024-03-30 11:23:05

深入理解Go高级并发模式编写更高效可扩展的应用程序

目录引言1. 基础Goroutine2. Channel和Select3. 高级模式: 工作池(Worker Pool)结论引言"并发不是并行，但使并行成为可能。" —— Rob Pike本文将深入探讨Go中的一

2024-03-30 11:23:03

golang实现ping命令的完整代码

目录golang实现ping命令（附：完整代码）1 ping原理：ICMP协议（Type+Code+checksum+ID+sequence）常见ICMP类型2 实现2.1 定义ICMP结构体2.2 计算校验和2.3 命令行参数2.4 发送ICMP包效

2024-03-30 11:23:01

Golang使用gofumpt进行代码格式化

目录更强的格式化：gofumpt赋值运算符后无空行函数体周围无空行函数应分隔 ) { ，缩进有助于提高可读性代码块中的单独语句（或注释）周围没有空行简单错误检查前无空行复合字面量应

2024-03-30 11:22:58

Go语言中常用语法编写与优化技巧小结

目录1. 利用 sync.Pool 减少内存分配2. 使用缓冲通道进行异步操作3. 利用 pprof 进行性能分析4. 使用 strings.Builder 进行字符串拼接5. 利用 time.After 避免 goroutine

2024-03-30 11:22:57

热点内容

goland2020.2.x永久激活码破解详细教程亲测可用(Windows Linux Mac)
2020-11-25
解决Goland 提示 Unresolved reference 错误的问题
2020-12-15
golang gorm 计算字段和获取sum()值的实现
2020-12-19
golang判断net.Conn 是否已关闭的操作
2020-12-24
go日志系统logrus显示文件和行号的操作
2020-11-10
golang获取网卡信息操作
2020-12-24
Goland调节字体大小的设置(编辑区,terminal区,页面字体)
2020-12-21
GoAdminGroup/go-admin的安装和运行的教程详解
2020-09-29
golang gorm多条件筛选查询操作
2020-12-19
如何解决go语言输出中文乱码的问题
2020-12-29
返回顶部
顶部