VB.net链接Mysql数据库的方法

sqlcommand = “select count( *) from user where User="+输入的User信息+"”；

如果执行这个语句返回的值大于0

说明数据库中存在此用户

Dim ADOrs AS RecordsetADOrs.Open "select * from {你的表名} where name='"+text1+"'" '把textbox1作为检索的对象即用来输入查找的条件 if NOT ADOrs.EOF then '开始查找(用了取么 *** 作没有找到到指针即找到了记录)那么执行下面的语句 ADOrs("name")=trim(text1) '把字段name显示给textbox1 ADOrs("year")=trim(text2） '把字段year显示给textbox2else msgbox "数据库没有检索到你要搜索的记录！"，vbokonly,"提示" end ifADOrs.close '最后记得把刚才打开的记录集给关闭掉或则会给数据库添加负荷的。

vb.net MySqlConnection主机不支持ssl连接

Java使用mysql-jdbc连接MySQL出现如下警告：

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

在mysql连接字符串url中加入ssl=true或者false即可，如下所示。

url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=true

---