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