东莞做网站费用网站导航如何优化

当前位置： 首页 > news >正文

东莞做网站费用,网站导航如何优化,东莞抖音代运营公司,做国外市场哪个网站好一、学习目标 spring整合MyBatis的原理主要涉及到将MyBatis的Mapper映射文件交由Spring容器管理#xff0c;并将其注入到MyBatis的SqlSessionFactory中#xff0c;从而实现两者的整合。 二、整合mybatis 1.写一个mybatis测试案例 项目结构#xff1a; 1.数据库 CREATE DA…一、学习目标 spring整合MyBatis的原理主要涉及到将MyBatis的Mapper映射文件交由Spring容器管理并将其注入到MyBatis的SqlSessionFactory中从而实现两者的整合。 二、整合mybatis 1.写一个mybatis测试案例 项目结构 1.数据库 CREATE DATABASE mybatis; USE mybatis;create table Users(id int not null auto_increment primary key,name varchar(10) not null,age int not null );insert into Users(id,name,age) values(null,张三,20),(null,李四,18);2.实体类 public class User {private int id; //idprivate String name; //姓名private int age; //密码public int getId() {return id;}public void setId(int id) {this.id id;}public String getName() {return name;}public void setName(String name) {this.name name;}public int getAge() {return age;}public void setAge(int age) {this.age age;}public User(int id, String name, int age) {this.id id;this.name name;this.age age;}Overridepublic String toString() {return User{ id id , name name \ , age age };}public User() {} }2.编写接口 public interface UserMapper {public ListUser selectUser(); } 3.mybatisConfig配置文件 ?xml version1.0 encodingUTF-8 ? !DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd configurationtypeAliasespackage namecom.lzh.pojo//typeAliasesenvironments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC/dataSource typePOOLEDproperty namedriver valuecom.mysql.jdbc.Driver/property nameurl valuejdbc:mysql://localhost:3306/mybatis?useSSLtrueamp;useUnicodetrueamp;characterEncodingutf8amp;useSSLfalse/property nameusername valueroot/property namepassword valueadmin123//dataSource/environment/environmentsmapperspackage namecom.lzh.dao//mappers /configuration 4.UserrMapper文件 ?xml version1.0 encodingUTF-8 ? !DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd mapper namespacecom.lzh.dao.UserMapperselect idselectUser resultTypeUserselect * from users/select /mapper 5.pom.xml ?xml version1.0 encodingUTF-8? project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdcom.lzh/groupIdartifactIdspring-07/artifactIdversion1.0-SNAPSHOT/versiondependenciesdependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.12/version/dependencydependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.2/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.47/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion5.1.10.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.1.10.RELEASE/version/dependency!– https://mvnrepository.com/artifact/org.aspectj/aspectjweaver –dependencygroupIdorg.aspectj/groupIdartifactIdaspectjweaver/artifactIdversion1.9.4/version/dependencydependencygroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactIdversion2.0.2/version/dependency/dependenciesbuildresourcesresourcedirectorysrc/main/java/directoryincludesinclude/*.properties/includeinclude/*.xml/include/includesfilteringtrue/filtering/resource/resources/buildpropertiesmaven.compiler.source1.8/maven.compiler.sourcemaven.compiler.target1.8/maven.compiler.target/properties/project 6.测试 Testpublic void selectUser() throws IOException {String resource MybatisConfig.xml;InputStream inputStream Resources.getResourceAsStream(resource);SqlSessionFactory sqlSessionFactory new SqlSessionFactoryBuilder().build(inputStream);SqlSession sqlSession sqlSessionFactory.openSession();UserMapper mapper sqlSession.getMapper(UserMapper.class);ListUser userList mapper.selectUser();for (User user: userList){System.out.println(user);}sqlSession.close();} 2.整合mybatis方式一 1.配置数据源 !–配置数据源-定义一个数据源beanid为dataSource用于管理数据库连接。class属性指定了数据源的实现类为org.springframework.jdbc.datasource.DriverManagerDataSource–bean iddataSource classorg.springframework.jdbc.datasource.DriverManagerDataSourceproperty namedriverClassName valuecom.mysql.jdbc.Driver/!–设置数据库连接的URL。- useSSLtrueamp;useSSLfalse这里似乎有一个错误通常只需要一个useSSL参数并且应该保持一致。对于本地开发通常不需要SSL所以应设置为false。- useUnicodetrue指定使用Unicode字符集。- characterEncodingutf8指定字符编码为UTF-8。注意从MySQL 5.5.3版本开始建议使用utf8mb4代替utf8以支持更广泛的Unicode字符包括emoji表情等。–property nameurl valuejdbc:mysql://localhost:3306/mybatis?useSSLfalseamp;useUnicodetrueamp;characterEncodingutf8/property nameusername valueroot/property namepassword valueadmin123//bean 2.配置SqlSessionFactory关联MyBatis注册,sqlSessionTemplate关联sqlSessionFactory !– 配置SqlSessionFactory –bean idsqlSessionFactory classorg.mybatis.spring.SqlSessionFactoryBean!– 注入数据源这里的ref指向之前定义的数据源bean –property namedataSource refdataSource/!– 关联Mybatis的全局配置文件MybatisConfig.xml中包含了MyBatis的设置如别名、类型处理器、插件等 –property nameconfigLocation valueclasspath:MybatisConfig.xml/!– 指定Mapper XML文件的位置MyBatis会根据这些XML文件来创建Mapper接口的实现 –!– 注意这里只指定了一个Mapper XML文件如果有多个可以使用逗号分隔或者使用通配符 –property namemapperLocations valueclasspath:com/lzh/dao/UserMapper.xml//bean!– 注册sqlSessionTemplate关联sqlSessionFactory –bean idsqlSession classorg.mybatis.spring.SqlSessionTemplate!– 通过构造器注入SqlSessionFactory使得SqlSessionTemplate能够管理SqlSession –!– index0指定了构造器参数的索引这里假设SqlSessionTemplate的构造器第一个参数就是SqlSessionFactory –constructor-arg index0 refsqlSessionFactory//bean 3.增加接口实现类 public class UserDaoImpl implements UserMapper {// 注入SqlSessionTemplateSpring容器会负责注入private SqlSessionTemplate sqlSession;// 通过构造器注入SqlSessionTemplate推荐的方式因为它支持Spring的依赖注入最佳实践public void setSqlSession(SqlSessionTemplate sqlSession) {this.sqlSession sqlSession;}public ListUser selectUser() {UserMapper mapper sqlSession.getMapper(UserMapper.class);return mapper.selectUser();} } 4.注册bean bean iduserDao classcom.lzh.dao.UserDaoImplproperty namesqlSession refsqlSession//bean 5.修改mybatis配置文件 !–mapperspackage namecom.lzh.dao//mappers– 6.测试 Testpublic void test2(){ApplicationContext context new ClassPathXmlApplicationContext(beans.xml);UserMapper mapper (UserMapper) context.getBean(userDao);ListUser user mapper.selectUser();System.out.println(user);} 2.整合mybatis方式二 1.修改接口实现类 public class UserDaoImpl extends SqlSessionDaoSupport implements UserMapper {public ListUser selectUser() {UserMapper mapper getSqlSession().getMapper(UserMapper.class);return mapper.selectUser();} } 2.修改bean配置 !– 注册sqlSessionTemplate关联sqlSessionFactory –!–bean idsqlSession classorg.mybatis.spring.SqlSessionTemplate 通过构造器注入SqlSessionFactory使得SqlSessionTemplate能够管理SqlSession –!– index0指定了构造器参数的索引这里假设SqlSessionTemplate的构造器第一个参数就是SqlSessionFactory –!–constructor-arg index0 refsqlSessionFactory//bean–!–bean iduserDao classcom.lzh.dao.UserDaoImplproperty namesqlSession refsqlSession//bean–bean iduserDao classcom.lzh.dao.UserDaoImplproperty namesqlSessionFactory refsqlSessionFactory //bean