# kingbase.com

**Repository Path**: general252/kingbase.com

## Basic Information

- **Project Name**: kingbase.com
- **Description**: 人大金仓数据库
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-09-26
- **Last Updated**: 2024-09-26

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README


### 人大金仓数据库 [kingbase](https://www.kingbase.com.cn)

```
package main

import (
	"database/sql"
	"fmt"
	"log"

	_ "gitee.com/general252/kingbase.com/gokb"
)

const (
	host     = "192.168.88.88"
	port     = 54321
	user     = "system"
	password = "123456"
	dbname   = "test"
)

func main() {
	connInfo := fmt.Sprintf("host=%s port=%d user=%s "+
		"password=%s dbname=%s sslmode=disable",
		host, port, user, password, dbname)

	db, err := sql.Open("kingbase", connInfo)
	if err != nil {
		panic(err)
	}

	if err = db.Ping(); err != nil {
		panic(err)
	}

	fmt.Println("Connection test success!")

	rows, err := db.Query("SELECT tablename FROM pg_tables WHERE schemaname = 'public'")
	if err != nil {
		log.Println(err)
		return
	}
	defer rows.Close()

	for rows.Next() {
		var tableName string
		if err = rows.Scan(&tableName); err != nil {
			log.Println(err)
		} else {
			log.Println(tableName)
		}
	}

	_ = db.Close()
}

```