匯出資料庫到網頁

程式設計工藝大師

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();
?>

程式設計工藝大師

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace mark

{

    public partial class Form1 : Form

    {

        int a=0, b=0, c=0;

        int rndmoney1 = 0, rndmoney2 = 0, rndmoney3 = 0, rndmoney4 = 0, rndmoney5 = 0, rndmoney6 = 0, rndmoney7 = 0, rndmoney8 = 0, rndmoney9 = 0;

        public Form1()

        {

            InitializeComponent();

        }

        private void button2_Click(object sender, EventArgs e)

        {

        }

        private void button6_Click(object sender, EventArgs e)

        {

        }

        private void button9_Click(object sender, EventArgs e)

        {

            a = a + 1;

            button9.Text=a.ToString();

        }

        private void button10_Click(object sender, EventArgs e)

        {

            

            Random rnd = new Random();

            rndmoney1 = rnd.Next(0, 9);

            rndmoney2 = rnd.Next(0, 9);

            rndmoney3 = rnd.Next(0, 9);

            rndmoney4 = rnd.Next(0, 9);

            rndmoney5 = rnd.Next(0, 9);

            rndmoney6 = rnd.Next(0, 9);

            rndmoney7 = rnd.Next(0, 9);

            rndmoney8 = rnd.Next(0, 9);

            rndmoney9 = rnd.Next(0, 9);

            button1.Text = rndmoney1.ToString();

            button2.Text = rndmoney2.ToString();

            button3.Text = rndmoney3.ToString();

            button4.Text = rndmoney4.ToString();

            button5.Text = rndmoney5.ToString();

            button6.Text = rndmoney6.ToString();

            button7.Text = rndmoney7.ToString();

            button8.Text = rndmoney8.ToString();

            button9.Text = rndmoney9.ToString();

            while (rndmoney1 == rndmoney2) { rndmoney2 = rnd.Next(0, 9); button2.Text = rndmoney2.ToString(); }

            while (rndmoney1 == rndmoney3 || rndmoney2 == rndmoney3) { rndmoney3 = rnd.Next(0, 9); button3.Text = rndmoney3.ToString(); }

            while (rndmoney1 == rndmoney4 || rndmoney2 == rndmoney4 || rndmoney3 == rndmoney4) { rndmoney4 = rnd.Next(0, 9); button4.Text = rndmoney4.ToString(); }

            while (rndmoney1 == rndmoney5 || rndmoney2 == rndmoney5 || rndmoney3 == rndmoney5 || rndmoney4 == rndmoney5) { rndmoney5 = rnd.Next(0, 9); button5.Text = rndmoney5.ToString(); }

            while (rndmoney1 == rndmoney6 || rndmoney2 == rndmoney6 || rndmoney3 == rndmoney6 || rndmoney4 == rndmoney6||rndmoney5 == rndmoney6) { rndmoney6 = rnd.Next(0, 9); button6.Text = rndmoney6.ToString(); }

            while (rndmoney1 == rndmoney7 || rndmoney2 == rndmoney7 || rndmoney3 == rndmoney7 || rndmoney4 == rndmoney7 || rndmoney5 == rndmoney7 || rndmoney6 == rndmoney7) { rndmoney7 = rnd.Next(0, 9); button7.Text = rndmoney7.ToString(); }

            while (rndmoney1 == rndmoney8 || rndmoney2 == rndmoney8 || rndmoney3 == rndmoney8 || rndmoney4 == rndmoney8 || rndmoney5 == rndmoney8 || rndmoney6 == rndmoney8 || rndmoney7 == rndmoney8) { rndmoney8 = rnd.Next(0, 9); button8.Text = rndmoney8.ToString(); }

            while (rndmoney1 == rndmoney9 || rndmoney2 == rndmoney9 || rndmoney3 == rndmoney9 || rndmoney4 == rndmoney9 || rndmoney5 == rndmoney9 || rndmoney6 == rndmoney9 || rndmoney7 == rndmoney9 || rndmoney8 == rndmoney9) { rndmoney9 = rnd.Next(0, 9); button9.Text = rndmoney9.ToString(); }            

            button1.Enabled = false;

            button2.Enabled = false;

            button3.Enabled = false;

            button4.Enabled = false;

            button5.Enabled = false;

            button6.Enabled = false;

            button7.Enabled = false;

            button8.Enabled = false;

            button9.Enabled = false;

            

        }

        private void button8_Click(object sender, EventArgs e)

        {

            b = b + 1;

            button8.Text = b.ToString();

        }

        private void button7_Click(object sender, EventArgs e)

        {

            c = c + 1;

            button7.Text = c.ToString();

        }

    }

}