循环执行sql语句
(conn *sql.DB)
| 48 | |
| 49 | // 循环执行sql语句 |
| 50 | func loopOracleCMD(conn *sql.DB) { |
| 51 | Info("执行Oracle SQL命令") |
| 52 | reader := bufio.NewReader(os.Stdin) |
| 53 | for { |
| 54 | fmt.Printf("%s:%s> ", Rhost, Rport) |
| 55 | cmd, _ := reader.ReadString('\n') |
| 56 | cmd = strings.TrimRight(cmd, "\r\n") |
| 57 | if cmd == "exit" || cmd == "q" || cmd == "quit" { |
| 58 | break |
| 59 | } |
| 60 | resultSet, err := OracleCMD(cmd, conn) |
| 61 | for _, m := range resultSet { |
| 62 | for _, value := range m { |
| 63 | fmt.Println(value) |
| 64 | } |
| 65 | } |
| 66 | |
| 67 | if err != nil { |
| 68 | Info("循环执行sql语句报错") |
| 69 | } |
| 70 | } |
| 71 | } |