golang 远程连接mssql 2000
来源:互联网 发布:手机淘宝怎么买电影票 编辑:程序博客网 时间:2024/06/07 14:15
package mainimport ("database/sql""flag""fmt""log")import (_ "github.com/mattn/go-adodb")var (local boolremoteIP stringremoteDS string)func init() {flag.BoolVar(&local, "local", true, "set window connect.")flag.StringVar(&remoteIP, "remoteIP", "192.168.1.104", "set up remote mssql of ip.")flag.StringVar(&remoteDS, "remoteDS", "MSSQLSERVER", "set up remote mssql of datasource.")}type Mssql struct {*sql.DBdataSource stringdatabase stringwindows boolsa *SA}type SA struct {user stringpasswd stringport int}func NewMssql() *Mssql {mssql := new(Mssql)dataS := "localhost"if !local {dataS = fmt.Sprintf("%s\\%s", remoteIP, remoteDS)}mssql = &Mssql{// 如果数据库是默认实例(MSSQLSERVER)则直接使用IP,命名实例需要指明。// dataSource: "192.168.1.104\\MSSQLSERVER",dataSource: dataS,database: "iman",// windows: true 为windows身份验证,false 必须设置sa账号和密码windows: local,sa: &SA{user: "sa",passwd: "123456",port: 1433,},}return mssql}func (m *Mssql) Open() error {config := fmt.Sprintf("Provider=SQLOLEDB;Initial Catalog=%s;Data Source=%s",m.database, m.dataSource)if m.windows {config = fmt.Sprintf("%s;Integrated Security=SSPI", config)} else {// sql 2000的端口写法和sql 2005以上的有所不同,在Data Source 后以逗号隔开。config = fmt.Sprintf("%s,%d;user id=%s;password=%s",config, m.sa.port, m.sa.user, m.sa.passwd)}var err errorm.DB, err = sql.Open("adodb", config)fmt.Println(config)return err}func (m *Mssql) Select() {rows, err := m.Query("select id, name from users")if err != nil {fmt.Printf("select query err: %s\n", err)}for rows.Next() {var id, name stringrows.Scan(&id, &name)fmt.Printf("id = %s, name = %s\n", id, name)}}func main() {flag.Parse()mssql := NewMssql()err := mssql.Open()checkError(err)mssql.Select()}func checkError(err error) {if err != nil {log.Fatal(err)}}
0 0
- golang 远程连接mssql 2000
- golang 远程连接mssql sql server
- MSSQL远程连接
- centos6.4下用golang连接mssql
- windows下用golang连接mssql
- MFC ado远程连接MSSQL
- 连接远程MSSQL服务器的怪事
- lnmpa配置远程连接mssql的教程
- golang 本地连接mssql sql server
- OFBiz 9.04连接MSSQL 2000异常
- Asp.net连接MSSQL 2000过程笔记
- MSSQL远程维护教程!
- 远程备份 MSSQL SERVER
- golang 远程传输文件
- golang 远程传输文件
- golang远程执行命令
- ThinkPHP 连接MSSQL PHP连接MSSQL
- jdbc连接mssql
- 使用scrapy-redis构建简单的分布式爬虫
- Majority Element
- Windows 消息机制浅析
- 最快的了解安卓中常用的设计模式
- Leetcode 157,158, Read N Characters Given Read4
- golang 远程连接mssql 2000
- Android-常用UI控件(Spinner/AutoCompleteTextView)
- Openstack组建部署 — Environment of Controller Node
- centOS升级python2.6至2.7
- Linux 下挂载硬盘方法
- Contains Duplicate
- 【树莓派2B折腾日志】无法获得锁 /var/lib/dpkg/lock - open (11: 资源临时不可用)
- Java练习:条件表达式语句
- Intersection of Two Arrays II