//updateaccess.java:更新Access數據庫
import java.sql.*;

class updateaccess{
	public static void main (String args[]) throws Exception{
		Connection    con;          
		Statement    stmt;          
		try{      
		       //Load  JDBC  driver  
		       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");      
		       //注意DBQ的寫法      
		       String url    =    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\jdk1.3.1\\javaprograms\\jdbc.mdb"; 
		       con    =    DriverManager.getConnection(url,"sa",""); 
		       stmt    =    con.createStatement();          
		       String    update    =    "update userInfo set tel = '12345678' where name = 'bi' ";          
		       int  result    =    stmt.executeUpdate(update); 
		       if  ( result > 0 ) 
		       {      
		              System.out.println("update success!"); 
		       } else{
		              System.out.println("update fail!"); 
		       }
		       //close db
		      try{ 
			if(!con.isClosed())
			con.close();
		       }catch(SQLException err){
			System.err.println(err.toString());
		       }
		}      
		catch(    Exception    e    ){      
		       e.printStackTrace(); 		     
		} 
		
	}   
}