数据库学习（MySQL）：JDBC的简单增删改查实现

本文为原创，转载请注明出处：

https://www.cnblogs.com/Tom-shushu/p/9171896.html

这里我们先在数据库建立一个userinfo表：

CREATE TABLE userinfo (
    userid` INT (11),
    userName VARCHAR (180),
    userSex CHAR (27),
    userAge INT (11),
    userAddress VARCHAR (900)
);

随便添加几项内容：

INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('1','肖军','男','18','汉中');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('2','折为成','女','50','西安');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('3','田野','男','25','北京');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('4','折挨成','男','33','香港');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('5','折改何','女','41','商洛');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('6','张飞','男','18','洋县');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('7','郝埃连','女','55','西安');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('8','丁冬芹','女','23','北京');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('9','孙立军','男','48','苏州');
INSERT INTO `userinfo` (`userid`, `userName`, `userSex`, `userAge`, `userAddress`) VALUES('10','张虎豹','男','57','洛杉矶');

然后进行操作：

一。进行查找

备注：我这里的数据库名为userinfo ,表名为userinfo