从昨晚开始做家庭财经系统。不要以为有系统两个字就怎么复杂,都是大家都会的。建库、建表。
第一个使用软件是mysql
2021.05.26
数据库 lianxi 已建好。
表 members_basic_information(家庭财经系统)已建好。
mysql> select * from members_basic_information
-> ;
Empty set (0.00 sec)
mysql> desc members_basic_information;
±---------------------±-------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±---------------------±-------------±-----±----±--------±---------------+
| Members_Id | int(11) | NO | PRI | NULL | auto_increment |
| Members_nickName | varchar(30) | YES | UNI | NULL | |
| Members_Name | varchar(30) | YES | | NULL | |
| Member_ship | varchar(20) | YES | | NULL | |
| Membership_number | int(11) | YES | | NULL | |
| Registered_residence | varchar(20) | YES | | NULL | |
| Occupation | varchar(20) | YES | | NULL | |
| Remarks | varchar(150) | YES | | NULL | |
±---------------------±-------------±-----±----±--------±---------------+
8 rows in 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)
Copyright © 2000, 2021, Oracle and/or its affiliates.
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)
Copyright © 2000, 2021, Oracle and/or its affiliates.
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>