匯出資料庫到網頁

程式設計工藝大師

SQL

import java.sql.Connection;
import java.sql.DriverManager;
public class test {

public static void main(String[] args) {
Connection c = null;
 try {
  Class.forName("org.sqlite.JDBC");
  c = DriverManager.getConnection("jdbc:sqlite:test.db");
 } catch (Exception e) {
  System.err.println(e.getClass().getName() + ": " + e.getMessage());
  System.exit(0);
 }
 System.out.println("Opened database successfully");
}

}

匯出資料庫到網頁

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM `user`";
$result = $conn->query($sql);

if ($result != null) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id:" . $row["name"].  $row["passwd"]. "<br>";  
    }
} else {
    echo "0 results";
}
$conn->close();
?>