inportmdb.java

数据库设计的一个lab

import java.sql.*;



public class InportMdb {
	
	private String filename;                
	private ResultSet tableRet; 			
	private ResultSet tableColRet;          
	private Connection conn;                
	private DatabaseMetaData m_DBMetaData;
	private Statement stmt;
	private ResultSet content;
	
	
	InportMdb(String filename)
	{
		this.filename = filename;
	}
	
	
	public ResultSet getTables(){return tableRet;}
	public ResultSet getContent(){return content;}
	
	
	public void connect()
	{
		try{ 
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
			String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+filename; 
			conn=DriverManager.getConnection(url); 
			
			m_DBMetaData = conn.getMetaData();
			tableRet = m_DBMetaData.getTables(null, null,"%",new String[]{"TABLE"});
			stmt=conn.createStatement();
			} 
			catch(Exception e){
				e.printStackTrace();
			} 
	}
	
	public ResultSet readContent(String name)
	{
		try {
			content=stmt.executeQuery("select * from "+name);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return content;
	}
	
	public ResultSet readColumn(String name)
	{
		try {
			tableColRet= m_DBMetaData.getColumns(null, null,name, "%");
		} catch (SQLException e) {
				e.printStackTrace();
		}
		return tableColRet;
		
	}
	
	public void closeConn() throws SQLException
	{
		tableRet.close();
		conn.close();
	}

}