PowerShell : 连接字符串生成SQL语句

---

目的: 通过DB output 的数据, 自动生成 Insert SQL 语句

１、代码示例：

################################################################################################
# 标题: PowerShell : 连接字符串生成SQL语句
# 目的: 通过DB output 的数据, 自动生成 Insert SQL 语句 
# 1.按行读取文件，直到最后一行 
# 2.拼接字符串 
# 3.出力文件 
################################################################################################
# SQL插入语句模板
$sqlFormat = "INSERT INTO department(dno, dname, loc) VALUES("
# 入出力文件
$InputDate = "C:\wang\PowerShell\file\test\input.txt"
$OutputDate = "C:\wang\PowerShell\file\test\output.txt"
# 取得文件
$sku = Get-Content  $InputDate
# 按行读取文件
foreach  ( $skuLine  in  $sku ) {
     $newLine = -Join($sqlFormat, $skuLine, ");")
     # $newLine  =  $skuLine.Insert( $skuLine.Length, ");" )
     $newLine  >> $OutputDate
}

---

２、入力文件示 例：

'10', 'ENGINEERING', 'New York'
'11', 'ENGINEERING', 'New York'
'12', 'ENGINEERING', 'New York'
'13', 'ENGINEERING', 'New York'
'14', 'ENGINEERING', 'New York'
'15', 'ENGINEERING', 'New York'

---

３、出力文件示例：

INSERT INTO department(dno, dname, loc) VALUES('10', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('11', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('12', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('13', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('14', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('15', 'ENGINEERING', 'New York');

---