Vb6 TCP Server服务端监听多个RFID读卡器客户端上传的刷卡数据

本文主要是介绍Vb6 TCP Server服务端监听多个RFID读卡器客户端上传的刷卡数据,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

本示例使用设备介绍:WIFI无线4G网络RFID云读卡器远程网络开关物流网阅读器TTS语音-淘宝网 (taobao.com) 

Option ExplicitConst BUSY As Boolean = False    '定义常量
Const FREE As Boolean = TrueDim ConnectState() As Boolean   '定义连接状态
Dim ServerSendbuf() As Byte     '数据发送缓冲Private Sub Check1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Check1.Value > 0 Then Frame1.Visible = True Else Frame1.Visible = False
End SubPrivate Sub Command1_Click()
initsock
End SubPrivate Sub Command10_Click()
Dim copstr As String
Dim i As Long
Clipboard.Clear
copstr = ""
For i = 0 To List2.ListCountcopstr = copstr & List2.List(i)copstr = copstr & vbCrLf
NextClipboard.SetText (copstr)
MsgBox "TCP通讯报文列表已拷贝!", vbInformation + vbOKOnly, "提示"
End SubPrivate Sub Command2_Click()
GetSendData 5
ButtonSend
End SubPrivate Sub Command3_Click()
Dim i As Integer
Dim sockid As Integer
Dim dispinf As StringOn Error Resume NextFor i = List1.ListCount - 1 To 0 Step -1   '要用倒序If List1.Selected(i) = True Thensockid = Val(Mid(List1.List(i), 1, 2))Sock(sockid).CloseConnectState(sockid) = FREEdispinf = Format(Now, "HH:MM:SS") & " 连接 " & sockid & " 已关闭"List2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1List1.RemoveItem iEnd If
Next
End SubPrivate Sub Command4_Click()
GetSendData 0
ButtonSend
End SubPrivate Sub Command5_Click()
GetSendData 1
ButtonSendEnd SubPrivate Sub Command6_Click()
GetSendData 2
ButtonSend
End SubPrivate Sub Command7_Click()
GetSendData 3
ButtonSend
End SubPrivate Sub Command8_Click()
GetSendData 4
ButtonSend
End SubPrivate Sub Command9_Click()
List2.Clear
End SubPrivate Sub Form_Load()
Dim i As IntegerFor i = 1 To 255Combo9.AddItem (Format(i, "0"))
Next
Combo9.ListIndex = 19
Combo2.ListIndex = 1
Combo3.ListIndex = 0
Combo8.ListIndex = 1Command1_Click
End SubPrivate Sub Listener_Close()
'MsgBox "close"
Dim dispinf As String
dispinf = Format(Now, "HH:MM:SS") & " 监听服务已关闭!"
List2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1
End SubPrivate Sub Listener_ConnectionRequest(ByVal requestID As Long)
Dim SockIndex As Integer
Dim SockNum As Integer
Dim dispinf As String
Dim onlines As StringOn Error Resume Nextdispinf = Format(Now, "HH:MM:SS") & " " & requestID & "连接请求"SockNum = UBound(ConnectState)   '查找连接的用户数
If SockNum > 100 Thendispinf = dispinf & SockIndex & " ,当前连接数>100,系统不接受新连接!"List2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1Exit Sub
End IfSockIndex = FindFreeSocket()   '查找空闲的sockIf SockIndex > SockNum Then    '如果已有的sock都忙,而且sock数不超过15个,动态添加sockLoad Sock(SockIndex)
End If
ConnectState(SockIndex) = BUSY
Sock(SockIndex).LocalPort = 0
Sock(SockIndex).Tag = SockIndex
Sock(SockIndex).Accept (requestID)  '接受请求onlines = Format(SockIndex, "00") & "|" & Format(requestID, "00000") & "|" & Listener.RemoteHostIP & ":" & Listener.RemotePort
dispinf = dispinf & SockIndex & "接受请求," & Listener.RemoteHostIP & ":" & Listener.RemotePortList1.AddItem (onlines)
List1.ListIndex = List1.ListCount - 1
List1.Selected(List1.ListCount - 1) = TrueList2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1
End SubPrivate Sub Listener_Error(ByVal Number As Integer, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, CancelDisplay As Boolean)
'MsgBox "err"
Dim dispinf As String
dispinf = Format(Now, "HH:MM:SS") & " 监听到异常错误!"
List2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1
End SubPrivate Sub Sock_Close(Index As Integer)
Dim dispinf As String
Dim i As IntegerIf Sock(Index).State <> sckClosed ThenSock(Index).Close
End If
ConnectState(Index) = FREEdispinf = Format(Now, "HH:MM:SS") & " 连接 " & Index & " 已关闭"
List2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1For i = 0 To List1.ListCount - 1If Val(Mid(List1.List(i), 1, 2)) = Index ThenList1.RemoveItem iExit ForEnd If
Next
End SubPrivate Sub Sock_DataArrival(Index As Integer, ByVal bytesTotal As Long)
Dim dx As String
Dim dispinf As String
Dim dispstr As String
Dim i As Integer
Dim TcpData() As Byte
Dim IPort As String
Dim doublecardhao  As Double
Dim card10str As StringSock(Index).GetData TcpData
IPort = Sock(Index).RemoteHostIP & ":" & Sock(Index).RemotePortFor i = 0 To bytesTotal - 1dispstr = dispstr + Right("00" + Hex(TcpData(i)), 2) + " "
Next
dispinf = Format(Now, "HH:MM:SS") & " FromIP " & IPort & " :" & dispstr
List2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1Select Case TcpData(0)Case &HC1, &HCFIf TcpData(0) = &HC1 Thendispstr = "数据解析:接收到IC卡刷卡数据,读卡器IP["Elsedispstr = "数据解析:接收到IC卡离开读卡器,读卡器IP["End Ifdispstr = dispstr + Trim(Str(TcpData(1))) + "." + Trim(Str(TcpData(2))) + "." + Trim(Str(TcpData(3))) + "." + Trim(Str(TcpData(4)))dispstr = dispstr + "],机号["'机号dispstr = dispstr + Format(Str$(CLng(TcpData(5)) + CLng(TcpData(6)) * 256), "00000")dispstr = dispstr + "],数据包序号["'数据包序号,每个包都不一样,按递增1变化dispstr = dispstr + Format(Str$(CLng(TcpData(7)) + CLng(TcpData(8)) * 256), "00000")dispstr = dispstr + "],卡号长度[" + Trim(Str(TcpData(9)))dispstr = dispstr + "],16进制卡号["For i = 10 To 9 + TcpData(9)dispstr = dispstr + Right("00" + Hex(TcpData(i)), 2)Nextdoublecardhao = TcpData(13)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(12)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(11)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(10)card10str = Right("0000000000" + CStr(doublecardhao), 10)dispstr = dispstr + "],转10进制卡号[" + card10strdispstr = dispstr + "],唯一硬件序号["For i = 10 + TcpData(9) To bytesTotal - 1dispstr = dispstr + Right("00" + Hex(TcpData(i)), 2)Nextdispstr = dispstr + "]"List2.AddItem (dispstr)List2.AddItem ("")List2.ListIndex = List2.ListCount - 1If Check1.Value > 0 Then Response Index, IPortCase &HD1, &HDFIf TcpData(0) = &HD1 Thendispstr = "数据解析:接收到ID卡刷卡数据,读卡器IP["Elsedispstr = "数据解析:接收到ID卡离开读卡器,读卡器IP["End Ifdispstr = dispstr + Trim(Str(TcpData(1))) + "." + Trim(Str(TcpData(2))) + "." + Trim(Str(TcpData(3))) + "." + Trim(Str(TcpData(4)))dispstr = dispstr + "],机号["'机号dispstr = dispstr + Format(Str$(CLng(TcpData(5)) + CLng(TcpData(6)) * 256), "00000")dispstr = dispstr + "],数据包序号["'数据包序号,每个包都不一样,按递增1变化dispstr = dispstr + Format(Str$(CLng(TcpData(7)) + CLng(TcpData(8)) * 256), "00000")doublecardhao = TcpData(12)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(11)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(10)doublecardhao = doublecardhao * 256doublecardhao = doublecardhao + TcpData(9)card10str = Right("0000000000" + CStr(doublecardhao), 10)dispstr = dispstr + "],16进制卡号["dispstr = dispstr + Right("00" + Hex(TcpData(9)), 2) + Right("00" + Hex(TcpData(10)), 2) + Right("00" + Hex(TcpData(11)), 2) + Right("00" + Hex(TcpData(12)), 2) + Right("00" + Hex(TcpData(13)), 2) + "],转10进制卡号[" + card10strdispstr = dispstr + "],唯一硬件序号["For i = 14 To bytesTotal - 1dispstr = dispstr + Right("00" + Hex(TcpData(i)), 2)Nextdispstr = dispstr + "]"List2.AddItem (dispstr)List2.AddItem ("")List2.ListIndex = List2.ListCount - 1If Check1.Value > 0 Then Response Index, IPortCase &HF3dispstr = "数据解析:接收到读卡器心跳包,读卡器IP["dispstr = dispstr + Trim(Str(TcpData(1))) + "." + Trim(Str(TcpData(2))) + "." + Trim(Str(TcpData(3))) + "." + Trim(Str(TcpData(4)))dispstr = dispstr + "],机号["'机号dispstr = dispstr + Format(Str$(CLng(TcpData(5)) + CLng(TcpData(6)) * 256), "00000")dispstr = dispstr + "],数据包序号["'数据包序号,每个包都不一样,按递增1变化dispstr = dispstr + Format(Str$(CLng(TcpData(7)) + CLng(TcpData(8)) * 256), "00000") + "],"dispstr = dispstr + "心跳包类型[" + Right("00" + Hex(TcpData(9)), 2) + "],"dispstr = dispstr + "长度[" + Right("00" + Hex(TcpData(10)), 2) + "],"dispstr = dispstr + "继电器状态[" + Right("00" + Hex(TcpData(11)), 2) + "],"dispstr = dispstr + "外部输入状态[" + Right("00" + Hex(TcpData(12)), 2) + "],"dispstr = dispstr + "随机动态码[" + Right("00" + Hex(TcpData(13)), 2) + Right("00" + Hex(TcpData(14)), 2) + Right("00" + Hex(TcpData(15)), 2) + Right("00" + Hex(TcpData(16)), 2) + "],"dispstr = dispstr + "唯一硬件序号["For i = 17 To bytesTotal - 1dispstr = dispstr + Right("00" + Hex(TcpData(i)), 2)Nextdispstr = dispstr + "]"List2.AddItem (dispstr)List2.AddItem ("")List2.ListIndex = List2.ListCount - 1
End Select
End SubPublic Function FindFreeSocket()   '寻找空闲的sock
Dim SockCount, i As Integer
SockCount = UBound(ConnectState)
For i = 0 To SockCountIf ConnectState(i) = FREE ThenFindFreeSocket = iExit FunctionEnd If
Next iReDim Preserve ConnectState(0 To SockCount + 1)
FindFreeSocket = UBound(ConnectState)
End FunctionPrivate Sub initsock()
Dim dispinf As String
ReDim Preserve ConnectState(0 To 1)
On Error GoTo err1ConnectState(0) = FREE
ConnectState(1) = FREEIf Listener.State = sckClosed ThenListener.LocalPort = CLng(Text1.Text)    '指定网络端口号Listener.Listen                          '开始侦听dispinf = Format(Now, "HH:MM:SS") & " 已创建监听服务!可以接收客户端的连接请求。"List2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1Command1.Caption = "关闭监听服务"
ElseListener.Closedispinf = Format(Now, "HH:MM:SS") & " 已关闭监听服务!不再接受新的客户端连接请求,已连接的客户端还可以通讯。"List2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1Command1.Caption = "创建监听服务"
End IfExit Suberr1:dispinf = Format(Now, "HH:MM:SS") & " 开启监听服务时出现错误:" & Err.Number & Err.DescriptionList2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1
End SubPrivate Sub Sock_Error(Index As Integer, ByVal Number As Integer, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, CancelDisplay As Boolean)
Dim dispinf As String
Dim i As IntegerIf Sock(Index).State <> sckClosed ThenSock(Index).Close
End If
ConnectState(Index) = FREEdispinf = Format(Now, "HH:MM:SS") & " 连接 " & Index & " 错误提示:" & Description
List2.AddItem (dispinf)
List2.ListIndex = List2.ListCount - 1For i = 0 To List1.ListCount - 1If Val(Mid(List1.List(i), 1, 2)) = Index ThenList1.RemoveItem iExit ForEnd If
Next
End SubPrivate Sub Text5_Click()
Shell Environ("PROGRAMFILES") & "\Internet Explorer\iexplore.exe  " & Trim(Text5)
End SubPrivate Sub Response(Index As Integer, IPort As String)
On Error GoTo err1If Check1.Value > 0 ThenIf Option1(0) ThenGetSendData 0ElseIf Option1(1) ThenGetSendData 1ElseIf Option1(2) ThenGetSendData 2ElseGetSendData 3End If
End IfDim dispinf As String
Dim sendstr As String
Dim i As IntegerOn Error GoTo err1For i = 0 To UBound(ServerSendbuf)sendstr = sendstr + Right("00" + Hex(ServerSendbuf(i)), 2) + " "
NextSock(Index).SendData ServerSendbufdispinf = Format(Now, "HH:MM:SS") & " SendTo " & IPort & " :" & sendstr
List2.AddItem (dispinf)
List2.AddItem ("")
List2.ListIndex = List2.ListCount - 1Exit Suberr1:dispinf = Format(Now, "HH:MM:SS") & " 连接 " & Index & " 传送数据时出错:" & Err.DescriptionList2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1List1.RemoveItem iEnd SubPrivate Sub ButtonSend()
Dim dataArray() As String
Dim sendstr As String
Dim IPort As String
Dim i As Integer
Dim sockid As Integer
Dim dispinf As StringOn Error GoTo err1For i = 0 To UBound(ServerSendbuf)sendstr = sendstr + Right("00" + Hex(ServerSendbuf(i)), 2) + " "
NextFor i = 0 To List1.ListCount - 1If List1.Selected(i) = True Thensockid = Val(Mid(List1.List(i), 1, 2))Sock(sockid).SendData ServerSendbufdataArray = Split(List1.List(i), "|")IPort = dataArray(2)dispinf = Format(Now, "HH:MM:SS") & " SendTo " & IPort & " :" & sendstrList2.AddItem (dispinf)List2.AddItem ("")List2.ListIndex = List2.ListCount - 1End If
Next
Exit Suberr1:dispinf = Format(Now, "HH:MM:SS") & " 连接 " & sockid & " 传送数据时出错:" & Err.DescriptionList2.AddItem (dispinf)List2.ListIndex = List2.ListCount - 1List1.RemoveItem iEnd SubPrivate Sub GetSendData(responseid As Integer)    '生成服务器发送缓冲数据
Dim i, J As Integer
Dim longi As Long
Dim dispinf As String
Dim strls As String
Dim lensy, displen, sendbyte As Integer
Dim textbyte() As ByteSelect Case responseidCase 0                      '生成显示文字发送数据缓冲ReDim ServerSendbuf(38)ServerSendbuf(0) = &H5A '命令字,表示驱动蜂鸣器声响ServerSendbuf(1) = 0ServerSendbuf(2) = 0If Check2.Value = 1 ThenServerSendbuf(3) = Combo2.ListIndex '声音类型If Option12.Value = True ThenServerSendbuf(3) = ServerSendbuf(3) Or 128End IfElseServerSendbuf(3) = &HFF '不发音If Option12.Value = True ThenServerSendbuf(3) = ServerSendbuf(3) And 127End IfEnd IfServerSendbuf(4) = Combo9.ListIndex  '20 '显示保留时间,单位为秒,为255时表示永久显示strls = Text7.Text + "                                         "textbyte = StrConv(strls, vbFromUnicode)      '字符串转换为字节数组For i = 0 To 33ServerSendbuf(i + 5) = textbyte(i)NextCase 1              '生成显示文字+蜂鸣响声+继电器+TTS语音发送数据缓冲strls = "[v"If (Combo8.ListIndex <= 16) Then strls = strls & Format(Combo8.ListIndex, "0") & "]" Else strls = strls & "16]"     '在需要发送的语音字符串中任何位置加入[v10],表示将音量调到10级(范围0~16,0表示静音,16最大,每次重开机后,音量重置为10级)!strls = strls & Trim(Text3.Text)textbyte = StrConv(strls, vbFromUnicode)      '字符串转换为字节数组lensy = UBound(textbyte) + 1displen = 34   '双行屏34,四行屏72sendbyte = 11 + displen + lensy + 4ReDim ServerSendbuf(sendbyte)ServerSendbuf(0) = &H5C    '命令字,表示驱动TTS合成语音\显示及继电器ServerSendbuf(1) = 0ServerSendbuf(2) = 0If Check2.Value = 1 ThenServerSendbuf(3) = Combo2.ListIndex '声音类型If Option12.Value = True ThenServerSendbuf(3) = ServerSendbuf(3) Or 128End IfElseServerSendbuf(3) = &HFF '不发音If Option12.Value = True ThenServerSendbuf(3) = ServerSendbuf(3) And 127End IfEnd IfSelect Case Combo3.ListIndexCase 1ServerSendbuf(4) = &HF1Case 2ServerSendbuf(4) = &HF2Case 3ServerSendbuf(4) = &HF3Case 4ServerSendbuf(4) = &HF4Case 5ServerSendbuf(4) = &HF5Case 6ServerSendbuf(4) = &HF6Case 7ServerSendbuf(4) = &HF7Case 8ServerSendbuf(4) = &HF8Case ElseServerSendbuf(4) = &HF0End Select'时长i = Val(Trim(Text30.Text))ServerSendbuf(5) = i Mod 256ServerSendbuf(6) = Int(i / 256) Mod 256ServerSendbuf(7) = Combo9.ListIndex  '20 '显示保留时间,单位为秒,为255时表示永久显示ServerSendbuf(8) = 0 '在显示屏中的哪个位置开始ServerSendbuf(9) = displen '显示字符串长度 0-34为全屏strls = Text7.Text + "                                         "Dim a() As Bytea = StrConv(strls, vbFromUnicode)      '字符串转换为字节数组For i = 1 To displen                        '显示文字的ASCII码ServerSendbuf(i + 10) = a(i - 1)NextServerSendbuf(10) = lensy                    '语音长度,最长可为126For i = 1 To lensy                     'TTS语音的ASCII码ServerSendbuf(i + 10 + displen) = textbyte(i - 1)NextServerSendbuf(10 + ServerSendbuf(9) + lensy + 1) = &H55ServerSendbuf(10 + ServerSendbuf(9) + lensy + 2) = &HAAServerSendbuf(10 + ServerSendbuf(9) + lensy + 3) = &H66ServerSendbuf(10 + ServerSendbuf(9) + lensy + 4) = &H99Case 2      '生成蜂鸣响声发送数据缓冲ReDim ServerSendbuf(3)ServerSendbuf(0) = &H96 '命令字,表示驱动蜂鸣器声响ServerSendbuf(1) = 0    'Tcp通讯,机号00表示任意机器ServerSendbuf(2) = 0ServerSendbuf(3) = Combo2.ListIndex  '声音类型Case 3       '生成继电器开关发送数据缓冲ReDim ServerSendbuf(5)ServerSendbuf(0) = &H78 '命令字,表示驱动蜂鸣器声响ServerSendbuf(1) = 0    'Tcp通讯,机号00表示任意机器ServerSendbuf(2) = 0Select Case Combo3.ListIndexCase 1ServerSendbuf(3) = &HF1Case 2ServerSendbuf(3) = &HF2Case 3ServerSendbuf(3) = &HF3Case 4ServerSendbuf(3) = &HF4Case 5ServerSendbuf(3) = &HF5Case 6ServerSendbuf(3) = &HF6Case 7ServerSendbuf(3) = &HF7Case 8ServerSendbuf(3) = &HF8Case ElseServerSendbuf(3) = &HF0End Selecti = Val(Trim(Text30.Text))  '时长ServerSendbuf(4) = i Mod 256ServerSendbuf(5) = Int(i / 256) Mod 256Case 4       '生成继电器开关发送数据缓冲ReDim ServerSendbuf(5)ServerSendbuf(0) = &H78 '命令字,表示驱动蜂鸣器声响ServerSendbuf(1) = 0    'Tcp通讯,机号00表示任意机器ServerSendbuf(2) = 0Select Case Combo3.ListIndexCase 1ServerSendbuf(3) = &HE1Case 2ServerSendbuf(3) = &HE2Case 3ServerSendbuf(3) = &HE3Case 4ServerSendbuf(3) = &HE4Case 5ServerSendbuf(3) = &HE5Case 6ServerSendbuf(3) = &HE6Case 7ServerSendbuf(3) = &HE7Case 8ServerSendbuf(3) = &HE8Case ElseServerSendbuf(3) = &HE0End Selecti = Val(Trim(Text30.Text))  '时长ServerSendbuf(4) = i Mod 256ServerSendbuf(5) = Int(i / 256) Mod 256Case 5      '生成重发刷卡数据发送数据缓冲ReDim ServerSendbuf(2)ServerSendbuf(0) = &HA7  '命令字:重新获取刷卡信息ServerSendbuf(1) = 0    'Tcp通讯,机号00表示任意机器ServerSendbuf(2) = 0End SelectEnd Sub

 

这篇关于Vb6 TCP Server服务端监听多个RFID读卡器客户端上传的刷卡数据的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/369128

相关文章

Python将大量遥感数据的值缩放指定倍数的方法(推荐)

《Python将大量遥感数据的值缩放指定倍数的方法(推荐)》本文介绍基于Python中的gdal模块,批量读取大量多波段遥感影像文件,分别对各波段数据加以数值处理,并将所得处理后数据保存为新的遥感影像... 本文介绍基于python中的gdal模块,批量读取大量多波段遥感影像文件,分别对各波段数据加以数值处

Window Server创建2台服务器的故障转移群集的图文教程

《WindowServer创建2台服务器的故障转移群集的图文教程》本文主要介绍了在WindowsServer系统上创建一个包含两台成员服务器的故障转移群集,文中通过图文示例介绍的非常详细,对大家的... 目录一、 准备条件二、在ServerB安装故障转移群集三、在ServerC安装故障转移群集,操作与Ser

使用MongoDB进行数据存储的操作流程

《使用MongoDB进行数据存储的操作流程》在现代应用开发中,数据存储是一个至关重要的部分,随着数据量的增大和复杂性的增加,传统的关系型数据库有时难以应对高并发和大数据量的处理需求,MongoDB作为... 目录什么是MongoDB?MongoDB的优势使用MongoDB进行数据存储1. 安装MongoDB

Python MySQL如何通过Binlog获取变更记录恢复数据

《PythonMySQL如何通过Binlog获取变更记录恢复数据》本文介绍了如何使用Python和pymysqlreplication库通过MySQL的二进制日志(Binlog)获取数据库的变更记录... 目录python mysql通过Binlog获取变更记录恢复数据1.安装pymysqlreplicat

Linux使用dd命令来复制和转换数据的操作方法

《Linux使用dd命令来复制和转换数据的操作方法》Linux中的dd命令是一个功能强大的数据复制和转换实用程序,它以较低级别运行,通常用于创建可启动的USB驱动器、克隆磁盘和生成随机数据等任务,本文... 目录简介功能和能力语法常用选项示例用法基础用法创建可启动www.chinasem.cn的 USB 驱动

使用SQL语言查询多个Excel表格的操作方法

《使用SQL语言查询多个Excel表格的操作方法》本文介绍了如何使用SQL语言查询多个Excel表格,通过将所有Excel表格放入一个.xlsx文件中,并使用pandas和pandasql库进行读取和... 目录如何用SQL语言查询多个Excel表格如何使用sql查询excel内容1. 简介2. 实现思路3

Python手搓邮件发送客户端

《Python手搓邮件发送客户端》这篇文章主要为大家详细介绍了如何使用Python手搓邮件发送客户端,支持发送邮件,附件,定时发送以及个性化邮件正文,感兴趣的可以了解下... 目录1. 简介2.主要功能2.1.邮件发送功能2.2.个性签名功能2.3.定时发送功能2. 4.附件管理2.5.配置加载功能2.6.

Oracle数据库使用 listagg去重删除重复数据的方法汇总

《Oracle数据库使用listagg去重删除重复数据的方法汇总》文章介绍了在Oracle数据库中使用LISTAGG和XMLAGG函数进行字符串聚合并去重的方法,包括去重聚合、使用XML解析和CLO... 目录案例表第一种:使用wm_concat() + distinct去重聚合第二种:使用listagg,

Python实现将实体类列表数据导出到Excel文件

《Python实现将实体类列表数据导出到Excel文件》在数据处理和报告生成中,将实体类的列表数据导出到Excel文件是一项常见任务,Python提供了多种库来实现这一目标,下面就来跟随小编一起学习一... 目录一、环境准备二、定义实体类三、创建实体类列表四、将实体类列表转换为DataFrame五、导出Da

Python实现数据清洗的18种方法

《Python实现数据清洗的18种方法》本文主要介绍了Python实现数据清洗的18种方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学... 目录1. 去除字符串两边空格2. 转换数据类型3. 大小写转换4. 移除列表中的重复元素5. 快速统