esclipse连接mysql数据库

1）eclipse开发环境里没有集成mysql的驱动，需要从以下地址下载连接驱动程序mysql-connector-java-XX-XX-XX.zip：

http://dev.mysql.com/downloads/connector/j

2）解压，只取文件mysql-connector-java-XX.XX.XX-bin.jar，将其引用到你需要连接mysql数据库的工程里，如：我在eclipsel里建了一个测试数据库连接的工程ConMysql。具体操作如下：

   在工程ConMysql上点击右键

   properties->Java Build Path->Libraries

   点击Add External JARS...

   选取解压后的mysql-connector-java-XX.XX.XX-bin.jar

2）驱动已经导入，下面我们来写一个程序验证一下

<span style="font-size: 13px"><span style="color: #0000ff">package</span><span style="color: #000000"> test1;
</span><span style="color: #0000ff">import</span> java.sql.*<span style="color: #000000">;
</span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> MysqlJdbc {
  </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">static</span> <span style="color: #0000ff">void</span><span style="color: #000000"> main(String args[]) {
    </span><span style="color: #0000ff">try</span><span style="color: #000000"> {
      Class.forName(</span>"com.mysql.jdbc.Driver");     <span style="color: #008000">//</span><span style="color: #008000">加载MYSQL JDBC驱动程序   
      </span><span style="color: #008000">//</span><span style="color: #008000">Class.forName("org.gjt.mm.mysql.Driver");</span>
     System.out.println("Success loading Mysql Driver!"<span style="color: #000000">);
    }
    </span><span style="color: #0000ff">catch</span><span style="color: #000000"> (Exception e) {
      System.out.print(</span>"Error loading Mysql Driver!"<span style="color: #000000">);
      e.printStackTrace();
    }
    </span><span style="color: #0000ff">try</span><span style="color: #000000"> {
      Connection connect </span>=<span style="color: #000000"> DriverManager.getConnection(
          </span>"jdbc:mysql://localhost:3306/test1","root","Aa-12345"<span style="color: #000000">);
           </span><span style="color: #008000">//</span><span style="color: #008000">连接URL为   jdbc:mysql</span><span style="color: #008000">//</span><span style="color: #008000">服务器地址/数据库名  ，后面的2个参数分别是登陆用户名和密码</span>
<span style="color: #000000">
      System.out.println(</span>"Success connect Mysql server!"<span style="color: #000000">);
      Statement stmt </span>=<span style="color: #000000"> connect.createStatement();
      ResultSet rs </span>= stmt.executeQuery("select * from stu"<span style="color: #000000">);
                                                              </span><span style="color: #008000">//</span><span style="color: #008000">user 为你表的名称</span>
<span style="color: #0000ff">while</span><span style="color: #000000"> (rs.next()) {
        System.out.println(rs.getString(</span>"name"<span style="color: #000000">));
      }
    }
    </span><span style="color: #0000ff">catch</span><span style="color: #000000"> (Exception e) {
      System.out.print(</span>"get data error!"<span style="color: #000000">);
      e.printStackTrace();
    }
  }
}</span></span>

点击运行程序：出现以下代码则表示连接成功

Success loading Mysql Driver!
Success connect Mysql server!
npu(mysql里自己写入的内容)

esclipse连接mysql数据库

标签：creates   运行程序   UI   loading   驱动程序   import   数据库名   mysq   bin