龙空技术网

五分钟学会Mybatis通过Mapper代理连接数据库

KK星牛通 369

前言:

目前看官们对“apache如何连接数据库”大概比较看重,咱们都想要分析一些“apache如何连接数据库”的相关内容。那么小编同时在网上搜集了一些关于“apache如何连接数据库””的相关文章,希望兄弟们能喜欢,大家快快来学习一下吧!

fromname,message,toname,类型为varchar2.创建对应的pojo实体类,注意类型要和数据库创建类型一致,如varchar()对应的是java.lang.String

schema名字,数据库username和password输入自己的账号和密码,而在下方mapper则是用于注册我们待会要写的xml文件,路径用/ 写上xml的全名称。

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"        ";><configuration>    <!--配置Mybatis运行环境-->    <environments default="development"><!--default命名-->        <environment id="development"><!--和上面的一致-->            <transactionManager type="JDBC"></transactionManager><!--事务管理 交给JDBC-->            <!-- 数据源 -->            <dataSource type="POOLED">                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>                <property name="url" value="jdbc:mysql://localhost:3306/bjpower?        useUnicode=true&characterEncoding=UTF-8"/>                <property name="username" value="root"/>                <property name="password" value="xxxx"/>            </dataSource>        </environment>    </environments>     <mappers><!--        <mapper resource="com/yyj/repository/msgdataRepository.xml"></mapper>-->        <mapper resource="com/yyj/repository/msgdatanewRepository.xml"></mapper>    </mappers></configuration>
4.自定义接口,在repository包下自定义接口,待会在xml中实现即可5.在repository中建立对应的xml文件,如我取的名称为MsgdatanewReposiotory,名字可自定义,注意mapper注册和改名字一样即可,然后编写sql语句

statement 的 id 为接⼝中对应的⽅法名

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"        ";><mapper namespace="com.yyj.repository.MsgdatanewRepository"><!--接口全类名-->    <insert id="save1" parameterType="com.yyj.pojo.MessageData">        <!--parameterType为传入的参数类型,是刚刚设置的pojo类-->        insert into msgdatanew(fromname,message,toname) values (#{fromName},#{message},#{toName})    </insert>        <!--resultType为返回值类型-->    <select id="findByName1" parameterType="java.lang.String"            resultType="com.yyj.pojo.MessageData">        select * from msgdatanew where toname = #{toName}    </select></mapper>
6.调用测试类即可,注意要添加commit事务才能提交成功,数据库才有变化
package com.yyj.Test; import com.yyj.pojo.MessageData;import com.yyj.repository.MsgdatanewRepository;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder; import java.io.InputStream; public class Test2 {//    public void add(String toName,String message,String fromName){public static void main(String[] args) {    InputStream inputStream = Test2.class.getClassLoader().getResourceAsStream("config.xml");    SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();    SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);    SqlSession sqlSession = sqlSessionFactory.openSession();    MsgdatanewRepository msgdatanewRepository = sqlSession.getMapper(MsgdatanewRepository.class);    MessageData messageData=new MessageData();    messageData.setMessage("nihaoyayay");    messageData.setFromName("lisi");    int save = msgdatanewRepository.save1(messageData);    System.out.println(save);    sqlSession.commit();}}
7.效果展示

8.附上pom.xml文件

<?xml version="1.0" encoding="UTF-8"?><project xmlns="; xmlns:xsi=";         xsi:schemaLocation=" ;>    <modelVersion>4.0.0</modelVersion>    <groupId>com.demo</groupId>    <artifactId>websocket-chatroom</artifactId>    <version>0.0.1-SNAPSHOT</version>    <name>websocket-chatroom</name>    <description>WebSocket示例工程</description>     <properties>        <java.version>1.8</java.version>        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>        <spring-boot.version>2.3.7.RELEASE</spring-boot.version>    </properties>     <dependencies>        <!--mybatis-->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.4.5</version>        </dependency>        <!--mysql驱动-->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>8.0.27</version>        </dependency>         <dependency>            <groupId>org.projectlombok</groupId>            <artifactId>lombok</artifactId>        </dependency>         <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-web</artifactId>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-websocket</artifactId>        </dependency>         <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-devtools</artifactId>            <scope>runtime</scope>            <optional>true</optional>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-test</artifactId>            <scope>test</scope>            <exclusions>                <exclusion>                    <groupId>org.junit.vintage</groupId>                    <artifactId>junit-vintage-engine</artifactId>                </exclusion>            </exclusions>        </dependency>    </dependencies>     <dependencyManagement>        <dependencies>            <dependency>                <groupId>org.springframework.boot</groupId>                <artifactId>spring-boot-dependencies</artifactId>                <version>${spring-boot.version}</version>                <type>pom</type>                <scope>import</scope>            </dependency><!--            <!– ehcache –>--><!--            <dependency>--><!--                <groupId>net.sf.ehcache</groupId>--><!--                <artifactId>ehcache-core</artifactId>--><!--                <version>2.4.3</version>--><!--            </dependency> <dependency>--><!--            <groupId>org.mybatis</groupId>--><!--            <artifactId>mybatis-ehcache</artifactId>--><!--            <version>1.0.0</version>--><!--        </dependency>-->        </dependencies>      </dependencyManagement>     <build>        <plugins>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-compiler-plugin</artifactId>                <version>3.8.1</version>                <configuration>                    <source>1.8</source>                    <target>1.8</target>                    <encoding>UTF-8</encoding>                </configuration>            </plugin>            <plugin>                <groupId>org.springframework.boot</groupId>                <artifactId>spring-boot-maven-plugin</artifactId>                <version>2.3.7.RELEASE</version>                <configuration>                    <mainClass>com.yyj.WebsocketChatroomApplication</mainClass>                </configuration>                <executions>                    <execution>                        <id>repackage</id>                        <goals>                            <goal>repackage</goal>                        </goals>                    </execution>                </executions>            </plugin>        </plugins>         <resources>            <resource>                <directory>src/main/java</directory>                <includes>                    <include>**/*.xml</include>                </includes>            </resource>        </resources>    </build>  </project>

标签: #apache如何连接数据库