delete~1.jav

来自「java编程实例」· JAV 代码 · 共 36 行

//deleteaccess.java:删除Access数据库中的记录
import java.sql.*;

class deleteaccess{
	public static void main (String args[]) throws Exception{
		Connection    con;          
		Statement    stmt;    
		//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","");       
		try{      
		       stmt    =    con.createStatement();          
		       String    delete    =    " delete from userInfo  where name = 'feng' "; 
		       int  result    =    stmt.executeUpdate(delete);    
		       if  ( result > 0 ) 
		       {      
		              System.out.println("delete success!"); 
		       } else{
		              System.out.println("delete fail!"); 
		       }
		       //close db
		      try{ 
			if(!con.isClosed())
			con.close();
		       }catch(SQLException err){
			System.err.println(err.toString());
		       }
		}      
		catch(    Exception    e    ){      
		       e.printStackTrace();  		      	       
		} 
		
	}   
}