centos7安装mysql并jdbc测试教程
16lz
2022-01-03
yum安装mysql5.5
之前用rpm安装方式安装不成功,换成yum安装之后安装ok了,在网上搜索到很多的rmp安装和tar包安装的方式,但是是centos7.x与centos6.x做了很大的改变,可能别人的6.x不适合7.x的安装,尤其是对于像博主一样的新人来说,照搬教程可能导致安装不成功,如果你rmp安装失败,那么尝试跟着本教程来吧。
先卸载已经存在的MySQL。
[root@shizongger bin]# rpm -qa|grep mysql [root@shizongger bin]# rpm -qa mysql [root@shizongger bin]# rpm -qa|grep -i mysql MySQL-client-5.5.54-1.el7.x86_64 [root@shizongger bin]# rpm -e --nodeps M ModemManager ModemManager-glib MySQL-client [root@shizongger bin]# rpm -e --nodeps MySQL-client
[root@shizongger bin]# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm[root@shizongger bin]# rpm -ivh mysql-community-release-el7-5.noarch.rpm
[root@shizongger bin]# yum install mysql-community-server
[root@shizongger bin]# service mysqld start
[shizongger@shizongger src]$ netstat -anp |grep 3306(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)tcp6 0 0 :::3306 :::* LISTEN -
[root@shizongger bin]# mysql -urootmysql> set password for 'root'@'localhost' =password('root');mysql>exit
[root@shizongger bin]# mysql -uroot -proot mysql> show database; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+
[root@shizongger bin]# service mysqld stop
测试jdbc
首先需要准备好jar包,mysql只需要一个jar包:mysql-connector-java-3.0.14-production-bin.jar,如果你是用vi/vim作为编辑工具,那么你的jar包需要放在jdk的lib文件夹下面,或者放在一个独立的地方,然后将其加入classpath里面,我在centos下面用ide eclipse来开发,这里以eclipse为例子说来(感觉自己在linux用ide,有点low).复制+粘帖,放在项目的lib下面。接着来开放我们的jdbc测试用例。
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JdbcTest { public static void main(String[] args) { Connection conn = null; Statement sm = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/shopping?zeroDateTimeBehavior=convertToNull"; conn = DriverManager.getConnection(url, "root", "root"); sm = conn.createStatement(); rs = sm.executeQuery("select * from user"); while(rs.next()) { System.out.println("id:" + rs.getInt("id") + " name:" + rs.getString("name")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try{ if(rs != null) { rs.close(); rs = null; } if(sm != null) { sm.close(); sm = null; } if(conn != null) { conn.close(); conn = null; } } catch(Exception e) { e.printStackTrace(); } } }}
更多相关文章
- MySQL系列多表连接查询92及99语法示例详解教程
- Pycharm安装PyQt5的详细教程
- 【阿里云镜像】使用阿里巴巴DNS镜像源——DNS配置教程
- android用户界面之按钮(Button)教程实例汇
- 【Android(安卓)开发教程】Toast通知
- 细数Android(安卓)Studio中使用junit4测试框架中的坑
- android 下写文件性能测试
- android 单元测试
- Android简易实战教程--第三十九话《Chronometer实现倒计时》