实验八 JDBC.zip

2301_81125866实验八 JDBC.zip 3.78MB

资源文件列表:

实验八 JDBC.zip 大约有4个文件

librarydb.sql 950B
mysql-connector-j-9.0.0.jar 2.47MB
实验八.docx 200.68KB
数据库设计与练习.pptx 1.53MB

资源介绍:

实验八 JDBC.zip

<link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90114433/2/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90114433/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">实验八<span class="_ _0"></span>：基于<span class="_ _1"> </span><span class="ff2 sc1">Java JDBC<span class="_"> </span></span>的图书<span class="_ _0"></span>增删改<span class="_ _0"></span>查</div><div class="t m0 x2 h3 y2 ff1 fs1 fc0 sc0 ls0 ws0">实验目标</div><div class="t m0 x3 h4 y3 ff3 fs2 fc0 sc1 ls0 ws0">了解数据库的基本操作，包括安装数据库、创建数据库、创建表等。</div><div class="t m0 x3 h4 y4 ff3 fs2 fc0 sc1 ls0 ws0">学习通过<span class="_ _2"> </span><span class="ff4">JDBC<span class="_"> </span></span>连接数据库并进行基本的增删改查操作。</div><div class="t m0 x3 h4 y5 ff3 fs2 fc0 sc1 ls0 ws0">使用<span class="_ _2"> </span><span class="ff4">Java<span class="_"> </span></span>和<span class="_ _2"> </span><span class="ff4">JDBC<span class="_"> </span></span>实现图书信息的管理。</div><div class="t m0 x2 h3 y6 ff1 fs1 fc0 sc0 ls0 ws0">实验环境</div><div class="t m0 x3 h4 y7 ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff3">数据库：<span class="ff4">MySQL</span></span></div><div class="t m0 x3 h4 y8 ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff3">数据库管理系统：<span class="ff4">Navicat for MySQL</span>、<span class="ff4">HeidiSQL</span>、<span class="ff4">MySQL Workbench<span class="_"> </span></span>等</span></div><div class="t m0 x3 h4 y9 ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff3">下载网址：<span class="fc1">吾要是知<span class="ff4"> <span class="_"> </span>| <span class="_"> </span></span>知之为知之<span class="ff4"> <span class="_"> </span></span>不知需求是<span class="ff4"> <span class="_"> </span>— it<span class="_"> </span></span>开发者社区</span></span></div><div class="t m0 x3 h4 ya ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff3">下载网址：<span class="fc1">搜索：<span class="ff4">Navicat for MySQL - <span class="_"> </span></span>悠久的小宝库</span></span></div><div class="t m0 x3 h4 yb ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff4"> <span class="_"> </span><span class="ff3">编程语言：</span>Java</span></div><div class="t m0 x3 h4 yc ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff4">Java<span class="_"> </span><span class="ff3">开发工具：</span>Eclipse/IntelliJ IDEA<span class="_"> </span><span class="ff3">或其他<span class="_ _2"> </span></span>IDE</span></div><div class="t m0 x3 h4 yd ff5 fs2 fc0 sc1 ls0 ws0"><span class="_ _3"> </span><span class="ff4">MySQL JDBC<span class="_"> </span><span class="ff3">驱动</span></span></div><div class="t m0 x2 h3 ye ff1 fs1 fc0 sc0 ls0 ws0">实验内容</div><div class="t m0 x4 h5 yf ff6 fs1 fc0 sc0 ls0 ws0">数据库的<span class="_ _0"></span>安装和基本<span class="_ _0"></span>操作</div><div class="t m0 x3 h4 y10 ff2 fs2 fc0 sc1 ls0 ws0">MySQL<span class="_"> </span><span class="ff6 sc0">安装</span><span class="ff3">：</span></div><div class="t m0 x5 h4 y11 ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">提供<span class="_ _5"> </span><span class="ff4">MySQL<span class="_ _5"> </span></span>安装的详细步骤或参考链接，<span class="_ _6"></span>确保学生能够顺利安装<span class="_ _5"> </span><span class="ff4">MySQL</span>。</span></div><div class="t m0 x5 h4 y12 ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">配置<span class="_ _2"> </span><span class="ff4">MySQL<span class="_"> </span></span>的环境变量和设置密码。</span></div><div class="t m0 x3 h4 y13 ff3 fs2 fc0 sc1 ls0 ws0">自行百度【<span class="ff4">MySQL<span class="_"> </span></span>的下载安装与配置】</div><div class="t m0 x3 h4 y14 ff3 fs2 fc0 sc1 ls0 ws0">例如<span class="_ _7"></span>：<span class="_ _7"></span><span class="ff4 fc1">MYSQL_<span class="ff3">安装与配置（超详细，仅需一篇就能帮你成功安装<span class="_ _2"> </span></span>MYSQL<span class="ff3">）</span>-CSDN<span class="_"> </span><span class="ff3">博</span></span></div><div class="t m0 x2 h4 y15 ff3 fs2 fc1 sc1 ls0 ws0">客</div><div class="t m0 x3 h4 y16 ff6 fs2 fc0 sc0 ls0 ws0">数据库的创建<span class="_ _0"></span><span class="ff3 sc1">：</span></div><div class="t m0 x5 h4 y17 ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">使用<span class="ff4"> <span class="_"> </span></span>之前下载安装的数据库管理系统<span class="ff4"> <span class="_"> </span></span>连接到<span class="_ _2"> </span><span class="ff4">MySQL<span class="_"> </span></span>数据库。</span></div><div class="t m0 x5 h4 y18 ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">在<span class="ff4"> <span class="_"> </span></span>数<span class="_ _0"></span>据库<span class="_ _0"></span>管理系<span class="_ _0"></span>统<span class="ff4"> <span class="_ _8"> </span></span>中执行<span class="_ _8"> </span><span class="ff4">SQL<span class="_"> </span></span>命令<span class="_ _0"></span>来创<span class="_ _0"></span>建一<span class="_ _0"></span>个名为<span class="_ _8"> </span><span class="ff4">LibraryDB<span class="_"> </span></span>的数<span class="_ _0"></span>据</span></div><div class="t m0 x6 h4 y19 ff3 fs2 fc0 sc1 ls0 ws0">库。</div><div class="t m0 x5 h4 y1a ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">参考上课的时候的创建数据库的语句（见<span class="_ _2"> </span><span class="ff4">PPT</span>）<span class="ff4"> <span class="_"> </span></span>或<span class="ff4"> <span class="_"> </span></span>自行百度</span></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90114433/bg2.jpg"><div class="t m0 x3 h4 y1b ff6 fs2 fc0 sc0 ls0 ws0">创建图书表</div><div class="t m0 x5 h4 y1c ff7 fs3 fc0 sc1 ls0 ws0">�<span class="_ _4"> </span><span class="ff3 fs2">参考上课的时候的创建数据表的语句（见<span class="_ _2"> </span><span class="ff4">PPT</span>）<span class="ff4"> <span class="_"> </span></span>或<span class="ff4"> <span class="_"> </span></span>自行百度</span></div><div class="t m0 x4 h5 y1d ff2 fs1 fc0 sc1 ls0 ws0">JDBC<span class="_"> </span><span class="ff6 sc0">的配置和<span class="_ _0"></span>基础操作</span></div><div class="t m0 x3 h4 y1e ff6 fs2 fc0 sc0 ls0 ws0">添加<span class="_ _2"> </span><span class="ff2 sc1">JDBC<span class="_"> </span></span>驱动：</div><div class="t m0 x7 h4 y1f ff3 fs2 fc0 sc1 ls0 ws0">下载<span class="_ _2"> </span><span class="ff4">MySQL JDBC<span class="_"> </span></span>驱动<span class="_ _9"></span>（<span class="ff4">mysql-connector-java.jar</span>）<span class="_ _9"></span>并将其导入到<span class="_ _2"> </span><span class="ff4">IDE<span class="_"> </span></span>项目中。<span class="_ _9"></span>压</div><div class="t m0 x3 h4 y20 ff3 fs2 fc0 sc1 ls0 ws0">缩包已提供。</div><div class="t m0 x7 h4 y21 ff3 fs2 fc0 sc1 ls0 ws0">手动导入<span class="_ _2"> </span><span class="ff4">jar<span class="_"> </span></span>包操作可自行百度【怎么在<span class="_ _2"> </span><span class="ff4">IDEA<span class="_"> </span></span>中手动导入<span class="_ _2"> </span><span class="ff4">jar<span class="_"> </span></span>包】<span class="ff4"> <span class="_"> </span></span>或参考</div><div class="t m0 x7 h4 y22 ff3 fs2 fc0 sc1 ls0 ws0">链接：<span class="ff4 fc1">idea<span class="_"> </span><span class="ff3">如何导入<span class="_ _2"> </span></span>jar<span class="_"> </span><span class="ff3">包</span>(<span class="ff3">详细</span>)_idea<span class="_"> </span><span class="ff3">引入本地<span class="_ _2"> </span></span>jar-CSDN<span class="_"> </span><span class="ff3">博客</span></span></div><div class="t m0 x3 h4 y23 ff6 fs2 fc0 sc0 ls0 ws0">连接数据库<span class="ff3 sc1">：</span></div><div class="t m0 x7 h4 y24 ff3 fs2 fc0 sc1 ls0 ws0">在<span class="_ _2"> </span><span class="ff4">Java<span class="_"> </span></span>代码中，编写连接数据库的代码，确保连接成功。</div><div class="t m0 x4 h5 y25 ff3 fs1 fc2 sc1 ls0 ws0">其中<span class="_ _a"> </span><span class="ff4">username<span class="_ _b"></span></span>、<span class="ff4">password<span class="_ _c"> </span></span>以及<span class="_ _a"> </span><span class="ff4">url<span class="_ _a"> </span></span>都<span class="_ _0"></span>是<span class="_ _0"></span>自己<span class="_ _0"></span>系统<span class="_ _0"></span>设置<span class="_ _0"></span>的<span class="_ _0"></span>，</div><div class="t m0 x2 h5 y26 ff3 fs1 fc2 sc1 ls0 ws0">这一点提醒你注意！<span class="_ _d"></span>！<span class="_ _d"></span>！</div><div class="t m0 x4 h5 y27 ff6 fs1 fc0 sc0 ls0 ws0">总结实验<span class="_ _0"></span>步骤</div><div class="t m0 x3 h4 y28 ff4 fs2 fc0 sc1 ls0 ws0">1.<span class="_ _3"> </span><span class="ff3">安装并配置<span class="_ _2"> </span></span>MySQL<span class="_"> </span><span class="ff3">数据库。</span></div><div class="t m0 x3 h4 y29 ff4 fs2 fc0 sc1 ls0 ws0">2.<span class="_ _3"> </span><span class="ff3">使用<span class="_ _2"> </span></span>SQL<span class="_"> </span><span class="ff3">语句在<span class="_ _2"> </span></span>MySQL<span class="_"> </span><span class="ff3">中创建<span class="_ _2"> </span></span>LibraryDB<span class="_"> </span><span class="ff3">数据库和<span class="_ _2"> </span></span>Books<span class="_"> </span><span class="ff3">表。</span></div><div class="t m0 x3 h4 y2a ff4 fs2 fc0 sc1 ls0 ws0">3.<span class="_ _3"> </span><span class="ff3">在<span class="_ _2"> </span></span>Java<span class="_"> </span><span class="ff3">项目中添加<span class="_ _2"> </span></span>MySQL JDBC<span class="_"> </span><span class="ff3">驱动。</span></div><div class="t m0 x3 h4 y2b ff4 fs2 fc0 sc1 ls0 ws0">4.<span class="_ _3"> </span><span class="ff3">编写<span class="_ _2"> </span></span>DatabaseConnection<span class="_"> </span><span class="ff3">类实现数据库的连接。</span></div><div class="t m0 x3 h4 y2c ff4 fs2 fc0 sc1 ls0 ws0">5.<span class="_ _3"> </span><span class="ff3">完<span class="_ _0"></span>成<span class="_ _0"></span>图<span class="_ _0"></span>书<span class="_ _0"></span>管<span class="_ _0"></span>理<span class="_ _0"></span>系<span class="_ _0"></span>统<span class="_ _b"></span>的<span class="_ _0"></span>功<span class="_ _0"></span>能<span class="_ _0"></span>代<span class="_ _0"></span>码<span class="_ _0"></span>，<span class="_ _0"></span>包<span class="_ _0"></span>括<span class="_ _8"> </span></span>addBook<span class="_ _0"></span><span class="ff3">、<span class="_ _b"></span></span>searchBook<span class="_ _0"></span><span class="ff3">、<span class="_ _0"></span></span>updateBookStatus<span class="_ _0"></span><span class="ff3">、</span></div><div class="t m0 x8 h4 y2d ff4 fs2 fc0 sc1 ls0 ws0">deleteBook<span class="_"> </span><span class="ff3">等方法。</span></div><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div>

100+评论昵称:

captcha

ModbusRTU用于STM32的模板，基于Keil工程，几年前做的，以用于实际项目的运行
ModbusRTU用于STM32的模板，基于Keil工程，几年前做的，以用于实际项目的运行
硬件开发
Modbus案例+资料.zip 10.41MB
6 月前

WTI测试用例-weihua
WTI测试用例-weihua
后端
cloud_llm-master.zip 376.82KB
6 月前
303009557022761DRV8825步进电机驱动器板-3D打印机（1个）MK658.zip
303009557022761DRV8825步进电机驱动器板-3D打印机（1个）MK658.zip
行业研究
303009557022761DRV8825步进电机驱动器板-3D打印机（1个）MK658.zip 184.14KB
6 月前
ACS400-2.2KW变频器图纸
ACS400-2.2KW变频器图纸
行业研究
ABB.zip 115.82KB
6 月前
大学英语Pre展示原文+翻译+ppt汇报+学术海报(ppt)
学术海报想要有其他格式都可以由ppt格式进行导出
考试认证
英语展示MyEPRE.zip 8.81MB
6 月前

HP150系列打印机定影器单元清零
HP150系列打印机定影器单元清零
操作系统
HP 150A 150NW 清零软件.zip 2.9MB
6 月前
springboot红色旅游城市风貌展示平台（附源码+数据库）31956
1、设计和开发一个基于SpringBoot的红色旅游城市风貌展示平台。2、实现用户注册、登录、搜索景点、查看景点详情、购买旅游产品、对景点信息、商品信息进行修改等基本功能以及实现红色旅游文化或茶文化模块的特色功能。3、掌握SpringBoot框架的核心技术，如SpringMVC、MyBatis等，并能够灵活运用到实际项目中。4、掌握前端Vue框架的核心技术，包括Vue.js、ElementUI等，并能够根据实际需求进行定制化开发。5、通过测试和优化，提高平台的性能和稳定性，并保证平台的安全性和易用性.
后端
springboot红色旅游城市风貌展示平台[编号：project31956].zip 26.61MB
6 月前
springboot天文科普网站（附源码+数据库）31654
①、普通用户功能：主要包括注册登录、浏览天文知识、天文新闻与发现、天文活动与讲座、提问与讨论、个人设置与管理这六大功能模块。② 管理员功能：主要包括网站管理、文章发布与编辑、新闻和动态管理、活动管理、用户管理、问题回答与讨论、数据分析与报表生成这七大功能模块。
后端
springboot天文科普网站[编号：project31654](1).zip 53.31MB
6 月前