JDBC连接MySQL5.7的方法

1.首先准备mysql 和eclipse环境，在环境搭建好之后，从eclipse官网下载jdbc的驱动包，下载地址http://dev.mysql.com/downloads/connector/j/

2.从下载的文件中取出mysql-connector-java-5.1.31-bin.jar，放到工程中，并导入路径

方法：右击工程名->Build Path->Configure Build Path,选择Add External JAR... 找到mysql-connector-java-5.1.31-bin.jar所在的位置，然后将驱动包加载到项目中，

3.写个例子测试一下

?

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

package testmysql; import java.sql.*; public class Test {      public static void main(String[] args) {      String driver = "com.mysql.jdbc.Driver" ;      String URL = "jdbc:mysql://localhost:3306/student" ;      Connection con = null ;      try      {        Class.forName(driver);      }      catch (java.lang.ClassNotFoundException e)      {        System.out.println( "Connect Successfull." );        System.out.println( "Cant't load Driver" );      }      try        {                                                con=DriverManager.getConnection(URL, "root" , "root" );        System.out.println( "Connect Successfull." );      }       catch (Exception e)      {        System.out.println( "Connect fail:" + e.getMessage());      }    } }

连接上数据库之后，可以根据表中的内容进行数据库表的查询，首先表中要有内容，将一些信息输入到表中之后即可使用SQL语言进行查询

?

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 41 42 43 44 45 46 47 48 49 50 51 52

import java.sql.*;  public class Main {        public static void main(String[] args) {       String driver = "com.mysql.jdbc.Driver" ;       String URL = "jdbc:mysql://localhost:3306/xiaolu" ;       Connection con = null ;      ResultSet rs = null ;      Statement st = null ;      String sql = "select * from student" ;      try      {         Class.forName(driver);       }       catch (java.lang.ClassNotFoundException e)       {         // System.out.println("Connect Successfull.");         System.out.println( "Cant't load Driver" );       }       try         {                                                 con=DriverManager.getConnection(URL, "root" , "root" );         st=con.createStatement();        rs=st.executeQuery(sql);        if (rs!= null ) {          ResultSetMetaData rsmd = rs.getMetaData();          int countcols = rsmd.getColumnCount();          for ( int i= 1 ;i<=countcols;i++) {            if (i> 1 ) System.out.print( ";" );            System.out.print(rsmd.getColumnName(i)+ " " );          }          System.out.println( "" );          while (rs.next()) {            System.out.print(rs.getString( "sno" )+ " " );            System.out.print(rs.getString( "sname" )+ " " );            System.out.print(rs.getString( "ssex" )+ " " );            System.out.print(rs.getString( "sage" )+ " " );            System.out.println(rs.getString( "sdept" )+ " " );          }        }        //System.out.println("Connect Successfull.");         System.out.println( "ok" );        rs.close();        st.close();        con.close();      }        catch (Exception e)       {         System.out.println( "Connect fail:" + e.getMessage());       }     }  }

关于JDBC连接MySQL5.7的文章就介绍到这，其他的可以查下服务器之家其它相关文章。

原文链接：https://blog.csdn.net/lxl121181/article/details/78056415