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

查詢與新增Access(db1.mdb)資料
JDK版本：jdk-6-windows-i586.exe

範例：jdbc002.java（查詢資料庫資料）

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

class jdbc002 {
public static void main(String args[]) {
  try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url = "jdbc:odbc:testdb1";
   String user = "";
   String pass = "";
   Connection con = DriverManager.getConnection(url,user,pass);

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

 //執行SQL
   String query = "SELECT * FROM table1 WHERE id = 2" ;
   ResultSet rs = stmt.executeQuery(query);
   System.out.println("Stu   Id   Score");
   System.out.println("-------------------------");

 //取得搜尋結果
   while(rs.next()) {
    String stuname = rs.getString("stu");
    int idnum = rs.getInt("id");
    int score = rs.getInt("score");
    System.out.print(stuname + "    ");
    System.out.print(idnum + " ");
    System.out.println(score);
   }

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

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

範例：jdbc003.java（新增一筆資料）

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

class jdbc003 {
 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);
   BufferedReader buffreader2 = new BufferedReader(reader);
   BufferedReader buffreader3 = new BufferedReader(reader);
   System.out.print("請輸姓名:");
   String str1 = buffreader1.readLine();
   System.out.print("請輸入座號:");
   String str2 = buffreader2.readLine();
   System.out.print("請輸入分數:");
   String str3 = buffreader3.readLine();

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

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

 //SQL敘述
   String query = "INSERT INTO table1 (stu, id, score) VALUES ('"+str1+"','"+str2+"',"+str3+")";
   int num = stmt.executeUpdate(query);
   System.out.println("新增一筆資料為:"+ str1);

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

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