我正在玩射频识别,为了学习我买的RC522的技术。将其连接到覆盆子圆周率并开始构建应用程序。
当尝试将标记注册到mariadb数据库时,它失败了。我找不出哪里出了问题。
表:
CREATE TABLE RFID.Users (
ID INT(10) NOT NULL AUTO_INCREMENT,
Fname VARCHAR(100) NOT NULL,
Lname VARCHAR(100) NOT NULL,
TAG VARCHAR(100) NOT NULL,
Image LONGBLOB NOT NULL,
PRIMARY KEY (ID)
)
ENGINE = INNODB,
AUTO_INCREMENT = 4,
AVG_ROW_LENGTH = 16384,
CHARACTER SET latin1,
COLLATE latin1_swedish_ci;存储过程:
CREATE DEFINER = 'root'@'%'
PROCEDURE RFID.Write_Tag(IN `@Fname` VARCHAR(100), IN `@Lname` VARCHAR(100), IN `@Tag` VARCHAR(100), IN `@Image` LONGBLOB)
BEGIN
INSERT INTO
Users
(Fname, Lname, TAG, Image)
VALUES
(@Fname, @Lname, @Tag, @Image);
END插入标签的Vb.net代码:
Private Sub BtnWriteTag_Click(sender As Object, e As EventArgs) Handles btnWriteTag.Click
Try
If IsNothing(PictureBox1.Image) Then
MsgBox("Please load image first")
Else
lblinfo.Text = "Please place your tag near the reader"
sshcmd = sshClient.RunCommand("python /home/pi/fabio/workingwriter.py " & "'" & txtFname.Text & "'")
txtTag.Text = sshcmd.Result.Replace(vbCr, "").Replace(vbLf, "")
Dim filesize As UInt32
Dim mstream As New System.IO.MemoryStream()
PictureBox1.Image.Save(mstream, Imaging.ImageFormat.Jpeg)
Dim arrImage() As Byte = mstream.GetBuffer()
filesize = mstream.Length
mstream.Close()
MessageBox.Show(filesize)
MessageBox.Show(txtFname.Text)
con = GetConnect()
con.Open()
cmd = New MySqlCommand("Write_Tag", con) With {
.CommandType = CommandType.StoredProcedure
}
cmd.Parameters.AddWithValue("@Fname", txtFname.Text)
cmd.Parameters.AddWithValue("@Lname", txtLname.Text)
cmd.Parameters.AddWithValue("@TAG", txtTag.Text)
cmd.Parameters.AddWithValue("@image", arrImage)
Dim x As Integer = cmd.ExecuteNonQuery()
If x = 1 Then
MessageBox.Show(" User saved.")
End If
End If
Catch ex As Exception
MsgBox("Error found: " & vbCrLf & ex.Message, MsgBoxStyle.Critical, "RFID Tag Reader")
Finally
If cmd IsNot Nothing Then cmd.Dispose()
If con IsNot Nothing AndAlso con.State <> ConnectionState.Closed Then con.Close()
End Try
End Sub从try catch返回的错误是:“'Fname‘列不能为空”
感谢你的帮助,
法比奥
发布于 2020-03-08 03:05:55
到处删除参数中的@符号-我不完全确定这是问题所在,但我从来没有见过它用于Maria。
在文档中,Maria sproc params的名称前没有@。
也将其从AddWithValue调用中删除:
CREATE DEFINER = 'root'@'%'
PROCEDURE RFID.Write_Tag(
IN pFname VARCHAR(100),
IN pLname VARCHAR(100),
IN pTag VARCHAR(100),
IN pImage LONGBLOB)
BEGIN
INSERT INTO
Users
(Fname, Lname, TAG, Image)
VALUES
(pFname, pLname, pTag, pImage);
END
cmd.Parameters.AddWithValue("pFname", txtFname.Text)
...https://stackoverflow.com/questions/60580423
复制相似问题