1.MySQL操作流程
1.搭建Maven项目
2.寻找相关依赖(需要相关依赖可访问https://mvnrepository.com/)
<!--mabatis相关包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--mysql依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
3.创建实体类,分别生成get和set方法。
4.jdbcConfig.properties创建,配置信息。
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://42.192.129.221:3306/loveweb?useSSL=false
jdbc.username=loveWeb
jdbc.password=3TXhjyaesTc3TnG7
5.新建mybatis.xml配置文件
<?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="jdbcConfig.properties"></properties>
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
<typeAliases>
<package name="com.iboxpay.demo.bean.Section"/>
</typeAliases>
<!-- 配置properties-->
<!--配置环境-->
<environments default="mysql">
<!-- 配置mysql的环境-->
<environment id="mysql">
<!-- 配置事务 -->
<transactionManager type="JDBC"/>
<!--配置连接池-->
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</dataSource>
</environment>
</environments>
<!-- 配置映射文件的位置 -->
<mappers>
<!--指定要扫描的接口-->
<package name="com/iboxpay/demo"/>
</mappers>
</configuration>
2.操作Oracle数据库
1.导入依赖
<!-- oracle相关包-->
<dependency>
<groupId>com.hynnet</groupId>
<artifactId>oracle-driver-ojdbc</artifactId>
<version>12.1.0.2</version>
</dependency>
2.配置连接相关信息(jdbcOracle.properties)
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@172.30.38.135:1521:alidev
jdbc.username=DEV_IB_CB_QYS
jdbc.password=ba8Hasg7
3.xml配置和Mysql相似。
4.创建实体类
5.在dao层中编写mapper接口。
package com.iboxpay.demo.dao;
import com.iboxpay.demo.bean.Student;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface StudentDao {
@Results(id = "resultMap" , value = {
@Result(property = "sName",column = "S_NAME"),
@Result(property = "sClass",column = "S_CLASS"),
@Result(property = "sScore",column = "S_SCORE")
})
@Select("SELECT * FROM student")
public List<Student> selectAllStudent();
}
3.温馨提示
1.如果需要导入日志需要导入相关依赖例如
<!--日志输出-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
2.编写日志模板,例如 log4j.properties
log4j.rootLogger=DEBUG, stdout, filelog
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} %c{1} - %m%n
log4j.appender.filelog=org.apache.log4j.DailyRollingFileAppender
log4j.appender.filelog.file=D:\\logs\\workOrder\\logs.txt
log4j.appender.filelog.DatePattern='.'yyyy-MM-dd
log4j.appender.filelog.layout=org.apache.log4j.PatternLayout
log4j.appender.filelog.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} %c{1} - %m%n
3.在xml配置文件中使用标签
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
4.MyBatis的使用有哪些步骤?
●步骤:
- 步骤1:添加框架依赖、mybatis-config.xml文件进行框架配置(数据库环境、Mapper映射);
- 步骤2:Resources加载配置文件;
- 步骤3:根据加载到的配置文件,通过SqlSessionFactoryBuilder创建SqlSessionFactory对象;
- 步骤4:通过SqlSessionFactory对象的openSession()方法,创建SqlSession对象;
- 步骤5:通过SqlSession对象的getMapper( )方法,获取映射接口的MapperProxy代理对象;
- 步骤6:通过MapperProxy代理对象完成SQL映射的CRUD方法的调用执行;