module1.bas

VB+SQL写的图书管理系统,用了ACTIVESKIN界面,请自行下载该控件

Attribute VB_Name = "Module1"
Option Explicit
Public book_num As String  '记录图书的总量
Public username As String  '记录登录时的用户名，以便修改密码
Public ConnStr
Public conn As New ADODB.Connection



Sub main()
Dim SqlDatabaseName As String: SqlDatabaseName = "master"
Dim SqlUsername As String: SqlUsername = "sa"
Dim SqlPassword As String: SqlPassword = "djhaoren"
Dim SqlLocalName As String: SqlLocalName = "(local)"
Dim SqlNowString As String: SqlNowString = "GetDate()"

Dim sql As String
ConnStr = "Provider=SQLOLEDB.1;Persist Security InFso=true;Data Source='(local)';Initial Catalog='book';User ID='book';Password='book';CONNect Timeout=30"
conn.Open ConnStr
frmLogin.Show
End Sub