数据库驱动

package newexam;import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DAOAccess {private Connection con = null;private String fileName;private boolean isCrp = false;public DAOAccess(String fileName) {this.fileName = fileName;if (fileName.endsWith(".crp")) {isCrp = true;File srcFile = new File(fileName);File tempFile = null;try {tempFile = File.createTempFile("tiku", ".mdb");BufferedInputStream in = new BufferedInputStream(new FileInputStream(srcFile));BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(tempFile));int ch;while ((ch = in.read()) != -1) {ch ^= 9;out.write(ch);}in.close();out.close();this.fileName = tempFile.getAbsolutePath();} catch (FileNotFoundException e) {System.out.println("找不到文件!");e.printStackTrace();} catch (IOException e) {System.out.println("文件操作失败!");e.printStackTrace();}}}public Connection getConnection() {try {Class.forName("com.hxtt.sql.access.AccessDriver");String url = "jdbc:access:///" + fileName;con = DriverManager.getConnection(url);} catch (ClassNotFoundException e) {System.out.println("ACCESS_JDBC加载失败");e.printStackTrace();} catch (SQLException e) {System.out.println("数据库连接或创建语句失败");e.printStackTrace();}return con;}public void close() {if (con != null)try {con.close();} catch (SQLException e) {System.out.println("数据库无法关闭");e.printStackTrace();}if (isCrp) {System.out.println("删除临时文件：" + this.fileName);File file = new File(this.fileName);if (file.exists()) {file.deleteOnExit();}}}}