Eclpse IDE 連線MySQL 設定 @ 月曜

這篇我也卡了一段時間才解決，喜歡的朋友，請不吝惜給個讚加訂閱吧~

歡迎朋友一起進步~(我實測可行)我是用MySQL5.多版此為連線jar包

順便解說一下，如果不是IDE版是我也簡單說下就將我給的連線jar包，直接旁邊找個資料夾圖示Build Path，如圖 :

Add jar.jpg

接著就Add External JARS選擇你jar的路徑找到我給你的jar存進去。

注意:其實這個連線的jar不用import，但有些Jar要

注意2:你的資料庫名字跟使用者名稱及密碼不會跟我一樣

附上我的連線測試程式:

package TestConMySQL;
import java.sql.*;
public class TestConMySQL {

   public static void main(String[] args) {
       try {
           Class.forName("com.mysql.jdbc.Driver");
           Connection conn = DriverManager.getConnection(

//aaa="Your DataBase"，root= "Username", rootroot ="your password"
                   "jdbc:mysql://localhost:3306/aaa","root","rootroot");
           Statement stmt = conn.createStatement();
           //存放結果
           ResultSet rs = stmt.executeQuery("select * from stars");
           System.out.println("已經連上線了");
           while(rs.next()) {
               String name1 = rs.getString("name");
               String name2 = rs.getString("name");
               System.out.println(name1);
               System.out.println(name2);
           }

       }catch(Exception e) {
           e.printStackTrace();
       }
   }

}
--------------------------------------------------------------------------------------------------------------------

IDE版，我試過了很多方法就這個對我來說最有效。其實很簡單，秘訣就是灌對位置，我直接找lib資料夾複製貼上，如圖。

一開始先點你的專案資料夾然後如圖去找~一樣用上面的那個Jar

最後! 打開你的Eclipse IDE ，當你的lib資料夾底下有connector的jar就表示你成功了!

預祝成功囉!

測試的Java Servlet，相信會用IDE的玩家程度都很好，自己理解下吧w我懶了

package Servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class QueryUser
*/
@WebServlet("/QueryUser")
public class QueryUser extends HttpServlet {
private static final long serialVersionUID = 1L;

public QueryUser() {
super();
// TODO Auto-generated constructor stub
}

   protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   Connection con = null;
   Statement stmt = null;
   ResultSet rs = null;
   request.setCharacterEncoding("big5");
   response.setCharacterEncoding("big5");
   response.setContentType("big5");
   PrintWriter out = response.getWriter();
   out.println("<html><head></head><body>");
   try {
       Class.forName("com.mysql.jdbc.Driver");
       con = DriverManager.getConnection("jdbc:mysql://localhost/aaa","root","rootroot");
       stmt = con.createStatement();
       rs = stmt.executeQuery("select * from user");
       out.print("<table border ='1'>");
       while(rs.next()) {
           out.print("<tr>");
           out.print("<td>"+rs.getInt("id"));
           out.print("<td>"+rs.getString("name"));
           out.print("<td>"+rs.getString("passwd"));
           out.print("<td>"+rs.getString("email"));
           out.print("<td>"+rs.getString("city"));
       }
       out.println("</table>");
   } catch (Exception e) {
       out.println(e);
   }
   finally {
       try {
           con.close();
           stmt.close();
       } catch (SQLException e) {
           e.printStackTrace();
       }
   }
   }

   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated method stub
       doGet(request, response);
   }

}