Mybatis对接开发Web应用-----Mybatis框架

小咪咪 2024-03-08 08:29 105阅读 0赞

>     <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/maven-v4_0_0.xsd">
>       <modelVersion>4.0.0</modelVersion>
>       <groupId>com.powernode</groupId>
>       <artifactId>Mybatis004</artifactId>
>       <packaging>war</packaging>
>       <version>1.0</version>
>       <name>Mybatis004 Maven Webapp</name>
>       <url>http://maven.apache.org</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>
>         <dependency>
>           <groupId>org.mybatis</groupId>
>           <artifactId>mybatis</artifactId>
>           <version>3.5.10</version>
>         </dependency>
>         <dependency>
>           <groupId>mysql</groupId>
>           <artifactId>mysql-connector-java</artifactId>
>           <version>8.0.33</version>
>         </dependency>
>         <dependency>
>           <groupId>ch.qos.logback</groupId>
>           <artifactId>logback-classic</artifactId>
>           <version>1.2.11</version>
>         </dependency>
>         <dependency>
>           <groupId>javax.servlet</groupId>
>           <artifactId>javax.servlet-api</artifactId>
>           <version>4.0.1</version>
>         </dependency>
>       </dependencies>
>       <build>
>         <finalName>Mybatis004</finalName>
>       </build>
>     </project>
> 
>     <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/maven-v4_0_0.xsd">
>       <modelVersion>4.0.0</modelVersion>
>       <groupId>com.powernode</groupId>
>       <artifactId>Mybatis004</artifactId>
>       <packaging>war</packaging>
>       <version>1.0</version>
>       <name>Mybatis004 Maven Webapp</name>
>       <url>http://maven.apache.org</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>
>         <dependency>
>           <groupId>org.mybatis</groupId>
>           <artifactId>mybatis</artifactId>
>           <version>3.5.10</version>
>         </dependency>
>         <dependency>
>           <groupId>mysql</groupId>
>           <artifactId>mysql-connector-java</artifactId>
>           <version>8.0.33</version>
>         </dependency>
>         <dependency>
>           <groupId>ch.qos.logback</groupId>
>           <artifactId>logback-classic</artifactId>
>           <version>1.2.11</version>
>         </dependency>
>         <dependency>
>           <groupId>javax.servlet</groupId>
>           <artifactId>javax.servlet-api</artifactId>
>           <version>4.0.1</version>
>         </dependency>
>       </dependencies>
>       <build>
>         <finalName>Mybatis004</finalName>
>       </build>
>     </project>

>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
>                           http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
>              version="4.0"
>              metadata-complete="true">
>     </web-app>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
>                           http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
>              version="4.0"
>              metadata-complete="true">
>     </web-app>

>     <!DOCTYPE html>
>     <html lang="en">
>     <head>
>         <meta charset="UTF-8">
>         <title>银行转账</title>
>     </head>
>     <body>
>         <form action="/bank/transfer" method="post">
>             转出账号:<input type="text" name="fromActno"/><br>
>             转入账号:<input type="text" name="toActno"/><br>
>             转账金额:<input type="text" name="money"/><br>
>             <input type="submit" value="转账">
>         </form>
>     </body>
>     </html>
> 
>     <!DOCTYPE html>
>     <html lang="en">
>     <head>
>         <meta charset="UTF-8">
>         <title>银行转账</title>
>     </head>
>     <body>
>         <form action="/bank/transfer" method="post">
>             转出账号:<input type="text" name="fromActno"/><br>
>             转入账号:<input type="text" name="toActno"/><br>
>             转账金额:<input type="text" name="money"/><br>
>             <input type="submit" value="转账">
>         </form>
>     </body>
>     </html>

>     <?xml version="1.0" encoding="UTF-8" ?>
>     
>     <configuration debug="false">
>         <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
>             <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
>                 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
>             </encoder>
>         </appender>
>     
>         <logger name="org.apache.ibatis" level="TRACE">
>     
>         </logger>
>         <logger name="java.sql.Connection" level="DEBUG">
>     
>         </logger>
>         <logger name="java.sql.Statement" level="DEBUG">
>     
>         </logger>
>         <logger name="java.sql.PreparedStatement" level="DEBUG">
>     
>         </logger>
>         
>         
>         <root level="DEBUG">
>             <appender-ref ref="STDOUT">
>     
>             </appender-ref>
>             <appender-ref ref="FILE">
>     
>             </appender-ref>
>         </root>
>     
>     </configuration>
> 
>     <?xml version="1.0" encoding="UTF-8" ?>
>     
>     <configuration debug="false">
>         <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
>             <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
>                 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
>             </encoder>
>         </appender>
>     
>         <logger name="org.apache.ibatis" level="TRACE">
>     
>         </logger>
>         <logger name="java.sql.Connection" level="DEBUG">
>     
>         </logger>
>         <logger name="java.sql.Statement" level="DEBUG">
>     
>         </logger>
>         <logger name="java.sql.PreparedStatement" level="DEBUG">
>     
>         </logger>
>         
>         
>         <root level="DEBUG">
>             <appender-ref ref="STDOUT">
>     
>             </appender-ref>
>             <appender-ref ref="FILE">
>     
>             </appender-ref>
>         </root>
>     
>     </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>
>         
>         <properties resource="jdbc.properties"/>
>         <settings>
>             <setting name="logImpl" value="SLF4J"/>
>         </settings>
>         <environments default="development">
>             <environment id="development">
>                 <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"></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>
>         
>         <properties resource="jdbc.properties"/>
>         <settings>
>             <setting name="logImpl" value="SLF4J"/>
>         </settings>
>         <environments default="development">
>             <environment id="development">
>                 <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"></mapper>
>             
>             
>         </mappers>
>     </configuration>

>     jdbc.driver=com.mysql.cj.jdbc.Driver
>     jdbc.url=jdbc:mysql://localhost:13306/powernode
>     jdbc.username=root
>     jdbc.password=abc123
> 
>     jdbc.driver=com.mysql.cj.jdbc.Driver
>     jdbc.url=jdbc:mysql://localhost:13306/powernode
>     jdbc.username=root
>     jdbc.password=abc123

>     <?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">
>     
>     <mapper namespace="account">
>     </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">
>     
>     <mapper namespace="account">
>     </mapper>

>     package com.powernode.bank.utils;
>     
>     import org.apache.ibatis.io.Resources;
>     import org.apache.ibatis.session.SqlSession;
>     import org.apache.ibatis.session.SqlSessionFactory;
>     import org.apache.ibatis.session.SqlSessionFactoryBuilder;
>     
>     import java.io.IOException;
>     
>     public class SqlSessionUtil
>     {
>         private SqlSessionUtil(){}
>         private static SqlSessionFactory sqlSessionFactory;
>         static
>         {
>             try
>             {
>                 sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("Mybatis-config.xml"));
>             }
>             catch (IOException e)
>             {
>                 throw new RuntimeException(e);
>             }
>         }
>         public static SqlSession openSession()
>         {
>             return sqlSessionFactory.openSession();
>         }
>     }
> 
>     package com.powernode.bank.utils;
>     
>     import org.apache.ibatis.io.Resources;
>     import org.apache.ibatis.session.SqlSession;
>     import org.apache.ibatis.session.SqlSessionFactory;
>     import org.apache.ibatis.session.SqlSessionFactoryBuilder;
>     
>     import java.io.IOException;
>     
>     public class SqlSessionUtil
>     {
>         private SqlSessionUtil(){}
>         private static SqlSessionFactory sqlSessionFactory;
>         static
>         {
>             try
>             {
>                 sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("Mybatis-config.xml"));
>             }
>             catch (IOException e)
>             {
>                 throw new RuntimeException(e);
>             }
>         }
>         public static SqlSession openSession()
>         {
>             return sqlSessionFactory.openSession();
>         }
>     }

>     package com.powernode.bank.POJO;
>     
>     public class Account
>     {
>         //封装账户数据
>         private Long id;
>         private String actno;
>         private Double balance;
>     
>         @Override
>         public String toString() {
>             return "Account{" +
>                     "id=" + id +
>                     ", actno='" + actno + '\'' +
>                     ", balance=" + balance +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getActno() {
>             return actno;
>         }
>     
>         public void setActno(String actno) {
>             this.actno = actno;
>         }
>     
>         public Double getBalance() {
>             return balance;
>         }
>     
>         public void setBalance(Double balance) {
>             this.balance = balance;
>         }
>     
>         public Account(Long id, String actno, Double balance) {
>             this.id = id;
>             this.actno = actno;
>             this.balance = balance;
>         }
>     
>         public Account() {
>         }
>     }
> 
>     package com.powernode.bank.POJO;
>     
>     public class Account
>     {
>         //封装账户数据
>         private Long id;
>         private String actno;
>         private Double balance;
>     
>         @Override
>         public String toString() {
>             return "Account{" +
>                     "id=" + id +
>                     ", actno='" + actno + '\'' +
>                     ", balance=" + balance +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getActno() {
>             return actno;
>         }
>     
>         public void setActno(String actno) {
>             this.actno = actno;
>         }
>     
>         public Double getBalance() {
>             return balance;
>         }
>     
>         public void setBalance(Double balance) {
>             this.balance = balance;
>         }
>     
>         public Account(Long id, String actno, Double balance) {
>             this.id = id;
>             this.actno = actno;
>             this.balance = balance;
>         }
>     
>         public Account() {
>         }
>     }