android - 将 MySQL 工作台连接到 Eclipse

Question

我对编程非常陌生，以前从未使用过 MySQL，所以请耐心等待!我正在尝试将 MySQL Workbench 连接到我的 Eclipse 项目，但我不知道从哪里开始。有人可以解释一下我需要经历的流程以及我将如何实现它们吗？

谢谢!

Answer 1

在Eclipse中创建一个java项目

创建包名称com.example.sql

在您的项目中包含mysqlconnector.jar

package com.example.sql;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCExample {
    public static Connection con;
  public static void main(String[] argv) {
      try
        {
            connectionQuery();

            PreparedStatement statement =  con.prepareStatement("SELECT * from table_name");/*write query inside of prepared statement*/
            ResultSet result = statement.executeQuery();
            System.out.println("DataBase table accessed");

            while(result.next())
            {
               String retrievedid= result.getString("Column_name");

               System.out.println(retrievedid);
            }


            con.close();
        }

        catch(Exception e)
        {
            e.printStackTrace();
            System.out.println(e.getMessage().toString());
        }
  }

  public static void connectionQuery()
  {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/boopathi","root","root");
            System.out.println("Remote DB connection established");
        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
            System.out.println("Remote server could not be connected");
        }
        catch (NullPointerException e)
        {
            e.printStackTrace();
            System.out.println("Remote server could not be connected");
        }
        catch (SQLException e)
        {
            e.printStackTrace();
            System.out.println("Remote db connection establishment error");
        }
        catch (Exception e)
        {
            e.printStackTrace();
            System.out.println("False query");
        }
    }
}

Refer this link also