返回一个表示指定 int 值的 Integer 实例。 如果不需要新的 Integer 实例,则通常应优先使用此方法而不是构造函数 Integer(int),因为此方法可能会通过缓存频繁请求的值来显着提高空间和时间性能。 此方法将始终缓存 -128 到 127(含)范围内的值,并且可能缓存此范围之外的其他值。
操作Access数据库的一些常用方法,代码如下Imports SystemImports Class DBPrivate Shared com As Shared reader As Shared adapter As Shared conn As 获取数据库连接 Public Shared ReadOnly Property NewConn() As oleDbConnectionGetDim connectionString As StringconnectionString = (Supermarket)连接2010数据库connectionString = Provider=.12.0;Data Source=F:\连接03-07数据库connectionString = Provider=.4.0;Data Source=F:\JL\应该在这里先判断conn是否为NothingIf conn Is Nothing Thenconn = New (connectionString)End IfIf <> ()End IfReturn connEnd GetEnd Property 执行增删改(无参) 执行的Sql语句 Public Shared Function executeNonQuery(ByVal sql As String) As Integercom = New (sql, NewConn())Return ()End Function 执行增删改(有参) Public Shared Function ExecuteNonQuery(ByVal sql As String, ByVal para As OleDbParameter()) As Integercom = New (sql, NewConn)(para)Return ()End Function 执行增删改的存储过程 Public Shared Function ExecuteNonQuery(ByVal para As SqlParameter(), ByVal ProcedureName As String) As IntegerDim cmd As = New () = NewConn() = = (para)Return Function 执行查询(返回一个结果集,无参) Public Shared Function GetScalar(ByVal sql As String) As StringDim> Public Shared Function GetScalar(ByVal sql As String, ByVal para As SqlParameter()) As Integercom = New (sql, NewConn)(para)Return 32(())End Function 执行查询(返回一行数据,无参) Public Shared Function GetReader(ByVal sql As String) As OleDbDataReadercom = New (sql, NewConn)reader = ()Return readerEnd Function 执行查询(返回一行数据,有参) Public Shared Function GetReader(ByVal sql As String, ByVal para As SqlParameter()) As OleDbDataReadercom = New (sql, NewConn)(para)reader = ()Return readerEnd Function 执行查询(返回一个数据集,无参) Public Shared Function GetDataSet(ByVal sql As String) As> Public Shared Function GetDataSet(ByVal sql As String, ByVal para As SqlParameter()) As DataTableDim dataset As DataSetdataset = New DataSet()com = New OleDbCommand(sql, NewConn)(para)adapter = New OleDbDataAdapter(com)(dataset)Return (0)End FunctionEnd Class
vb6 鼠标的使用
以下是文本框text1的代码:Dim Bj As IntegerPrivate Sub Text1_Click()If Bj = 1 Then Exit SubMsgBox 现在文本框接收单击事件。End SubPrivate Sub Text1_DblClick()Bj = 0End SubPrivate Sub Text1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)If Button = 2 Then Bj = 1End Sub
T=1^2+2^2+3^2...100^2应如何编程
T=0for (i=1,i<101,i++) {T+=i*i }
发表评论