insert~1.jav

java编程实例

//insertaccess.java:插入Access数据库
import java.sql.*;

class insertaccess{
	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 insert = "insert into userInfo (name , address, tel) values ('feng', 'shandong','2222') ";
		       int  result    =    stmt.executeUpdate(insert);    
		       if  ( result > 0 ) 
		       {      
		              System.out.println("insert success!"); 
		       } else{
		              System.out.println("insert fail!"); 
		       }
		       //close db
		      try{ 
			if(!con.isClosed())
			con.close();
		       }catch(SQLException err){
			System.err.println(err.toString());
		       }
		       
		}catch(    Exception    e    ){      
		       e.printStackTrace();  		      
		} 
		
	}   
}