实验八 JDBC.zip 3.78MB

2301_81125866需要积分:5(1积分=1元)

资源文件列表:

实验八 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工程，几年前做的，以用于实际项目的运行	10.41MB	4月前

	WTI测试用例-weihua	376.82KB	4月前
	303009557022761DRV8825步进电机驱动器板-3D打印机（1个）MK658.zip	184.14KB	4月前
	ACS400-2.2KW变频器图纸	115.82KB	4月前
	大学英语Pre展示原文+翻译+ppt汇报+学术海报(ppt)	8.81MB	4月前

	HP150系列打印机定影器单元清零	2.9MB	4月前
	springboot红色旅游城市风貌展示平台（附源码+数据库）31956	26.61MB	4月前
	springboot天文科普网站（附源码+数据库）31654	53.31MB	4月前