Java learning notes 51 (integrated project: home accounting system)

This case almost uses all the contents of the first 50 articles to realize a simple family accounting software Function: add, delete, modify, query by criteria Required jar package: commons-dbcp-1.4.jar commons-pool-1.5.6.jar mysql-connector-java-5.1.37-bin.jar commons-dbutils-1.6.jar   Database table creation: /* Create database Name gjp ...

Added by yashvant on Sat, 02 May 2020 22:52:29 +0300

Simple operation of php and mysql

mysql is a fast, reliable and easy-to-use database system running on the server, which is often combined with php for web development. There are two ways for php to connect to mysql: mysql i ('i 'means improved): only for mysql pdo (php data objects): can be used in many databases mysqli connection mode can be divide ...

Added by hightechredneck on Sat, 02 May 2020 00:52:55 +0300

Get database metadata

MySQL provides a variety of methods to obtain database metadata (information about the database and various objects in it): *Various SHOW statements, such as SHOW DATABASES or SHOW TABLES; *Information? Table in schema database; *Command line programs, such as mysqlshow or mysqldump. Use SHOW statement to get metadata -- List accessible ...

Added by riyaz123 on Thu, 30 Apr 2020 21:47:29 +0300

gorm series - Update

Catalog Gorm update operation Update all fields Update modified fields Update selected fields No Hooks updates Batch update Update with SQL expression Modify values in Hooks Other update options Gorm update operation Update all fields Save() updates all fields of the object by default, even if you don't have an assignment. package main im ...

Added by deft on Mon, 27 Apr 2020 18:54:52 +0300

CentOS7 Installation\Uninstall MySQL

1. Download and install MySQL's official Yum Repository [root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm Install MySQL Server root@localhost ~]# yum -y install mysql-community-server 2. MySQL database settings Start MySQL [root@localhost ~]# systemctl start mysqld.service View MySQL r ...

Added by tweet on Sun, 26 Apr 2020 19:48:31 +0300

Java project creation -- unified result processing and exception handling

1, IDEA plug-in use 1. Description Spring boot 2.2.6, JDK 1.8 and mysql 8.0.18 are used as demonstration here. Use IDEA as a development tool.   2. IDEA plug-in -- Lombok (1) IntroductionLombok can automatically generate constructor, getter/setter, equals, hashcode, toString and other methods for properties during compilation through annotation ...

Added by juneym on Sun, 26 Apr 2020 14:45:44 +0300

Security mode of MYSQL: introduction to SQL safe updates

What is safe mode In mysql, if the where condition is not added to update and delete, all data will be modified. It's not only the developers who are new to MySQL that will encounter this problem, but also the engineers who have some experience will inevitably forget to write where conditions. In order to avoid all data modification and deleti ...

Added by tyler on Thu, 23 Apr 2020 17:03:38 +0300

Upfront - backstage - environment building

1, Create pom project Name: atcrowdfunding01-admin-parent GroupId: com.atguigu.crowd 2, Create module: atcrowdfinding02 admin webui atcrowdfunding02-admin-webui 3, Create module: atcrowdfinding03 admin component     4, Create module: atcrowdfunding 04 admin entity   5, Create module: atcrowdfinding05 commo ...

Added by bacil on Tue, 21 Apr 2020 17:15:44 +0300

[interesting case] Python command line implementation - check the national 7-day weather

Why climb the weather? 1. You can practice. 2. After using the itchat library to realize the function of automatic reply, integrate the function of weather check, and realize the function of wechat self-service weather check! First of all, it's a similar pattern. Let's see if we can grab a general API directly on the official website (XHR). The ...

Added by expertis on Tue, 21 Apr 2020 10:55:26 +0300

Transaction control configuration based on xml file

Configure transaction manager <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/myword"></property> <property name="username" ...

Added by blt2589 on Tue, 21 Apr 2020 06:49:54 +0300