<%@ page import = "java.sql.*, java.util.*" %>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%
try {
//Step 1: 載入資料庫驅動程式
    Class.forName("com.mysql.jdbc.Driver");
    try {
//Step 2: 建立連線
        String url="jdbc:mysql://localhost/?serverTimezone=UTC  ";
        String sql="";
        Connection con=DriverManager.getConnection(url,"root","1234");  //密碼此處
        if(con.isClosed())
           out.println("連線建立失敗");
        else {
//Step 3: 選擇資料庫
           sql="SELECT * FROM mypooh.pooh_member;";     //SQL語法此處
           con.createStatement().execute(sql);
//Step 4: 執行 SQL 指令, 若要操作記錄集, 需使用executeQuery, 才能傳回ResultSet
           ResultSet rs=con.createStatement().executeQuery(sql);


           while(rs.next())
           {
                 out.println("會員帳號:"+rs.getString(1)+"<br>");
                 out.println("會員密碼:"+rs.getString(2)+"<br>");
                 out.println("會員名子:"+rs.getString(3)+"<br>");
                 out.println("會員電話:"+rs.getString(4)+"<br>");
                 out.println("會員地址:"+rs.getString(5)+"<br><hr>");
           }

          con.close();
      }
    }
    catch (SQLException sExec)
	{
           out.println("SQL錯誤"+sExec);
    }
}
catch (ClassNotFoundException err)
{
      out.println("class錯誤"+err);
}
%>