Programming VIP

MyBatis avoids almost all JDBC code and manual setting of parameters and getting result sets. But the cost is to need tedious configuration, but these configurations are almost the same, but they are very complex. With the help of plug-ins, you can write configuration files more easily, or record the co ...

step Import jar package Import c3p0-0.9.5.2.jar and mchange-commons-java-0.2.12.jar Define profileName: c3p0.properties or c3p0-config.xmlPath: put the file directly in the src directory <c3p0-config> <!-- Read connection pool objects using the default configuration --> <default- ...

1. JDBC Driver JDBC-driven loading: 1. Loading through containers: For Java applications with containers, the corresponding driver jar packages can be placed directly in the lib directory of the container, such as web applications using Tomcat as a container, and the driver can be copied to the lib subdirectory of tomcat. 2. Application Runtim ...

1, Statement interface introduction Function: object used to execute a static SQL statement and return the result it generates int executeUpdate(String sql) executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement, or an SQL statement that does not return anything, such as a SQLDDL statement. vo ...

MyBatis configuring dynamic SQL statements In the SQL mapping file of MyBatis, sometimes you need to select different SQL statements according to some query conditions. If you rewrite SQL in every scenario, it's obvious that the efficiency is not very high, and the dynamic SQL of MyBatis solves this problem well. The dynamic SQL of MyBatis pro ...

layout: post author: zjhChester header-img: img/post-bg-os-metro.jpg catalog: true tags: - ssm integration spring+springmvc+mybatis (ssm) integration 1. Preliminary preparation 1. Build maven project, check skeleton construction, check web app [external link image transfer failed. The sour ...

Reprinted from Reading the source code of mybatis (2): initialization of mybatis 1. Initialization entry //Mybatis obtains SqlSession through SqlSessionFactory, and then can interact with the database through SqlSession private static SqlSessionFactory getSessionFactory() { SqlSessionFactory se ...

1.orcale downloads sdk and installs 2. Download mycat https://github.com/MyCATApache/Mycat-download 3.server.xml <?xml version="1.0" encoding="UTF-8"?> <!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the Lic ...

This article comes from the "excellent course" -- to elaborate on the architecture. ORM (object relational mapping) is an excellent tool for database programming. With a little experience and the power of Java annotations, we can build complex database systems and take advantage of productivity relatively easily. Relational databases ...

1.JDBC introduction jdbc(java database connectivity) provides a unified programming interface for java developers to use the database. It consists of a set of java classes and interfaces. The classes and interfaces needed for JDBC are: DriverManager,Connection,Statement,ResultSet            2. Download MySQL connector Java The mysql version of ...