It's YOUR world......ENJOY IT!

刪除Access(db1.mdb)資料
JDK版本：jdk-6-windows-i586.exe

範例：jdbc004.java（刪除資料庫資料）

import java.io.*;
import java.net.*;
import java.sql.*;

class jdbc004 {
 public static void main(String args[]) {
  try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url = "jdbc:odbc:testdb1";
   String user = "";
   String pass = "";
   InputStreamReader reader = new InputStreamReader(System.in);
   BufferedReader buffreader1 = new BufferedReader(reader);

   Connection con = DriverManager.getConnection(url,user,pass);

 //建立Statement物件
   Statement stmt = con.createStatement();

 //SQL敘述
   
   String query = "SELECT * FROM table1";
   ResultSet rs = stmt.executeQuery(query);
   System.out.println("stu    id     score");
   System.out.println("-------------------------");
   while(rs.next()) {
    String shohincd = rs.getString("stu");
    int shohinmei = rs.getInt("id");
    int tanka = rs.getInt("score");
    System.out.print(shohincd + "     ");
    System.out.print(shohinmei + " ");
    System.out.println(tanka);
    }
   rs.close();
   System.out.print("請輸入要刪除的stu:");
   String str1 = buffreader1.readLine();

   //SQL敘述
   String query1 = "DELETE FROM table1 WHERE stu = '"+ str1 +"'";
   int num = stmt.executeUpdate(query1);
   System.out.println("刪除資料為:"+ str1);

 //釋放先前建立的物件
   stmt.close();
   con.close();

  } catch (Exception e) {
    System.out.println("發生了" + e + "例外");
  }
 }
}