#1. Explain the role of namespace in MyBatis.
In large projects, there may be a large number of SQL statements. At this time, it is not easy to give each SQL statement a unique identification (ID). In order to solve this problem, in MyBatis, you can create a unique namespace for each mapping file, so that each SQL statement defined in this mapping file becomes an ID defined in this namespace.
As long as we can ensure that this ID is unique in each namespace, even if the statement IDs in different mapping files are the same, conflicts will no longer occur.
(Recommended tutorial: java quick start)
2. What does dynamic SQL in MyBatis mean?
For some complex queries, we may specify multiple query conditions, but these conditions may or may not exist. If we do not use the persistence layer framework, we may need to assemble the SQL statements ourselves. , but MyBatis provides dynamic SQL functionality to solve this problem.
The elements used to implement dynamic SQL in MyBatis mainly include:
- if - choose / when / otherwise - trim - where - set - foreach
Usage examples:
<select id="foo" parameterType="Blog" resultType="Blog"> select * from t_blog where 1 = 1 <if test="title != null"> and title = #{title} </if> <if test="content != null"> and content = #{content} </if> <if test="owner != null"> and owner = #{owner} </if> </select>
3. What are the shortcomings of JDBC programming? How does MyBatis solve these problems??????
MyBatis: Configure the data link pool in SqlMapConfig.xml and use the connection pool to manage database links. (2) JDBC: Sql statements are written in the code, making the code difficult to maintain. The actual application of sql may change greatly, and sql changes require changes to the java code. MyBatis: Configure the Sql statement in the XXXXmapper.xml file and separate it from the java code. (3) JDBC: It is troublesome to pass parameters to the sql statement, because the where condition of the sql statement is not necessarily certain, it may be more or less, and the placeholders need to correspond to the parameters one-to-one. MyBatis: Mybatis automatically maps java objects to sql statements. (4) JDBC: It is troublesome to parse the result set. SQL changes lead to changes in the parsing code, and it needs to be traversed before parsing. It would be more convenient to parse the database records into pojo objects. MyBatis: Mybatis automatically maps sql execution results to java objects.4. What are the differences between MyBatis and Hibernate?
(1) Mybatis is different from hibernate. It is not entirely an ORM framework because MyBatis requires programmers to write SQL statements themselves. However, mybatis can flexibly configure the SQL statements to be run through XML or annotations. , and map java objects and sql statements to generate the final executed sql, and finally map the results of sql execution to generate java objects.
(2) Mybatis has a low learning threshold and is easy to learn. Programmers can directly write original SQL, which can strictly control SQL execution performance. It is highly flexible and is very suitable for software development that does not have high requirements for relational data models, such as Internet software, enterprise operation software, etc., because the demand for this type of software changes frequently, once the demand changes, the results must be output quickly. However, the premise of flexibility is that mybatis cannot be database independent. If you need to implement software that supports multiple databases, you need to customize multiple sets of sql mapping files, which is a heavy workload. (3) Hibernate has strong object/relational mapping capabilities and good database independence. For software with high requirements on relational models (such as customized software with fixed requirements), if you use hibernate to develop it, you can save a lot of code and improve efficiency. However, the disadvantage of Hibernate is that the threshold for learning is high, and the threshold for mastery is even higher. Moreover, how to design O/R mapping, how to weigh the performance and object model, and how to use Hibernate well requires strong experience and ability.? ? ? ? In short, as long as a software architecture with good maintainability and scalability can be made according to the needs of users in a limited resource environment, it is a good architecture, so the framework is only the best if it is suitable.5. Briefly talk about the first-level cache and second-level cache of MyBatis?
Mybatis first queries the result set in the cache. If there is no result set, it queries the database. If there is, it retrieves the result set from the cache and returns it without going to the database. Mybatis internal storage cache uses a HashMap, and the key is hashCode sqlId Sql statement. value is the java object generated by mapping from the query.
Mybatis's second-level cache is the query cache. Its scope is the namespace of a mapper. That is, querying SQL in the same namespace can obtain data from the cache. The second-level cache can span SqlSession. Recommended related video tutorials:java video tutorial
The above is the detailed content of Java persistence layer interview questions (2). For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

To correctly handle JDBC transactions, you must first turn off the automatic commit mode, then perform multiple operations, and finally commit or rollback according to the results; 1. Call conn.setAutoCommit(false) to start the transaction; 2. Execute multiple SQL operations, such as INSERT and UPDATE; 3. Call conn.commit() if all operations are successful, and call conn.rollback() if an exception occurs to ensure data consistency; at the same time, try-with-resources should be used to manage resources, properly handle exceptions and close connections to avoid connection leakage; in addition, it is recommended to use connection pools and set save points to achieve partial rollback, and keep transactions as short as possible to improve performance.

TheJVMenablesJava’s"writeonce,runanywhere"capabilitybyexecutingbytecodethroughfourmaincomponents:1.TheClassLoaderSubsystemloads,links,andinitializes.classfilesusingbootstrap,extension,andapplicationclassloaders,ensuringsecureandlazyclassloa

Use classes in the java.time package to replace the old Date and Calendar classes; 2. Get the current date and time through LocalDate, LocalDateTime and LocalTime; 3. Create a specific date and time using the of() method; 4. Use the plus/minus method to immutably increase and decrease the time; 5. Use ZonedDateTime and ZoneId to process the time zone; 6. Format and parse date strings through DateTimeFormatter; 7. Use Instant to be compatible with the old date types when necessary; date processing in modern Java should give priority to using java.timeAPI, which provides clear, immutable and linear

Pre-formanceTartuptimeMoryusage, Quarkusandmicronautleadduetocompile-Timeprocessingandgraalvsupport, Withquarkusoftenperforminglightbetterine ServerLess scenarios.2.Thyvelopecosyste,

Networkportsandfirewallsworktogethertoenablecommunicationwhileensuringsecurity.1.Networkportsarevirtualendpointsnumbered0–65535,withwell-knownportslike80(HTTP),443(HTTPS),22(SSH),and25(SMTP)identifyingspecificservices.2.PortsoperateoverTCP(reliable,c

Java's garbage collection (GC) is a mechanism that automatically manages memory, which reduces the risk of memory leakage by reclaiming unreachable objects. 1.GC judges the accessibility of the object from the root object (such as stack variables, active threads, static fields, etc.), and unreachable objects are marked as garbage. 2. Based on the mark-clearing algorithm, mark all reachable objects and clear unmarked objects. 3. Adopt a generational collection strategy: the new generation (Eden, S0, S1) frequently executes MinorGC; the elderly performs less but takes longer to perform MajorGC; Metaspace stores class metadata. 4. JVM provides a variety of GC devices: SerialGC is suitable for small applications; ParallelGC improves throughput; CMS reduces

Gradleisthebetterchoiceformostnewprojectsduetoitssuperiorflexibility,performance,andmoderntoolingsupport.1.Gradle’sGroovy/KotlinDSLismoreconciseandexpressivethanMaven’sverboseXML.2.GradleoutperformsMaveninbuildspeedwithincrementalcompilation,buildcac

defer is used to perform specified operations before the function returns, such as cleaning resources; parameters are evaluated immediately when defer, and the functions are executed in the order of last-in-first-out (LIFO); 1. Multiple defers are executed in reverse order of declarations; 2. Commonly used for secure cleaning such as file closing; 3. The named return value can be modified; 4. It will be executed even if panic occurs, suitable for recovery; 5. Avoid abuse of defer in loops to prevent resource leakage; correct use can improve code security and readability.
