Mbatis select update delete insert tag attribute set

<select id="selectUser" //Method corresponding to PersonMapper.java interface parameterType="int" //Input parameter format resultType="hashmap" //Return data type. When multiple parameters are returned, resultMap is recommended. resultMap="userResultMap" //The data type returned is equivalent to encapsulating resultT ...

Posted by eheia on Tue, 19 Mar 2019 03:15:26 -0700

[Solved] spring+mybatis+mysql can select but can not insert, no error, that is, no data is written

Premise: web development, spring+mybatis+mysql, using mybatis to automatically generate plug-ins to automatically generate various classes, mapping documents and so on from database forms. Symptoms: When the user registration function is implemented, it is found that insert user data is not available. When the controller calls the insert met ...

Posted by marijn on Tue, 12 Feb 2019 17:30:17 -0800

Springboot integrates general Mapper and Pagehelper to realize mybatis+Druid multi-data source configuration

1. As a supplement to the previous one, this article can be referred to.     https://my.oschina.net/swiftloop/blog/1031404 2. Realization     1)pom.xml <?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.apa ...

Posted by Assim on Mon, 11 Feb 2019 08:45:17 -0800

Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed

background mybatis is used only, but spring is not used because it involves multiple data sources, so each query uses the mapper factory method to create mappers to execute select or Update. Executor was closed when the same mapper executed select and executed update. Solve Log 2018-05-30 17:09:58,941 DEBUG [org.apache ...

Posted by JayFM on Wed, 06 Feb 2019 08:54:16 -0800

mybatis realizes data addition, deletion and alteration checking

Concept: mybatis is a persistence framework, a top-level project under apache Let the program focus on sql, through the mapping method provided by mybatis, free and flexible generation of SQL statements needed. The parameters in the prepareStatement can be automatically input mapped, and the query result set can be flexibly mapped ...

Posted by gnunoob on Thu, 31 Jan 2019 03:36:14 -0800

MyBatis Learning (6)

This video viewing address: https://edu.51cto.com/sd/3ec2c 1. Caching 1.1. The Significance of Caching By putting the data that users often query in the cache (memory), users can query the data from the cache instead of from the disk (relational database data files), thus improving the query efficiency and solving the performance problems of ...

Posted by prue_ on Wed, 30 Jan 2019 20:45:15 -0800

Spring+zookeeper+dubbo to build the framework of micro-service project

The whole project source code has been submitted to Github, you can see: Project source address 1. First of all, the project structure is built. Hierarchical multi-module web project (micro-service architecture)Spring MVC+Spring+mybatis-plus integrated redis commons-parent is the version information of the maven jar package for the parent proj ...

Posted by sajy2k on Tue, 29 Jan 2019 15:57:16 -0800

SpringBoot (V) Java implements people nearby based on MySQL

The function of "people in the vicinity" is not unfamiliar. Similar functions were first contacted by maps applications, such as searching nearby cinemas, supermarkets and so on. Nevertheless, it is the function of Wechat "people around" that really makes the nearby people popular in the north and south of the Yangtze Ri ...

Posted by sridhar golyandla on Sun, 27 Jan 2019 21:27:15 -0800

Analysis and Solution of mysql Error Duplicate Key Exception

When doing database synchronization, an error was found. mysql reported the following error: org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:XXX ### The error may involve com.jd.medicine.b2c.trade.center.daoHistory.RxOrd ...

Posted by edraynham on Sun, 27 Jan 2019 12:12:15 -0800

Proficiency in SpringBoot - Article 13: Integrating Mybatis Multiple Data Sources

Long time no see, recently passed a period of burnout, this period of time do not have motivation, procrastination recurrence. Fortunately, I'm back... - From me.Getting into today's topic, integrating mybatis multiple data sources in Spring Book project, is actually simple, but not difficult.Overall project structure and data source configurat ...

Posted by Jeroen_nld on Sun, 27 Jan 2019 03:42:14 -0800