select~1.jav

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

//selectaccess.java:查询Access数据库
import java.sql.*;

class selectaccess{
	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    query    =    "select * from userInfo";          
		       ResultSet    rs    =    stmt.executeQuery(query);      
		       while    (    rs.next()    )      
		       {      
		             String    str    =    rs.getString( "name" )+":"+ rs.getString( "address" )+ ":"+rs.getString( "tel" );      
		             System.out.println(str);      		             
		       }     
		      //close db
		      try{ 
			if(!con.isClosed())
			con.close();
		       }catch(SQLException err){
			System.err.println(err.toString());
		       } 
		}      
		catch(    Exception    e    ){      
		       e.printStackTrace();  		      
		} 
	}   
}