MySQL安装及结合MyBatis使用
官网地址:https://www.mysql.com
一、下载安装及启动MySQL
windows下安装
1、用管理员启动cmd到mysql的bin目录下执行mysqld --install
显示Service successfully installed则安装成功。注意使用管理员启动
2、执行mysqld --initialize --console 进行初始化,记住初始化显示的最后一行,结尾是初始化的密码
3、执行net start MySQL启动服务
4、执行mysql -u root -p 进行登录,root是默认用户名,之后输入初始化密码则可登录
5、执行exit可退出登录
6、执行set password for root@localhost = password(‘新密码’); 可重新设置其密码(需要先登录,注意记得结尾要输入分号)
7、执行完以上操作后还是改用Navicat进行连接操作比较方便
linux下安装(CentOS)
1、下载安装
#下载rpm文件
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
#执行rpm源文件
rpm -ivh mysql-community-release-el6-5.noarch.rpm
#执行安装文件
yum install mysql-community-server
2、查看安装的mysql
rpm -qa|grep mysql
yum repolist all | grep mysql
3、卸载mysql
yum remove -y mysql mysql-libs mysql-common #卸载mysql
rm -rf /var/lib/mysql #删除mysql下的数据文件
rm /etc/my.cnf #删除mysql配置文件
yum remove -y mysql-community-release-el6-5.noarch #删除组件
二、Idea使用MyBatis连接MySql
1、maven添加依赖
注意IDEA不识别maven工程里resources里的xml和properties文件需要添加
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>6</source>
<target>6</target>
</configuration>
</plugin>
</plugins>
</build>
maven依赖如下:
//mybatis
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
//mysql
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
</dependency>
//junit
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
<scope>test</scope>
</dependency>
2、配置SqlMapConfig.xml
注意configuration内的内容是有顺序要求的否则会产生如下报错
Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.
Cause: org.xml.sax.SAXParseException; lineNumber: 27; columnNumber: 17;
元素类型为 "configuration" 的内容必须匹配 "(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,objectWrapperFactory?,reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="config/db.properties"/>
<typeAliases>
<!-- 定义单个别名 -->
<typeAlias type="com.mybatis.po.User" alias="user"/>
<!-- 定义整个包的别名 -->
<!-- <package name="com.mybatis.po"/>-->
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<!-- 配置数据库连接信息 -->
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="config/UserMapper.xml"/>
</mappers>
</configuration>
3、配置db.properties
注意mysql的连接驱动在8版本后变成了com.mysql.cj.jdbc.Driver,之前的为com.mysql.jdbc.Driver。
且url需要加时间戳&serverTimezone=UTC
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=utf8&serverTimezone=UTC
jdbc.username=mybatis
jdbc.password=mybatis
4、配置UserMapper.xml(原生写法)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="test" >
<select id = "findUserById" parameterType = "int" resultType = "com.mybatis.po.User">
SELECT * FROM user WHERE id = #{id}
</select>
</mapper>
注意如果IDEA报错找不到配置文件,记得clean一下工程再重新加载试试