2021.05.27 发表自己第一篇技术文章_技术文章发表-CSDN博客

本文链接：https://blog.csdn.net/songweixun/article/details/117323462

从昨晚开始做家庭财经系统。不要以为有系统两个字就怎么复杂，都是大家都会的。建库、建表。

第一个使用软件是mysql

2021.05.26
数据库 lianxi 已建好。
表 members_basic_information(家庭财经系统)已建好。
mysql> select * from members_basic_information
-> ;
Empty set (0.00 sec)

2021.05.27

插入数据
mysql> insert into members_basic_information(Members_ID,Members_nickName,Members_Name,Member_ship,Membership_number) VALUES(01,‘Li’,‘李朔’,‘爷爷’,1111111110);
ERROR 1366 (HY000): Incorrect string value: ‘\xE6\x9D\x8E\xE6\x9C\x94’ for column ‘Members_Name’ at row 1

出现报错。开始逐一插入。

mysql> insert into members_basic_information(Members_Id) VALUES(01);
Query OK, 1 row affected (0.01 sec)

插入 01 成功。

mysql> insert into members_basic_information(Members_Id,Members_nickName) VALUES(02,‘Li’);
Query OK, 1 row affected (0.00 sec)

插入02 和Li 成功。

mysql> insert into members_basic_information(Members_nickName,Members_Name) VALUES(‘Shuo’,‘李朔’);
ERROR 1366 (HY000): Incorrect string value: ‘\xE6\x9D\x8E\xE6\x9C\x94’ for column ‘Members_Name’ at row 1

插入第三列碰到和之前同样报错。上网查解决方案。
格式问题，查询后确认格式是 Latin1 。后面修改这个格式就可以了。
show create table members_basic_information;
| members_basic_information | CREATE TABLE members_basic_information (
Members_Id int(11) NOT NULL AUTO_INCREMENT,
Members_nickName varchar(30) CHARACTER SET latin1 DEFAULT NULL,
Members_Name varchar(30) CHARACTER SET latin1 DEFAULT NULL,
Member_ship varchar(20) CHARACTER SET latin1 DEFAULT NULL,
Membership_number int(11) DEFAULT NULL,
Registered_residence varchar(20) CHARACTER SET latin1 DEFAULT NULL,
Occupation varchar(20) CHARACTER SET latin1 DEFAULT NULL,
Remarks varchar(150) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (Members_Id),
UNIQUE KEY Members_nickName (Members_nickName)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 |

碰到插入汉字问题。表字符集修改，chartset为utf8
alter table members_basic_information default character set utf8;

字段字符集修改
alter table members_basic_information change name Members_Name varchar(255) character set utf8;

mysql> insert into members_basic_information(Members_nickName,Members_Name,Member_ship,Membership_number) VALUES(‘Song’,‘宋伟’,‘爸爸’,1111111110);
Query OK, 1 row affected (0.02 sec)

删除表清空数据再重新添加数据。

drop table members_basic_information;
添加一个新功能自动从01开始并且后一列数据+1自动增长。

mysql> alter table members_basic_information modify Members_Id integer default ‘01’;
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0

2021.05.29

插入数据
insert into members_basic_information(Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(‘Li’,‘李朔’,‘爷爷’,1111111110,‘山西’,‘退休’,‘户主’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(02,‘Wang’,‘王英’,‘奶奶’,1111111111,‘山西’,‘退休’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(03,‘LiWei’,‘李伟’,‘长子’,222222220,‘成都’,‘军人’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(04,‘ZhengQian’,‘郑茜’,‘长子妻’,222222221,‘上海’,‘销售’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(05,‘LiJuan’,‘李娟’,‘长女’,222222222,‘成都’,‘作家’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(06,‘ShiJin’,‘史进’,‘长女夫’,222222223,‘杭州’,‘教师’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(07,‘LiJian’,‘李健’,‘次子’,222222224,‘北京’,‘警察’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(08,‘YangLiu’,‘杨柳’,‘次子妻’,222222225,‘山西’,‘军人’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(09,‘LiHaiYang’,‘李海洋’,‘次女’,222222226,‘天津’,‘医生’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(10,‘LiuXiaoXuan’,‘刘晓轩’,‘次女夫’,222222227,‘天津’,‘自由职业者’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(11,‘LiYong’,‘李勇’,‘小儿子’,222222228,‘大连’,‘程序员’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation) VALUES(12,‘LinLei’,‘林蕾’,‘小儿子妻’,222222229,‘大连’,‘客服’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(13,‘LiXiao’,‘李笑’,‘小女儿’,222222230,‘山西’,‘助理’,‘未婚,预留一行’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(14,‘LiZhongMing’,‘李忠明’,‘孙子’,33333330,‘上海’,‘大学生’,‘长子李伟之子’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(15,‘LiQinQin’,‘李芹芹’,‘孙女’,33333331,‘杭州’,‘大学生’,‘长子李伟之女’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(16,‘ShiNing’,‘史宁’,‘二孙子’,33333332,‘成都’,‘中学生’,‘长女李娟之子,随父姓史’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(17,‘ShiJia’,‘史佳’,‘二孙女’,33333333,‘杭州’,‘中学生’,‘长女李娟之女,随父姓史’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(18,‘LiPi’,‘李皮’,‘小孙子’,33333334,‘天津’,‘小学生’,‘次子李健之子’);
insert into members_basic_information(Members_Id,Members_nickName,Members_Name,Member_ship,Membership_number,Registered_residence,Occupation,Remarks) VALUES(19,‘LiQinTian’,‘李晴天’,‘小孙女’,33333335,‘大连’,‘小学生’,‘次子李健之女’);

下载eclipse和JDK1.8.0并配置环境变量。

“属性”–>“高级系统设置”–>“环境变量”
根据您放置文件的路径在“环境变量”中进行修改

环境变量→新建 JAVA_HOME 变量。

变量值填写jdk的安装目录（本人是 E:\Java\jdk1.7.0)
环境变量→寻找 Path 变量→编辑

在变量值最后输入
%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;
（注意原来Path的变量值末尾有没有;号，如果没有，先输入；号再输入上面的代码）

环境变量→新建 CLASSPATH 变量

变量值填写
.;%JAVA_HOME%\lib;%JAVA_HOME%\lib\tools.jar（注意最前面有一点）

系统变量配置完毕

检验是否配置成功运行cmd 输入 java -version （java 和 -version 之间有空格）

2021.06.06
下载JDK1.8和JDBC

遇到mysql 对话框一闪而过问题。

CMD 中 C盘怎么切换到E盘。输入cd /d e:\回车就可以切换到E盘中

E:\Program Files\MySQL\MySQL Server 5.7>cd bin

E:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.34-log MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

e:>cd Program Files\MySQL\MySQL Server 5.7\bin
记录下bin的路径，出现新问题mysql黑框一闪而过。但可以用这种方式打开。

e:>cd Program Files\MySQL\MySQL Server 5.7\bin

e:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.34-log MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>