马良行网站3d模型预览怎么做的,重庆建设工程信息网站,wordpress jetpack中国,微信开放平台网站应用目录 一、基础工程
1、创建一个数据库#xff1a;mp
2、添加数据
3、创建初始工程 4、添加依赖
二、Mybatis Mybatis-Plus
1、创建子工程#xff1a;mybatis-plus-simple
2、在子工程下添加配置
2.1Mybatis实现查询User
2.1.1、编写User实体对象
2.1.2、编写UserMa…
目录 一、基础工程
1、创建一个数据库mp
2、添加数据
3、创建初始工程 4、添加依赖
二、Mybatis Mybatis-Plus
1、创建子工程mybatis-plus-simple
2、在子工程下添加配置
2.1Mybatis实现查询User
2.1.1、编写User实体对象
2.1.2、编写UserMapper接口
2.1.3、编写UserMapper.xml文件
2.1.4、编写TestMybatis测试
2.2MybatisMP实现查询User
2.2.1、将UserMapper继承BaseMapper将拥有了BaseMapper中的所有方法
2.2.2、使用MP中的MybatisSqlSessionFactoryBuilder进程构建
三、Spring Mybatis Mybatis-Plus
1、创建子Module 2、添加pom文件 3、编写jdbc.properties
4、编写applicationContext.xml
5、编写User对象以及UserMapper接口
6、编写测试类
四、SpringBoot Mybatis Mybatis-Plus
1、创建一个工springboot程 2、添加依赖
3、添加日志文件及配置
4、编写pojo
5、编写mapper
6、编写测试类 一、基础工程
1、创建一个数据库mp
create database if not exists mp;
2、添加数据
-- 创建测试表
CREATE TABLE tb_user (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键ID,
user_name varchar(20) NOT NULL COMMENT 用户名,
password varchar(20) NOT NULL COMMENT 密码,
name varchar(30) DEFAULT NULL COMMENT 姓名,
age int(11) DEFAULT NULL COMMENT 年龄,
email varchar(50) DEFAULT NULL COMMENT 邮箱,
PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1 DEFAULT CHARSETutf8;
-- 插入测试数据
INSERT INTO tb_user (id, user_name, password, name, age, email) VALUES
(1, zhangsan, 123456, 张三, 18, test1itcast.cn);
INSERT INTO tb_user (id, user_name, password, name, age, email) VALUES
(2, lisi, 123456, 李四, 20, test2itcast.cn);
INSERT INTO tb_user (id, user_name, password, name, age, email) VALUES
(3, wangwu, 123456, 王五, 28, test3itcast.cn);
INSERT INTO tb_user (id, user_name, password, name, age, email) VALUES
(4, zhaoliu, 123456, 赵六, 21, test4itcast.cn);
INSERT INTO tb_user (id, user_name, password, name, age, email) VALUES
(5, sunqi, 123456, 孙七, 24, test5itcast.cn);
3、创建初始工程 4、添加依赖 dependencies!-- mybatis-plus插件依赖 --dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus/artifactIdversion3.1.1/version/dependency!-- MySql --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.47/version/dependency!-- 连接池 --dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.0.11/version/dependency!--简化bean代码的工具包--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optionalversion1.18.4/version/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.12/version/dependencydependencygroupIdorg.slf4j/groupIdartifactIdslf4j-log4j12/artifactIdversion1.6.4/version/dependency/dependenciesbuildpluginsplugingroupIdorg.apache.maven.plugins/groupIdartifactIdmaven-compiler-plugin/artifactIdconfigurationsource1.8/sourcetarget1.8/target/configuration/plugin/plugins/build
二、Mybatis Mybatis-Plus
1、创建子工程mybatis-plus-simple
2、在子工程下添加配置
2.1Mybatis实现查询User
日之文件log4j.properties
log4j.rootLoggerDEBUG,A1
log4j.appender.A1org.apache.log4j.ConsoleAppender
log4j.appender.A1.layoutorg.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern[%t] [%c]-[%p] %m%n
mybatis-config.xml文件
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configurationenvironments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC/dataSource typePOOLEDproperty namedriver valuecom.mysql.jdbc.Driver/property nameurl valuejdbc:mysql://127.0.0.1:3306/mp?useUnicodetrueamp;characterEncodingutf8amp;autoReconnecttrueamp;allowMultiQueriestrueamp;useSSLfalse/property nameusername valueroot/property namepassword valueroot//dataSource/environment/environmentsmappersmapper resourceUserMapper.xml//mappers
/configuration
2.1.1、编写User实体对象
package com.mp.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;Data
NoArgsConstructor
AllArgsConstructor
public class User {private Long id;private String userName;private String password;private String name;private Integer age;private String email;
}
2.1.2、编写UserMapper接口
public interface UserMapper {ListUser findAll();
}
2.1.3、编写UserMapper.xml文件
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.mp.mapper.UserMapperresultMap idMappingName typecom.mp.pojo.Userid propertyid columnid/result propertyuserName columnuser_name/result propertypassword columnpassword/result propertyname columnname/result propertyage columnage/result propertyemail columnemail//resultMapselect idfindAll resultMapMappingNameselect * from tb_user/select
/mapper
2.1.4、编写TestMybatis测试
public class TestMybatis {Testpublic void testUserList() throws Exception{//读取配置文件String resource mybatis-config.xml;//加载资源文件。InputStream inputStream Resources.getResourceAsStream(resource);//创建 sqlSessionFactory 工厂SqlSessionFactory sqlSessionFactory new SqlSessionFactoryBuilder().build(inputStream);//创建 SqlSession 对象SqlSession sqlSession sqlSessionFactory.openSession();//获取一个 UserMapper 的实例UserMapper userMapper sqlSession.getMapper(UserMapper.class);//调用方法ListUser list userMapper.findAll();for (User user : list) {System.out.println(user);}}
}
2.2MybatisMP实现查询User
2.2.1、将UserMapper继承BaseMapper将拥有了BaseMapper中的所有方法
public interface UserMapper extends BaseMapperUser {ListUser findAll();
}
2.2.2、使用MP中的MybatisSqlSessionFactoryBuilder进程构建
public class TestMybatisPlus {Testpublic void testUserList() throws Exception{//读取配置文件String resource mybatis-config.xml;//加载资源文件。InputStream inputStream Resources.getResourceAsStream(resource);//这里使用的是mybatisplus中的MybatisSqlSessionFactoryBuilderSqlSessionFactory sqlSessionFactory new MybatisSqlSessionFactoryBuilder().build(inputStream);//创建 SqlSession 对象SqlSession sqlSession sqlSessionFactory.openSession();//获取一个 UserMapper 的实例UserMapper userMapper sqlSession.getMapper(UserMapper.class);// 可以调用BaseMapper中定义的方法ListUser list userMapper.selectList(null);for (User user : list) {System.out.println(user);}}}
三、Spring Mybatis Mybatis-Plus
1、创建子Module 2、添加pom文件 propertiesmaven.compiler.source8/maven.compiler.sourcemaven.compiler.target8/maven.compiler.targetspring.version5.1.6.RELEASE/spring.version/propertiesdependenciesdependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion${spring.version}/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion${spring.version}/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-test/artifactIdversion${spring.version}/version/dependency/dependencies 3、编写jdbc.properties
jdbc.drivercom.mysql.jdbc.Driver
jdbc.urljdbc:mysql://127.0.0.1:3306/mp?useUnicodetruecharacterEncodingutf8autoReconnecttrueallowMultiQueriestrueuseSSLfalse
jdbc.usernameroot
jdbc.passwordroot4、编写applicationContext.xml
?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdcontext:property-placeholder locationclasspath:*.properties/!-- 定义数据源 --bean iddataSource classcom.alibaba.druid.pool.DruidDataSourcedestroy-methodcloseproperty nameurl value${jdbc.url}/property nameusername value${jdbc.username}/property namepassword value${jdbc.password}/property namedriverClassName value${jdbc.driver}/property namemaxActive value10/property nameminIdle value5//bean!--这里使用MP提供的sqlSessionFactory完成了Spring与MP的整合--bean idsqlSessionFactoryclasscom.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBeanproperty namedataSource refdataSource//bean!--扫描mapper接口使用的依然是Mybatis原生的扫描器--bean classorg.mybatis.spring.mapper.MapperScannerConfigurerproperty namebasePackage valuecom.mybatisplus.mapper//bean/beans
5、编写User对象以及UserMapper接口
Data
NoArgsConstructor
AllArgsConstructor
TableName(tb_user)
public class User {private Long id;private String userName;private String password;private String name;private Integer age;private String email;
}
public interface UserMapper extends BaseMapperUser {
}
6、编写测试类
RunWith(SpringJUnit4ClassRunner.class)
ContextConfiguration(locations classpath:applicationContext.xml)
public class TestSpringMP {Autowiredprivate UserMapper userMapper;Testpublic void testSelectList(){ListUser users this.userMapper.selectList(null);for (User user : users) {System.out.println(user);}}}
在teat下测试可能会读取不到 applicationContext.xml文件复制一份放在teat目录下即可 四、SpringBoot Mybatis Mybatis-Plus
1、创建一个工springboot程 2、添加依赖
dependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter/artifactId/dependencydependencygroupIdcom.mysql/groupIdartifactIdmysql-connector-j/artifactIdscoperuntime/scope/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency!--mybatis-plus的springboot支持--dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.1.1/version/dependencydependencygroupIdorg.slf4j/groupIdartifactIdslf4j-log4j12/artifactId/dependency/dependencies
3、添加日志文件及配置
log4j.properties
log4j.rootLoggerDEBUG,A1
log4j.appender.A1org.apache.log4j.ConsoleAppender
log4j.appender.A1.layoutorg.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern[%t] [%c]-[%p] %m%n 编写application.properties文件
spring.application.name itcast-mp-springboot
spring.datasource.driver-class-namecom.mysql.jdbc.Driver
spring.datasource.urljdbc:mysql://127.0.0.1:3306/mp?useUnicodetruecharacterEncodingutf8autoReconnecttrueallowMultiQueriestrueuseSSLfalse
spring.datasource.usernameroot
spring.datasource.passwordroot
4、编写pojo
Data
NoArgsConstructor
AllArgsConstructor
TableName(tb_user)
public class User {private Long id;private String userName;private String password;private String name;private Integer age;private String email;
}
5、编写mapper
public interface UserMapper extends BaseMapperUser {
}
6、编写测试类 Autowiredprivate UserMapper userMapper;Testpublic void testSelect() {ListUser userList userMapper.selectList(null);for (User user : userList) {System.out.println(user);}}
