* Created on 2008-12-31 * Copyright 2008 by Springs Design Inc. All Rights Reserved * */ package net.xfok.db; import java.sql.*; /** * @author YangHua * 转载请注明出处:http://www.xfok.net/2009/10/134509.html */ public class DBAccess { public Connection conn=null; /** * 连接未加密的数据库 * @param dbPath * @return * @throws Exception */ public Statement getStatement(String dbPath) throws Exception{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" + "DBQ="+dbPath;// 此为NO-DSN方式 // String dburl ="jdbc:odbc:odbcName";//此为ODBC连接方式 conn = DriverManager.getConnection(dburl); return conn.createStatement(); } /** * 连接加密的数据库 * @param dbPath * @return * @throws Exception */ public Statement getStatement(String dbPath,String password) throws Exception{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" + "pwd="+password+";DBQ="+dbPath;// 此为NO-DSN方式 // String dburl ="jdbc:odbc:odbcName";//此为ODBC连接方式 conn = DriverManager.getConnection(dburl); return conn.createStatement(); } /** * 查询数据库 * @param stmt * @param query * @return * @throws Exception */ public ResultSet executeQuery(Statement stmt,String query) throws Exception{ ResultSet rs=stmt.executeQuery(query); return rs; } /** * 更新数据库 * @param stmt * @param query * @throws SQLException */ public void executeUpdate(Statement stmt,String query) throws SQLException{ stmt.executeUpdate(query); } /** * 关闭链接 * @throws SQLException */ public void close() throws SQLException{ if(conn!=null) conn.close(); } public static void main(String args[]) throws Exception { DBAccess db=new DBAccess(); String dbPath="D:\\work\\workTime\\iCCard.mdb"; String query="select top 20 * from t_b_Consumer"; String password="168168"; Statement stmt=db.getStatement(dbPath, password); ResultSet rs=db.executeQuery(stmt, query); while(rs.next()){ System.out.println(rs.getString(1) + "\t" + rs.getString(2) + "\t" + rs.getString(3) + "\t" + rs.getString(4) + "\t" + rs.getString(5)); } } }
小编推荐:欲学习电脑技术、系统维护、网络管理、编程开发和安全攻防等高端IT技术,请 点击这里注册账号,公开课频道价值万元IT培训教程免费学,让您少走弯路、事半功倍,好工作升职加薪!
免责声明:本站系公益性非盈利IT技术普及网,本文由投稿者转载自互联网的公开文章,文末均已注明出处,其内容和图片版权归原网站或作者所有,文中所述不代表本站观点,若有无意侵权或转载不当之处请从网站右下角联系我们处理,谢谢合作!