Review of JDBC and summary of tools

Article directory Summary JDBC JDBC access database steps jdbc common interface 1. Statement interface Three Statement classes Common Statement transaction management Time type 1. java.util.Date Date comparison processing Text storage CLOB Related types in mysql BLOB Related types in Mysql ...

Posted by crimsonmoon on Fri, 17 Jan 2020 07:15:00 -0800

Address book management system based on JDBC

Article directory 1. Design stage 1.1 demand analysis 1.2 function diagram of address book management system 1.3 use case diagram of address book management system 1.4 E-R diagram of address book management system 2. Database design 3. Program design 2.1function 2.1.1 design ContactPerson class 2 ...

Posted by teng84 on Tue, 14 Jan 2020 20:58:32 -0800

Data connection pool - DBCP

I think DBCP is a little more complex than c3p0, but DBCP also has a certain share of use, so I recommend learning it To establish a DBCP connection pool: 1. Import jar package (DBCP needs more jars, four) Don't mention the jar package for operating the database, as mentioned in the last blog commons-dbcp2-2.5.0.jar and com ...

Posted by DonelleJenae on Sun, 12 Jan 2020 07:35:01 -0800

springmvc+spring4.2+hibernate5 Integrated Records

1, Profile There are a lot of jar packages involved. Here I choose to help me manage jars by maven <?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.apache. ...

Posted by uglyrat on Sun, 12 Jan 2020 06:08:38 -0800

eclipse tool Java connects to MySQL version 8.0 database

1, Preliminary preparation 1. First, ensure that MySQL version 8.0 database is installed on the host 2. Go to the official website to download the database connection tool. MySQL version 8.0 database requires the latest connect jar connector. Otherwise, an exception of "Could not create connection to database server - ja ...

Posted by soccer022483 on Wed, 08 Jan 2020 10:10:16 -0800

Agent mechanism of spring boot project [1]

This is the first article to understand the Spring proxy mechanism, trying to understand how Spring implements Bean registration and proxy. This article will raise the question: will Spring register beans and create proxy objects with Jdk proxy or cglib? 1 project preparation 1.1 create a Spring Boot project Create a Spring Boot project that ...

Posted by mrfritz379 on Tue, 07 Jan 2020 03:22:55 -0800

Spring MVC and Mybaits integration

Integration steps Guide bag 1.spring (including spring MVC) 2.mybatis 3. Mybatis spring integration package 4. Database drive 5. Third party connection pool. Configure the web.xml file spring listener and front-end controller as well as solving the Chinese scrambling of post submission request <?xml version="1.0" e ...

Posted by mark bowen on Mon, 06 Jan 2020 19:16:00 -0800

Encapsulation of Java database connection, close, add, delete, modify and query methods (2) implementation of add, delete, modify and query

According to the article "JDBC util tool class of Java database connection, close, add, delete and modify query method encapsulation (1)", it realizes the connection, close, add, delete and modify query tool class. Then we will analyze it further. 1. First, edit an entity class and put it in the entry package accordi ...

Posted by plsanders on Mon, 06 Jan 2020 08:26:20 -0800

Implementation of inheriting JDBC daosupport (add, delete, modify and query)

First, create database tables and corresponding fields, and create constraints Second, build the project, import the jar package (ioc,aop,dao, database driver, connection pool) and put the applicationContext.xml file under src 3. Enable component scanning and configure data source 4. Write an entity class (provide get set) method, toString(), w ...

Posted by Devil_Banner on Sat, 04 Jan 2020 11:23:16 -0800

java database connection pool configuration

jar package required for connection pool configuration Servlet api.jar imports the jar package under Tomcat directory by itself. If there are no other jar packages See download link ----- > download (there's no way to set it as free, set it as the lowest point to download) Download portal 2: YouDaoNote These jar packag ...

Posted by coldwerturkey on Wed, 01 Jan 2020 18:04:42 -0800