DBConnect1.java

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

public class DBConnect1 {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub
        /* 1) 連接至MariaDB的資訊 */
        Connection con;
        Statement st;
        ResultSet rs;

        String url = "jdbc:mariadb://localhost:3306/mysql";
        //String user = "<帳號>";
        String user = "root";
        //String password = "<密碼>";
        String password = "XXXX";

        /* 2) 載入JDBC驅動程式 */
        Class.forName("org.mariadb.jdbc.Driver");

        /* 3) 連接至MariaDB */
        con = DriverManager.getConnection(url, user, password);
        st = con.createStatement();

        /* 4) 執行SELECT敘述 */
        rs = st.executeQuery("SELECT 1 AS col_1");

        /* 5) 將結果顯示於畫面上 */
        rs.next();
        System.out.print(rs.getInt("col_1"));

        /* 6) 關閉和MariaDB之間的連線 */
        rs.close();
        st.close();
        con.close();
    }

}