How to import mysql into eclipse?

In the process of software or website development, database connection is very necessary. I wonder if you are learning how to connect eclipse to mysql? Friends who don’t know can learn it with me. Friends who don’t know can also take a look and review it. Please correct me if I am wrong.

Import mysql--conncetor --java--jars into Eclipse

Right-click on the project item in Eclipse and click Build Path->Configure Build Path-->Libraries- ->Add External JARs (add local jars package)-->Apply

Connection code:

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

The above is the detailed content of How to import mysql into eclipse?. For more information, please follow other related articles on the PHP Chinese website!