源代码地址(访问密码:7567):
https://url56.ctfile.com/f/34653256-530871914-801508
将页面中的数据逐步替换为数据库管理
准备一个连接数据库的类
![](https://img.haomeiwen.com/i7076276/ce83b49ef0a69f4e.png)
准备连接的方法
![](https://img.haomeiwen.com/i7076276/7eaf1c18786ff85a.png)
连接数据库的代码
![](https://img.haomeiwen.com/i7076276/afa3f4c2bfd9b749.png)
关闭数据库
![](https://img.haomeiwen.com/i7076276/6d232b42b5af4230.png)
测试一下
![](https://img.haomeiwen.com/i7076276/55cc7074d08a4f33.png)
连接成功
![](https://img.haomeiwen.com/i7076276/f48bc2f34889ba25.png)
准备一个连接数据库的类
![](https://img.haomeiwen.com/i7076276/354d9bd12027568a.png)
查询所有用户数据
![](https://img.haomeiwen.com/i7076276/2a2a3fac35eb931a.png)
代码实现
![](https://img.haomeiwen.com/i7076276/a3afc8b42d6b4f9c.png)
准备一个测试数据,表名为xhb,字段名字为yhm,mm
![](https://img.haomeiwen.com/i7076276/39487136cfb5922c.png)
准备执行SQL语句
![](https://img.haomeiwen.com/i7076276/eb7cdeef3a372543.png)
填充数据
![](https://img.haomeiwen.com/i7076276/a10dee1611e19ee6.png)
准备一个业务包
![](https://img.haomeiwen.com/i7076276/56d4644b35d14cad.png)
调用业务方法
![](https://img.haomeiwen.com/i7076276/4eb27efd06d74f41.png)
测试一下数据是否打印
![](https://img.haomeiwen.com/i7076276/c822bcc311e2aef7.png)
出现第一个错误表示表不存在
![](https://img.haomeiwen.com/i7076276/4600b17c7092f251.png)
这个位置改一下就可以
![](https://img.haomeiwen.com/i7076276/137be4e5680a5df6.png)
显示效果
![](https://img.haomeiwen.com/i7076276/7d38737567fa3dc1.png)
将之前的登录部分的代码进行一次更改,需要连接数据库进行操作
![](https://img.haomeiwen.com/i7076276/1a042899b5cf605a.png)
通过用户名,去数据库中查询,如果能够查询出数据,说明数据库中有该用户,如果查询不出,说明没有该用户。
![](https://img.haomeiwen.com/i7076276/b89e8b3d6a6c016f.png)
在业务层中添加用户名查询
![](https://img.haomeiwen.com/i7076276/623c99ea83c0265c.png)
调用业务层方法
![](https://img.haomeiwen.com/i7076276/2d9438d9ea116755.png)
添加Dao层的代码
![](https://img.haomeiwen.com/i7076276/736281295b8a6ef8.png)
准备SQL语句和参数
![](https://img.haomeiwen.com/i7076276/05ca38d4cdfe7526.png)
生成返回的数据
![](https://img.haomeiwen.com/i7076276/efd85f935b225d86.png)
可以在业务层使用Dao层的方法了
![](https://img.haomeiwen.com/i7076276/0495ea4a0c6e4baa.png)
查看效果
![](https://img.haomeiwen.com/i7076276/b7764f53f9928af5.png)
对的情况
![](https://img.haomeiwen.com/i7076276/a89c86d30852e1dc.png)
进行密码校验
![](https://img.haomeiwen.com/i7076276/5cf7c4ab9d7f77f4.png)
运行查看
![](https://img.haomeiwen.com/i7076276/235a14f3988f25cd.png)
如果用户名和密码正确
![](https://img.haomeiwen.com/i7076276/48a5df701fc1571f.png)
同样用户名返回的地方也要更改
![](https://img.haomeiwen.com/i7076276/e5331d25d768ebd3.png)
准备数据库
![](https://img.haomeiwen.com/i7076276/7c7ce4bb75a8bb7d.png)
数据库建表语句
![](https://img.haomeiwen.com/i7076276/50aecde6784f73d1.png)
建DAO层
![](https://img.haomeiwen.com/i7076276/bd6de0756f165c36.png)
返回全部数据的函数
第一段
![](https://img.haomeiwen.com/i7076276/e3c4d666063765a5.png)
第二段
![](https://img.haomeiwen.com/i7076276/5853dc1b26016c30.png)
第三段
![](https://img.haomeiwen.com/i7076276/8ed46d42575e3343.png)
第四段
![](https://img.haomeiwen.com/i7076276/26a5bcdd8b46f646.png)
准备业务层的调用
![](https://img.haomeiwen.com/i7076276/e481418cdc57a34d.png)
准备Dao的调用
![](https://img.haomeiwen.com/i7076276/194a04f20892e326.png)
在Controller中更改
![](https://img.haomeiwen.com/i7076276/944343cb3be9d7b6.png)
调用部分
![](https://img.haomeiwen.com/i7076276/5d48ffb68f46032a.png)
准备几个数据
![](https://img.haomeiwen.com/i7076276/d9d438fbbdeeb450.png)
测试页面
![](https://img.haomeiwen.com/i7076276/46cb27a7d9cea33b.png)
准备学生成绩信息管理界面的函数
![](https://img.haomeiwen.com/i7076276/834757ab14bb196a.png)
调用该函数
![](https://img.haomeiwen.com/i7076276/1ba2fe1334c9a07c.png)
准备菜单
![](https://img.haomeiwen.com/i7076276/8f2b4adb4abc9477.png)
结果测试
![](https://img.haomeiwen.com/i7076276/02ab626d9a3fb7dd.png)
完成菜单的跳转
![](https://img.haomeiwen.com/i7076276/015a0c876ce4a63c.png)
![](https://img.haomeiwen.com/i7076276/318057472d1defe3.png)
查看效果
![](https://img.haomeiwen.com/i7076276/100e7f1c1c5d3598.png)
显示所有学生成绩信息
![](https://img.haomeiwen.com/i7076276/41b8da7403473bd8.png)
调用函数
![](https://img.haomeiwen.com/i7076276/eff1d6155e953d4f.png)
建包建类
![](https://img.haomeiwen.com/i7076276/f2130af13c1b94f7.png)
准备四个属性
![](https://img.haomeiwen.com/i7076276/81907ee2db48552e.png)
快捷键shift+alt+s
选择Generate Getters and Setters
![](https://img.haomeiwen.com/i7076276/765a74ff766b178b.png)
出现如下效果
![](https://img.haomeiwen.com/i7076276/64c11625affdbb7e.png)
生成学生信息
![](https://img.haomeiwen.com/i7076276/424134b5b300fda6.png)
创建返回值
![](https://img.haomeiwen.com/i7076276/d21ceb8b9eaf0a06.png)
完成学生的添加
![](https://img.haomeiwen.com/i7076276/8a63ae83837a3441.png)
![](https://img.haomeiwen.com/i7076276/0585547c95db4fef.png)
调用显示
![](https://img.haomeiwen.com/i7076276/a3eaccf0ce9b4f55.png)
开始循环
![](https://img.haomeiwen.com/i7076276/10b598405d5077ad.png)
打印学生信息
![](https://img.haomeiwen.com/i7076276/bf0bd7f3d1785658.png)
调用打印就行了
![](https://img.haomeiwen.com/i7076276/e9732ca9a5d030ae.png)
显示结果
![](https://img.haomeiwen.com/i7076276/92421bce5ed95cc9.png)
网友评论