Shulou(Shulou.com)06/02 Report--

This article mainly shows you "Mybatis how to connect to the database through the Mapper agent", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how Mybatis connects to the database through the Mapper agent" this article.

1. Create tables and corresponding fields in the database, as shown in the following figure. I created three fields named fromname,message,toname and type varchar.

two。 Create the corresponding pojo entity class. Note that the type should be the same as the database creation type, for example, varchar () corresponds to java.lang.String.

3. Configure config.xml under the resource path, configure the running environment of Mybatis 3306 / followed by your own database schema name, database username and password enter your own account and password, while the mapper below is used to register the xml file we are going to write later, and the path uses / writes the full name of xml.

4. Custom API. Customize the API under the repository package, which can be implemented in xml later.

5. Set up the corresponding xml file in repository. If I choose the name MsgdatanewReposiotory, the name can be customized. Note that mapper registration is the same as changing the name, and then write the sql statement.

The id of statement is the corresponding password name in the receiver.

Insert into msgdatanew (fromname,message,toname) values (# {fromName}, # {message}, # {toName}) select * from msgdatanew where toname = # {toName}

6. Just call the test class. Note that you need to add commit transactions to successfully commit and change the database.

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. Effect display

8. Attached is the pom.xml file

4.0.0 com.demo websocket-chatroom 0.0.1-SNAPSHOT websocket-chatroom WebSocket sample Project 1.8 UTF-8 UTF-8 2.3.7.RELEASE org.mybatis mybatis 3.4.5 mysql Mysql-connector-java 8.0.27 org.projectlombok lombok org.springframework.boot spring-boot-starter-web org.springframework.boot spring-boot-starter-websocket org.springframework.boot Spring-boot-devtools runtime true org.springframework.boot spring-boot-starter-test test org.junit.vintage junit-vintage-engine Org.springframework.boot spring-boot-dependencies ${spring-boot.version} pom import org.apache.maven.plugins maven-compiler- Plugin 3.8.1 1.8 1.8 UTF-8 org.springframework.boot spring-boot-maven-plugin 2.3.7.RELEASE Com.yyj.WebsocketChatroomApplication repackage repackage Src/main/java * * / *. Xml is all the content of the article "how Mybatis connects to the database through the Mapper agent" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.