Google's younger brother learns backstage (--mysql) (1)

Explore the puzzles of Android soft keyboard
Delve into Android Async Essentials Handler
The essential cornerstone of Android's mainstream framework
Standing on the shoulder of the source code full solution scroller working mechanism

Android multi-resolution adaptation framework (1)-Core Foundation
Android multi-resolution adaptation framework (2)-Principle analysis
Android multi-resolution adaptation framework (3)-User Guide

Custom View Series Tutorial 00– Overthrow yourself and the past, re-learn custom view
Custom View Series Tutorials 01– Common Tools Introduction
Custom View Series Tutorial 02–onmeasure Source detailed analysis
Custom View Series Tutorial 03–onlayout Source detailed analysis
Custom View Series Tutorial 04–draw source code Analysis and its practice
Custom View Series Tutorial 05– Sample Analysis
Custom View Series Tutorial 06– Detailed View Touch event handling
Custom View Series Tutorial 07– ViewGroup distributing Touch events
Custom View Series Tutorial 08– the generation and processing of sliding conflicts

Copyright Notice

• This article original Google's younger brother
• Author Blog address: HTTP://BLOG.CSDN.NET/LFDFHL

Opening words

I was originally engaged in mobile app development, and then I slowly learned the front end, such as HTML, CSS, JavaScript. One day when writing code, feel the heart empty, always feel almost what. I stopped tapping on the keyboard finger, staring at the API that the page was ready to invoke; At this point, I understand the heart of the vacancy: I should learn some background development technology.

As for the content of the study, the current plan is: MySQL, Spring, Hibernate, Struts, JDBC, MyBatis, SPRINGMVC, and so on.

Well, let's start with this idea!

Learning Materials

• Struts
• Spring
• Hibernate
• A tutorial on the development of Wisdom Podcast Java
• Classic Java EE enterprise application Combat
• A detailed description of Tomcat and Java Web Development technology

Basic concepts of databases

database (db for short)
Database refers to a  that is stored on a computer storage device for a long time and is organized according to certain rules that can be shared by users or applications. In essence, database is a file system.

Database Management System (DBMS for short)
The database Management system is a large software that operates and manages databases, so it is essentially a management software that allows users to access data in a database through a database management system. The primary function of database Management system is to establish databases, use databases, maintain databases, and unify the database to ensure the security and integrity of the database.

Common database management Systems (DB Management System)

• Oracle
  Oracle is a relational database management system. It is characterized by: stable operation, complete functions, excellent performance, mainly used in large-scale enterprise database field.
• DB2
  DB2 is developed by IBM Corporation. It is characterized by: good scalability, mainly used in large-scale applications, can support from mainframe to single-user environment.
• SQL Server
  SQL Server was developed by Microsoft. It is characterized by: friendly interface, simple operation, mainly used in e-commerce, Enterprise ERP, invoicing and other software
• Mysql
  MySQL belongs to the Swedish MySQL AB product. The SQL language used by MySQL is the most commonly used standardized language for accessing databases; it is characterized by small size, fast speed and low cost, mainly in small and medium-sized application systems.

installation steps for MySQL

In this study backstage development process, I use is MySQL, therefore this takes MySQL5.6 as the example detailed record its installation process.

First step: Double-click the installation file

Step Two: Start the installation

Tick the I accept the license terms and click Next to start the installation

Step Three: Select the installation type

Tick Developer Default and click Next to continue the installation

Fourth Step: Check the installation requirements

Click Next to continue the installation

Fifth step: Perform the installation

Click Execute to continue the installation, the process takes a few minutes, please wait patiently

Sixth Step: Installation Complete

Click Next to enter the MySQL configuration process

Seventh step: Start configuring MySQL

Click Next to continue configuring MySQL

Eighth step: Configuration type and port number

Click Next to continue configuring MySQL

Nineth Step: Set a password with root privileges

Set the password to root, then click Next to continue configuring MySQL

Tenth step: Configure Windows Services

You can modify the Windows Service Name on Demand, and then click Next to continue configuring MySQL

11th Step: Determine the server configuration

Click Execute to continue the configuration

12th Step: Installation Complete

Click Finish to complete the installation

13th Step: Open the Service

Click Next

Click Check

Click Next

Click Execute

Click Finish

Click Next

Click Finish to complete the installation and configuration of MySQL.

Configuring environment variables for MySQL

1. Locate the path where the MySQL bin file is located

For example: C:\Program files\mysql\mysql Server 5.6\bin

2. Add the path to the system's path

Please note the semicolon before and after the path;

3. Enter Mysql-u root-p in the command line

Enter back

4. Enter the password root in the command line

Input after enter after success

Google's younger brother learns backstage (--mysql) (1)