my eclipse 连接数据库（详细步骤）

曾经终败给现在 2022-06-11 03:57 217阅读 0赞

# MyEclipse实现数据库的简单连接 #

1，新建一个dynamic web工程。点击file--new--other然后选择dynamic web工程进行下一步

![Image 1][]

![Center][]

2.测试名字我设置为JDBCTest,建好后如下图

![Image 1][]

![Center 1][]

3.用Java连接数据库需要用到jar包，这里的jar包是mysql-connector-java-5.0.8-bin

然后把jar包添加到工程中

①　工程右击选择properties如图

![Center 2][]

②　    点击 ADD ExternalJARs...后，选择jar包所在的路径然后点击最后打开即可，

如下图

![Center 3][]

③　最后效果图为：

![Center 4][]

④　点击OK后工程根目录下也会多出相关驱动：

![Center 5][]

4，建一个class,在class中写相关代码。数据库的连接主要包括以下几个步骤

a,加载驱动

b，建立连接

c，创建sql语句

d，发送sql语句

5，相关代码：

C++ Code

<table style="width:100%; font-family:'Consolas','Courier New'; font-size:12px; vertical-align:text-top; line-height:15px"> 
 <tbody> 
 <tr> 
 <td style="color:#008284; background-color:#e3e3e3; vertical-align:text-top"> 
 <div style="margin:7px; text-align:right; white-space:nowrap">
 1 
 2 
 3 
 4 
 5 
 6 
 7 
 8 
 9 
 10 
 11 
 12 
 13 
 14 
 15 
 16 
 17 
 18 
 19 
 20 
 21 
 22 
 23 
 24 
 25 
 26 
 27 
 28 
 29 
 30 
 31 
 32 
 33 
 34 
 35 
 36 
 37 
 38 
 39 
 40 
 
 </div> </td> 
 <td style="background-color:#008284; padding:1px"> 
 <div style="border:1px #008284 solid"></div> </td> 
 <td style="background-color:rgb(239,239,239); width:100%; vertical-align:text-top"> 
 <div style="margin:7px">
 import&nbsp;java.sql.*;&nbsp; 
 
 public&nbsp; 
 class&nbsp;Test&nbsp; 
 {&nbsp; 
 &nbsp; 
 public&nbsp; 
 static&nbsp; 
 void&nbsp;main(String&nbsp;args[])&nbsp; 
 &nbsp;{&nbsp; 
 &nbsp; 
 try&nbsp;{&nbsp; 
 &nbsp;&nbsp;Class.forName( 
 "com.mysql.jdbc.Driver");&nbsp;&nbsp; 
 //加载MYSQL&nbsp;JDBC驱动程序&nbsp; &nbsp;&nbsp; 
 //Class.forName("org.gjt.mm.mysql.Driver");&nbsp; &nbsp;&nbsp;System.out.println( 
 "Success&nbsp;loading&nbsp;Mysql&nbsp;Driver!");&nbsp; 
 &nbsp;}&nbsp; 
 &nbsp; 
 catch&nbsp;(Exception&nbsp;e) 
 &nbsp;{&nbsp; 
 &nbsp;&nbsp;System.out.print( 
 "Error&nbsp;loading&nbsp;Mysql&nbsp;Driver!");&nbsp; 
 &nbsp;&nbsp;e.printStackTrace();&nbsp; 
 &nbsp;}&nbsp; 
 &nbsp; 
 &nbsp; 
 try 
 &nbsp;{&nbsp; 
 &nbsp;&nbsp;Connection&nbsp;connect&nbsp;=&nbsp;DriverManager.getConnection(&nbsp; 
 &nbsp;&nbsp;&nbsp; 
 "jdbc:mysql://localhost:3306/world", 
 "****", 
 "*****");&nbsp; 
 &nbsp;&nbsp;&nbsp; 
 //连接URL为&nbsp;jdbc:mysql//服务器地址/数据库名&nbsp;，后面的2个参数分别是登陆用户名和密码&nbsp; &nbsp;&nbsp; 
 &nbsp;&nbsp;System.out.println( 
 "Success&nbsp;connect&nbsp;Mysql&nbsp;server!");&nbsp; 
 &nbsp;&nbsp; 
 &nbsp;&nbsp;Statement&nbsp;stmt&nbsp;=&nbsp;connect.createStatement();&nbsp; 
 &nbsp;&nbsp;ResultSet&nbsp;rs&nbsp;=&nbsp;stmt.executeQuery( 
 "select&nbsp;*&nbsp;from&nbsp;city");&nbsp; 
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 //user&nbsp;为你表的名称&nbsp; &nbsp;&nbsp; 
 while&nbsp;(rs.next()) 
 &nbsp;&nbsp;{&nbsp; 
 &nbsp;&nbsp;System.out.println(rs.getString( 
 "name"));&nbsp; 
 &nbsp;&nbsp;}&nbsp; 
 &nbsp;&nbsp; 
 &nbsp;}&nbsp; 
 &nbsp; 
 catch&nbsp;(Exception&nbsp;e) 
 &nbsp;{&nbsp; 
 &nbsp;&nbsp;System.out.print( 
 "get&nbsp;data&nbsp;error!");&nbsp; 
 &nbsp;&nbsp;e.printStackTrace();&nbsp; 
 &nbsp;}&nbsp; 
 &nbsp;}&nbsp; 
 } 
 </div> </td> 
 </tr> 
 </tbody> 
</table>

6，连接成功后的效果图为：

![Center 6][]

[Image 1]: 
[Center]: /images/20220611/d532632c925046b8b5b92416dd642d9b.png
[Center 1]: /images/20220611/65537c54530f4ddba9a2376fda19c386.png
[Center 2]: /images/20220611/d84e21be8c1f4bc7bf0967744c829ba2.png
[Center 3]: /images/20220611/39c3ab267b7a48eba95312d4b3323526.png
[Center 4]: /images/20220611/20a3acd19cd4478b87a70e84716fba78.png
[Center 5]: /images/20220611/7f9a1896bf5149de93edd90b4f2d5130.png
[Center 6]: /images/20220611/f1c6376fe0384d7282a706efd09ee8e0.png