標籤：
一、安裝MySQL並建立相應的資料庫和插入所要操作的資訊（如所示）
二、在Myeclipse中載入MySQL驅動
1）滑鼠右鍵 項目-->"Build Path"-->"Add Libraries..."-->選中"User Library"後單擊"next"，具體操作如下面的圖片所示：
最後查看項目處會出現如的資訊，則表示mysql資料庫載入成功。
三、在所建立的Servlet檔案中輸入
1 package com.servlet.datalink; 2 3 import java.io.IOException; 4 import java.io.PrintWriter; 5 import java.sql.Connection; 6 import java.sql.DriverManager; 7 import java.sql.ResultSet; 8 import java.sql.Statement; 9 10 import javax.servlet.ServletException;11 import javax.servlet.http.HttpServlet;12 import javax.servlet.http.HttpServletRequest;13 import javax.servlet.http.HttpServletResponse;14 15 public class Datalink extends HttpServlet {16 17 public void doGet(HttpServletRequest request, HttpServletResponse response)18 19 throws ServletException, IOException {20 // 設定上下文類型21 response.setContentType("text/html;charset=utf-8");22 // 設定統一文檔編碼23 request.setCharacterEncoding("UTF-8");24 PrintWriter out = response.getWriter();25 // 建立相應變數並賦值為null26 Connection conn = null;27 Statement stmt = null;28 ResultSet rs = null;29 30 // 通過異常處理操作31 try{32 // 載入mysql資料庫驅動33 Class.forName("com.mysql.jdbc.Driver");34 // 串連到資料庫35 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jifang", "root", "admin123456");36 // 建立串連狀態37 stmt = conn.createStatement();38 // 對資料庫進行操作39 rs = stmt.executeQuery("select * from user");40 // 輸出html資訊41 out.println("<html><head><title>讀取資料庫資訊</title></head><body></body></html>");42 // 利用while迴圈將資料庫中的資訊輸出43 while(rs.next()) {44 out.println(rs.getString("id") + "<br/>");45 out.println(rs.getString("username") + "<br/>");46 out.println(rs.getString("password") + "<br/>");47 }48 }catch(Exception e) {49 e.printStackTrace();50 }finally{51 // 關閉資料來源52 }53 54 }55 public void doPost(HttpServletRequest request, HttpServletResponse response)56 throws ServletException, IOException {57 this.doGet(request, response);58 }59 60 }
四、在tomcat中發布該項目，並利用瀏覽器進行測試
1）在myeclipse中發布該項目
2）在瀏覽器中輸入對應的URL 路徑，顯示結果如下
註：這篇文章為本人學習經驗，以上操作皆可執行。
Servlet 串連mysql資料庫
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
