weixin_44064357的博客

在pom.xml文件中安装依赖<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.10</version></dependency>在mybatis-config.xml配置文件中改变数据连接<environments default="mysql">

@Testpublic void querySubjectById() { try { /*向数据库添加数据*/ //1.加载配置文件 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); //2.获取sqlSessionFactory工厂 SqlSessionFactory sqlSessionFactory =

CREATE TABLE t_passengers (id int NOT NULL AUTO_INCREMENT,name varchar(50) DEFAULT NULL,sex varchar(1) DEFAULT NULL,birthday date DEFAULT NULL,PRIMARY KEY (id)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;CREATE TABLE t_passports (id int NO

使用的表CREATE TABLE t_departments (id int NOT NULL AUTO_INCREMENT,name varchar(50) DEFAULT NULL,location varchar(100) DEFAULT NULL,PRIMARY KEY (id)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;CREATE TABLE t_employees (id int NOT NULL AUTO_INC

抽取sql片段<!--抽取重复的sql片段--> <sql id="user_field"> select id,username,password,gender,regist_time from t_user </sql> <!--根据id查询--> <select id="queryUserById" resultType="User"> <include

mybatis-config.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> <!--导入外部的配置文件-->