调用本地adcess数据库

hys564219

于 2015-04-07 13:24:42 发布

阅读量88

点赞数

本文链接：https://blog.csdn.net/hys564219/article/details/44919099

版权

<pre name="code" class="java">// 词典检查
public static boolean dictionaryChk(List<String> nameList) {
	
	try{
		String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +
				"DBQ=src\\main\\resources\\EnglishWords.MDB";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection conn = DriverManager.getConnection(url);
		System.out.println(conn);
		Statement sta = conn.createStatement();
		
		for (String name : nameList) {
			if (name.length() > 0) {
				ResultSet resu = sta.executeQuery("select * from cetsix where words = '" +
						name.toLowerCase() + "'");
				if(!resu.next()){
					return false;
				}
			}
		}
	} catch (Exception e) {
		e.printStackTrace();
		return false;
	}
	
	return true;
}