菜鸟教你连接数据库!!!
时间:2021-07-01 10:21:17
帮助过:16人阅读
一、我们建一个项目,项目名为(work)。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644915504.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644916481.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644918434.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644920387.png)
1、在src中,开始建一个entity包,里面放了一个(Work)实体类;
![技术分享](http://images2015.cnblogs.com/blog/1153283/201706/1153283-20170621141634835-1556989905.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644923317.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644927223.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644928200.png)
2、在(Work)实体类中,定义sno,name,birt这三个属性,都是私有的;
![技术分享](http://images2015.cnblogs.com/blog/1153283/201706/1153283-20170621143511366-470646994.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644933083.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644934060.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644936989.png)
二、实体类我们已经弄完了,接下来要在MySQL数据库中创建一个表,表名为(work)。
1、先进到dos命令中
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644937966.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644939919.png)
2.创建一个数据库,名字为(test2)自定义的。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644940896.png)
进入数据库的命令
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644941872.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644942849.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644944802.png)
三、数据库建完表后,我们就弄web层代码。
1、创建一个名为index的jsp文件。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644945779.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644947732.png)
2、创建一个action包,里面放一个servlet控制器,我们命名为WorkAction。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644948709.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644950662.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644951638.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644953592.png)
四、接下来要弄业务层(service),建一个service包,里面放一个WorkService接口和WorkServiceImplement实现类。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644955545.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644956521.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644958475.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644959451.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644960428.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644962381.png)
五、最后弄数据层(dao),建一个dao包,里面有WorkDao接口和WorkDaoImpl实现类。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644963358.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644964334.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644965311.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644966287.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644968241.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644970194.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644971170.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644972147.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644974100.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644975077.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180110233644976053.png)
菜鸟教你连接数据库!!!
标签:com png img http 控制 实体 分享 bsp 连接数据库