java连接mysql

来源：互联网发布：护盾手机数据恢复软件编辑：程序博客网时间：2024/06/08 14:16

java连接mysql

http://likeyi.iteye.com/blog/557664

1.下载jar包
网址:http://dev.mysql.com/downloads/
-->点击:"MySQL Connector/J 5.1 — Generally Available (GA) release (recommended)"
-->点击:(mysql-connector-java-5.1.10.zip)后面的download按钮
-->点击:"» No thanks, just take me to the downloads!"
-->随便选一个"HTTP"超链接，开始下载
2.在项目中导入下载的jar包 mysql-connector-java-5.1.10-bin.jar

提示：没有 mysql-connector-java-5.1.10-bin.jar 包的话会报错：

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

可以使用maven 工具导入依赖关系
3.打开mysql
4.编写代码

    package Test;            import java.sql.Connection;      import java.sql.DriverManager;      import java.sql.ResultSet;      import java.sql.Statement;            public class TestMySql      {          public static void main(String[] args)          {              try              {                  Statement stmt=null;                  ResultSet rs=null;                  Class.forName("com.mysql.jdbc.Driver");                  Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名称","root","123456");                   stmt = (Statement)conn.createStatement();                   rs = stmt.executeQuery("SELECT * from PetInfo");                         while (rs.next())                   {                        System.out.println(rs.getString(2));                  }               }              catch(Exception ex)              {                  ex.printStackTrace();              }          }      }

代码说明：

1、3306是默认端口号，查看mysql端口：

先登录mysql，然后输入命令

show global variables like 'port';

结果展示：

mysql> show global variables like 'port';+---------------+-------+| Variable_name | Value |+---------------+-------+| port          | 3306  |+---------------+-------+1 row in set (0.00 sec)

2、

 System.out.println(rs.getString(2));

这里好像是从1开始的，不是0.

0 0