mybatis

最新推荐文章于 2024-04-09 17:08:04 发布

布响丸辣1

最新推荐文章于 2024-04-09 17:08:04 发布

阅读量65

点赞数

分类专栏： java 文章标签： mybatis

本文链接：https://blog.csdn.net/jianqingshan1/article/details/127828293

版权

java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

mybatis

mybatis结构

在这里插入图片描述

对于mybatis配置文件

1 映射的mapper文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--这个name的意思相当于一个包名 防止两个mapper文件下的jdbc 操作id重复 可以使用name.id来防止重复  -->
<mapper namespace="com.wzh.bank.dao.AccountDAO">
    <!--增-->
    <insert id="insertAccount">
        insert into t_car(id,car_num,brand,guide_peice,produce_time,car_type)values(#{id},#{car_num},#{brand},#{guide_peice},#{produce_time},#{car_type})
    </insert>
    <!--删-->
    <delete id="DeleteAccount">
        delete from t_car where id=#{id}
    </delete>
    <!--改-->
    <update id="updateByActno">
        update t_act set balance=#{balance} where actno=#{actno};
    </update>
    <!--查一个-->
   <select id="selectAccountByActno" resultType="com.wzh.bank.pojo.Account">
       select * from t_act where actno=#{actno}
   </select>
    <!--查所有-->
    <select id="SelectAccountAll" resultType="com.wzh.bank.pojo.Account">
        select * from t_car
    </select>
</mapper>

2 jdbc配置文件

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3307/mybayis?useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

3 log日志文件

<?xml version="1.0" encoding="UTF-8"?>
<configuration debug="false">
    <!--定义⽇志⽂件的存储地址-->
    <property name="LOG_HOME" value="/home"/>
    <!-- 控制台输出 -->
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncode
r">
            <!--格式化输出：%d表示⽇期(%d{yyyy-MM-dd HH:mm:ss.SSS})，%thread表示线程名，%-5level：级别从左显示5
           个字符宽度%msg：⽇志消息，%n是换⾏符-->
            <pattern> [%thread] %-5level %logge
                r{50} - %msg%n</pattern>
        </encoder>
    </appender>
    <!-- 按照每天⽣成⽇志⽂件 -->
    <!--mybatis log configure-->
    <logger name="com.apache.ibatis" level="TRACE"/>
    <logger name="java.sql.Connection" level="DEBUG"/>
    <logger name="java.sql.Statement" level="DEBUG"/>
    <logger name="java.sql.PreparedStatement" level="DEBUG"/>

    <!-- ⽇志输出级别,logback⽇志级别包括五个：TRACE < DEBUG < INFO < WARN < ER
   ROR -->
    <root level="DEBUG">
        <appender-ref ref="STDOUT"/>
        <appender-ref ref="FILE"/>
    </root>
</configuration>

4 mybatis核心配置文件

<?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>
    <properties resource="jdbc.properties" />
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <environments default="mybayisDB">
        <environment id="mybayisDB">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="AccountMapper.xml"/>
    </mappers>
</configuration>

5 pom导包文件

<?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.wzh</groupId>
  <artifactId>mybattis8</artifactId>
  <version>1.0</version>
  <packaging>war</packaging>

  <name>mybattis8 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <dependencies>
      <!--mybatis依赖-->
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.2</version>
      </dependency>
      <!--MySQL依赖-->
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.18</version>
      </dependency>
      <!--日志依赖-->
      <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>1.2.3</version>
      </dependency>
     <!-- servlet依赖-->
      <dependency>
        <groupId>jakarta.servlet</groupId>
        <artifactId>jakarta.servlet-api</artifactId>
        <version>6.0.0</version>
      </dependency>
  </dependencies>

  <build>
    <finalName>mybattis8</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

6 web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="https://jakarta.ee/xml/ns/jakartaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="https://jakarta.ee/xml/ns/jakartaee
                      https://jakarta.ee/xml/ns/jakartaee/web-app_5_0.xsd"
         version="5.0"
         metadata-complete="false">

<!--
<servlet>
    <servlet-name>test</servlet-name>
    <servlet-class>com.wzh.bank.web.AccountServlet</servlet-class>
</servlet>
    <servlet-mapping>
        <servlet-name>test</servlet-name>
        <url-pattern>/transfer</url-pattern>
    </servlet-mapping>
-->


</web-app>