Home > Java > javaTutorial > How to import mysql into eclipse?

How to import mysql into eclipse?

little bottle
Release: 2020-09-14 17:50:49
Original
8724 people have browsed it

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();
    }
  }
}
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template