插件 logback日志插件; HikariCP连接池插件
CartMapper类
package ws.wsj.mapper;
import org.apache.ibatis.annotations.Select;
public interface CartMapper {
@Select("select version()")
public String version();
}
CartMapper测试类
package ws;
import com.zaxxer.hikari.HikariDataSource;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.transaction.TransactionFactory;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import ws.wsj.mapper.CartMapper;
public class Demo {
public final static Logger logger = LoggerFactory.getLogger(Demo.class);
public static void main(String[] args) {
//建立数据源
var ds = new HikariDataSource();
ds.setJdbcUrl("jdbc:mysql:/d3");
ds.setUsername("root");
//建立事务对象 Jdbc事务工厂 JdbcTransactionFactory()
TransactionFactory tx = new JdbcTransactionFactory();
//建立环境对象
Environment env = new Environment("development", tx, ds);
//建立配置对象,相当于mybatis-config.xml文件
Configuration cfg = new Configuration(env);
//添加映射器 addMappers
cfg.addMappers("ws.wsj.mapper");
// Sql会话工厂 SqlSessionFactory
SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(cfg);
SqlSession ss = sf.openSession(true);
//获取映射器 getMapper
CartMapper cart = ss.getMapper(CartMapper.class);
//System.out.println(cart.version());
logger.info(cart.version());
}
}
logback日志,映射文件
<?xml version="1.0"?>
<configuration>
<!-- ch.qos.logback.core.ConsoleAppender 控制台输出 -->
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>[%-5level] %L %d{HH:mm:ss} [%thread] %L %logger{36} - %msg%n</pattern>
</encoder>
</appender>
<!-- 日志级别 all info off -->
<root>
<level value="off"/>
<appender-ref ref="STDOUT"/>
</root>
<logger name="ws" level="DEBUG"/>
<logger name="ws.MyDemo" level="info"/>
</configuration>
logback日志 测试类
package ws;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
@Slf4j
public class MyDemo {
//Logger log = LoggerFactory.getLogger(MyDemo.class);
@Test
public void t1() {
log.info("hello world");
}
}
pom.xml 处理无法src/main/java加载资源配置文件
<build>
<finalName>${project.artifactId}</finalName>
<testSourceDirectory>src/test/java</testSourceDirectory>
<sourceDirectory>src/main/java</sourceDirectory>
<!-- 处理无法src/main/java加载资源配置文件 -->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
</resource>
</resources>
</build>