使用 Java 的執行SQL 類別物件

簡單的使用Statement、ResultSet 類別
建立資料和查詢資料。

MySQL 的JDBC 驅動程式

使用MySQL的JDBC 驅動程式 建立和資料庫的連線

使用 MySQL 5 建立一資料庫和資料表

CREATE DATABASE demo;
USE demo;
CREATE TABLE t_message (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name CHAR(20) NOT NULL,
email CHAR(40),
msg TEXT NOT NULL
);

CRUD操作
INSERT
INSERT INTO t_message VALUES (1, 'shitRick', 'rick_tsai@hotmail.com', 'a good man.');
*字串資料必須在雙引號或單引號中，數字和日期則不用
若不想依照資料表欄位順序插入資料，則：
INSERT INTO t_message (name, msg) VALUES('shitRick', 'a good man.');
也可以一次加入多筆資料，如：
INSERT INTO t_message VALUES
(1, 'shitRick', 'rick_tsai@hotmail.com', 'a good man.'),
(2, 'Wang', 'wang@msn.com', 'a pitcher.'),
(3, 'AustinPower', 'charmed@mojo.com', 'a movie actor');
SELECT
SELECT * FROM 資料表;
SELECT * FROM t_message WHERE name='shitRick' AND email='rick_tsai@hotmail.com';
SELECT name, msg FROM t_message;
SELECT * FROM t_message ORDER BY name;
SELECT * FROM t_message ORDER BY name DESC;
UPDATE
UPDATE t_message SET name='AustinPower' WHERE id=1;
UPDATE t_message SET name='AustinPower', email='charmed@mojo.com' WHERE id=1;
DELETE
DELETE FROM t_message WHERE id=1;
DELETE FROM t_message; //全部刪除

筆記本程式

c:\>cd jar\
c:\jar>jar cvf ./bin/JNotePad.jar -C classes /

c:\jar>java -cp ./bin/JNotePad.jar home.shitRick.JNotePad

取得一段輸入(包含空白)

import java.io.*;
public class BufferedReaderDemo {

public static void main(String[] args) throws IOException{
BufferedReader bufferedReader =
new BufferedReader(new InputStreamReader(System.in));
System.out.print("請輸入一段文字(可包含空白):");
String text = bufferedReader.readLine();
System.out.println("文字輸出:" + text);
}
}

使用 Scanner 取得輸入

import java.util.Scanner;

public class ScannerDemo {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
System.out.print("請輸入你的名字:");
System.out.printf("哈囉! %s\n", scanner.next());
System.out.print("請輸入一個數字:");
System.out.printf("你輸入了 %d \n", scanner.nextInt());
}
}

DVD資料排序

將dvdinfo.txt內資料
Donnie Darko/sci-fi/Gyllenhall, Jake
Raiders of the Lost Ark/action/Ford, Harrison
2001/sci-fi/??
Caddy Shack/comedy/Murray, Bill
Star Wars/sci-fi/Ford, Harrison
Lost in Translation/comedy/Murray, Bill
Patriot Games/action/Ford, Harrison
依照title排序...