Mybatis框架的引入和原理解析-----Mybatis框架

素颜马尾好姑娘i 2024-03-24 19:40 3阅读 0赞

>     1.resource目录:放在这个目录下的一般都是资源文件,配置文件,直接放在Resource是\目录下的资源等于放到资源的根路径下
>     2.打包方式jar,因为不用导入到服务器上,故而不打包成war,引入mybatis依赖和jdbc依赖
>     从XML构建SqlSessionFactory,MyBatis一定有一个SqlSessionFactory对象
>     mybatis有两个主要的配置文件,mybatis-config.xml核心配置文件,配置连接数据库的信息等(一个)
>     xxMapper.xml专门写SQL语句的配置文件(一张表一个)
>     编写xxMapper.xml文件,用来写SQL语句,这个文件名字和位置都不固定
>     把它放在根路径下
>     在config文件中指定xml文件
>     在Mybatis中执行SQL语句的是SQLSession会话,这个是Java程序与数据库之间的一次会话
>     HttpSession是浏览器和Java的一次会话,要想获取SQLSession对象,我们要先获取
>     通过SqlSessionFactory对象获取
>     需要获取SqlSessionFactoryBuilder对象,通过其build方法来获取
>     SQLSessionFactory对象,
> 
>     1.resource目录:放在这个目录下的一般都是资源文件,配置文件,直接放在Resource是\目录下的资源等于放到资源的根路径下
>     2.打包方式jar,因为不用导入到服务器上,故而不打包成war,引入mybatis依赖和jdbc依赖
>     从XML构建SqlSessionFactory,MyBatis一定有一个SqlSessionFactory对象
>     mybatis有两个主要的配置文件,mybatis-config.xml核心配置文件,配置连接数据库的信息等(一个)
>     xxMapper.xml专门写SQL语句的配置文件(一张表一个)
>     编写xxMapper.xml文件,用来写SQL语句,这个文件名字和位置都不固定
>     把它放在根路径下
>     在config文件中指定xml文件
>     在Mybatis中执行SQL语句的是SQLSession会话,这个是Java程序与数据库之间的一次会话
>     HttpSession是浏览器和Java的一次会话,要想获取SQLSession对象,我们要先获取
>     通过SqlSessionFactory对象获取
>     需要获取SqlSessionFactoryBuilder对象,通过其build方法来获取
>     SQLSessionFactory对象,

>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>com.powernode</groupId>
>         <artifactId>mybatis-001-introduction</artifactId>
>         <version>1.0-SNAPSHOT</version>
>         <dependencies>
>             
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-core</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.mybatis</groupId>
>                 <artifactId>mybatis</artifactId>
>                 <version>3.5.10</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-slf4j2-impl</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.30</version>
>             </dependency>
>             
>             <dependency>
>                 <groupId>junit</groupId>
>                 <artifactId>junit</artifactId>
>                 <version>4.13.2</version>
>                 <scope>test</scope>
>             </dependency>
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>     </project>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>com.powernode</groupId>
>         <artifactId>mybatis-001-introduction</artifactId>
>         <version>1.0-SNAPSHOT</version>
>         <dependencies>
>             
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-core</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.mybatis</groupId>
>                 <artifactId>mybatis</artifactId>
>                 <version>3.5.10</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-slf4j2-impl</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.30</version>
>             </dependency>
>             
>             <dependency>
>                 <groupId>junit</groupId>
>                 <artifactId>junit</artifactId>
>                 <version>4.13.2</version>
>                 <scope>test</scope>
>             </dependency>
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>     </project>

>     <?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>
>         <environments default="development">
>             <environment id="development">
>                 <transactionManager type="JDBC" />
>                 <dataSource type="POOLED">
>                     <property name="driver" value="com.mysql.cj.jdbc.Driver" />
>                     <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
>                     <property name="username" value="root" />
>                     <property name="password" value="abc123" />
>                 </dataSource>
>             </environment>
>         </environments>
>         <mappers>
>     
>             <mapper resource="CarMapper.xml"></mapper>
>         </mappers>
>     </configuration>
> 
>     <?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>
>         <environments default="development">
>             <environment id="development">
>                 <transactionManager type="JDBC" />
>                 <dataSource type="POOLED">
>                     <property name="driver" value="com.mysql.cj.jdbc.Driver" />
>                     <property name="url" value="jdbc:mysql://localhost:13306/powernode" />
>                     <property name="username" value="root" />
>                     <property name="password" value="abc123" />
>                 </dataSource>
>             </environment>
>         </environments>
>         <mappers>
>     
>             <mapper resource="CarMapper.xml"></mapper>
>         </mappers>
>     </configuration>

>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <configuration>
>         <loggers>
>             
>             
>             <root level="INFO">
>                 <appender-ref ref="spring6log"/>
>             </root>
>         </loggers>
>         <appenders>
>             
>             <console name="spring6log" target="SYSTEM_OUT">
>                 
>                 <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss SSS} [%t] %-3level %logger{1024} - %msg%n"/>
>             </console>
>         </appenders>
>     </configuration>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <configuration>
>         <loggers>
>             
>             
>             <root level="INFO">
>                 <appender-ref ref="spring6log"/>
>             </root>
>         </loggers>
>         <appenders>
>             
>             <console name="spring6log" target="SYSTEM_OUT">
>                 
>                 <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss SSS} [%t] %-3level %logger{1024} - %msg%n"/>
>             </console>
>         </appenders>
>     </configuration>

>     <?xml version="1.0" encoding="ISO-8859-1"?>
>     
>     <!DOCTYPE mapper
>         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="abc">
>     
>         <insert id="">
>             insert into t_car(id,car_num,brand,guide_price,produce_time,car_type)
>             values(null,'1003','丰田霸道',30.0,'2000-10-11','燃油车')
>         </insert>
>     
>     
>     
>     
>     </mapper>
> 
>     <?xml version="1.0" encoding="ISO-8859-1"?>
>     
>     <!DOCTYPE mapper
>         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="abc">
>     
>         <insert id="">
>             insert into t_car(id,car_num,brand,guide_price,produce_time,car_type)
>             values(null,'1003','丰田霸道',30.0,'2000-10-11','燃油车')
>         </insert>
>     
>     
>     
>     
>     </mapper>